1z0-071 Exam Question 326
Which three arithmetic operations can be performed on a column by using a SQL function that is built into Oracle database? (Choose three.)
1z0-071 Exam Question 327
Which two statements are true regarding constraints? (Choose two.)
1z0-071 Exam Question 328
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?
Which SQL statement would retrieve from the table the number of products having LIST_PRICE as NULL?
1z0-071 Exam Question 329
The user SCOTTwho is the owner of ORDERSand ORDER_ITEMStables issues this GRANTcommand:
GRANT ALL
ON orders, order_items
TO PUBLIC;
What must be done to fix the statement?
GRANT ALL
ON orders, order_items
TO PUBLIC;
What must be done to fix the statement?
1z0-071 Exam Question 330
Which two statements are true about the SET VERIFY ONcommand? (Choose two.)