You have joined a new organization as a Database Administrat

题目
单选题
You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors, such as erroneously dropping users, tables, and important data, to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database, you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors, you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running?()
A

 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.

B

 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.

C

 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.

D

 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.

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

第1题:

At database startup, you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes?()

  • A、 Start the database in OPEN mode, and create a new index tablespace.
  • B、 Start the database in OPEN mode, and drop the lost index tablespace from the database.
  • C、Start the database in MOUNT mode, create a new index tablespace, and drop the lost index tablespace from the database.
  • D、 Start the database in MOUNT mode, drop the lost index tablespace from the database, open the database, and create a new index tablespace.

正确答案:D

第2题:

You have an Exchange Server 2010 organization.You acquire a new Internet domain name.Users report that they cannot receive e-mail sent to the new domain name.You verify that all users have the new domain name configured as an e-mail address suffix.You need to ensure that users can receive e-mail sent from the Internet to the new domain name. What should you create?()

  • A、an Authoritative Accepted Domain
  • B、an External Relay Accepted Domain
  • C、a new Receive connector
  • D、a remote domain

正确答案:A

第3题:

After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?()

A. Opening the database in RESTRICTED mode

B. Opening the database with the RESETLOGS option

C. Setting a new DBID for the newly restored database

D. Restoring the server parameter file (SPFILE) to the new host


参考答案:B

第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 are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations.  Which view would you query to estimate the flashback space required?()

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

正确答案:B

第6题:

In which three cases would you use the USING clause?()

  • A、You want to create a nonequijoin.
  • B、The tables to be joined have multiple NULL columns.
  • C、The tables to be joined have columns of the same name and different data types.
  • D、The tables to be joined have columns with the same name and compatible data types.
  • E、You want to use a NATURAL join, but you want to restrict the number of columns in the join condition.

正确答案:C,D,E

第7题:

You have an Exchange Server 2010 organization that contains five Mailbox servers.Your Active Directory domain contains five domain controllers in a single site. You create a new mailbox database.You notice that the database fails to mount. You need to ensure that the database mounts as soon as possible. What should you do?()

  • A、Configure all domain controllers as Global Catalog servers.
  • B、Install the Exchange Server 2010 Administration Tools on a domain controller.
  • C、Force the replication of the Active Directory Domain partition between all domain controllers.
  • D、Force the replication of the Active Directory Configuration partition between all domain controllers.

正确答案:D

第8题:

You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups.Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. ()(Choose two.)

A. Reregistering the target database in recovery catalog

B. Transporting the new tablespaces to the recovery catalog database

C. Syncronizing the recovery catalog with the target database control file

D. Performing a fresh backup of the target database to include the new data files in the catalog database


参考答案:C, D

第9题:

You work as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest containing a single site named KingSite1.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging  solution.Company.com has recently configured the mailbox server as members of a database availability group (DAG) with a public folder database. During the course of the business week you receive instruction from Company.com to create a new Active Directory site and install Exchange server in the site whilst ensuring the public folders are stored on servers in both sites. What should you do?()

  • A、You should consider having clustered continuous replication (CCR) configured on two servers in the new site.You should then have the replication settings for all public folder databases modified.
  • B、You should consider having the standby continuous replication (SCR) configured on a server in the new site.You should then have the Enable-StorageGroupCopy cmdlet run from a server in the new site.
  • C、You should consider having a public folder database created on a server in the new site.You should then have the replication settings for all public folders modified.
  • D、You should consider having a public folder database created on a server in the new site.You should then have the set-DatabaseAvailabilityGroup cmdlet run from a server in the new site.

正确答案:C

第10题:

You have an Exchange Server 2010 organization.You need to ensure that all users in the organization can automatically schedule the use of a projector.What should you do?()

  • A、Create a new sharing policy
  • B、Create a mailbox
  • C、Modify the properties of the Calendar managed default folder
  • D、Modify the schedule for the Managed Folder Assistant

正确答案:B

更多相关问题