Which command do you use to generate a report of database incarnations？（）  A、 list incarnation of databaseB、 report incarnation of databaseC、 list database incarnationD、 database incarnation listE、 report database incarnation

题目

Which command do you use to generate a report of database incarnations？（）  

  • A、 list incarnation of database
  • B、 report incarnation of database
  • C、 list database incarnation
  • D、 database incarnation list
  • E、 report database incarnation
相似考题

1.You are the administrator of a SQL Server computer. Users report that the database times out when they attempt to modify data. You use the Current Activity window to examine locks held in the database as shown in the following screenshot.You need to discover why users cannot modify data in the database, but you do not want to disrupt normal database activities. What should you do?A．Use the spid 52 icon in the Current Activity window to discover which SQL statement is being executedB．Use the sp_who stored procedure to discover who is logged in as spid 52C．Use SQL Profiler to capture the activity of the user who is logged in as spid 52D．Use System Monitor to log the locks that are granted in the database

2.You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). Identify two scenarios is which you must have a recovery catalog.（）A、To store the backup information of multiple databaseB、To restrict the amount of space that is used by the backupsC、To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.D、To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

3.Which three statements are true regarding the use of the Database Migration Assistant for Unicode(DMU)?（）A、A DBA can check specific tables with the DMUB、The database to be migrated must be opened read-only.C、The release of the database to be converted can be any release since 9.2.0.8.D、The DMU can report columns that are too long in the converted characterset.E、The DMU can report columns that are not represented in the converted characterset.

4. You work in Dublin at the main office of TestKing.com. You are responsible for managing a SQL Server 2005 database. The sales department wants a report that compares customer activity in the previous quarter between the main office in Dublin and the branch office in Buenos Aires. They want the data sorted by surname and first name.You restore a recent backup of the Buenos Aires database onto your server. You write queries to build the report， ordering the data by the Surname and FirstName columns. You review the data and notice that the customer list from the Buenos Aires database is sorted differently. The sales department needs the revised data within 15 minutes for a presentation.  You need to implement the fastest possible solution that ensures that the data from both databases is sorted identically. What should you do？（）A、Use the Copy Database Wizard to copy the data in the Buenos Aires database to a new database with the same collation as the Dublin database.B、Use the SQL Server Import and Export Wizard to copy the data from the Buenos Airesdatabase into new tables， specifying the same collation as the Dublin database.C、Modify the format file to specify the same collation as the Dublin database. Import the table again.D、Modify the query on the Buenos Aires database to use the COLLATE setting in the ORDER BY clause. In the query， specify the same collation as the Dublin database.

