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

examout.co

Examine this command: ALTER DATABASE MOVE DATAFILE '/u01/sales01.dbf' TO '/u02/sales02.dbf'; Which two statements are true?

A.

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

B.

It overwrites any existing file with the name sales02.dbf in /u02 by default.

C.

The "TO" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.

D.

Compressed objects in sales01.dbf will be uncompressed in sales02.dbf after the move.

E.

Tables with one or more extents in this data file may be queried during the execution of this command.

Which three statements are true about the tools used to configure Oracle Net Services?

A.

Oracle Net Manager can be used to centrally configure listeners on any database server target.

B.

The Oracle Net Configuration Assistant is only used when running the Oracle installer.

C.

Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target.

D.

Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server.

E.

The lsnrctl utility requires a listener.ora file to exist before it is started.

F.

Oracle Net Manager can be used to locally configure naming methods on a database server.

Your data center uses Oracle Managed Files (OMF) for all databases. All tablespaces are smallfile tablespaces. SALES_Q1 is a permanent user-defined tablespace in the SALES database. The following command is about to be issued by a DBA logged in to the SALES database: ALTER TABLESPACE sales_q1 ADD DATAFILE; Which two actions independently ensure that the command executes successfully?

A.

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

B.

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

C.

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

D.

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

E.

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

Which three functions are performed by dispatchers in a shared server configuration?

A.

Sending shared server session responses back to requesters on the appropriate connection.

B.

Writing inbound requests to the common request queue from all shared server connections.

C.

Broadcasting shared server session responses back to requesters on all connections.

D.

Receiving inbound requests from processes using shared server connections.

E.

Sending each connection input request to the appropriate shared server input queue.

F.

Checking for outbound shared server responses on the common outbound response queue.

orcl.dmp contains a full export of the ORCL database. This command is executed to load data from orcl.dmp into the TESTDB database: [oracle@host01 ~] impdp system/oracle SCHEMAS=sh,oe REMAP_SCHEMA=sh:hr DUMPFILE=orcl.dmp EXCLUDE=index TABLE_EXISTS_ACTION=replace LOGFILE=impdp.log Which two statements are true?

A.

It drops and re-creates indexes that exist in both ORCL:SH and TESTDB:HR.

B.

It skips only tables that exist in ORCL:SH and ORCL:OE.

C.

It skips all indexes of ORCL:SH and in both ORCL:SH and TESTDB:HR.

D.

It drops and re-creates tables that exist in both ORCL:SH and TESTDB:HR.

E.

It skips only indexes that exist in both ORCL:SH and TESTDB:HR.

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

A.

It is held inside an Oracle database schema.

B.

The ADR base defaults to $ORACLE_HOME/rdbms/admin if neither DIAGNOSTIC_DEST nor ORACLE_BASE is set.

C.

It supports diagnostics for Automatic Storage Management (ASM).

D.

It supports diagnostics for Oracle Clusterware.

E.

The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set.

You are going to perform a hot remote clone of PDB1 from CDB1 as TESTPDB in CDB2. Which of the following is a necessary prerequisite for the hot remote clone?

A.

PDB1 must be taken offline before the cloning process begins.

B.

Both CDBs need to be in local undo mode.

C.

PDB1 must be in read-only mode.

D.

TESTPDB must be in read-only mode after the cloning process is complete.

One of your database instances was shut down normally and then started in NOMOUNT state. You then executed this command: ALTER DATABASE MOUNT; Which two of these actions are performed?

A.

Online data files are opened.

B.

Online redo logs are opened.

C.

The initialization parameter file is read.

D.

Oracle shared memory structures are allocated.

E.

The alert log has instance startup details written to it.

F.

Control files are read.

You execute the SHUTDOWN ABORT command. Which two statements are true?

A.

A checkpoint is written.

B.

Subsequent instance startup performs media recovery.

C.

Subsequent instance startup performs instance recovery.

D.

Data files are closed normally.

E.

Uncommitted transactions are not rolled back by the shutdown.

Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)?

A.

ASSM assigns blocks to one of the four fullness categories based on what percentage of the block is allocated for rows.

B.

Update operations always relocate rows into blocks with free space appropriate to the length of the row being updated.

C.

Insert operations always insert new rows into blocks with free space appropriate to the length of the row being inserted.

D.

The first block with enough free space to accommodate a row being inserted will always be used for that row.

E.

PCTFREE defaults to 10% for all blocks in all segments for all compression methods.