CertsTopics Logo

Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Oracle Database 12c 1z0-062 Book

Page: 7 / 14
Total 379 questions
Get 1z0-062 Full Access Download 1z0-062 PDF

Oracle Database 12c: Installation and Administration Questions and Answers

Question 25

Which two must be installed or configured either manually or by DBCA in order to use Enterprise Manager

Database Express (EM Express)? (Choose two.)

Options:

A.

A port number for Oracle HTTP Server must be configured

B.

The APEX_PUBLIC_USER role must be granted to SYSMAN

C.

A SYSMAN user with SYSDBA privilege must be created

D.

At least one TCP/IP dispatcher must be configured

E.

The Oracle HTTP Server must be installed

Question 26

You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).

Examine the query and its output:

Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file? (Choose two.)

Options:

A.

Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.

B.

Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

C.

Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.

D.

Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.

E.

Re-create the password file in the Oracle Database 12c format.

Question 27

Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the following command:

1snrctl > STOP

What happens to the sessions that are presently connected to the database Instance?

Options:

A.

They are able to perform only queries.

B.

They are not affected and continue to function normally.

C.

They are terminated and the active transactions are rolled back.

D.

They are not allowed to perform any operations until the listener LISTENER is started.

Question 28

Which two statements are true about the logical storage structure of an Oracle database? (Choose two.)

Options:

A.

An extent contains data blocks that are always physically contiguous on disk.

B.

An extent can span multiple segments.

C.

Each data block always corresponds to one operating system block.

D.

It is possible to have tablespaces of different block sizes.

E.

A data block is the smallest unit of I/O in data files.

Page: 7 / 14
Total 379 questions
Get 1z0-062 Full Access Download 1z0-062 PDF