1Z0-082 by Oracle Actual Free Exam Q&As

Question 1

Which three statements are true about Oracle synonyms? (Choose three.)

A. A synonym created by one user can refer to an object belonging to another user B. Any user can drop a PUBLIC synonym C. A synonym can be available to all users D. A SEQUENCE can have a synonym E. A synonym cannot be created for a PL/SQL package

Discussion 0

Correct Answer: A,C,D Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 2

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

A. Trace file names are based on the database name concatenated with a sequential number B. They can be written by background processes C. They can be written by server processes D. All trace files contain error information that require contacting Oracle Support E. Trace files are written to the Fast Recovery Area (FRA)

Discussion 0

Correct Answer: B,C Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 3

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
conversion functions
2. Store a loan period of up to 10 years
3. Be used for calculating interest for the number of days the loan
remains unpaid
Which data type should you use?

A. INTERVAL YEAR TO MONTH B. TIMESTAMP C. TIMESTAMP WITH LOCAL TIMEZONE D. TIMESTAMP WITH TIMEZONE E. INTERVAL DAY TO SECOND

Discussion 0

Correct Answer: E Vote an answer

Question 4

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

A. one instance on one server associated with two or more databases on separate servers B. two or more instances on separate servers all associated with one database C. one instance on one server associated with two or more databases on the same server D. one instance on one server not associated with any database E. one instance on one server associated with one database

Discussion 0

Correct Answer: A,C,D Vote an answer

Question 5

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

A. the alert log B. data files C. control files D. online redo logs E. the initialization parameter file

Discussion 0

Correct Answer: B,E Vote an answer

Question 6

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 undoes the insert 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 does nothing E. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row

Discussion 0

Correct Answer: A,E Vote an answer

Question 7

Examine these SQL statements which execute successfully:

Which two statements are true after execution?

A. The primary key constraint will be enabled and deferred. B. The foreign key constraint will be enabled and immediate. C. The primary key constraint will be enabled and immediate. D. The foreign key constraint will be disabled. E. The foreign key constraint will be enabled and deferred.

Discussion 0

Correct Answer: D Vote an answer

Question 8

Which statement is true about the INTERSECT operator used in compound queries?

A. INTERSECT is of lower precedence than UNION or UNION ALL B. It ignores NULLs C. It processes NULLs in the selected columns D. Multiple INTERSECT operators are not possible in the same SQL statement

Discussion 0

Correct Answer: C Vote an answer

Question 9

In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.
Examine this command:
SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);
Which segment or segments, if any, are created as a result of executing the command?

A. T1, an index segment for the primary key, a LOB segment, and a lobindex segment B. T1, an index segment for the primary key, and a LOB segment only C. T1 only D. T1 and an index segment created for the primary key only E. no segments are created

Discussion 0

Correct Answer: C Vote an answer

Oracle Database Administration I - 1Z0-082 Exam Practice Test