更多“Which command do you use to generate a report of database incarnations？（）  A、 list incarnation of databaseB、 report incarnation of databaseC、 list database incarnationD、 database incarnation listE、 report database incarnation”相关问题

  • 第1题：

    Which command would you use to determine what database backups are currently available for restore?（）

    • A、list database backup
    • B、report database backup  
    • C、list backup of database
    • D、list summary backup
    • E、report backup of database

    正确答案:C

  • 第2题：

    You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement：       SQL>ALTER DATABASE OPEN RESETLOGS；   Which of the following options is true about using the RESETLOGS option？（）

    • A、 The log sequence is reset to 0.
    • B、 All the online redo logs are deleted.
    • C、 All the archived redo logs from a previous incarnation become useless.
    • D、 The full database backup taken from a previous incarnation can be used in future.
    • E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

    正确答案:D

  • 第3题：

    You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery catalog. （）(Choose two.)

    • A、To store the backup information of multiple database
    • B、To restrict the amount of space that is used by the backups
    • C、To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
    • D、To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

    正确答案:A,D

  • 第4题：

    You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）

    • A、 target database
    • B、 auxiliary database
    • C、 third-party database
    • D、 recovery catalog database

    正确答案:C

  • 第5题：

    You want to migrate your existing non/x7fASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task？（）

    • A、the CONVERT command of RMAN
    • B、Data Pump Export and Import into the same database
    • C、conventional export and import into the same database
    • D、the BACKUP DATABASE and RESTORE DATABASE commands of RMAN
    • E、the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN

    正确答案:A,E

  • 第6题：

    Why would you execute the report obsolete command？（）  

    • A、 To list all backups that were no longer available for restore operations
    • B、 To list all backups that had aged beyond the RMAN retention criteria
    • C、 To list all backup set pieces listed in control-file or recovery-catalog metadata that are not on the backup media
    • D、 To list all datafiles that are no longer part of the database and thus do not need to be backed up
    • E、 To list all archived redo logs that are no longer needed for any database recovery

    正确答案:B

  • 第7题：

    You are a database administrator for your company. The company uses a SQL Server 2005 computer that runs Reporting Services. Reporting Services is used to produce hundreds of reports each day. You discover that the ReportServerTempDB database is growing. You need to minimize the size of the ReportServerTempDB database. What should you do？（）

    • A、Decrease the time between transaction log backups of the database.
    • B、Delete report snapshot history each week.
    • C、Minimize the use of session caching in the reports.
    • D、Minimize the use of report snapshots in the reports.

    正确答案:C

  • 第8题：

    单选题
    Which command would you use to determine what database backups are currently available for restore？（）
    A

     list database backup

    B

     report database backup

    C

     list backup of database

    D

     list summary backup

    E

     report backup of database


    正确答案： A
    解析： 暂无解析

  • 第9题：

    多选题
    You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？ （）
    A

    This operation resets the SCN for the database.

    B

    This operation creates a new incarnation of the database.

    C

    This operation moves all the redo log files to a different location.

    D

    This operation deletes the old redo log files and creates new redo log files.

    E

    This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.


    正确答案： C,D
    解析： 暂无解析

  • 第10题：

    单选题
    What command is used to reset a database to a previous incarnation？（）
    A

     reset incarnation

    B

     incarnation reset

    C

     reset database to incarnation

    D

     reset database incarnation

    E

     reset databse incarnation number


    正确答案： E
    解析： 暂无解析

  • 第11题：

    单选题
    You work in Dublin at the main office of TestKing.com. You are responsible for managing a SQL Server 2005 database. The sales department wants a report that compares customer activity in the previous quarter between the main office in Dublin and the branch office in Buenos Aires. They want the data sorted by surname and first name.You restore a recent backup of the Buenos Aires database onto your server. You write queries to build the report， ordering the data by the Surname and FirstName columns. You review the data and notice that the customer list from the Buenos Aires database is sorted differently. The sales department needs the revised data within 15 minutes for a presentation.  You need to implement the fastest possible solution that ensures that the data from both databases is sorted identically. What should you do？（）
    A

    Use the Copy Database Wizard to copy the data in the Buenos Aires database to a new database with the same collation as the Dublin database.

    B

    Use the SQL Server Import and Export Wizard to copy the data from the Buenos Airesdatabase into new tables， specifying the same collation as the Dublin database.

    C

    Modify the format file to specify the same collation as the Dublin database. Import the table again.

    D

    Modify the query on the Buenos Aires database to use the COLLATE setting in the ORDER BY clause. In the query， specify the same collation as the Dublin database.


    正确答案： A
    解析： 暂无解析

  • 第12题：

    单选题
    You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）
    A

     target database

    B

     auxiliary database

    C

     third-party database

    D

     recovery catalog database


    正确答案： B
    解析： 暂无解析

  • 第13题：

    You are using Oracle Database 10g. You performed an  incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？（）

    • A、This operation resets the SCN for the database.
    • B、This operation creates a new incarnation of the database.
    • C、This operation moves all the redo log files to a different location.
    • D、This operation deletes the old redo log files and creates new redo log files.
    • E、This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

    正确答案:B,E

  • 第14题：

    Which command would you use to determine what database backups are currently available for restore？（）  

    • A、 list database backup
    • B、 report database backup
    • C、 list backup of database
    • D、 list summary backup
    • E、 report backup of database

    正确答案:C

  • 第15题：

    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 days
    • B、a list of files that have not been backed up for three days
    • C、a list of files that RMAN recommends be backed up only once in every three days， based on low volatility
    • D、a list of files for which a backup has already been performed and may need a backup after three days

    正确答案:B

  • 第16题：

    You want to migrate your existing non-ASM files to ASM files for the database PROD. Which method  or command would you use to accomplish this task？（）

    • A、the CONVERT command of RMAN
    • B、Data Pump Export and Import into the same database
    • C、conventional export and import into the same database
    • D、the BACKUP DATABASE and RESTORE DATABASE commands of RMAN
    • E、the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN

    正确答案:A,E

  • 第17题：

    What command is used to reset a database to a previous incarnation？（）  

    • A、 reset incarnation
    • B、 incarnation reset
    • C、 reset database to incarnation
    • D、 reset database incarnation
    • E、 reset databse incarnation number

    正确答案:C

  • 第18题：

    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 report which is often executed during business time. There is a stored procedure that is used as the data source for the report. You get a report from users saying that they receive the data returned by the report but the data is inconsistent. As the technical support, you check and find that phantom reads cause this problem. You must make sure that consistent data is returned by the report while not affecting other users. So what action should you perform to achieve this goal?（）  

    • A、You should configure the database for Read Committed Snapshot isolation. 
    • B、You should modify the stored procedure to use the Snapshot isolation level 
    • C、You should configure the database for Auto Update Statistics asynchronously 
    • D、You should modify the stored procedure to use the Repeatable Read isolation level

    正确答案:B

  • 第19题：

    多选题
    You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). Identify two scenarios is which you must have a recovery catalog.（）
    A

    To store the backup information of multiple database

    B

    To restrict the amount of space that is used by the backups

    C

    To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.

    D

    To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.


    正确答案： B,D
    解析： 暂无解析

  • 第20题：

    单选题
    You are maintaining your database in Oracle10g. You are required to view the list of files that have not been backed up for the last seven days. Which RMAN command will you use？（）
    A

     LIST command

    B

     CROSSCHECK command

    C

     REPORT command

    D

     SHOW command


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    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 report which is often executed during business time. There is a stored procedure that is used as the data source for the report. You get a report from users saying that they receive the data returned by the report but the data is inconsistent. As the technical support, you check and find that phantom reads cause this problem. You must make sure that consistent data is returned by the report while not affecting other users. So what action should you perform to achieve this goal?（）
    A

    You should configure the database for Read Committed Snapshot isolation. 

    B

    You should modify the stored procedure to use the Snapshot isolation level 

    C

    You should configure the database for Auto Update Statistics asynchronously 

    D

    You should modify the stored procedure to use the Repeatable Read isolation level


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement：       SQL>ALTER DATABASE OPEN RESETLOGS；   Which of the following options is true about using the RESETLOGS option？（）
    A

     The log sequence is reset to 0.

    B

     All the online redo logs are deleted.

    C

     All the archived redo logs from a previous incarnation become useless.

    D

     The full database backup taken from a previous incarnation can be used in future.

    E

     Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    Which command do you use to generate a report of database incarnations？（）
    A

     list incarnation of database

    B

     report incarnation of database

    C

     list database incarnation

    D

     database incarnation list

    E

     report database incarnation


    正确答案： B
    解析： 暂无解析

相关内容