1Z0-082 Online Practice Questions and Answers

Which statement is true about database links?

A. Private database link creation requires the same user to exist in both the local and the remote databases.

B. A public database link can be created only by SYS.

C. A database link can be created only between two Oracle databases.

D. A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance.

E. A database link created in a database allows a connection from that database's instance to the target database's Instance, but not vice versa.

Examine the description of the BOOKS table:

The table has 100 rows.

Examine this sequence of statements issued in a new session:

INSERT INTO books VALUES (`ADV112', `Adventures of Tom Sawyer', NULL, NULL);

SAVEPOINT a;

DELETE FROM books;

ROLLBACK TO SAVEPOINT a;

ROLLBACK;

Which two statements are true? (Choose two.)

A. The second ROLLBACK command does nothing

B. The second ROLLBACK command replays the delete

C. The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed

D. The second ROLLBACK command undoes the insert

E. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

A. External table files can be used for other external tables in a different database

B. The ORACLE_LOADER access driver can be used to unload data from a database into an external table

C. The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table

D. They cannot be partitioned

E. The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table

F. They support UPDATEs but not INSERTs and DELETEs

Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)

A. They can be written by server processes

B. Trace files are written to the Fast Recovery Area (FRA)

C. They can be written by background processes

D. All trace files contain error information that require contacting Oracle Support

E. Trace file names are based on the database name concatenated with a sequential number

Which three statements are true about data block storage in an Oracle Database?

A. A block header contains a row directory pointing to all rows in the block.

B. An index block can contain row data.

C. Row data is stored starting at the end of the block.

D. A data block header is of a fixed length.

E. A table block must always contain row data.

Which two statements are true about User Authentication in an Oracle Database?

A. Operating System authentication may be used for system-privileged administrative users.

B. REMOTE_LOGIN_PASSWORDFILE must be set to exclusive to permit password changes for system-privileged administrative users.

C. Password authentication must be used for system-privileged administrative users.

D. Password File authentication must be used for system-privileged administrative users.

E. Password File authentication is supported for any type of database user.

Which two statements are true about the configuration and use of UNDO_RETENTION with GURANTEED RETENTION? (Choose two.)

A. UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.

B. UNDO_RETENTION specifies how long all types of UNDO are retained.

C. Unexpired UNDO is always retained.

D. Active UNDO is always retained.

E. UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.

Examine this SQL statement:

SELECT cust_id, cust_last_name "Last Name" FROM customers WHERE country_id = 10 UNION SELECT cust_id CUST_NO, cust_last_name FROM customers WHERE country_id = 30

Identify three ORDER BY clauses, any one of which can complete the query successfully. (Choose three.)

A. ORDER BY "Last Name"

B. ORDER BY 2, 1

C. ORDER BY 2, cust_id

D. ORDER BY CUST_NO

E. ORDER BY "CUST_NO"

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

Which two statements are true regarding indexes? (Choose two.)

A. A non-unique index can be altered to be unique.

B. An update to a table can result in no updates to any of the table's indexes.

C. The RECYCLE BIN never contains indexes.

D. An update to a table can result in updates to any or all of the table's indexes.

E. A table belonging to one user cannot have an index that belongs to a different user.