최신 1z0-062 무료덤프 - Oracle Database 12c: Installation and Administration

문제1

Examine the parameter settings in your local ORCL database:

Examine the parameter settings for the remote SALES database:

As the SYS user, you issue the following command on ORCL:
CREATE PUBLIC DATABASE LINK sales.us.example.com USING 'sales1';
The sales1 tnsnames entry points to the sales database instance.
Which two are requirements to ensure that you can successfully connect by using this database link? (Choose two.)

A. The REMOTE_OS_AUTHENT initialization parameter should be set to FALSE in the remote database.

B. Only the user creating the database link must have an account and the required privileges in the remote database.

C. The GLOBAL_NAMES initialization parameter should be set to FALSE in the ORCL database.

D. The SALES1 net service name should be known to both the local and remote databases.

E. Local database users who use this database link should have accounts and the required privileges in the remote database.

정답: C,E

문제2

In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.
How would you accomplish this?

A. Setting a metric threshold

B. Enabling resumable timeout for user sessions

C. Implementing Database Resource Manager

D. Decreasing the value of the IDLE_TIME resource limit in the default profile

정답: C

문제3

Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?

A. MMAN

B. SMON

C. PMON

D. MMON

E. MMNL

정답: A

문제4

Which statement is true about redo log files during instance recovery?

A. All current, active, and inactive redo logs are required to complete instance recovery.

B. All redo log entries in the current log are applied to data files until the checkpoint position is reached.

C. All redo log entries in the current and active logs are applied to data files to reconstruct changes made after the most recent checkpoint.

D. All current, online, and archived redo logs are required to complete instance recovery.

정답: B

설명: (DumpTOP 회원만 볼 수 있음)

문제5

Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.
Which two RMAN commands may be; used to back up only the PDB1 pluggable database? (Choose two.)

A. BACKUP DATABASE while connected to the boot container

B. BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container

C. BACKUP PLUGGABLE database PDB1 while connected to PDB2

D. BACKUP DATABASE while connected to the PDB1 container

E. BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container

정답: B,D

설명: (DumpTOP 회원만 볼 수 있음)

문제6

Which statement is true about the loss of a data file belonging to the default undo tablespace?

A. All the noncommitted transactions are lost.

B. The database remains open in read-only mode.

C. The database is put in MOUNT state and requires recovery to be opened.

D. The database remains open for querying but no DML statements can be executed except by the users with SYSDBA privilege.

E. The database instance aborts.

정답: D

문제7

Which two statements are true about variable extent size support for large ASM files? (Choose two.)

A. Rebalance operations are completed faster than with a fixed extent size

B. Resync operations are completed faster when a disk comes online after being taken offline.

C. An ASM Instance automatically allocates an appropriate extent size.

D. The metadata used to track extents in SGA is reduced.

E. Performance improves in a stretch cluster configuration by reading from a local copy of an extent.

정답: C,D

설명: (DumpTOP 회원만 볼 수 있음)

문제8

Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column? (Choose two.)

A. All the components may be moved into SYSAUX tablespace.

B. All the components may be moved from the SYSAUX tablespace.

C. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.

D. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.

정답: C,D

문제9

For which three requirements would you use the Database Resource Manager? (Choose three.)

A. limiting the CPU used per database call

B. limiting the degree of parallelism of operations performed by user sessions in a consumer group

C. specifying the maximum number of concurrent sessions allowed for a user

D. specifying an idle time limit that applies to sessions that are idle and blocking other sessions

E. specifying the amount of private space a session can allocate in the shared pool of the SGA.

정답: B,C,D

설명: (DumpTOP 회원만 볼 수 있음)

문제10

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)? (Choose three.)

A. Tracking the most recent write time for a table block

B. Tracking insert time by row for table rows

C. Tracking the most recent read time for a table segment in the SYSAUX tablespace

D. Tracking the most recent write time for a table segment in the SYSAUX tablespace

E. Tracking the most recent read time for a table segment in a user tablespace

F. Tracking the most recent write time for a table segment in a user tablespace

정답: A,E,F

설명: (DumpTOP 회원만 볼 수 있음)

문제11

Which two actions does an incremental checkpoint perform? (Choose two.)

A. It advances the checkpoint position in the checkpoint queue.

B. It signals CKPT to write the checkpoint position to the data file headers.

