killtest分享最新的oracle 认证考试资料

1z0-047 资料的最新分享，下面一些题目是从最新的题库中精心整理出来的，质量很高，需要的朋友看过来的啊。

1. Which statements are true? (Choose all that apply.)

A. The data dictionary is created and maintained by the database administrator.

B. The data dictionary views can consist of joins of dictionary base tables and user-defined tables.

C. The usernames of all the users including the database administrators are stored in the data dictionary.

D. The USER_CONS_COLUMNS view should be queried to find the names of the columns to which a constraint applies.

E. Both USER_OBJECTS and CAT views provide the same information about all the objects that are owned by the user.

F. Views with the same name but different prefixes, such as DBA, ALL and USER, use the same base tables from the data dictionary

Answer: CDF

2. Which three statements are true regarding single-row functions? (Choose three.)

A. They can accept only one argument.

B. They can be nested up to only two levels.

C. They can return multiple values of more than one data type.

D. They can be used in SELECT, WHERE, and ORDER BY clauses.

E. They can modify the data type of the argument that is referenced.

F. They can accept a column name, expression, variable name, or a user-supplied constant as arguments.

Answer: DEF

3. Which two statements are true regarding operators used with subqueries? (Choose two.)

A. The NOT IN operator is equivalent to IS NULL.

B. The

C. =ANY and =ALL operators have the same functionality.

D. The IN operator cannot be used in single-row subqueries.

E. The NOT operator can be used with IN, ANY and ALL operators.

Answer: BE

4. Which two statements are true regarding views? (Choose two.)

A. A simple view in which column aliases have been used cannot be updated.

B. A subquery used in a complex view definition cannot contain group functions or joins.

C. Rows cannot be deleted through a view if the view definition contains the DISTINCT keyword.

D. Rows added through a view are deleted from the table automatically when the view is dropped.

E. The OR REPLACE option is used to change the definition of an existing view without dropping and re-creating it.

F. The WITH CHECK OPTION constraint can be used in a view definition to restrict the columns displayed through the view.

Answer: CE

5. Which two statements are true about sequences created in a single instance database? (Choose

two.)

A. The numbers generated by a sequence can be used only for one table.

B. DELETE would remove a sequence from the database.

C. CURRVAL is used to refer to the last sequence number that has been generated.

D. When the MAXVALUE limit for a sequence is reached, you can increase the MAXVALUE limit by using the ALTER SEQUENCE statement.

E. When a database instance shuts down abnormally, the sequence numbers that have been cached but

not used would be available once again when the database instance is restarted.

Answer: CD

6. Which statements are correct regarding indexes? (Choose all that apply.)

A. When a table is dropped, the corresponding indexes are automatically dropped.

B. For each DML operation performed, the corresponding indexes are automatically updated.

C. Indexes should be created on columns that are frequently referenced as part of an expression.

D. A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index.

Answer: ABD

  需要下载更多的题库资料的朋友可以登录 或者加我的QQ: 1044723042

你都将的到一份意外的收获。