You execute this command: TRUNCATE TABLE depts; Which two are true?
A. It retains the indexes defined on the table.
B. It drops any triggers defined on the table.
C. A Flashback TABLE statement can be used to retrieve the deleted data.
D. It retains the integrity constraints defined on the table.
E. A ROLLBACK statement can be used to retrieve the deleted data.
F. It always retains the space used by the removed rows
A session's NLS_DATE_FORMAT is set to DD Mon YYYY .
Which two queries return the value 1 Jan 2019?
A. SELECT to_date(' 2019-01-01 ', 'YYYY -MM-DD' ) FROM DUAL;
B. SELECT DATE '2019-01-01' FROM DUAL ;
C. SELECT TO_CHAR('2019-01-01') FROM DUAL; 2019-01-01
D. SELECT '2019-01-01' FROM DUAL ; 2019-01-01
E. SELECT TO_ DATE('2019-01-01') FROM DUAL;
Which three statements are true regarding single row subqueries?
A. They must be placed on the left side of the comparison operator or condition.
B. They must be placed on the right side of the comparison operator or condition.
C. They must return a row to prevent errors in the SQL statement.
D. A SQL statement may have multiple single row subquery blocks.
E. They can be used in the HAVINGclause.
F. They can be used in the WHEREclause.
View the exhibit and examine the ORDERS table.
The ORDERS table contains data and all orders have been assigned a customer ID. Which statement would add a NOT NULL constraint to the CUSTOMER_ID column?
A. ALTER TABLE orders MODIFY CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);
B. ALTER TABLE orders ADD CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);
C. ALTER TABLE orders MODIFY customer_id CONSTRAINT orders_cust_nn NOT NULL (customer_id);
D. ALTER TABLE orders ADD customer_id NUMBER(6)CONSTRAINT orders_cust_id_nn NOT NULL;
View the exhibit and examine the description of the PRODUCT_INFORMATION table.
Which SQL statement would retrieve from the table the number of products having LIST_PRICE as NULL?
A. SELECT COUNT (DISTINCT list_price) FROM product_information WHERE list_price is NULL
B. SELECT COUNT (NVL(list_price, 0)) FROM product_information WHERE list_price is NULL
C. SELECT COUNT (list_price) FROM product_information WHERE list_price i= NULL
D. SELECT COUNT (list_price) FROM product_information WHERE list_price is NULL
You issue this command Which succeeds: SQL> DROP TABLE products;
Which three statements are true?
A. All existing views and synonyms that refer to the table are invalidated but retained.
B. Any uncommitted transaction in the session is committed.
C. Table data and the table structure are deleted.
D. All the table's indexes if any exist, are invalidated but retained.
E. Table data is deleted but the table structure is retained.
Examine the data in the COLORS table:
Examine the data in the BRICKS table:
Which three privileges can be restricted to a subset of columns in a taS?
A. SELECT. FROM bricks b RIGHT JOIN colors c ON b. color _rgb_ hex_ value = c. rgb hex_ value;
B. SELECT EROM colors C LEFT JOIN bricks USING (rgb _ hex_ value) ;
C. SELECT FROM bricks b FULL JOIN colors C ON b. color rgb _ hex_ value = c. rgb _hex_ value;
D. SELECT * EROM bricks | b JOIN colors C ON b. color_ rgb_ hex_ value =c. rgb _hex value;
E. SELECT EROM colors C LEET JOIN bricks b ON b. color_ rgb_ hex value = c. rgb. hex. value WHERE b. brick_ id > 0;
Which three statements are true about inner and outer joins? (Choose three.)
A. A full outer join returns matched and unmatched rows.
B. A full outer join must use Oracle syntax.
C. Outer joins can be used when there are multiple join conditions on two tables.
D. Outer joins can only be used between two tables per query.
E. An inner join returns matched rows.
F. A left or right outer join returns only unmatched rows.
Examine the description of the EMPLOYEES table
You write this failing statement: SELECT dept_no AS department_id, MAX (salary) As max_sal FROM employees WHERE salary >10000 GROUP BY department_id ORDER BY max_sal; Which clause causes the error?
A. ORDER BY
B. WHERE
C. GROUP BY
D. SELECT
Examine the description of the CUSTOMERS table:
Which three statements will do an implicit conversion?
A. SELECT * FROM customers WHERE TO_ CHAR (customer_ id) = '0001';
B. SELECT * FROM customers WHERE customer id = '0001';
C. SELECT * FROM customers WHERE customer_ id = 0001;
D. SELECT FROM customers WHERE insert date = '01-JAN-19';
E. SELECT. FROM customers WHERE insert_ date = DATE *2019-01-01';
F. SELECT. FRON customers WE TO DATE (Insert _ date) = DATE `2019-01-01';
