单选题You are working on the APPDB database as a DB A. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1： DROP FLASHBACK ARCHIVE fla1； What is the effect of this command？（）A The Flashback Archive FLA1 is dropped only if it is empty.B The tablespace having Flashback Archive is dropped.C The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.D The Flashback Data Archive and historical data are dropped.
单选题
You are working on the APPDB database as a DB A. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1： DROP FLASHBACK ARCHIVE fla1； What is the effect of this command？（）
A
The Flashback Archive FLA1 is dropped only if it is empty.
B
The tablespace having Flashback Archive is dropped.
C
The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
D
The Flashback Data Archive and historical data are dropped.
参考解析
解析：
暂无解析
相关考题：
You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）A、 Flashback logs are not archived.B、 Flashback logs are maintained in redo log files.C、 Flashback logs are maintained in the Flash Recovery Area.D、 Flashback logs are used to maintain Flashback Database related errors.E、 Flashback logs need to be cleared manually after you disable Flashback Database.
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. The company stores clients data in DB1. Clients can access their profile data by using a Web application. You must ensure the security of the customer data, you must ensure that even if the backup media is lost, data files, log files and subsequent backups and so on are quite safe. So what action should you perform to achieve this goal?（）A、For both the CustomerDB database and the master database, enable Transparent Database Encryption.B、You should use the built-in encryption functions to encrypt the sensitive data at the cell level. C、You should make the CustomerDB database accessible only through stored procedures and functions. D、For the CustomerDB database, enable Transparent Database Encryption and back up the transaction log.
You are working on the APPDB database as a DB A. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1： DROP FLASHBACK ARCHIVE fla1； What is the effect of this command？（）A、 The Flashback Archive FLA1 is dropped only if it is empty.B、 The tablespace having Flashback Archive is dropped.C、 The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.D、 The Flashback Data Archive and historical data are dropped.
You are working on the 24X7 database with high transaction volume， to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database？（）A、The database performance would be enhanced.B、The redo log files would be get filled more frequently.C、The overall database performance would be degraded.D、The mean time to recover （MTTR） would be increased.
You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）A、 V$FLASHBACK_DATABASE_LOGB、 V$FLASHBACK_DATABASE_STATC、 V$DATABASED、 V$UNDOSTAT
In which two cases would you perform only consistent backup？（）A、You are working on a database where downtime is not tolerated.B、You are working on a database where downtime can be tolerated.C、You are working on a database that operates in ARCHIVELOG mode.D、You are working on a database that operates in NOARCHIVELOG mode.E、You are working on a database where all the tablespaces are locally managed.F、You are working on a database where control files and redo log files are multiplexed.G、You are working on a database where control files and redo log files are not multiplexed.
You work as a database administrator for Supportcenter.cn. You are using three database， SupportCenter DB01， SupportCenter DB02， and SupportCenter DB03， on different host machines in your development environment. The database server configuration， such as IP address and listener port number， change frequently due to development requirements， and you have the task of notifying the developers of the changes. Which connection method would you use to overcome this overhead？（）A、Host namingB、Local namingC、Easy ConnectD、External namingE、directory naming
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. VIP customer data of the company are stored in DB1. The customers access their profile data by using a Web application. You must ensure the security of the customer data， that is to say， even if the backup media is lost， you must guarantee that data files， log files and subsequent backups and so on are as safe as possible. So what action should you perform to achieve this goal？（）A、For both the CustomerDB database and the master database, enable Transparent Database Encryption B、You should use the built-in encryption functions to encrypt the sensitive data at the cell Ievel C、You should make the CustomerDB database accessible only through stored procedures and functions. D、For the CustomerDB database, enable Transparent Database Encryption and back up the transaction log.
You have an Exchange Server 2010 organization that contains a mailbox database named DB1.You have a backup of DB1.You need to copy a mailbox from the backup to a personal folder （PST） file.The solution must not prevent users on DB1 from accessing their mailboxes.What should you do？（）A、Restore the mailbox database to DB1 and then run the Move-Mailbox cmdlet.B、Restore the mailbox database to DB1 and then restore the mailbox.Run the New- MoveRequest cmdlet.C、Restore the mailbox database to a Recovery Mailbox database and then run the Connect- Mailbox cmdlet.D、Restore the mailbox database to a Recovery Mailbox database and then restore the mailbox.Run the Export-Mailbox cmdlet.
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. You have set the recovery model of DB1 to Full. At 2：00 There is a full database backup of all the user databases every day. Every quarter the transaction log backup is performed. Every 4 hours a differential backup is occurred. You are going to perform a full backup of DB1 at 11：00. When you perform this back up， you must make sure that the overall backup will not be affected. What'；s more， you have to restore procedures for DB1. You must make sure that the backup files are restored in proper sequence. In the options below， which Transact-SQL statement should you use？（）A、BACKUP LOG DB1 TO DISK = apos;t:/backups/db1.trnapos;; B、BACKUP DATABASE DB1 TO DISK = apos;t:/backups/db1.bakapos; WITH DIFFERENTIAL; C、BACKUP DATABASE DB1 TO DISK = apos;t:/backups/db1.bakapos; WITH NOUNLOAD; D、BACKUP DATABASE DB1 TO DISK = apos;t:/backups/db1.bakapos; WITH COPY_ONLY;
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. TheDB1 database includes spatial data types. On DB1 databse, you have to perform a database consistency check to include the spatial indexes. Besides this, you must make sure that you can reduce the effect on the database concurrency to the least. So which Transact-SQL statement should you run? （） A、DBCC CHECKCATALOG (DB1); B、DBCC CHECKALLOC (DB1) WITH TABLOCK; C、DBCC CHECKDB (DB1) WITH TABLOCK, PHYSICAL_ONLY; D、DBCC CHECKDB (DB1) WITH EXTENDED_LOGICAL_CHECKS;
You have an Exchange Server 2010 server named Server1.Server1 hosts a mailbox database named DB1 that contains 25 user mailboxes.You create a new public folder database named PUB2.You need to configure PUB2 as the default public folder database for each mailbox on DB1. Which properties should you modify？（）A、Modify the properties of each mailbox.B、Modify the properties of DB1.C、Modify the properties of Server1.D、Modify the properties of PUB2.
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 Enterprise Edition instance. There is a database named DB1 in the instance. A backup of DB1 is performed every day. You have to minimize the size of the full database backup files of DB1. In the options below, which Transact-SQL statement should you use? （） A、BACKUP DATABASE DB1 TO DISK = apos;t:/backups/db1.bakapos;; B、BACKUP DATABASE DB1 TO DISK = apos;t:/backups/db1.bakapos; WITH COMPRESSION; C、BACKUP DATABASE DB1 TO DISK = apos;t:/backups/db1.bakapos; WITH DIFFERENTIAL; D、BACKUP DATABASE DB1 TO DISK = apos;t:/backups/db1.bakapos; WITH COMPRESSION,DIFFERENTIAL;
A full backup of your database named DB1 is created automatically at midnight every day. Differential backups of DB1 occur twice each day at 10:00 and at 16:00. A database snapshot is created every day at noon. A developer reports that he accidentally dropped the Pricelist table in DB1 at 12:30. The last update to Pricelist occurred one week ago. You need to recover the Pricelist table. You want to achieve this goal by using the minimum amount of administrative effort. You must also minimize the amount of data that is lost. What should you do?（）A、 Restore the most recent backup into a new database named DB1bak. Apply the most recent differential backup. Copy the Pricelist table from DB1bak to DB1. B、 Delete all database snapshots except the most recent one. Restore DB1 from the most recent database snapshot. C、 Recover DB1 from the most recent backup. Apply the most recent differential backup. D、 Copy the Pricelist table from the most recent database snapshot into DB1.
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. In the database, a small percentage of data is modified everyday. Ever day in the morning, you have to create a read-only copy of the database for reporting purposes and make sure that you use as little disk space as possible. In the options below, which strategy should you use? （） A、You should use database snapshots B、You should use database backup and restore C、You should use database backup and restore along with compression D、You should use schema-bound views in a read-only database. The database resides on the same instance.
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. The latest differential backup is performed at 15:30, the full back up was performed at 13:30, and database snapshots were created at 16:30 and at 17:30. The backups and the database snapshots are stored on a different disk from the database files. At 17:05, the hard disk containing the database files fails at 17:02 hours. You must restore DB1 while reduce data loss to the least. So what action should you perform to achieve this goal?（） A、You should restore the full backup B、You should restore the database snapshot from 16:30 hours. C、You should restore the database snapshot from 17:30 hours D、You should restore both the full backup and the differential backup.
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. On DB1, quite few logged operations are performed. Now according to the requirement of the company CIO, you must validate that the database can be restored to a specific point in time. So what action should you perform to achieve this goal? （） A、You should verify that the simple recovery model is used by the database.B、You should verify that the full recovery model is used by the database.C、You should verify that the checksum page verify option is used by the database. D、You should verify that the bulk-logged recovery model is used by the database.
单选题You work as a database administrator for Supportcenter.cn. You are using three database， SupportCenter DB01， SupportCenter DB02， and SupportCenter DB03， on different host machines in your development environment. The database server configuration， such as IP address and listener port number， change frequently due to development requirements， and you have the task of notifying the developers of the changes. Which connection method would you use to overcome this overhead？（）AHost namingBLocal namingCEasy ConnectDExternal namingEdirectory naming
单选题You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）A V$FLASHBACK_DATABASE_LOGB V$FLASHBACK_DATABASE_STATC V$DATABASED V$UNDOSTAT
单选题You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1: DROP FLASHBACK ARCHIVE fla1,What is the effect of this command?（）AThe Flashback Archive FLA1 is dropped only if it is empty.BThe tablespace having Flashback Archive is dropped.CThe Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.DThe Flashback Data Archive and historical data are dropped.
单选题You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database. After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’ DB_RECOVERY_FILE_DEST = ’LOCATION=d：/product/10.1.0/flash_recovery_area’ DB_RECOVERY_FILE_DEST_SIZE=10g Where are the archived redo logs stored for your database？（）A The archived redo logs are stored in an operating system-dependent location.B The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.C The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.D The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and DB_RECOVERY_FILE_DEST.
多选题You are implementing transaction log shipping for a database named DB1 from a server named SQL1 to a server named SQL2. Because DB1 is 100 GB in size， it is too big to transfer over the network in a reasonable amount of time. You need to minimize the impact on the network while you initialize the secondary database. Which two actions should you perform？（）ASpecify the simple recovery model for DB1.BSpecify either the full or the bulk-logged recovery model for DB1.CPerform a complete backup of DB1 to portable media. Restore the secondary database from that backup； specify the RECOVERY option.DPerform a complete backup of DB1 to portable media. Restore the secondary database from that backup； specify the STANDBY option.EBefore you activate transaction log shipping to the secondary database， execute the following statement on the primary server.BACKUP LOG DB1 WITH TRUNCATE ONLY
多选题You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）AFlashback logs are not archived.BFlashback logs are maintained in redo log files.CFlashback logs are maintained in the Flash Recovery Area.DFlashback logs are used to maintain Flashback Database related errors.EFlashback logs need to be cleared manually after you disable Flashback Database.
单选题You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. On DB1, quite few logged operations are performed. Now according to the requirement of the company CIO, you must validate that the database can be restored to a specific point in time. So what action should you perform to achieve this goal? （）AYou should verify that the simple recovery model is used by the database.BYou should verify that the full recovery model is used by the database.CYou should verify that the checksum page verify option is used by the database. DYou should verify that the bulk-logged recovery model is used by the database.
单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. When you are absent, a user will use a login named Mary to log in and maintain the database snapshots. The user has to delete the database snapshots for DB1, so you have to give the appropriate permissions to the user. So which database permission should you give the user?（）ADELETE BCONTROL CDROP DATABASE DALTER ANY DATASPACE
单选题You network contains an Exchange Server 2010 Mailbox server.You install and configure a third-party antivirus application on the server.You discover that a mailbox database named DB1 does not mount.You attempt to mount the mailbox database and receive an error message starting that the file named E01.log cannot be found.You need to mount DB1.The solution must prevent the antivirus application from causing the same error. What should you do？（）ADisable the antivirus application.Restore E01.log from the most recent backup.Run the mount-database DB1 commandBDisable the antivirus application.Restore DB1 from the most recent backup.Run the mount-database DB1 commandCExclude the transaction log folder from the antivirus application scans.Restore E01.log from the antivirus quarentine.Run the mount-database DB1 commandDExclude the transaction log folder from the antivirus application scans.Restore DB1 from the most recent backup.Run the mount-database DB1 command
多选题In which two cases would you perform only consistent backup？（）AYou are working on a database where downtime is not tolerated.BYou are working on a database where downtime can be tolerated.CYou are working on a database that operates in ARCHIVELOG mode.DYou are working on a database that operates in NOARCHIVELOG mode.EYou are working on a database where all the tablespaces are locally managed.FYou are working on a database where control files and redo log files are multiplexed.GYou are working on a database where control files and redo log files are not multiplexed.