New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: Board70

New Release 1z0-082 Oracle Database 19c Questions

Page: 3 / 5
Question 12

Which two statements are true about Oracle synonyms?

Options:

A.

A synonym has an object number.

B.

A synonym can be created on an object in a package.

C.

A synonym can have a synonym.

D.

All private synonym names must be unique in the database.

E.

Any user can create a PUBLIC synonym.

Question 13

Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:

ALTER DATABASE MOUNT;

Which two actions are performed? (Choose two.)

Options:

A.

The online redo logs are opened

B.

The online data files are opened

C.

The alert log records the execution details

D.

The Oracle background processes are started

E.

The initialization parameter file is read

F.

The control file is read

Question 14

Examine these SQL statements which execute successfully:

Which two statements are true after execution?

Options:

A.

The primary key constraint will be enabled and deferred.

B.

The foreign key constraint will be enabled and deferred.

C.

The foreign key constraint will be disabled.

D.

The foreign key constraint will be enabled and immediate.

E.

The primary key constraint will be enabled and immediate.

Question 15

In one of your databases, user KING is:

1. Not a DBA user

2. An operating system (OS) user

Examine this command and its output:

What must you do so that KING is authenticated by the OS when connecting to the database instance?

Options:

A.

Set OS_AUTHENT_PREFIX to OPS$

B.

Have the OS administrator add KING to the OSDBA group

C.

Grant DBA to KING

D.

Unset REMOTE_LOGIN_PASSWORDFILE

E.

Alter user KING to be IDENTIFIED EXTERNALLY

Page: 3 / 5
Exam Code: 1z0-082
Exam Name: Oracle Database Administration I
Last Update: Dec 26, 2024
Questions: 142
1z0-082 pdf

1z0-082 PDF

$25.5  $84.99
1z0-082 Engine

1z0-082 Testing Engine

$28.5  $94.99
1z0-082 PDF + Engine

1z0-082 PDF + Testing Engine

$40.5  $134.99