Which two statements regarding a SQL profile are true？（）A、 It is built by Automatic Tuning Optimizer.B、 It cannot be stored persistently in the data dictionary.C、 It can be used by the query optimizer automatically.D、 It can be created manually by using t

第1题：

Which two statements are true regarding the USING clause in table joins?（）

• A、It can be used to join a maximum of three tables 
• B、It can be used to restrict the number of columns used in a NATURAL join 
• C、It can be used to access data from tables through equijoins as well as nonequijoins 
• D、It can be used to join tables that have columns with the same name and compatible data types

第2题：

Which three statements regarding the server parameter file （SPFILE） are true（）

• A、An SPFILE is a binary file.
• B、An SPFILE cannot reside on a client.
• C、An SPFILE cannot contain static parameters.
• D、An SPFILE can store changes persistently across instance restarts.
• E、An SPFILE can be read by the database server， but it is not written to by the server.
• F、An SPFILE must be created manually， before creating a database， even if you use the DatabaseConfiguration Assistant （DBCA） to create the database.

第3题：

第4题：

Which two statements about the SQL Management Base (SMB) are true? （）(Choose two.)

• A、It contains only SQL profiles generated by SQL Tuning Advisor.
• B、It stores plans generated by the optimizer using a stored outline.
• C、It is part of the data dictionary and stored in the SYSAUX tablespace.
• D、It is part of the data dictionary and stored in the SYSTEM tablespace.
• E、It contains the statement log, the plan history, plan baselines, and SQL profiles.

第5题：

Which two statements are true about WHERE and HAVING clauses? （）

• A、A WHERE clause can be used to restrict both rows and groups.
• B、A WHERE clause can be used to restrict rows only.
• C、A HAVING clause can be used to restrict both rows and groups.
• D、A HAVING clause can be used to restrict groups only.
• E、A WHERE clause CANNOT be used in a query of the query uses a HAVING clause.
• F、A HAVING clause CANNOT be used in subqueries.

第6题：

Examine the following output： SQL> SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）

• A、It is ignored by the query optimizer.
• B、It is not used while the index is being rebuilt.
• C、The index cannot be rebuilt， and has to be re-created.
• D、The index is automatically rebuilt when used the next time

第7题：

Which two statements are true regarding views?（）

• A、A subquery that defines a view cannot include the GROUP BY clause 
• B、A view that is created with the subquery having the DISTINCT keyword can be updated 
• C、A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated 
• D、A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table

第8题：

第9题：

Which two statements about subqueries are true? （）

• A、A subquery should retrieve only one row.
• B、A subquery can retrieve zero or more rows.
• C、A subquery can be used only in SQL query statements.
• D、Subqueries CANNOT be nested by more than two levels.
• E、A subquery CANNOT be used in an SQL query statement that uses group functions.
• F、When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.

第10题：

Which two statements are true regarding a PL/SQL package body？（）

• A、It cannot be created without a package specification.
• B、It cannot invoke subprograms defined in other packages.
• C、It can contain only the subprograms defined in the package specification.
• D、It can be changed and recompiled without making the package specification invalid.