Which three statements are true regarding indexes? (Choose three.) A. A SELECT statement can access one or more indices without accessing any tables B. An update to a table can result in no updates to any of the table’s indexes…
The ORDERS table has a primary key constraint on the ORDER_ID column. The ORDER_ITEMS table has a foreign key constraint on the ORDER_ID column, referencing the primary key of the ORDERS table. The constraint is defined with ON DELETE CASCADE.…
An Oracle database server session has an uncommitted transaction in progress which updated 5000 rows in a table. In which three situations does the transactions complete thereby committing the updates? (Choose three.) A. when a DBA issues a successful SHUTDOWN…
The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE. NLS_DATE_FORMAT is set to DD-MON-RR. Which two are true about data type conversions involving these columns in query expressions? (Choose two.)…
Examine this SQL statement: Which two are true? A. All existing rows in the ORDERS table are updated B. The subquery is executed for every updated row in the ORDERS table C. The subquery is executed before the UPDATE statement…
Which three statements are true about performing Data Manipulation Language (DML) operations on a view with no INSTEAD OF triggers defined? (Choose three.) A. Insert statements can always be done on a table through a view. B. Views cannot be…
Which three statements are true about the DESCRIBE command? (Choose three.) A. It can be used to display the structure of an existing view B. It can be used only from SQL*Plus C. It displays the PRIMARY KEY constraint for…
The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2. The table has two rows whose CUST_LAST_NAME values are Anderson and Ausson. Which query produces output for CUST_LAST_NAME containing Oder for the first row and Aus for the second?…
Which three statements are true about inner and outer joins? (Choose three.) A. A full outer join must use Oracle syntax B. An inner join returns matched rows C. A left or right outer join returns only unmatched rows D.…
Examine the description of the PRODUCTS table: Which three queries use valid expressions? (Choose three.) A. SELECT product_id, (expiry_date – delivery_date) * 2 FROM products; B. SELECT product_id, unit_price | | 5 "Discount", unit_price + surcharge – discount FROM products;…