单选题What is true about version-enabled tables？（）A The unit of versioning is the schema.B It is possible to version enable a table pertaining to SYS.C There are as many segments as versions for the same base table.D It is possible to create workspaces if th

第1题：

Which two statements are correct about routing tables in JUNOS?（）

• A、There are separate tables for IPv4 and IPv6 called inet.0 and inet6.0 respectively.
• B、They only contain the best possible route to each destination.
• C、All running protocols can populate the routing tables at the same time.
• D、Routes with the highest preference value are placed as active routes in the routing table.

第2题：

Which two statements are true about the primary key constraint in a table？ （）

• A、It is not possible to disable the primary key constraint.
• B、It is possible to have more than one primary key constraint in a single table.
• C、The primary key constraint can be referred by only one foreign key constraint.
• D、The primary key constraint can be imposed by combining more than one column.
• E、The non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.

第3题：

You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）

• A、MERGE
• B、SELECT …CROSS JOIN
• C、INSERT ALL …SELECT
• D、CREATE VIEW …CONSTRAINT

第4题：

Which two statements are correct regarding the Flashback Versions Query feature？（）

• A、 You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.
• B、 You can use this feature to identify the versions of V$ views.
• C、 You can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.
• D、 You can use this feature for a table only if row movement is enabled for the table.
• E、 You can use this feature to identify the versions of external and fixed tables.

第5题：

Which two statements are true about simple views？（）

• A、Views can be created as read only.
• B、Views are data segments like tables.
• C、Views can be created on the basis of more than one table.
• D、Data manipulation language （DML） operations cannot be performed on views.

第6题：

You want to implement a master-detail relation between data blocks based on object tables. How would you do this? （）

• A、Create the relation manually and coordinate the blocks using triggers. 
• B、Base the relation on a REF pointer using the Data Block Wizard. 
• C、Base the relation on a foreign key using the Data Block Wizard. 
• D、This task is not possible because master-detail relations can be implemented only for blocks based on relation tables.

第7题：

You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table：  SQL> FLASHBACK TABLE ORDERS TO SCN 771513；   What is the prerequisite to perform Flashback Table？（）

• A、 You must configure OMF in your database.
• B、 You must enable block change tracking feature in your database.
• C、 You must enable ROW MOVEMENT feature on the ORDERS table.
• D、 You must use the Flashback Version Query before using the Flashback Table feature.

第8题：

An application uses Windows Azure Table storage. The application uses five tables.  One table used by the application is approaching the limit for storage requests per second.  You need to recommend an approach for avoiding data access throttling.  What should you recommend？（）

• A、 Use a single partition key for the table.
• B、 Compress data before storing it in the table.
• C、 Create additional partition keys for the table.
• D、 Continually remove unnecessary data from the table.

第9题：

You are creating a view to join the Customers and Orders tables in a SQL Server 2005 database. You need to ensure that the view cannot be affected by modifications to underlying table schemas. You want to accomplish this goal by using the least possible amount of overhead. What should you do?（）

• A、Create CHECK constraints on the tables. 
• B、Create a DDL trigger to roll back any changes to the tables if the changes affect the columns in the view. 
• C、Create the view, specifying the WITH SCHEMABINDING option. 
• D、Create the view, specifying the WITH CHECK option. 

第10题：

第11题：

第12题：

第13题：

Which statement is true about the forwarding plane?（）

• A、The forwarding plane is the intelligence of the platform.
• B、The forwarding plane is based on an X86 architecture.
• C、The forwarding plane maintains the routing tables, bridging table, and primary forwarding table.
• D、The forwarding plane implements policers, stateless firewall filters, and class of service.

第14题：

What is true about sequences? （）

• A、Once created, a sequence belongs to a specific schema.
• B、Once created, a sequence is linked to a specific table.
• C、Once created, a sequence is automatically available to all users.
• D、Only the DBA can control which sequence is used by a certain table.
• E、Once created, a sequence is automatically used in all INSERT and UPDATE statements.

第15题：

Which three statements about subqueries are true? （）

• A、A main query can have more than one subquery.
• B、A subquery can have more than one main query.
• C、The subquery and main query must retrieve data from the same table.
• D、The subquery and main query can retrieve data from different tables.
• E、Only one column or expression can be compared between the subquery and main query.
• F、Multiple columns or expression can be compared between the subquery and main query.

第16题：

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.

第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题：

What is true about version-enabled tables？（）

• A、The unit of versioning is the schema.
• B、It is possible to version enable a table pertaining to SYS.
• C、There are as many segments as versions for the same base table.
• D、It is possible to create workspaces if there is no version-enabled table in the database.

第19题：

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.

第20题：

You are responsible for managing the database schema for an order entry application in a SQL Server 2005 database. After a design review， a member of the development staff asks you to add a new column named CommissionRate to the Product table. Because the actual commission rates for all products are not known at this time， each product has a default commission rate of 12 percent. The rate can be modified as necessary. You add the new column. You need to configure the table to assign the default value as efficiently as possible. What should you do？（）

• A、Create an INSERT trigger to assign the default value to each item in the table.
• B、Create a CHECK constraint to validate the data and to assign the default value to each item in the table.
• C、Create an UPDATE trigger to update the default value for each new item in the table.
• D、Create a DEFAULT constraint to assign the default value specifying the WITH VALUES argument.

第21题：

第22题：

第23题：