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

Oracle Updated 1z0-082 Exam Questions and Answers by juniper

Page: 5 / 5

Oracle 1z0-082 Exam Overview :

Exam Name: Oracle Database Administration I
Exam Code: 1z0-082 Dumps
Vendor: Oracle Certification: Oracle Database 19c
Questions: 142 Q&A's Shared By: juniper
Question 20

In your data center, Oracle Managed Files (OMF) is used for all databases.

All tablespaces are smallfile tablespaces.

SALES_Q1 is a permanent user-defined tablespace in the SALES database.

Examine this command which is about to be issued by a DBA logged in to the SALES database:

ALTER TABLESPACE sales_q1 ADD DATAFILE;

Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)

Options:

A.

Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.

B.

Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.

C.

Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.

D.

Add the AUTOEXTEND ON clause with NEXT set to 100M.

E.

Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.

Discussion
Question 21

Which two statements are true about Enterprise Manager Database Express? (Choose two.)

Options:

A.

It is available only when the database is open

B.

It can be used to perform database recovery

C.

The same port number can be used for Database Express configurations for databases on different hosts

D.

It can be used to switch a database into ARCHIVELOGMODE

E.

The same port number can be used for multiple Database Express configurations for multiple databases on the same host

Discussion
Page: 5 / 5

1z0-082
PDF

$35  $99.99

1z0-082 Testing Engine

$42  $119.99

1z0-082 PDF + Testing Engine

$56  $159.99