1Z1-082 試験問題を無料オンラインアクセス

Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence?
(Choose two.)

• A.Sequence ORD_SEQ is guaranteed not to generate duplicate numbers
• B.Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ
• C.Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times
• D.Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO
• E.If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS

Which two are true about complete and incomplete recovery? (Choose two.)

• A.The database must have FLASHBACK enabled in order to perform incomplete recovery.
• B.Incomplete recovery is possible only when the database is open.
• C.Uncommitted transactions will be rolled back after incomplete recovery completes.
• D.Only incremental backups can be used to roll forward the database while performing complete recovery.
• E.Uncommitted transactions will be rolled back after complete recovery completes.

The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)

• A.SELECT NVL(TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;
• B.SELECT NVL2(cust_credit_limit * .15, `Not Available') FROM customers;
• C.SELECT TO_CHAR(NVL(cust_credit_limit * .15, `Not Available')) FROM customers;
• D.SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;
• E.SELECT NVL(cust_credit_limit * .15, `Not Available') FROM customers;

Which three statements are true about roles?

• A.All roles granted to a user are set on by default when the user logs in,
• B.Roles may be granted to roles.
• C.Object privileges may not be granted to roles.
• D.Roles must be password protected.
• E.The SET ROLE statement can enable one or more roles for a session.
• F.The SET ROLE statement can disable one or more roles for a session.

Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

• A.INTERSECT ignores NULLs
• B.Column names in each SELECT in the compound query can be different
• C.The number of columns in each SELECT in the compound query can be different
• D.INTERSECT returns rows common to both sides of the compound query
• E.Reversing the order of the intersected tables can sometimes affect the output