多选题What are three purposes of the RMAN “FROM” clause?()Ato support PUSH-based active database duplicationBto support synchronization of a standby database with the primary database in a Data environmentCTo support PULL-based active database duplicationDTo support file restores over the network in a Data Guard environmentETo support file recovery over the network in a Data Guard environment
多选题
What are three purposes of the RMAN “FROM” clause?()
A
to support PUSH-based active database duplication
B
to support synchronization of a standby database with the primary database in a Data environment
C
To support PULL-based active database duplication
D
To support file restores over the network in a Data Guard environment
E
To support file recovery over the network in a Data Guard environment
参考解析
解析:
暂无解析
相关考题:
What would Hilary expect most from modern life in the three months? [ ]A To play computer gamesB To make phone callsC To listen to musicD To chat on the Internet
In which four clauses can a subquery be used? () A. in the INTO clause of an INSERT statementB. in the FROM clause of a SELECT statementC. in the GROUP BY clause of a SELECT statementD. in the WHERE clause of a SELECT statementE. in the SET clause of an UPDATE statementF. in the VALUES clause of an INSERT statement
You are the administrator of a SQL Server 2000 computer in your company's personnel department. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit.You want to create a text file that lists these data columns in the following format title, FirstName, LastName, WorkPhone, PositionName, DepartmentName.You want to create the text file as quickly as possible. You do not expect to re-create this file, and you want to avoid creating new database objects if possible.What should you do?A.Use the bcp utility to export data from each table to a separate text file. Use format files to select the appropriate columns. Merge the data from each text file into a single text file.B.Create a view that joins data from all three tables include only the columns you want to appear in the text file. Use the bcp utility to export data from the view.C.Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a local temporary table. Use the bcp utility to export data from the local temporary table to a text file.D.Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a global temporary table. Use the bcp utility to export data from the global temporary table to a text file.
In which of the following situations should correlation names be used?() A.A table referenced in the FROM clause has no indexed column.B.The table referenced in the FROM clause has more than 200 columns.C.Two or more tables in the FROM clause have identical column names.D.The FROM clause contains two or more tables in the SELECT statement.
In which four clauses can a subquery be used?()A、in the INTO clause of an INSERT statementB、in the FROM clause of a SELECT statementC、in the GROUP BY clause of a SELECT statementD、in the WHERE clause of a SELECT statementE、in the SET clause of an UPDATE statementF、in the VALUES clause of an INSERT statement
In which of the following situations should correlation names be used?()A、A table referenced in the FROM clause has no indexed column.B、The table referenced in the FROM clause has more than 200 columns.C、Two or more tables in the FROM clause have identical column names.D、The FROM clause contains two or more tables in the SELECT statement.
You executed the following command in Recovery Manager (RMAN) against your Oracle 10g database:RMAN REPORT NEED BACKUP days 3;What would be the output of this command?()A、 a list of files that require a backup within three daysB、 a list of files that have not been backed up for three daysC、 a list of files that RMAN recommends be backed up only once in every three days, based on low volatilityD、 a list of files for which a backup has already been performed and may need a backup after three days
What is the purpose of the catalog command?() A、 To review RMAN control file and recovery catalog metadata and ensure that its correctB、 To delete RMAN backup-related metadata from the recovery catalogC、 To create metadata in the control file and the recovery catalog related to backup set pieces D、 To create a report that lists database backupsE、 To rebuild the recovery catalog
You defined the Recovery Manager (RMAN) retention policy to recovery window of 7 days by executing the following command: RMAN CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; When a backup is performed, what would be the status of this backup after seven days?()A、 The backup would be marked as invalid.B、 The backup would be marked as obsolete.C、 The backup would be removed from the media.D、 The backup would be removed from the RMAN repository.
You executed the following command in the Recovery Manager (RMAN): RMAN REPORT NEED BACKUP days 3; What is the output of this command?() A、 A list of files that require a backup within 3 daysB、 A list of files requiring more than 3 days of archivelogs to applyC、 A list of files that RMAN recommends be backed up only once in every three days,based on low volatilityD、 A list of files for which a backup as already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them
You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility?()A、 UNTIL CANCELB、 UNTIL SCNC、 UNTIL SEQUENCED、 UNTIL TIME
You executed the following command in Recovery Manager (RMAN): RMAN REPORT NEED BACKUP days 3; What is the output of this command?() A、 a list of files that require a backup within three daysB、 a list of files requiring more than 3 days of archive logs to applyC、 a list of files that RMAN recommends be backed up only once in every three days,based on low volatilityD、 a list of files for which a backup has already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them
You perform a backup using the following BACKUP command: RMAN BACKUP AS COMPRESSED BACKUPSET DATABASE; Which statement is true of this command?() A、 A different procedure is required to restore a database from compressed backupsB、 The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.C、 Using this command to create backups minimizes the bandwidth consumedD、 Using this command to create backups improves the performance of the backup process
What are three uses for record groups?()A、To pass data to a pop-up menu. B、To populate a base table block. C、To pass data to other form modules. D、To pass data to other Oracle products. E、To dynamically construct SELECT statements. F、To server as the source for a FROM clause query.
What are three purposes of the RMAN “FROM” clause?()A、to support PUSH-based active database duplicationB、to support synchronization of a standby database with the primary database in a Data environmentC、To support PULL-based active database duplicationD、To support file restores over the network in a Data Guard environmentE、To support file recovery over the network in a Data Guard environment
单选题You issue the following RMAN command to set a retention policy on a database: RMANCONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command?()A After two days,a backup will be marked obsoleteB After two days,a backup will be deleted from the mediaC If the RMAN repository has records of two or more recent backups of a file,then older backups will be deleted from the media.D If the RMAN repository has records of two or more recent backups of a file then older backups will be marked obsolete.
单选题You issue the following RMAN command to set a retention policy on a database: RMANCONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of the above command?()A After two days, the backup will be marked obsolete.B After two days, the backup will be deleted from the media.C If the RMAN repository has records of two or more recent backups of a file, then the older backup will be deleted from the media.D If the RMAN repository has records of two or more recent backups of a file, then the older backup will be marked obsolete.
单选题You executed the following command in Recovery Manager (RMAN): RMAN REPORT NEED BACKUP days 3; What is the output of this command?()A a list of files that require a backup within three daysB a list of files requiring more than 3 days of archive logs to applyC a list of files that RMAN recommends be backed up only once in every three days,based on low volatilityD a list of files for which a backup has already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them
多选题What are three uses for record groups?()ATo pass data to a pop-up menu.BTo populate a base table block.CTo pass data to other form modules.DTo pass data to other Oracle products.ETo dynamically construct SELECT statements.FTo server as the source for a FROM clause query.
单选题You perform a backup using the following BACKUP command: RMAN BACKUP AS COMPRESSED BACKUPSET DATABASE; Which statement is true of this command?()AA different procedure is required to restore a database from compressed backupsBThe AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.CUsing this command to create backups minimizes the bandwidth consumedDUsing this command to create backups improves the performance of the backup process
多选题In which four clauses can a subquery be used? ()Ain the INTO clause of an INSERT statementBin the FROM clause of a SELECT statementCin the GROUP BY clause of a SELECT statementDin the WHERE clause of a SELECT statementEin the SET clause of an UPDATE statementFin the VALUES clause of an INSERT statement
单选题You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility?()A UNTIL CANCELB UNTIL SCNC UNTIL SEQUENCED UNTIL TIME
单选题You executed the following command in the Recovery Manager (RMAN): RMAN REPORT NEED BACKUP days 3; What is the output of this command?()A A list of files that require a backup within 3 daysB A list of files requiring more than 3 days of archivelogs to applyC A list of files that RMAN recommends be backed up only once in every three days,based on low volatilityD A list of files for which a backup as already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them
单选题You executed the following command in Recovery Manager (RMAN) against your Oracle 10g database: RMAN REPORT NEED BACKUP days 3; What would be the output of this command?()Aa list of files that require a backup within three daysBa list of files that have not been backed up for three daysCa list of files that RMAN recommends be backed up only once in every three days, based on low volatilityDa list of files for which a backup has already been performed and may need a backup after three days
单选题In which of the following situations should correlation names be used?()AA table referenced in the FROM clause has no indexed column.BThe table referenced in the FROM clause has more than 200 columns.CTwo or more tables in the FROM clause have identical column names.DThe FROM clause contains two or more tables in the SELECT statement.
单选题You defined the Recovery Manager (RMAN) retention policy to recovery window of 7 days by executing the following command: RMAN CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; When a backup is performed, what would be the status of this backup after seven days?()AThe backup would be marked as invalid.BThe backup would be marked as obsolete.CThe backup would be removed from the media.DThe backup would be removed from the RMAN repository.