The Flashback Archive FLA1 is dropped only if it is empty.
The tablespace having Flashback Archive is dropped.
The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
The Flashback Data Archive and historical data are dropped.
第1题:
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?()
第2题:
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?()
第3题:
You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()
第4题:
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?()
第5题:
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?()
第6题:
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?()
第7题:
In which two cases would you perform only consistent backup?()
第8题:
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?()
第9题:
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?()
第10题:
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?()