Oracle 1z0-074 問題集

質問 1：
In TESTDB, U1 has SYSDBA privileges and the password Oracle_4U.
You recreate the password file:
$ orapwd FILE=orapwtestdb FORMAT=12.2 password=Oracle_123 ENTRIES=5
Examine the command and result:
$ sqlplus u1/Oracle_4U@testdb as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied
What can you do to fix this error?
A. Restart the database instance.
B. Set the REMOTE_LOGIN_PASSWORDFILE parameter value to NONE.
C. Change the password of U1 to Oracle_123.
D. Recreate the password file with the password set to Oracle_4U.
E. Regrant SYSDBA to U1.
正解：D

質問 2：
Examine these steps to create a Transparent Sensitive Data Protection (TSDP) policy with unified auditing to protect sensitive data in certain table columns:
* Create a TSDP policy and define the audit parameter for the audited columns.
* Create a TSDP sensitive type using DBMS_TSDP_MANAGE.ADD_SENSITIVE_TYPE.
* Associate the TSDP policy with the sensitive type by using
DBMS_TSDP_PROTECT.ASSOCIATE_POLICY.
* Enable the TSDP policy at the sensitive type level.
* Associate the column to be audited to the sensitive type by using
DBMS_TSDP_MANAGE.ADD_SENSITIVE_COLUMN.
Identify the steps in the correct sequence.
A. 2, 5, 1, 3, 4
B. 1, 2, 4, 3, 5
C. 1, 2, 3, 4, 5
D. 2, 1, 5, 3, 4
E. 2, 1, 4, 5, 3
正解：A

質問 3：
Which two statements are true about a PDB lockdown profile? (Choose two.)
A. It is enabled by default on creation.
B. It is enabled in PDBs only after the CDB to which the PDBs belong is restarted.
C. It is enabled by using the PDB_LOCKDOWN parameter in each PDBs where it needs to be applied.
D. It is created by a local user with the SYSDBA privilege in each PDB where it needs to be applied.
E. It is created by a common user with the SYSDBA privilege in each PDB where it needs to be applied.
F. It is created by a common user with the SYSDBA privilege in CDB$ROOT.
正解：C,F

質問 4：
HR.EMP.EMPLOYEE_ID is the primary key of the HR.EMP partitioned table, which contains 108 rows and resides in the EXAMPLE tablespace.
HR executes this command:
SQL> CREATE TABLE employees TABLESPACE users FOR EXCHANGE WITH TABLE hr.emp; Table created.
Which two statements are true? (Choose two.)
A. The column names HR.EMP and HR.EMPLOYEES are identical.
B. Dependent objects of HR.EMP are automatically created for HR.EMPLOYEES.
C. HR.EMPLOYEES.EMPLOYEE_ID is the PRIMARY KEY of HR.EMPLOYEES
D. The column order HR.EMP and HR.EMPLOYEES are identical
E. HR.EMP is moved to the USERS tablespace.
F. The HR.EMPLOYEES table has 108 records.
正解：A,D

質問 5：
You create a refreshable copy PDB, PDB_COPY, from the PDB_ORG PDB by using the REFRESH MODE EVERY 5 MINUTES clause.
What happens every five minutes?
A. An automatic refresh is done provided PDB_COPY is in read-only mode; otherwise the refresh is deferred and attempted again after five minutes.
B. PDB_COPY'S state is automatically changed to read-only and then reopened as read-write after the refresh is complete.
C. PDB_COPY is automatically closed provided there is no ongoing transaction in PDB_ORG and then reopened as read-only after the refresh is complete.
D. An automatic refresh is done provided PDB_COPY is closed; otherwise the refresh is differed and attempted again after five minutes.
E. PDB_COPY'S state is automatically changed to read-write and back to read-only after the refresh is complete.
正解：A

質問 6：
Identify a situation where performance profiles can be used for application containers.
A. to specify the total number of parallel execution servers available
B. to enforce a limit on I/O throughput per second
C. to enforce a limit on the number of I/OS issued per second
D. to specify the maximum percentage of the parallel execution server pool that a particular application container can use
E. to specify the maximum time, in seconds, that a parallel statement can wait in the parallel statement queue before it is timed out
正解：A

質問 7：
In a database on an Oracle Exadata Database machine, a DBA executes this command:
SQL> exec DBMS_INMEMORY_ADMIN.ENABLE_FASTSTART ('fs_tbs');
What is the result?
A. Any data in the In-Memory column store is copied in row major format to the FS_TBS tablespace.
B. Any data in the In-Memory column store is copied in uncompressed columnar format to the FS_TBS tablespace.
C. Any data in the In-Memory column store is copied in compressed columnar format to the FS_TBS tablespace.
D. All columns for all tables in the FS_TBS tablespace are loaded into the In-Memory column store.
正解：D