View the Exhibit and examine the structure of the PRODUCTS table. You want to display only those product names with their list prices where the list price is at least double the minimum price. The report should start with the…
View the Exhibit and examine the structure of the CUSTOMERS table. You want to generate a report showing the last names and credit limits of all customers whose last names start with A, B, or C, and credit limit is…
View the Exhibit and examine the structure of CUSTOMERS table. Evaluate the following query: Which statement is true regarding the above query? A. It executes successfully. B. It produces an error because the condition on the CUST_CITY column is not…
View the Exhibit and examine the data in the PROMOTIONS table. PROMO_BEGIN_DATE is stored in the default date format, dd-mon-rr. You need to produce a report that provides the name, cost, and start date of all promos in the POST…
SLS is a private synonym for the SH.SALES table. The user SH issues the following command: DROP SYNONYM sls; Which statement is true regarding the above SQL statement? A. Only the synonym would be dropped. B. The synonym would be…
Which two statements are true regarding indexes? (Choose two.) A. They can be created on tables and clusters. B. They can be created on tables and simple views. C. You can create only one index by using the same columns.…
Evaluate the following CREATE SEQUENCE statement: CREATE SEQUENCE seq1 START WITH 100 INCREMENT BY 10 MAXVALUE 200 CYCLE NOCACHE; The SEQ1 sequence has generated numbers up to the maximum limit of 200. You issue the following SQL statement: SELECT seq1.nextval…
Which three statements are true regarding views? (Choose three.) A. Views can be created only from tables. B. Views can be created from tables or other views. C. Only simple views can use indexes existing on the underlying tables. D.…
Which two statements are true regarding views? (Choose two.) A. A simple view in which column aliases have been used cannot be updated. B. Rows cannot be deleted through a view if the view definition contains the DISTINCT keyword. C.…
Examine the following SQL commands: Which statement is true regarding the execution of the above SQL commands? A. Both commands execute successfully. B. The first CREATE TABLE command generates an error because the NULL constraint is not valid. C. The…