還在猶豫 1Z0-514 題庫該選哪一家？Fast2test 提供免費範例試題，讓你在購買 Oracle Database 11g Essentials 完整題庫（共 68 題）之前，先親自檢驗內容品質再決定。

Oracle 1Z0-514 考試概覽:

Oracle 1Z0-514 考試大綱主題:

Oracle Database 11g Essentials 考生最常問的問題

最新的 Oracle Database 1Z0-514 免費考試真題：

問題 #1

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:
Which three constraints must be explicitly enforced on the table? (Choose three)

A. check constraint on the COURSE_ID column
B. not null constraint on the DATE_OF_BIRTH column
C. unique key constraint on the STUDENT_ID column
D. foreign key constraint on the COURSE_ID column
E. check constraint on the DATE_OF_BIRTH column
F. primary key constraint on the STUDENT_ID columns

問題 #2

Which two statements are true regarding indexes? (Choose two.)

A. column can have multiple indexes created on it.
B. Indexes are implicitly created by the PRIMARY KEY and UNIQUE constrains.
C. An index can be created on one or more columns.
D. Index must be created in the same tablespace as the table.

問題 #3

Which two statements are true regarding the structure of the redo logs? (Choose two.)

A. A minimum of two redo log groups is required for a database to open.
B. Each group must have the same number of members.
C. The redo log groups in a database are written to in a cyclic fashion.
D. Each group must have a minimum of two members.
E. The members within a redo log group are written to in a cyclic fashion.

問題 #4

Which two statements ore true regarding the- Database Configuration Assistant (DIKIA)? (Choose two.)

A. It can be used to change the configurations of a database only if it has been created using DBCA.
B. It can be used to delete Uu1 logical structure and physical files of a database.
C. It can be used to change the configurations of a database that has been created either manually or using DBCA.
D. It can be used to delete only the logical structure of a database.

問題 #5

View the exhibit above.

Which two statements ore true regarding the status of data file backups after31 days?
(Choose two)

A. In flash recovery area, they are marked as obsolete but retained and deleted automatically when space is required.
B. In non lash recovery area, they .ire marked as obsolete and have to be deleted manually.
C. In non flash recovery area, they are marked as obsolete but retained and deleted automatically when space is required.
D. In Rash recovery area, they are deleted immediately.

問題與答案：