Question: 1
The SQL statements executed in a user session are as follows:
Which two statements describe the consequences of issuing the ROLLBACK TO SAVE POINT a command in the session? (Choose two.)
Question: 2
View the Exhibit and examine the structure of the PRODUCT_INFORMATION table.
You want to see the product names and the date of expiration of warranty for all the products, if the product is purchased today. The products that have no warranty should be displayed at the top and the products with maximum warranty period should be displayed at the bottom.
Which SQL statement would you execute to fulfill this requirement?
Question: 3
Examine the description of the CUSTOMERS table:
You need to display last names and credit limits of all customers whose last name starts with A or B in lower or upper case, and whose credit limit is below 1000.
Examine this partial query:
Which two WHERE conditions give the required result?
Question: 4
Examine the data in the CUST_NAME column of the CUSTOMERS table:
You want to display the CUST_NAME values where the last name starts with Mc or MC.
Which two WHERE clauses give the required result?
Answer : A
Show Answer
Hide Answer
Question: 5
Which three are true about the MERGE statement?
