[2026] Oracle Database 12c: Installation and Administration

문제1

What should you do for a Scheduler to start a job when a file arrives on a remote system?

A. Start an Oracle database instance on the remote system and register the Scheduler agent with this database.

B. Shutdown the file watcher on the local system.

C. Ensure dedicated server is enabled on both the local and remote databases.

D. Install the Scheduler agent on the remote system and register the agent with the database on the local system.

정답: A

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

문제2

You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server.
All databases of all versions use Automatic Storage Management (ASM).
Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group? (Choose three.)

A. The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.

B. RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.

C. The ASM compatibility attribute controls the format of the disk group metadata.

D. The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.

E. The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10 g database.

정답: B,C,D

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

문제3

Examine the parameters for a database instance:

Which two statements are true? (Choose two.)

A. Undo records for temporary tables are stored in the undo tablespace and logged in the redo.

B. Undo records for temporary tables are stored in the undo tablespace and logged in the redo only for those sessions where temporary undo is enabled.

C. No redo and undo records are generated for temporary tables.

D. Undo records for temporary tables are stored in a temporary tablespace.

E. No redo is generated for the undo records belonging to temporary tables.

정답: D,E

문제4

You want to create a database and you have the following:
- Oracle Grid Infrastructure is installed and configured.
- Oracle Database Vault is installed in ORACLE_HOME to be used for this database.
- Oracle Enterprise Manager Cloud Control is available and an agent is deployed on the database server.
Examine the requirements:
1. configuring the database instance to support shared server mode
2. using Automatic Storage Management (ASM) for storing database files.
3. configuring a naming method to help a remote user connect to a database instance
4. configuring the Fast Recovery Area
5. configuring Database Vault
6. configuring Enterprise Manager (EM) Database Express
7. registering with EM Cloud Control
8. configuring remote log archive destinations
9. enabling daily incremental backups
10. configuring a nondefault block size for nondefault block size tablespaces Which of these requirements can be met while creating a database by using the Database Configuration Assistant (DBCA)?

A. 1, 2, 4, 5, 6 and 7

B. 1, 2, 3, 8, 9 and 10

C. 1, 2, 4, 5, 6, 7 and 8

D. 1, 2, 4, 5, 7, 8, 9 and 10

E. 1, 2, 3, 4, 6, 8, 9 and 10

정답: E

문제5

Which two must be installed or configured either manually or by DBCA in order to use Enterprise Manager Database Express (EM Express)? (Choose two.)

A. A port number for Oracle HTTP Server must be configured

B. At least one TCP/IP dispatcher must be configured

C. A SYSMAN user with SYSDBA privilege must be created

D. The APEX_PUBLIC_USER role must be granted to SYSMAN

E. The Oracle HTTP Server must be installed

정답: B,D

문제6

You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces are created by default in HR_PDB? (Choose three.)

A. UNDO

B. EXAMPLE

C. TEMP

D. SYSTEM

E. SYSAUX

F. USERS

정답: C,D,E

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

문제7

Which three statements are true about automated maintenance tasks? (Choose three.)

A. A maintenance window is automatically extended until all the maintenance tasks defined are completed.

B. A repository is maintained in the SYSTEM tablespace to store the history of execution of all tasks.

C. They run at predefined time intervals that are intended to occur during a period of low system load.

D. An Oracle Scheduler job is created for each maintenance task that is scheduled to run in a maintenance window.

E. Predefined maintenance tasks consist of automatic optimizer statistics collection, running Automatic Segment Advisor, and running Automatic SQL Tuning Advisor.

정답: C,D,E

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

문제8

You notice that the elapsed time for an important database scheduler Job is unacceptably long.
The job belongs to a scheduler job class and window.
Which two actions would reduce the job's elapsed time? (Choose two.)

A. Increasing the priority of the job class to which the job belongs

B. Moving the job to an existing higher priority scheduler window with the same schedule and duration

C. Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window

D. Increasing the priority of the scheduler window to which the job belongs

E. Increasing the job's relative priority within the Job class to which it belongs

F. Increasing the value of the JOB_QUEUE_PROCESSES parameter

정답: C,E

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

문제9

Which three are activities performed by SMON? (Choose three.)

A. restarting a server or a dispatcher process that terminated abnormally

B. cleaning up the database buffer cache and freeing resources that a client process was using

C. recovering failed transactions that were skipped during instance recovery because of file-read or tablespace offline errors

D. performing database services registration with the default listener

E. applying online redo during instance recovery

F. cleaning up temporary segments that are no longer needed

정답: C,E,F

문제10

Which four operations performed after the Oracle Restart installation are automatically added to the Oracle Restart configuration? (Choose four.)

A. database created by using a SQL statement

B. database service created by using DBMS_SERVICE.CREATE_SERVICE

C. listener configured by using NETCA

D. database created by using DBCA

E. ASM instance created by using ASMCA

F. database service created by modifying the SERVICE_NAMES initialization parameter

G. database service created by using SRVCTL

정답: C,D,E,G

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

문제11

You want to load data from a large file into your database without causing an overhead on the SGA.
Which tool would you use.

A. Oracle data Pump

B. external table

C. Enterprise Manager Database Express

D. SQL*Loader with a conventional data path

E. SQL*Loader with a direct data path

정답: E

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

문제12

You executed the following query:
SELECT oldest_flashback_scn, oldest_flashback_time
FROM V$FLASHBACK_DATABASE_LOG;
Considering that all the redo logs are available, what information can you derive from the output of the preceding query?

A. The time when the first flashback operation in our database was performed

B. The approximate time and the lowest system change number (SCN) to which you can flash back your database

C. The time when the last flashback operation in your database was performed

D. The system change number (SCN) and the time when the Flashback Database was enabled in the database instance

정답: B

문제13

Which two statements are true about Oracle Managed Files (OMF)? (Choose two.)

A. OMF cannot be used in a database that already has data files created with user-specified directions.

B. The file system directions that are specified by OMF parameters are created automatically.

C. OMF may affect the location of the redo log files and archived log files.

D. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.

E. OMF automatically creates unique file names for table spaces and control files.

정답: C,E

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

문제14

To implement Automatic Management (AMM), you set the following parameters:

When you try to start the database instance with these parameter settings, you receive the following error message:
SQL > startup
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.
Identify the reason the instance failed to start.

A. The STATISTICS_LEVEL parameter is set to BASIC.

B. Both the SGA_TARGET and MEMORY_TARGET parameters are set.

C. The PGA_AGGREGATE_TARGET parameter is set to zero.

D. The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.

정답: A

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

Oracle Database 12c: Installation and Administration - 1z1-062무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트