Oracle 1Z0-052 問題集

質問 1：
The database instance has the following parameter setting:
OS_AUTHENT_PREFIX = OPS$
OS_ROLES = FALSE
REMOTE_OS_AUTHENT = FALSE
REMOTE_OS_ROLES = FALSE
TIMED_OS_STATISTICS = 0
You have a local operating system user SKD. You create a database user OPS$SKD, and then assign external authentication. The user OPS$SKD has the CREATE SESSION privilege.
What would you achieve by the above process?
A. The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.
B. The local operating system user SKD will be able to access the database instance without specifying the username and password.
C. The authentication detail for the database user OPS$SKD is recorded in the password file.
D. The database user OPS$SKD will be able to administer the database.
正解：B

質問 2：
You have to create a table, STUDENTS, with the columns: STUDENT_ID,
STUDENT_NAME, DATE_OF_BIRTH, and COURSE_ID.
The following constraints have to be enforced on this table:
1 ) Each student must be uniquely identifiable by the STUDENT_ID.
2 ) STUDENT_ID column should not be left blank.
3 ) The student should not be less than 15 years of age.
4 ) The student can only take a course that is specified in the COURSE table in the database.
Which three constrains must be explicitly enforced on this table? (Choose three.)
A. foreign key constraint on the COURSE_ID column
B. unique key constraint on the STUDENT_ID column
C. not null constraint on the DATE_OF_BIRTH column
D. primary key constraint on the COURSE_ID column
E. check constraint on the DATE_OF_BIRTH column
F. check constraint on the COURSE_ID column
正解：A,D,E

質問 3：
View the Exhibit and examine the setting for a table.

Which statement is true about the PCTFREE setting for the table?
A. It sets the minimum percentage of a data block to be reserved to contain chained rows from other blocks.
B. It sets the minimum percentage of a data block to be reserved to contain the bitmap used to maintain the free block information.
C. It sets the minimum percentage of a data block to be reserved as free space before the server prevents inserts into the block.
D. It sets the minimum percentage of a block that can be used for row data plus overhead before new rows are added to the block.
正解：C

質問 4：
You are installing Oracle Grid Infrastructure by using the Oracle Universal Installer (OUI).
You select the "Install and Configure Grid Infrastructure for a Standalone Server' option.
Which task is performed by OUI as part of this installation?
A. creation of a general purpose database
B. creation of privileged operating system group that are used for OS authentication.
C. creation of an ASM disk group and registration of ASM components with Oracle Restart
D. creation and configuration of Enterprise Managed Cloud Control on the server
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
You configured the Flash Recovery Area (FRA) for your database. The database instance is running in ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which two files are removed automatically if the space is required in the FRA as per the retention policy? (Choose two.)
A. Archived redo log files that have multiple copies in a different archive location and not backed up
B. Backups that have become obsolete
C. Flashback log files
D. User managed backups of the data files and control files
正解：B,C
解説: (Topexam メンバーにのみ表示されます)