单选题Which describes the default behavior when you create a table?（）A The table is accessible to all users.B Tables are created in the public schema.C Tables are created in your schema.D Tables are created in the DBA schema.E You must specify the schema whe

第1题：

While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）

• A、A primary key must have been created.
• B、A mapping table must have been created.
• C、An overflow tablespace must have been specified.
• D、The PCTTHRESHOLD option must have been specified.

第2题：

You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing. Which two variables would likely fix this issue?（）

• A、Table_open_cache
• B、Table_open_cache_instancs
• C、Table_definition_cache
• D、Tmp_table_size
• E、Max_heap_table_size
• F、Max_tmp_tables

第3题：

Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 isperformed（）

• A、The table created by SKD is not accessible and SKD cannot create new tables.
• B、The tables created by SKD and HR remain， but both cannot create new tables.
• C、The table created by HR remains and HR still has the CREATE TABLE system privilege.
• D、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

第4题：

You execute the following command to audit the database activities：   SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command？（）

• A、One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
• B、One audit record is created for every session when any user successfully drops a table owned by SCOTT.
• C、One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
• D、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
• E、One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

第5题：

Which describes the default behavior when you create a table?（）

• A、The table is accessible to all users.
• B、Tables are created in the public schema.
• C、Tables are created in your schema.
• D、Tables are created in the DBA schema.
• E、You must specify the schema when the table is created.

第6题：

You are granted the CREATE VIEW privilege. What does this allow you to do?（）

• A、Create a table view.
• B、Create a view in any schema.
• C、Create a view in your schema.
• D、Create a sequence view in any schema.
• E、Create a view that is accessible by everyone.
• F、Create a view only of it is based on tables that you created.

第7题：

You need to ensure that old data and current data can be queried according to the business requirements. What should you do?（）

• A、Specify a view based on the archival data table and current data tables.
• B、Specify that the data must be queried by using a stored procedure.
• C、Specify that both the archival data table and the current data tables must have indexes created on the same columns.
• D、Specify that a SQL Server Agent job must be used to copy current data into the archival data table each night.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

While designing your database， you have created the EMPLOYEES table as an index-organized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（） 

• A、A primary key must have been created.
• B、A mapping table must have been created.
• C、An overflow tablespace must have been specified.
• D、The PCTTHRESHOLD option must have been specified.

第14题：

You execute the following command to audit database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）

• A、One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.
• B、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.
• C、One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.
• D、One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
• E、One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT

第15题：

What is necessary for your query on an existing view to execute successfully? （）

• A、The underlying tables must have data.
• B、You need SELECT privileges on the view.
• C、The underlying tables must be in the same schema.
• D、You need SELECT privileges only on the underlying tables.

第16题：

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.

第17题：

Examine the following steps performed on a database instance：  1：The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION.  2：The SKD usercreates a table.  3：The SKD user grants theCREATETABLE system privilege to the HR user.  4：The HR user creates a table.  5：The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 is performed（）

• A、The table created by SKD isnot accessibleand SKD cannot create new tables.
• B、The tables created by SKD and HR remain， but both cannot create new tables.
• C、The table created by HR remains and HR still has the CREATE TABLE system privilege.
• D、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

第18题：

Examine the statement: Create synonym emp for hr. employees; What happens when you issue the statement? （）

• A、An error is generated.
• B、You will have two identical tables in the HR schema with different names.
• C、You create a table called employees in the HR schema based on you EMP table.
• D、You create an alternative name for the employees table in the HR schema in your own schema.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：