I need some help with these SQL questions. Thanks 1. Assume that you are require
ID: 3719267 • Letter: I
Question
I need some help with these SQL questions. Thanks
1. Assume that you are required to arrange the results of a query in some specified sequence which involves consideration of several columns, some in ascending sequence, and some in descending sequence. Describe how you would form the ORDER BY clause. NOTE: you are not being asked to write the specific ORDER BY clause, but describe what factors you would consider if you had to write the clause.
2. What are the four rules for an Oracle identifier (name of a table, column, etc.)? List the rules; sentences are not required, but your answer must be clear and accurate.
3. Referencing the CUSTOMERS table, write an Oracle statement to increase the capacity of the Lastname and Firstname fields to 15 characters without changing the data type of the attributes.
4. Identify three (3) circumstances/conditions when changes to a database are committed
5. Identify two (2) circumstances when changes to a database are “rolled back.”
Explanation / Answer
1. Answer
with the help of the keyword asc or desc along with the order by clause with the select clause, which can be used to select the specific rows and columns and display in the specific sequence which can be sorted in the order of ascending or descending. with the select statement, mor than one columns can be selected which is needed to be displayed in the result along with the sorting order.
2, Answer
3. Answer
alter table CUSTOMERS add (Lastname varchar(15), Firstname varchar(15));
4. Answer
5. Answer