[多项选择] Mysqldump was used to create a single schema backup; Shell> mysqldump –u root –p sakila > sakila2013.sql Which two commands will restore the sakila database without interfering with other running database?（）
A. Mysql＞ USE sakila; LOAD DATA INFILE 'sakila2013.sql';
B. Shell＞ mysql –u root –p sakila sakila2013.sql
C. Shell＞ mysql import –u root –p sakila sakila2013.sql
D. Shell＞ mysql  –u root -p  –e 'use sakila; source sakila2013.sql'
E. Shell＞ mysql  –u root  –p  –silent ＜ sakila2013.sql

[单项选择]An administrator is creating a comprehensive backup system to backup a single web server.Which of the following is the BEST way to provide full restore?（）
A. Take an image backup nightly while the server is online.
B. Take an incremental backup while the server is offline.
C. Take a monthly snapshot backup while the server is online.
D. Take a differential backup while the server is online.

[单项选择]Which mode is used to allow only a single person to edit a configuration?（）
A. configure batch
B. configure private
C. configure exclusive
D. configure dynamic

[单项选择]You are performing a backup of your database across the network. While taking the backup， you want to save space on the storage media and reduce the network bandwidth. Which command will you issue to configure the required type of backup？（）
A.  CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO BACKUPSET；
B.  CONFIGURE DEVICE TYPE TO disk BACKUP TYPE TO COPY；
C.  CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED BACKUPSET；
D.  CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED COPY；

[填空题]XML使用（）或者Schema来描述数据。

[多项选择] Consider the events_% tables in performance Schema. Which two methods will clear or reset the collected events in the tables?（）
A. Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_current
B. Using the statement RESET PERFORMANCE CACHE
C. Using the statement FLUSH PERFORMANCE CACHE
D. Using TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_current
E. Disabling and re-enabling all instruments
F. Restarting Mysql

[多项选择] The EMP table exists in your schema. You want to execute the following query: SELECT ename, sal FROM emp AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE) WHERE ename = 'ALLEN'; What are the minimum requirements for the statement to execute successfully? （）
A. ARCHIVELOG mode must be enabled
B. Row Movement must be enabled for the table
C. FLASHBACK must be set to ON for the database
D. The UNDO_MANAGEMENT parameter must be set to AUTO
E. The UNDO_RETENTION parameter must be set appropriately

[单项选择]The schema theory is an important element in ______ , which is "action-based", more concerned with the process of learning than what is learnt.

[单项选择]Suppose we have the relation schema R(A,B,C,D) with functional dependencies ;F{A→ B,B→C,C→D,D→A},then R(A,B,C,D) at least is in
A. 1NF
B. 2NF
C. 3NF
D. BCNF

[单项选择] You dropped a schema of a user in an Oracle 10g by mistake. You decide to flash the database back to its previous state to restore the deleted schema.   Which process writes the before images of the physical database blocks to the flashback database logs？（）
A.  LGWR
B.  DBWR
C.  MMON
D.  RVWR

[单项选择]下列哪些方法被用来安装Active Directory Schema夹（）
A. 在Control Panel中，使用Add/Remove Programs
B. 从Active Directory中，创建一个新的Server对象
C. 运行DCPROMO，选定Schema
D. 上面的任何一个

[单项选择] You want to import schema objects of the HR user using Oracle Data Pump from the development database，DEVDB， to the production database， PRODDB. A database link devdb.us.oracle.com is created betweenPRODDB and DEVDB. You execute the following command on the PRODDB database server：$ impdp system/manager directory = DB_DATAdumpfile = schemas.datschemas = hr flashback_time = "TO_TIMESTAMP（’25-08-2007 14：35：00’， ’DD-MM-YYYY HH24：MI：SS’）"The command fails displaying the following error：ORA-39001： invalid argument valueORA-39000： bad dump file specification ORA-31640： unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-27037： unable toobtain file status What would you do to overcome the error（）
A. Add the user， SYSTEM， to the schemas option.
B. Add the network_link = devdb.us.oracle.com option.
C. Change the dumpfile option to schema.dat@devdb.us.oracle.com.
D. Replace the schemas option with the network_link = devdb.us.oracle.com
E. Replace the dumpfile option with the network_link = devdb.us.oracle.com

[单项选择] You discover that the schema changes that were recently made to your SQL Server 2005 database have caused your Web site to stop functioning. It is unclear who made the changes. TestKing.com now mandates that all changes to the database schema be tracked. You need to implement a mechanism that will track schema changes in your database.  What should you do？（）
A. Implement a stored procedure that writes data about schema changes to a log table.
B. Implement DDL AFTER triggers that write user and schema information to a log table.
C. Implement a DML INSTEAD OF trigger that writes data about schema changes to a log table.
D. Implement a DML AFTER trigger that writes data about schema changes to a log table.

[判断题]因为Single类型的变量可存储数值的范围大于Long类型的变量，所以Single类型占用内存大于Long类型。

[单项选择]What are nitrates used for
A. They preserve flavor in packaged foods.
B. They preserve the color of meats.
C. They are the objects of research.
D. They cause the animals to become fatter.

[单项选择]When using keyboard shortcuts, which single keystroke combination allows users to erase the entire current command?（）
A. Ctrl + a
B. Ctrl + e
C. Ctrl + u
D. Ctrl + w

[单项选择]your company has a single active directory forest that has a domain in North America named na.contoso.com and a domain in south America named sa.contoso.com. The client computers run windows vista. You need to configure the client computes in north America office to improve the name resolution response time for resources in the south ameirca offica. What should you do?（）
A. Configure a new GPO that disables the Local-Link multicast name resolution feature. Apply the policy to all the client computes in the north America office.
B. Configure a new GPO that enables the local-Link Multicast name resolution feature. Apply the policy to all the client computers in the north America office.
C. Configure a new GPO that configures the DNS suffix search list option to sa. Contoso.com, na.contoso.com apply the policy to all the client computers in the north America office.
D. Configure the priority value for the SRV records on each of the north America domain controllers to 5.

[单项选择] Your network consists of a single Active Directory domain. All computers on the network are joined to the domain. You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). You install a network management application named App1 on Server1. A user named Admin1 logs on to Server1 and reports that the shortcut to App1 does not exist. You log on to Server1 as a local administrator and verify that the shortcut to App1 exists. You need to ensure that a shortcut to App1 is available for Admin1 on Server1 only. What should you do? （）
A. Log on to Server1 as a local administrator. Create a shortcut to App1 in the Default User profile.
B. Log on to Server1 as a local administrator. Create a shortcut to App1 in the All Users profile.
C. In the Netlogon share on a domain controller, create a folder named Default User. Create a shortcut for App1 in the new folder.
D. In the Netlogon share on a domain controller, create a folder named All Users. Create a shortcut for App1 in the new folder.