Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:<br /> SQL> SELECT * FROM sales;<br /> Which process would retrieve the result from the database and return it to the client program?（）..

第1题

[单选题] You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）

A、renaming the control files B、dropping a user in your database C、enabling or disabling redo log archiving D、dropping a tablespace in your database E、re-creating the control files， after you lost all the control files in your database

点击查看答案

第2题

[] You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（） You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）

A、A.the time when the last flashback operation in your database was performed B、B.the time when the first flashback operation in your database was performed C、C.a list of flashback operations performed in your database using SCN and time D、D.the approximate time and the lowest system change number （SCN） to which you can flash back your database

点击查看答案

第3题

[] You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（） You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）

A、A. You must have change tracking enabled in your database B、B. Your database must be running in NOARCHIVELOG mode C、C. To back up a tablespace, it must be in backup mode D、D. To back up a tablespace, it must first be taken offline

点击查看答案

第4题

[单选题] You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）

A、You must have change tracking enabled in your database B、Your database must be running in NOARCHIVELOG mode C、To back up a tablespace, it must be in backup mode D、To back up a tablespace, it must first be taken offline

点击查看答案

第5题

[单选题] A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）

A、 backup database all B、 backup compressed database C、 backup as compressed backupset database D、 backup as compressed backup database plus archivelog all E、 backup as compressed backupset database plus compress archivelog all

点击查看答案

第6题

[单选题] You are a network administrator for your company. All servers run Windows Server 2003. You manage a file server named Server8. You need to create a performance baseline for Server8 by using Performance Logs and Alerts. You need to store the performance data in an existing Microsoft SQL Server database on another computer. You create a new counter log, and you select SQL Database as the log file format. When you attempt to save your changes, you receive an error message stating that you must select a data source name. You examine the configuration of the SQL Logs, as shown in the following dialog box. You need to configure the counter log to use a SQL database. What should you do? （）

A、Use the relog command-line utility to configure a connection to your SQL database. B、Use Add or Remove programs to install Connection Point Services. Configure a connection to your SQL database. C、Use the logman command-line utility with the create switch to configure a connection to your SQL database. D、Use Data Sources (ODBC) to configure a connection to your SQL database.

点击查看答案

第7题

[单选题] You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）

A、 The time when the last flashback operation in your database was performed. B、 The time when the first flashback operation in your database was performed. C、 A list of flashback operations performed in your database using SCN and time. D、 The approximate time and the lowest system change number （SCN） to which you can flash back your database.

点击查看答案

第8题

[] Your database runs in ARCHIVELOG mode， and is backed up every Sunday night using RMAN scripts. On Friday your database crashes. Now you want to use the backups from last Sunday night to restore your database. How can you do this？（） Your database runs in ARCHIVELOG mode， and is backed up every Sunday night using RMAN scripts. On Friday your database crashes. Now you want to use the backups from last Sunday night to restore your database. How can you do this？（）

A、A.A B、B.B C、C.C D、D.D

点击查看答案

第9题

[多选题] 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

点击查看答案

第10题

[] You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（） You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the product

A、A. Open the database in NORMAL mode B、B. Open the database in read-only mode C、C. Open the database in RESTRICTED mode D、D. Open the database with the RESETLOGS option

点击查看答案

Your database interface is running. A user SCOTT starts a SQL Plus session, and issues the following query:<br /> SQL> SELECT FROM sales;<br /> Which process would retrieve the result from the database and return it to the client program?（）

请使用微信扫码支付