C. It writes the checkpoint position to the control file.

D. It writes the checkpoint position to the data file headers.

정답: A,C

설명: (DumpTOP 회원만 볼 수 있음)

문제12

Which three statements are true about Oracle Data Pump? (Choose three.)

A. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

B. Oracle Data Pump export operations invoked from the clients that are connected remotely by using a connection string, create Data Pump files on the client file system.

C. Oracle Data Pump export and import operations can be performed to move data across different database releases.

D. A directory object must exist and a user performing an EXPDP or IMPDP operation must have read and write permission on that directory object.

E. DBMS_DATAPUMP PL/SQL packages can be used independent of Data Pump clients.

정답: C,D,E

문제13

You have the following entry in the tnsnames.ors of your hq.us.example.com host machine:

You issue the following command at the command prompt:
Sqlplus HR/HR@ORCL
Which statement is true about the connection to the ORCL database instance?

A. The connection succeeds, provided the NAMES.DEFAULT_DOMAIN parameter is set to us.example.com in the sqlnet.ora file on the client side.

B. The connection fails because the net service name does not have the suffix us.example.com.

C. The connection succeeds, provided the ORCL.us.example.com database service is registered with a listener, the listener is up, and the database is open.

D. The connection succeeds, provided the SERVICE_NAMES initialization parameter is set to ORCL.

정답: C

문제14

You create a locally managed tablespace ORDERS_TBS with automatic segment management.
You then create the table DAILY_ORDS_LST in the ORDERS_TBS tablespace using the command.
CREATE TABLE daily_ords_1st(ordno NUMBER, ord_date DATE) PCTFREE 20;
How does the PCTFREE storage parameter influence data storage for this table?

A. It minimizes row chaining during row insertion.

B. It minimizes row migration during existing row data updation.

C. It allows only 80% of space to be occupied in all data blocks of this table.

D. It automatically coalesces free space of a data block when it reaches 20% of available space.

정답: C

문제15

Which three statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)? (Choose three.)

A. Local users cannot use local system privileges on the schema of a common user.

B. The granter of system privileges must possess the set container privilege.

C. Common users connected to a PDB can exercise privileges across other PDBs.

D. System privileges apply only to the PDB in which they are used.

E. System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.

정답: B,D,E

설명: (DumpTOP 회원만 볼 수 있음)

문제16

Which two statements are true about availability audit features after migration to unified auditing? (Choose two.)

A. The ability of users to audit their own schema objects is not available in the post-migrated database.

B. Network auditing is available in the post-migrated database.

C. Mandatory auditing of audit administrative actions is available in the post-migrated database.

D. Operating system audit trail is available in the post-migrated database.

정답: A,C

설명: (DumpTOP 회원만 볼 수 있음)

문제17

You want to import the schema objects of the HR user from the development database DEVDB to the production database PRODDB by using Oracle Data Pump. A database link devdb.us.oracle.com is created between PRODDB and DEVDB.
You execute the following command on the PRODDB database server:

What should you do to resolve the error?

A. Change the dumpfile option value to [email protected].

B. Replace the dumpfile option with network_1ink = devdb.us.oracle.com.

C. Add the SYSTEM user to the schemas option.

D. Replace the schemas option with network_1ink = devdb.us.oracle.com.

E. Add network_link = devdb.us.oracle.com.

정답: B

문제18

Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:

Which two statements are true about redefining the table? (Choose two.)

A. All the triggers for the table are disabled without changing any of the column names or column types in the table.

B. The primary key constraint on the EMPLOYEES table is disabled during redefinition.

C. VPD policies are copied from the original table to the new table during online redefinition.

D. You must copy the VPD policies manually from the original table to the new table during online redefinition.

정답: B,C

설명: (DumpTOP 회원만 볼 수 있음)

문제19

Which two tasks must you perform before you begin the upgrade process to Oracle Database 12c? (Choose two.)

A. Empty all user recycle bins

B. Recompile all invalid objects

C. Put all readonly tablespaces in read write mode

D. Set the compatible parameter to 12.1.0.1

E. Gather dictionary statistics

정답: A,B

최신 1z0-062 무료덤프 - Oracle Database 12c: Installation and Administration

우리와 연락하기

유용한 링크

최신 업데이트