You are working on the APPDB database as a DB A. The databas

题目
单选题
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.

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第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?()

  • 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.

正确答案:D

第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?()

  • A、 V$FLASHBACK_DATABASE_LOG
  • B、 V$FLASHBACK_DATABASE_STAT
  • C、 V$DATABASE
  • D、 V$UNDOSTAT

正确答案:A

第3题:

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.

正确答案:A,C

第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?()

  • 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.

正确答案:D

第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?()

  • A、Host naming
  • B、Local naming
  • C、Easy Connect
  • D、External naming
  • E、directory naming

正确答案:E

第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?()

  • 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.

正确答案:C

第7题:

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.

正确答案:B,D

第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?()

  • 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.

正确答案:D

第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?()

  • 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. 

正确答案:D

第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?()

  • A、BACKUP LOG DB1 TO DISK = 't:/backups/db1.trn'; 
  • B、BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH DIFFERENTIAL; 
  • C、BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH NOUNLOAD; 
  • D、BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH COPY_ONLY; 

正确答案:D

更多相关问题