Oracle 1Z0-052 問題集

質問 1：
SQL> CREATE BIGFILE TABLESPACE MRKT
2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING
3 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT;
Database altered.
Which two statements are true regarding the MRKT tablespace? (Choose two.)
A. The tablespace can be dropped with the current setting with segments present in it.
B. Segment space is managed by free lists in the tablespace.
C. No more data files can be added to the tablespace.
D. A user created without being assigned a default tablespace uses this tablespace.
正解：C,D

質問 2：
Examine these components:
* Execution plan for a non-embedded SQL statement
* Local, global, and package variables for a session
* Execution plan for a SQL statement contained in a PL/SQL program unit
* Results of executed queries and query fragments
* PL/SQL function result sets
Which of these are stored in the shared SQL area?
A. 1, 2, 4, and 5
B. 1 and 4
C. 1, 2, and 3
D. 1 and 3
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
You have decided to implement the principle of least privilege and separation of duties.
Which two actions must you take? (Choose two.)
A. Assign the OSOPER and OSDBA groups to the Oracle software owner O/S account
B. Assign different O/S groups to the OSOPER and OSDBA credentials
C. Assign the DBA role to application schema owners
D. Grant access to the Oracle software owner O/S account to all database administrators
E. Grant SYSOPER to application schema owners
正解：B,C

質問 4：
Your database instance is running with full workload after database creation. You have decided to use a fixedsize undo tablespace. You want to use the undo Advisor to estimate the capacity of the undo tablespace.
Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undo tablespace? (Choose two.)
A. The size of the Flash Recovery Area for the database instance
B. The expected length of the longest-running query
C. The number of undo tablespaces in the database
D. The retention period to support flashback
正解：B,D

質問 5：
Which is true about invalid PL/SQL objects?
A. They can be manually recompiled only by using SQL commands.
B. They are automatically recompiled against the new definition of a referenced object at the same time as the modified referenced object.
C. They are automatically recompiled against the new definition of a referenced object when they are called.
D. They must be manually recompiled before they can be used if a DDL is performed on a table that is referenced in the PL/SQL object.
正解：C