1Z0-082 Exam Questions

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)

A database is configured to use automatic undo management with temporary undo enabled. An UPDATE is executed on a temporary table. Where is the UNDO stored?

You have been tasked to create a table for a banking application. One of the columns must meet three requirements: 1. Be stored in a format supporting date arithmetic without using...

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains: Which statement...

Which three statements are true concerning logical and physical database structures? (Choose three.)

Which two statements are true regarding a SAVEPOINT? (Choose two.)

Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)

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

Which two can you use to recover a dropped table? (Choose two.)

Which is true about roles?

Which is true about security rules on a compute node?

Which three statements are true about a self join? (Choose three.)

You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is e...

Examine the description of the CUSTOMERS table: You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters. Wh...

Examine this command: Which two statements are true? (Choose two.)

Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)

Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two.)

Evaluate these commands which execute successfully: Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

Which three instance situations are possible with the Oracle Database server without multi- tenant? (Choose three.)

Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)

A user complains about poor database performance. You suspect that the user's session is waiting for an event to complete. You want to verify this. Which two views may reveal for w...

What two are benefits of Data Pump? (Choose two.)

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

Which two functions are performed by a listener?

Which four account management capabilities can be configured using Oracle profiles? (Choose four.)

Which three statements are true about single-row functions? (Choose three.)

You want to use table compression suitable for OLTP that will: 1. Compress rows for all DML statements on that table 2. Minimize the overheads associated with compression Which com...

Which two statements are true about space-saving features in an Oracle Database? (Choose two.)

Which two statements are true about the PMON background process? (Choose two.)

In which three situations does a new transaction always start? (Choose three.)

Examine the description of the SALES1 table: SALES2 is a table with the same description as SALES1. Some sales data is duplicated in both tables. You want to display the rows from...

Your database instance is started with a PFILE. Examine these parameters: You want to increase the size of the buffer cache. Free memory is available to increase the size of the bu...

Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)

Which three failures do not require intervention for recovery? (Choose three.)

Which three object types support deferred segment creation? (Choose three.)

Which two are true about instance recovery for a database that is open in read write mode? (Choose two.)

Which two types of files are opened by a database instance in the NOMOUNT state?

You execute this command: During the export operation, you detach from the job by using CTRL+C and then execute this command: Export> STOP_JOB=immediate Are you sure you wish to st...

In one of your databases, you create a user, HR, and then execute this command: GRANT CREATE SESSION TO hr WITH ADMIN OPTION; Which three actions can HR perform? (Choose three.)

Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choose two.)

Which two statements are true about UNDO and REDO? (Choose two.)

The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations. Each database has a tnsnames.ora file defining DALLAS_DB as a service name. Exami...

Which three statements are true about the DESCRIBE command? (Choose three.)

Examine the description of the CUSTOMERS table: For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Custome...

The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE. NLS_DATE_FORMAT is set to DD-MON-RR. Which two are true about data type co...

Which two are true about the roles? (Choose two.)

Which three are true about the Oracle Optimizer? (Choose three.)

Which two are true about conventional path SQL load? (Choose two.)

Which three are types of segments in an Oracle Database? (Choose three.)

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