Oracle 1z0-074 問題集

質問 1：
In which four situations does the RMAN DUPLICATE command use the "pull" method? (Choose four.)
A. when no auxiliary channels are allocated
B. when the USING BACKUPSET clause is used
C. when IMAGE COPIES are used for the DUPLICATE operation
D. when the number of auxiliary channels allocated is less than the number of target channels allocated
E. when the USING COMPRESSED BACKUPSET clause is used
F. when the SET ENCRYPTION clause is added before the DUPLICATE command
G. when the SECTION SIZE clause is used
正解：B,D,E,G

質問 2：
Which two statements are true about a band join? (Choose two.)
A. It is a non-equijoin in which the key values in one data set must fall within the specified range of the second data set.
B. For each row in the first row source, Oracle probes the second row source for matching rows and joins them.
C. The SQL runtime engine avoids unnecessary scanning of rows that fall outside the defined ranges.
D. It returns rows for SQL statements that contain an equijoin.
E. The optimizer always uses the smaller of the two row sources to build a hash table on the join key.
正解：A,C

質問 3：
One of your databases supports an OLTP workload.
If a better plan is discovered for a statement, then you want that plan to be used.
Which two can cause better plans to be used for a statement? (Choose two.)
A. SQL Access Advisor
B. SQL Performance Analyzer
C. adaptive execution plans
D. using literals in SQL statements
E. adaptive cursor sharing
正解：A,C

質問 4：
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

質問 5：
You create and enable a unified audit policy on a database that has the default auditing configuration.

The OE user, who has the DBA role, executes these statements.

What is true about the SELECT statement and why?
A. It is not audited because audit records are stored only when unified auditing is enabled in the database.
B. It is audited because unified auditing is disabled be default.
C. It is audited because, by default, the database is in mixed auditing mode with default policies enabled.
D. It is audited because, by default, all user activities in the database are audited.
E. It is not audited because the table belongs to another schema.
正解：D

質問 6：
Examine these parameters in a PFILE used to start database instance.

Which two statements are true after an instance restart is attempted and why? (Choose two.)
A. The MEMORY_MAX_TARGET parameter is set to zero for the instance.
B. PGA_AGGREGATE_TARGET and SGA_TARGET remain 1G and 2G respectively.
C. The instance does not start because AMM is enabled but PGA_AGGREGATE_TARGET and SGA_TARGET are set to nonzero values.
D. PGA_AGGREGATE_TARGET and SGA_TARGET are set to zero for the instance.
E. MEMORY_MAX_TARGET is automatically set to 4G for the instance.
正解：A,E

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