Examine the structure of the BOOKS_ TRANSACTIONS table: Examine the SQL statement: Which statement is true about the outcome?

n the customers table, the CUST_CITY column contains the value 'Paris' for the CUST_FIRST_NAME 'Abigail'. Evaluate the following query: What would be the outcome?

Which two statements are true about Data Manipulation Language (DML) statements?

You must create a table for a banking application. (Choose the best answer.) One of the columns in the table has these requirements: 1: A column to store the duration of a short team loan 2: The data should be stored in a format supporting DATE arithmetic with DATE datatypes without using conversion functions. 3: The maximum loan period is 30 days. 4: Interest must be calculated based on the number of days for which the loan remains unpaid. Which data type would you use?

Which two statements are true regarding constraints? (Choose two.)

You issue the following command to drop the PRODUCTS table: (Choose all that apply.) SQL > DROP TABLE products; Which three statements are true about the implication of this command?

Examine the command: SQL> ALTER TABLE books_transactions ADD CONSTRAINT fk_book_id FOREIGN KEY (book_id) REFERENCES books (book_id) ON DELETE CASCADE; What does ON DELETE CASCADE imply?

Evaluate the following query: SQL> SELECT TRUNC (ROUND (156.00, -1),-1) FROM DUAL; What would be the outcome?

Which statements are correct regarding indexes? (Choose all that apply.)

You execute the following commands: SQL > DEFINE hiredate = '01-APR-2011' SQL >SELECT employee_id, first_name, salary FROM employees WHERE hire_date > '&hiredate' AND manager_id >&mgr_id; For which substitution variables are you prompted for the input?

Which two are the minimal requirements for a self-join? (Choose two.)