SQL Server中ALTER DATABASE可以提供以下哪些功能选项？（）

A .  Implement transactions for database queries. B .  Close database connections in the application. C .  Use Microsoft ADO.NET in the data access layer. D .  Implement a retry policy in the data access layer.

A . It updates the control file with the new location of the data file.  B . It updates only the data dictionary with the new location of the data file.  C . It changes the location of the user_data01.dbf file in the operating system.  D . It changes the location of the user_data01.dbf file in the operating system and updates the control file with the new location of the data file.

A . The command succeeds only if Automatic Memory Management is not enabled. B . The command succeeds， but you need to restart the database for changes to take effect. C . The command returns an error because the size of the redo log buffer cannot be changed dynamically. D . The parameter value is changed and it comes into effect as soon as space becomes available in theSystem Global Area （SGA）

A . The command would return an error because LOG_BUFFER is a static parameter. B . The parameter value would be changed and it would come into effect immediately. C . You need to restart the database so that parameter changes can come into effect. D . The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.

A . The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command. B .  The command will not execute successfully because resumable space allocation is enabled at the session level. C .  The command will execute successfully and resumable space will be allocated at the session level. D .  The command will execute successfully and resumable space will be allocated at the instance level.

A .  The control file will be multiplexed. B .  The control file will be recreated. C . The script containing the CREATE CONTROLFILE statement will be created. D .  The binary backup of the control file will be created.

A .  creating a table in your schema and you exceed your allocated space quota on the tablespace B .  executing a long query that involves a sort operation and the statement runs out of temporary space C .  loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit D .  creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

A . The command would return an error because LOG_BUFFER is a static parameter. B . The parameter value would be changed and it would come into effect immediately. C . You need to restart the database so that parameter changes can come into effect. D . The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.

A . 表 B . 系统数据库 C . 用户数据库 D . 视图

A . The online redo log files and online data files are opened. B . All the online data file headers are checked for consistency. C . Instance recovery is performed before opening the database. D . The path and existence of all the log file members are checked

A .  True B .  False

A . The online redo log files and online data files are opened. B . All the online data file headers are checked for consistency. C . Instance recovery is performed before opening the database. D . The path and existence of all the log file members are checked

A .  The database does not record flashback logs for MY_TABLESPACE B .  The tables residing in MY_TABLESPACE are not protected by the Recycle Bin. C .  All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature. D .  None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE

A . 实例恢复是打开数据库之前执行 B . 所有的日志文件成员的路径和存在进行检查 C . 所有的在线数据文件头进行一致性检查 D . 联机重做日志文件和联机数据文件被打开

A . The tablespace must be locally managed. B . The tablespace must have only one temp file. C . The tablespace must be made nondefault and offline. D . The tablespace can remain as the default but must have no active sort operations.

A .  The DBWn process writes to the datafile. B .  Changes in the background process are recorded. C .  The log file is updated with the current SCN number. D .  The System Change Number （SCN） is recorded in the control file. E .  The changes to the listener configuration in the listener.ora file are recorded.

A . DBCC DBREINDEX B . SELECT * FROM sys.dm_db_index_physical_stats C . DBCC INDEXDEFRAG D . SELECT * FROM sys.indexe

A .  Flashback logs are not deleted. B .  Flashback logs are deleted automatically. C .  Flashback logs are deleted only if you are using Recovery Manager （RMAN） D .  Flashback logs are deleted only if you are using Oracle Manager Files （OFM） E .  Flashback logs are deleted only if you are using Automatic Storage Management （ASM）

A . The command succeeds only if Automatic Memory Management is not enabled. B . The command succeeds， but you need to restart the database for changes to take effect. C . The command returns an error because the size of the redo log buffer cannot be changed dynamically. D . The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area （SGA）.

A .  The tablespace must be locally managed. B .  The tablespace must have only one temp file. C .  The tablespace must be made nondefault and offline. D .  The tablespace can remain as the default but must have no active sort operations.

A．SQL Server 数据库对象的分配 B．SQL Server复制代理程序的信息 C．SQL Server所用的内存缓冲区的信息 D．SQL Server数据库的信息

A．可以增加主要数据文件 B．可以删除次要数据文件 C．可以修改文件的增容方式 D．可以增加事务日志文件