单选题Which statement is true regarding synonyms?（）A Synonyms can be created only for a table B Synonyms are used to reference only those tables that are owned by another user C A public synonym and a private synonym can exist with the same name for the same

第1题：

Which three statements are true regarding subqueries?（）

• A、Subqueries can contain GROUP BY and ORDER BY clauses 
• B、Main query and subquery can get data from different tables 
• C、Main query and subquery must get data from the same tables 
• D、Subqueries can contain ORDER BY but not the GROUP BY clause 
• E、Only one column or expression can be compared between the main query and subquery
• F、 Multiple columns or expressions can be compared between the main query and subquery

第2题：

Which statements are true regarding the Query Result Cache？（） 

• A、 It can be set at the system， session， or table level.
• B、 It is used only across statements in the same session.
• C、 It can store the results from normal as well as flashback queries.
• D、 It can store the results of queries based on normal，temporary，and dictionary tables.

第3题：

第4题：

Which three statements are true regarding single-row functions？（）

• 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.

第5题：

The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR;（）

• A、You obtain the results retrieved from the public synonym HR created by the database administrator.
• B、You obtain the results retrieved from the HR table that belongs to your schema.
• C、You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
• D、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
• E、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.

第6题：

Which statement is true regarding virtual private catalogs?（）

• A、A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.
• B、The virtual private catalog owner cannot create and modify the stored scripts.
• C、The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.
• D、To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database

第7题：

Which three are true?（）

• A、A MERGE statement is used to merge the data of one table with data from another.
• B、A MERGE statement replaces the data of one table with that of another.
• C、A MERGE statement can be used to insert new rows into a table.
• D、A MERGE statement can be used to update existing rows in a table.

第8题：

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

第9题：

Which statements are true regarding system-partitioned tables？（）  

• A、 Only a single partitioning key column can be specified.
• B、 All DML statements must use partition-extended syntax.
• C、 The same physical attributes must be specified for each partition.
• D、 Unique local indexes cannot be created on a system-partitioned table.
• E、 Traditional partition pruning and partitionwise joins are not supported on these tables.

第10题：

User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She has the privilege to create a public synonym, and would like to create a synonym for this view that can be used by all users of the database.Which SQL statement can Mary use to accomplish that task?（）

• A、CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu
• B、CREATE PUBLIC SYNONYM EDL:VU FOR mary (emp_dept_loc_vu);
• C、CREATE PUBLIC SYNONYM EDL_VU FOR emp _dept_loc_vu;
• D、CREATE SYNONYM EDL_VU ON emp_dept_loc_vu FOR EACH USER;
• E、CREATE SYNONYM EDL_VU FOR EACH USER ON emp_dept_loc_vu
• F、CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu FOR ALL USERS;