最新的Oracle Database 12c: Installation and Administration - 1z0-062免費考試真題
問題1
A senior DBA asked you to execute the following command to improve performance:
SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);
You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.
What could be a reason for this recommendation?
SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);
You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.
What could be a reason for this recommendation?
正確答案: D
說明：（僅 VCESoft 成員可見）
問題2
Examine the following command:
SQL> DBMS_STATS. SET_TABLE_PREFS ('SH', 'CUSTOMERS', 'PUBLISH', 'false'); What is the effect of executing this command?
SQL> DBMS_STATS. SET_TABLE_PREFS ('SH', 'CUSTOMERS', 'PUBLISH', 'false'); What is the effect of executing this command?
正確答案: B
問題3
Which two statements are true? (Choose two.)
正確答案: C,D
問題4
What is pre-requisite to alter a role?
正確答案: D
問題5
Examine these steps:
CONNECT / AS SYSDBA
CREATE DIRECTORY dumpdir AS '/u01/app/';
Directory created.
GRANT READ, WRITE ON DIRECTORY dumpdir TO PUBLIC;
Grant succeeded.
CREATE USER TEST IDENTIFIED BY test;
User created.
GRANT CREATE SESSION, RESOURCE, UNLIMITED TABLESPACE TO test;
Grant succeeded.
CONN test/test
Connected.
CREATE TABLE test_employees (id NUMBER(3), name VARCHAR2(20), salary NUMBER(7)); Table created.
SQL> CREATE SYNONYM emp FOR test_employees;
Synonym created.
Now examine this command:
$ expdp test/test DIRECTORY=dumpdir DUMPFILE=test_emp.dmp LOGFILE=test.log TABLES=emp CONTENT=data_only query='EMP:"WHERE salary=12000"' What is true about the execution of this command?
CONNECT / AS SYSDBA
CREATE DIRECTORY dumpdir AS '/u01/app/';
Directory created.
GRANT READ, WRITE ON DIRECTORY dumpdir TO PUBLIC;
Grant succeeded.
CREATE USER TEST IDENTIFIED BY test;
User created.
GRANT CREATE SESSION, RESOURCE, UNLIMITED TABLESPACE TO test;
Grant succeeded.
CONN test/test
Connected.
CREATE TABLE test_employees (id NUMBER(3), name VARCHAR2(20), salary NUMBER(7)); Table created.
SQL> CREATE SYNONYM emp FOR test_employees;
Synonym created.
Now examine this command:
$ expdp test/test DIRECTORY=dumpdir DUMPFILE=test_emp.dmp LOGFILE=test.log TABLES=emp CONTENT=data_only query='EMP:"WHERE salary=12000"' What is true about the execution of this command?
正確答案: A
問題6
You have a production Oracle 12c database running on a host.
You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database.
The steps in random order:
1. Create directory structures similar to the production database on all new machines.
2. Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.
3. Create a database clone template for the database.
4. Run the Database Configuration Assistant (DBCA) to create the database.
5. Run OUI in graphical mode on each machine.
6. Run OUI in silent mode using the OUI response file.
Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.
You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database.
The steps in random order:
1. Create directory structures similar to the production database on all new machines.
2. Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.
3. Create a database clone template for the database.
4. Run the Database Configuration Assistant (DBCA) to create the database.
5. Run OUI in graphical mode on each machine.
6. Run OUI in silent mode using the OUI response file.
Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.
正確答案: E
問題7
Which two statements are true about Oracle Managed Files (OMF)? (Choose two.)
正確答案: A,E
說明：（僅 VCESoft 成員可見）
問題8
What should you do to ensure that a job stores minimal job metadata and runtime data on disk, and uses only existing PL/SQL programs?
正確答案: D
說明：（僅 VCESoft 成員可見）
問題9
Your database instance has Automatic Memory Management enabled and supports shared server connections.
Examine the following:
1. Parallel execution messages and control structures
2. Local variables for a process
3. Security and resource usage information
4. Runtime memory values, such as rows retrieved for a SQL statement using a serial execution plan
5. SQL execution work areas
Which option indicates what is allocated from the large pool in this instance?
Examine the following:
1. Parallel execution messages and control structures
2. Local variables for a process
3. Security and resource usage information
4. Runtime memory values, such as rows retrieved for a SQL statement using a serial execution plan
5. SQL execution work areas
Which option indicates what is allocated from the large pool in this instance?
正確答案: B
問題10
You set the following parameters in the parameter file and restart the database instance:
Which two statements are true? (Choose two.)
Which two statements are true? (Choose two.)
正確答案: A,B
問題11
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.)
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.)
正確答案: B,D
問題12
Which two statements are true about SQL *Loader Express Mode in an Oracle 12c database? (Choose two.)
正確答案: A,D
說明：（僅 VCESoft 成員可見）
問題13
Examine this command executed on a client that is remote from the database server.
SQL> CONNECT hr/hr@orcl
Which two are required for this command to connect the SQLPLUS client to a database instance? (Choose two.)
SQL> CONNECT hr/hr@orcl
Which two are required for this command to connect the SQLPLUS client to a database instance? (Choose two.)
正確答案: C,E
問題14
Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache.
What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?
What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?
正確答案: E
說明：（僅 VCESoft 成員可見）
問題15
What is the outcome of the SHUTDOWN ABORT command?
正確答案: A
