Which statement is true regarding the SESSION_PRIVS dictionary view? A) It contains the object privileges granted to other users by the current user session. В) It contains the system privileges gran ...

View the Exhibit and examine the structure of the ORDERS table. The columns ORDER_MODE and ORDER TOTAL have the default values'direct “and respectively. Which two INSERT statements are valid? (C ...

Viev the Exhibit and examine the structure of the PRODUCT INFORMATION and INVENTORIEStables. You have a requirement from the supplies department to give a list containing PRODUCT _ID,SUPPLIER ID, and ...

Which statement is true about the INTERSECT operator used in compound queries? A) It processes NULLS in the selected columns. B) INTERSECT is of lower precedence than UNION or UNION ALL. C) It ignores ...

You execute this query: SELECT TO CHAR (NEXT_DAY(LAST_DAY(SYSDATE),’MON’ ),’ dd“Monday for” fmMonth rrr’) FROM DUAL; What is the result? A) It executes successfully but does not return any resul ...

You issued this command: DROP TABLE hr. employees; Which three statements are true? A) ALL constraints defined on HR, EMPLOYEES are dropped. B) The HR. EMPLOYEES table may be moved to the recycle bin. ...

Which is the default column or columns for sorting output from compound queries using SET operators such as INTERSECT in a SQL statement? A) The first column in the last SELECT of the compound query B ...

You are administering a multitenant container database (CDB) cdb1 that has multiple pluggable databases (PDBs). As the sys user on cdb$root, you execute the commands: SQL> CREATE USER C##ADMIN IDENTIF ...