1Z0-082 Online Practice Questions and Answers

The orders table has a column ORDER_DATE of data type DATE.

The default display format for a date is DD-MON-RR.

Which two WHERE conditions demonstrate the correct usage of conversion functions? (Choose two.)

A. WHERE order_date > TO_DATE(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')

B. WHERE order dare > TO DATE('JUL 10 2018', 'MON DD YYYY')

C. WHERE TO_CHAR(order date, 'MON DD YYYY') = 'JAN 20 2019'

D. WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')

E. WHERE order_date IN (TO_DATE('Oct 21 2018', 'Mon DD YYYY'), TO_CHAR('Nov 21 2018', 'Mon DD YYYY'))

You want to apply the principle of Least Privilege in all your live databases.

One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.

Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three.)

A. analysis of all privileges used by all users including administrative users in the database

B. analysis of all privileges used by all users but excluding administrative users in the database

C. analysis of privileges that a user has on their own schema objects that they did not use

D. analysis of privileges that a user has on their own schema objects that they did use

E. analysis of privileges granted directly to a role that are then used by a user who has been granted that role

F. analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role

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

A. writing inbound request to the common request queue from all shared server connections

B. checking for outbound shared server responses on the common outbound response queue

C. receiving inbound requests from processes using shared server connections

D. sending each connection input request to the appropriate shared server input queue

E. broadcasting shared server session responses back to requesters on all connections

F. sending shared server session responses back to requesters on the appropriate connection

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

A. A table can have only one primary key but multiple foreign keys

B. A table can have only one primary key and one foreign key

C. The foreign key columns and parent table primary key columns must have the same names

D. It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted

E. It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted

F. Only the primary key can be defined at the column and table level

G. Primary key and foreign key constraints can be defined at both the column and table level

Which three files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.)

A. dump files

B. control files

C. password files

D. bad files

E. input files

Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.)

A. An undo segment may be used by multiple transactions simultaneously

B. Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment

C. Undo segments have a minimum of three extents

D. Undo segments can extend when a transaction fills the last extent of the undo segment

E. A single transaction may use multiple undo segments simultaneously

F. Undo segments must be stored in a BIGFILE tablespace

G. Undo segments must be stored in a SMALLFILE tablespace

While one of your databases was in mount state, the datafiles were renamed because they had been moved to a new file system. The database was then opened.

Which two statements are true?

A. DBA_DATA_FILES displays the original name for the data files.

B. V$DATAFILE displays the new names for the data files.

C. DBA_DATA _FILES displays both the new name and the old name for the data files.

D. DBA_DATA_FILES displays the new name for the data files.

E. DBA_DATA_FILES must be resynchronized manually with the control file an order to have it display the new file names.

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 buffer cache.

You execute the command:

SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;

What is the outcome?

A. The value is changed only in the PFILE and takes effect at the next instance startup

B. The value is changed for the current instance and in the PFILE

C. It fails because the SCOPE clause is missing

D. Change is applied to the current instance, but does not persist after instance restart

Examine the description of the PRODUCTS table:

Which query is valid?

A. SELECT prod_id, release_date, SUM(cost) FROM products GROUP BY prod_id;

B. SELECT prod_id, release_date, SUM(cost) FROM products GROUP BY prod_id, release_date;

C. SELECT prod_id, AVG(MAX(cost)) FROM products GROUP BY prod_id;

D. SELECT prod_id, MAX(AVG(cost)) FROM products GROUP BY prod_id;

Which three statements are true about indexes and their administration in an Oracle database? (Choose three.)

A. An index can be created as part of a CREATE TABLE statement.

B. If a query filters on an indexed column, then it will always be used during execution of the query.

C. A descending index is a type of function-based index.

D. A DROP INDEX statement always prevents updates to the table during the drop operation.

E. A UNIQUE and non-unique index can be created on the same table column.

F. An INVINSIBLE INDEX is not maintained when Data Manipulation Language (DML) is performed on its underlying table.