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：
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

質問 3：
Identify two operations for which the bkup_api utility can be used. (Choose two.)
A. to define the cycle period for backups
B. to define which system files are backed up
C. to define the retention period for backups
D. to define which database configuration files are backed up
E. to define the frequency of automatic backups
正解：A,C

質問 4：
USER1 is an OS user with the password oracle and is only a member of the oinstall group.
In the ORCL database, the OS_AUTHEN_PREFIX value is ops$.
Examine these commands executed by the DBA:
SQL> CREATE USER ops$user1 IDENTIFIED externally;
SQL> GRANT create session TO ops$user1;
How can USER1 be given the SYSRAC privilege?
A. Grant SYSDBA to ops$user1
B. Grant SYSRAC to ops$user1.
C. Make USER1 a member of the OSRACDBA group in Linux or the ORA_%HOMENAME%_SYSRAC group in Windows.
D. Grant SYSRAC to user1.
E. Make User1 a member of the OSDBA group in Linux or the ORA_%HOMENAME%_SYSDBA group in Windows only.
正解：B

質問 5：
In your CDB1 container database, the DB_CREATE_FILE_DEST parameter is set to
'/u01/app/oracle/oradata'.
CDB1 has an application container called REGIONS_APP.
There are no seeds for REGIONS_APP and there are no other application containers.
You plan to execute this command.
CREATE PLUGGABLE DATABASE AS SEED ADMIN USER seed_adm IDENTIFIED BY admin_123; What must you do for the command to execute successfully?
A. Set the current container to CDB1
B. Add the FILE_NAME_CONVERT clause to the command
C. Add the CREATE_FILE_DEST clause to the command
D. Set the current container to REGIONS_APP
E. Set the PDB_FILE_NAME_CONVERT parameter to '/u01/app/oracle/oradata'
正解：E

質問 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：
You plan to use Information Lifecycle Management (ILM) for the ORDERS table.
Which is true about Heat Map statistics when HEAT_MAP is ON?
A. They are collected only for the ORDERS table if it has an associated ADO policy.
B. They are collected for all segments and are stored in the SYSAUX tablespace.
C. They are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and are stored in the SYSTEM tablespace.
D. They are collected for all segments and are stored in the SYSTEM tablespace.
E. They are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and are stored in the SYSAUX tablespace.
正解：D

質問 8：
In an Oracle 12c Release 2 database, USER1 has CREATE SESSION, CREATE PROCEDURE, and CREATE FUNCTION privileges.
Examine these commands:

SYS executes this command:
SQL> SELECT add_num(1,2) FROM DUAL;
What is the result?
A. Only "3" is displayed
B. TESTDBA is created with the SYSDBA privilege only
C. An error is returned
D. The message "The result is 3" only is displayed
E. TESTDBA is created will the SYSDBA privilege and the message "The result is 3" is displayed
正解：C