1z0-082 Practice Test

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

Examine this command:

Which two statements are true? (Choose two.)

A.

DML may be performed on tables with one or more extents in this data file during the execution of this command.

B.

The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.

C.

The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.

D.

If Oracle Managed Files (OMF) is used, then the file is renamed but moved to
DB_CREATE_FILE_DEST.

E.

The file is renamed and stored in the same location

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.)

A.

Revoke the CREATE SESSION privilege from other users

B.

Revoke the CREATE SESSION privilege from user HR

C.

Log in to the database instance

D.

Grant the CREATE SESSION privilege with ADMIN OPTION to other users

E.

Execute DDL statements in the HR schema

F.

Execute DML statements in the HR schema

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

A.

MOD : returns the quotient of a division operation

B.

FLOOR : returns the smallest integer greater than or equal to a specified number

C.

TRUNC : can be used to combine any number of values

D.

CONCAT : can be used to combine any number of values

E.

CEIL : can be used for positive and negative numbers

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

A.

A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.

B.

An UNUSED column’s space is reclaimed automatically when the block containing that column is next queried.

C.

An UNUSED column’s space is reclaimed automatically when the row containing that column is next queried.

D.

Partition key columns cannot be dropped.

E.

A DROP COLUMN command can be rolled back

F.

A column that is set to UNUSED still counts towards the limit of 1000 columns per table