最新的Oracle 1z1-062免費考試真題

問題1

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

A. Perform a rolling upgrade.

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

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

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

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

正確答案: A,E

問題2

You use multiple temporary tables frequently in your database. Which two are benefits of configuring temporary undo? (Choose two.)

A. Performance improves because data manipulation language (DML) operations performed on temporary tables do not use the buffer cache.

B. Performance improves because less redo is written to the redo log.

C. Performance improves because no redo and undo are generated for the temporary tables.

D. Temporary undo reduces the amount of undo stored in undo tablespaces.

正確答案: B,D

問題3

You executed a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTS table to the OCP schema.
The RECYCLE_BIN enabled before the DROP USER was executed and the OCP user has been granted the FLASHBACK ANY TABLE system privilege.
What is the quickest way to recover the contents of the OCA.EXAM_RESULTS table to the OCP schema?

A. Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO
EXAM_RESULTS; connected as the OCP user.

B. Recover the table using traditional Tablespace Point In Time Recovery.

C. Recover the table using Automated Tablespace Point In Time Recovery.

D. Recovery the table using Database Point In Time Recovery.

E. Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO
OCP.EXAM_RESULTS; connected as SYSTEM.

正確答案: C

說明：（僅 Fast2test 成員可見）

問題4

What happens if a maintenance window closes before a job that collects optimizer statistics completes?

A. The job is terminated but the gathered statistics are not published.

B. The job continues to run until all statistics are gathered.

C. The job is terminated and the gathered statistics are not saved.

D. The job is terminated and statistics for the remaining objects are collected the next time the maintenance window opens.

正確答案: D

說明：（僅 Fast2test 成員可見）

問題5

Your database is configured in ARCHIVELOG mode, and daily full database backups are taken. RMAN is configured to perform control file autobackups.
Which statement is true about the loss of a duplexed control file?

A. The database instance aborts and a control file restore operation does not require media recovery.

B. The database instance remains open and the control file can be restored without shutting down the database.

C. The database remains open but transactions are not permitted.

D. The database instance aborts, and media recovery is required after restoration of the control file to open the database.

正確答案: B

問題6

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

A. You cannot start up or shut down a database Instance by using EM express.

B. You can use EM express to manage multiple databases running on the same server.

C. By default, EM express is available for a database after database creation.

D. You can create and configure pluggable databases by using EM express.

E. You can perform basic administrative tasks for pluggable databases by using the EM express interface.

正確答案: A

說明：（僅 Fast2test 成員可見）

問題7

You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:

Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table? (Choose three.)

A. The valid time columns are not populated by the Oracle Server automatically.

B. The valid time columns are visible by default when the table is described.

C. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

D. The valid time columns employee_time_start and employee_time_end are automatically created.

E. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

正確答案: A,D,E

問題8

You ran this command on a source database:
$> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLES=emp_dept On the target database, you run this command:
$> impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLES=emp_dept Which two statements are true? (Choose two.)

A. The impdp operation creates EMP_DEPT as a view

B. The expdp operation exports all rows that are displayed when querying the EMP_DEPT view with no filter

C. The expdp operation exports the table definitions for tables that are queried in the EMP_DEPT view.

D. The impdp operation creates EMP_DEPT as a table

E. The impdp operation creates separate tables for each table contained in the defining query of the EMP_DEPT view

F. The expdp operation exports all rows for tables contained in the defining query of the EMP_DEPT view

正確答案: C,D

問題9

The HR schema exists in databases, BOSTON and DENVER, with the same password, HR.
You have CREATE DATABASE LINK and CREATE SESSION privileges in both databases.
DENVER is defined as a service name in the tnsnames.ora of both databases.
You plan to use this command:
CREATE DATABASE LNK hr_link CONNECT TO hr IDENTIFIED BY hr USING 'DENVER'; What must be done to ensure that all users in BOSTON can access the HR schema in DENVER?

A. Execute the command as HR in BOSTON and SYS in DENVER.

B. Execute the command as SYS in BOSTON.

C. Execute the command as SYS in both databases.

D. Change the command to create a public database link in BOSTON.

E. Change the command to create a public database link in DENVER.

F. Execute the command as SYS in DENVER.

正確答案: A

問題10

You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? (Choose two.)

A. control file autobackups

B. backup pieces

C. copies of all parameter files

D. trace file generated using BACKUP CONTROLFILE TO TRACE

正確答案: A,B

問題11

You are administering a database and you receive a requirement to apply the following restrictions:
1. A connection must be terminated after four unsuccessful login attempts by user.
2. A user should not be able to create more than four simultaneous sessions.
3. User session must be terminated after 15 minutes of inactivity.
4. Users must be prompted to change their passwords every 15 days.
How would you accomplish these requirements?

A. By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE.

B. by granting a secure application role to the users

C. by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to FALSE

D. By creating and assigning a profile to the users and setting the
SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4

E. By implementing the database resource Manager plan and setting the
SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.

正確答案: B

說明：（僅 Fast2test 成員可見）

問題12

Automatic Shared Memory Management is enabled for your database instance. You notice that there are SQL statements performing poorly because of repeated parsing activity.
Which action generates recommendations to overcome the performance issues?

A. running the Memory Advisor for the library cache

B. running the Memory Advisor for the SGA

C. running the Memory Advisor for the PGA

D. running the Memory Advisor for the buffer cache

正確答案: A

最新的Oracle Database 12c: Installation and Administration - 1z1-062免費考試真題

聯系我們

站內鏈接

最新更新