Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exc65

examout.co

Which three statements are true about the Automatic Diagnostic Repository (ADR)?

A.

It Is held Inside an Oracle database schema.

B.

The ADR base is specified In the diagnostic_dest database parameter.

C.

It is only used for Oracle Database diagnostic information.

D.

It is a file-based repository held outside any database.

E.

It can be used for problem diagnosis of a database when that database's instance is down.

Which three statements are true about roles?

A.

All roles granted to a user are set on by default when the user logs in,

B.

Object privileges may not be granted to roles.

C.

The SET ROLE statement can disable one or more roles for a session.

D.

Roles must be password protected.

E.

Roles may be granted to roles.

F.

The SET ROLE statement can enable one or more roles for a session.

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

One of the columns must meet three requirements:

Be stored in a format supporting date arithmetic without using conversion functions

Store a loan period of up to 10 years

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.

INTERVAL DAY TO SECOND

C.

TIMESTAMP WITH LOCAL TIMEZONE

D.

TIMESTAMP

E.

TIMESTAMP WITH TIMEZONE

Which two statements are true about Enterprise Manager (EM) Express?

A.

You can use a single instance of EM Express to manage multiple database running on the same server.

B.

EM Express uses a separate repository database to store target database metadata.

C.

By default, EM express is available for a database after database creation using DBCA.

D.

You can shut down a database instance using EM Express.

E.

You cannot start up a database instance using EM Express.

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.

CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds

B.

SYSDATE can be queried only from the DUAL table

C.

CURRENT_DATE returns the current date and time as per the session time zone

D.

SYSDATE can be used in expressions only if the default date format is DD-MON-RR

E.

SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server

F.

CURRENT_TIMESTAMP returns the same date as CURRENT_DATE

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

A.

The data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query.

B.

The number, but not names, of columns must be identical for all SELECT statements in the query.

C.

The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.

D.

The names and number of columns must be identical for all SELECT statements in the query.

E.

The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.

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

A.

Multiple INTERSECT operators are not possible in the same SQL statement

B.

It processes NULLs in the selected columns

C.

INTERSECT is of lower precedence than UNION or UNION ALL

D.

It ignores NULLs

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 two statements are true about interval data types?

A.

INTERVAL year TO month columns support yearly intervals.

B.

The value in an interval day to SECOND column can be copied into an interval year to month column.

C.

INTERVAL day to second columns support fractions of seconds.

D.

INTERVAL year to month columns only support monthly Intervals within a single year.

E.

INTERVAL year to month columns only support monthly intervals within a range of years.

F.

The year field in an interval year to month column must be a positive value.

Which three statements are true about the Oracle Data Dictionary? (Choose three.)

A.

Data dictionary views are created by joins of dictionary base tables and DBA-defined tables

B.

The data dictionary is created and maintained by the database administrator

C.

Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary

D.

Base tables can be queried directly

E.

It is owned by the SYSTEM user

F.

Usernames of all users including database administrators are stored in the data dictionary