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

문제1

Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container:

Which two statements are true? (Choose two.)

A. The schema for the common user C # # A_ADMIN can be different in each container.

B. The command will, create a common user whose description is contained in the root and each PDB.

C. The command will create a user in the root container only because the container clause is not used.

D. The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.

E. Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.

정답: A,B

문제2

Your database is configured in ARCHIVELOG mode.
Examine the RMAN configuration parameters:

Examine the command:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
What is the outcome?

A. It fails because the DELETE INPUT option can be used only with the BACKUP AS COPY command.

B. It executes successfully and creates an image copy of the database along with archive log files and then deletes the original archived log files.

C. It fails because the DELETE INPUT option can be used only with the BACKUP AS BACKUPSET command.

D. It executes successfully and creates a backup set of the database along with archived log files and then deletes the original archived log files.

정답: D

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

문제3

You execute the commands:

Which two statements are true? (Choose two.)

A. The user Sidney can connect to the database instance but cannot perform sort operations because no space quota is specified for the temp tablespace.

B. The create user command fails if any role with the name Sidney exists in the database.

C. The user Sidney is created and authenticated by the operating system.

D. The user Sidney can connect to the database instance but requires relevant privileges to create objects in the users tablespace.

E. The user Sidney is created but cannot connect to the database instance because no profile is default.

정답: B,D

문제4

You are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table's indexes, to another tablespace.
The table does not have a primary key and is used by an OLTP application.
Which technique will move the table and indexes while maintaining the highest level of availability to the application?

A. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.

B. Edition-Based Table Redefinition.

C. Online Table Redefinition.

D. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.

E. Oracle Data Pump.

정답: C

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

문제5

You plan to upgrade your Oracle Database 9i to Oracle Database 12c.
Which two methods can you use? (Choose two.)

A. Perform a direct upgrade by running the Database Upgrade Assistant (DBUA).

B. Upgrade your current database to Oracle Database release 10.2.0.5, and then upgrade to Oracle Database
12c.

C. Perform a rolling upgrade.

D. Perform a direct upgrade by manually running the catctl.pl and catupgrd.sql scripts before issuing the STARTUPUPGRADE command.

E. Install the Oracle Database 12c software, create a new Oracle 12c database, and then use the Oracle Data Pump to import data from the source Oracle 9i database to the target Oracle 12c database.

정답: B,C

문제6

Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:

What are three possible causes for the latch-related wait events?

A. The size of the shared pool is too small.

B. A large number COMMITS are being performed.

C. There are frequent logons and logoffs.

D. Cursors are not being shared.

E. The buffers are being read into the buffer cache, but some other session is changing the buffers.

정답: A,C,D

문제7

What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?

A. Helps you to easily upgrade the database from a prior release.

B. Enables the Installation of Grid Infrastructure files on block or raw devices.

C. Effectively implements role separation

D. Enables you to take advantage of Oracle Managed Files.

E. Automatically registers the database with Oracle Restart.

정답: C,E

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

문제8

Which two can be recommendations given by SQL Access Advisor? (Choose two.)

A. creation of SQL profiles

B. creation of SQL plan baselines

C. creation of materialized views

D. creation of indexes

E. rewriting of SQL statements

정답: C,D

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

문제9

You plan to migrate your database from a File system to Automata Storage Management (ASM) on same platform.
Which two methods or commands would you use to accomplish this task? (Choose two.)

A. The BACKUP AS COPY DATABASE . . . command of RMAN

B. Conventional Export and Import

C. DBMS_FILE_TRANSFER with transportable tablespace

D. Data Pump Export and import

E. RMAN CONVERT command

정답: A,E

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

문제10

You use the segment advisor to help determine objects for which space may be reclaimed.
Which three statements are true about the advisor given by the segment advisor? (Choose three.)

A. It may advise the use of segment shrink for free list managed tables.

B. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.

C. It may advise the use of online table redefinition for tables in dictionary managed tablespace.

D. It may advise the use of online table redefinition for tables in locally managed tablespaces

E. It will detect and advise about chained rows.

정답: C,D,E

문제11

The performance of your database degrades between 11:00 AM and 3:00 PM. Automatic Workload Repository (AWR) snapshots are collected on an hourly basis.
What is the most efficient way of diagnosing this problem?

A. Analyze the latest Automatic Database Diagnostic Monitor (ADDM) report.

B. Create a SQL Tuning Set (STS) for the currently cached SQL statements in the shared pool and run SQL Performance Analyzer (SPA) to generate recommendations.

C. Create a custom ADDM task for the period defined by the snapshots taken between 11:00 AM and 3:00 PM.

D. Analyze the hourly ADDM reports generated between 11:00 AM and 3:00 PM.

정답: C

문제12

Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle Database Resource Manager? (Choose three.)

A. Parallel server limit

B. CPU

C. Maximum Undo per consumer group

D. Maximum Idle time

E. Exadata I/O

F. Local file system I/O

정답: A,B,E

문제13

Which statement is true about using the Database Upgrade Assistant (DBUA) to upgrade your database from Oracle Database 11g to Oracle Database 12c?

A. It automatically adds new data files if there is not enough disk space to grow.

B. It terminates if the SYSTEM tablespace in the source database is not autoextensible.

C. It automatically makes necessary changes to Oracle environment variables.

D. It automatically enables unified auditing in the upgraded database.

정답: A

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

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

우리와 연락하기

유용한 링크

최신 업데이트