Tag Archives: 1z0-082

Q22 Which two statements are true about the job?

Q22 You execute this command: During the export operation, you detach from the job by...

Q21 You have been tasked to create a table for a banking application

Q21 You have been tasked to create a table for a banking application. One of...

Q20 Which two are true about data type conversions involving these columns in query expressions?

Q20 The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE...

Q19 You want to display the first name and due amount as 5% of their credit limit

Q19 Examine the description of the CUSTOMERS table: For customers whose income level has a...

Q18. In one of your databases, the user HR has the password HRMGR

Q18. In one of your databases, the user HR has the password HRMGR You want...

Q17. Which two statements are true about the configuration and use of UNDO_RETENTION with no GUATANTEED RETENTION?

Q17. Which two statements are true about the configuration and use of UNDO_RETENTION with no...

Q16. Which two statements are true regarding a SAVEPOINT?

Q16. Which two statements are true regarding a SAVEPOINT? (Choose two.) (A). Rolling back to...

Q15. Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER

Q15. Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER. Examine these...

Q14. Which two statements are true about the SET VERIFY ON command?

Q14. Which two statements are true about the SET VERIFY ON command? (Choose two.) (A)....

Q13. Which is the default column or columns for sorting output from compound queries using SET operators such as intersect In a SQL statement?

Q13. Which is the default column or columns for sorting output from compound queries using...

Q12. Why does the DB01.abc.com service show unknown status?

Q12. Examine this command and some partial output: Why does the DB01.abc.com service show unknown...

Q11. Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace?

Q11. Examine this command: CREATE UNDO TABLESPACE undotbs01 DATAFILE 'undotbs_01.dbf' SIZE 100M AUTOEXTEND ON; Which...