[2026] Oracle Database 12c: Installation and Administration

문제1

The HR user receives the following error while inserting data into the sales table:

On investigation, you find that the users tablespace uses Automatic Segment Space Management (ASSM). It is the default tablespace for the HR user with an unlimited quota on it.
Which two methods would you use to resolve this error? (Choose two.)

A. Changing segment space management for the USERS tablespace to manual

B. Altering the data file associated with the USERS tablespace to extend automatically

C. Creating a new tablespace with autoextend enabled and changing the default tablespace of the HR user to the new tablespace

D. Adding a data file to the USERS tablespace

E. Enabling resumable space allocation by setting the RESUMABLE_TIMEOUT parameter to a nonzero value

정답: B,D

문제2

In your database, USERS is the default permanent tablespace.
Examine the commands and their outcome:

You plan to execute the commands:

Which two statements are true? (Choose two.)

A. The CREATE TABLE statement generates an error because the SYSDBA privilege does not provide any space quota on the SYSTEM tablespace by default.

B. The MYTAB table is created in the USERS tablespace but no rows can be inserted into the table by USER02.

C. The MYTAB table is created in the SYSTEM tablespace and rows can be inserted into the table by USER02.

D. The MYTAB table is created in the SYSTEM tablespace but no rows can be inserted into the table by USER02.

E. The MYTAB table is owned by the SYS user.

정답: C,E

문제3

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 회원만 볼 수 있음)

문제4

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 회원만 볼 수 있음)

문제5

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. Mandatory auditing of audit administrative actions is available in the post-migrated database.

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

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

정답: A,B

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

문제6

Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)

A. The AWR data is stored in memory and in the database.

B. All AWR tables belong to the SYSTEM schema.

C. AWR contains system wide tracing and logging information.

D. The snapshots collected by AWR are used by the self-tuning components in the database

E. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.

정답: A,D,E

문제7

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. A directory object must exist and a user performing an EXPDP or IMPDP operation must have read and write permission on that directory object.

C. 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.

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

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

정답: B,D,E

문제8

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 terminates if the SYSTEM tablespace in the source database is not autoextensible.

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

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

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

정답: D

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

문제9

Which files must you copy from the Oracle home of the database that is being upgraded to the new Oracle home for Oracle Database 12c? (Choose three.)

A. the sqlnet.ora file

B. the initialization parameter file

C. the tnsnames.ora file

D. the password file

E. the listener.ora file

정답: A,C,E

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

문제10

Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance.
What should you use to achieve this?

A. Automatic Workload Repository compare reports

B. Database replay

C. SQL Access Advisor

D. SQL Tuning Advisor

E. SQL Performance Analyzer

정답: E

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

문제11

In your database, the RESOURCE_LIMIT parameter is set to TRUE.
You create the profile:

Which two statements are true about users and their sessions that are subject to this profile? (Choose two.)

A. The PASSWORD_LIFE_TIME value is ignored because of the unlimited value of PASSWORD_REUSE_MAX.

B. These users can never reuse a password

C. The CPU_PER_CALL is ignored in the user sessions because of the unlimited value of CPU_PER_CALL

D. In each user session, the limit for LOGICAL_READS_PER_SESSION in the same as defined in the DEFAULT profile.

정답: A,D

문제12

Which three statements are true PFILEs, SPFILEs or both? (Choose three.)

A. A PFILE can be created by an idle instance

B. All SPFILE parameters can be modified successfully with the SCOPE=BOTH clause

C. Some SPFILE parameters can be modified successfully with the SCOPE=MEMORY clause

D. All SPFILE parameters can be modified successfully with the SCOPE=MEMORY clause

E. A SPFILE can be created by an idle instance

F. SPFILEs and PFILEs may both be edited with an O/S editing utility

정답: A,B,C

문제13

You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.
You plan to create the database using SQL statements.
Which three techniques can you use to achieve this? (Choose three.)

A. Specify the PDB_FILE_NAME_CONVERT initialization parameter.

B. Use Oracle Managed Files (OMF).

C. Specify the DB_FILE_NAMECONVERT initialization parameter.

D. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

E. Specify the SEED FILE_NAME_CONVERT clause.

정답: A,B,E

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

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

우리와 연락하기

유용한 링크

최신 업데이트