最新的Oracle Database 12c: Installation and Administration - 1z1-062免費考試真題
問題1
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.)
Examine the commands and their outcome:
You plan to execute the commands:
Which two statements are true? (Choose two.)
正確答案: C,D
問題2
In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer.
Which statement is true?
Which statement is true?
正確答案: D
說明：（僅 VCESoft 成員可見）
問題3
A database uses Automatic Storage Management (ASM) as database storage, which has a diskgroup, DATA1, which is created as follows:
What happens when the FAILGRP1 failure group is corrupted?
What happens when the FAILGRP1 failure group is corrupted?
正確答案: C
問題4
Your single-instance Oracle 12c database home currently supports conventional auditing and uses Automatic Storage Management (ASM). You want to enable unified auditing by executing the command:
$ make -fins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME
Which two steps should you perform before executing this command? (Choose two.)
$ make -fins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME
Which two steps should you perform before executing this command? (Choose two.)
正確答案: B,E
說明：（僅 VCESoft 成員可見）
問題5
Which two statements are true about Oracle Data Pump export and import operations? (Choose two.)
正確答案: A,D
說明：（僅 VCESoft 成員可見）
問題6
You Execute the Following command to create a password file in the database server:
$ orapwd file = '+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12' Which two statements are true about the password file? (Choose two.)
$ orapwd file = '+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12' Which two statements are true about the password file? (Choose two.)
正確答案: C,D
問題7
Your production database uses file system storage. You want to move storage to Oracle Automatic Storage Management (ASM).
How would you achieve this?
How would you achieve this?
正確答案: D
說明：（僅 VCESoft 成員可見）
問題8
In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure:
CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2, v_SALARY NUMBER, v_dept_id NUMBER) BEGIN INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id); END;
/
GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king;
How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?
CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2, v_SALARY NUMBER, v_dept_id NUMBER) BEGIN INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id); END;
/
GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king;
How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?
正確答案: B
說明：（僅 VCESoft 成員可見）
問題9
Examine the parameter for your database instance:
You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan:
Identify the reason why the optimizer chose different execution plans.
You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan:
Identify the reason why the optimizer chose different execution plans.
正確答案: A
