单选题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
参考解析
解析：
暂无解析
相关考题：
In which two scenarios do you use SQL* Loader to load data?() A. Transform the data while it is being loaded into the database.B. Use transparent parallel processing without having to split the external data first.C. Load data into multiple tables during the same load statement.D. Generate unique sequential key values in specified columns.
Which command do you use to display the status of an antivirus database update?() A. show security utm anti-virus statusB. show security anti-virus database statusC. show security utm anti-virus databaseD. show security utm anti-virus update
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
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 would you use to determine what database backups are currently available for restore?（）A、list database backupB、report database backup C、list backup of databaseD、list summary backupE、report backup of database
You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.
You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task？（） A、 Data Pump Export and ImportB、 conventional export and importC、 the CONVERT command of RMAND、 the BACKUP AS COPY. command of RMAN
You want to drop the TBS1 tablespace from your database. You also want to delete the corresponding data files automatically， and not have to do it manually. What should you do？（）A、Use the DROP DATAFILE command.B、Use the DROP TABLESPACE command.C、Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.D、Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.
Which command would you use to determine what database backups are currently available for restore？（） A、 list database backupB、 report database backupC、 list backup of databaseD、 list summary backupE、 report backup of database
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 RMANB、Data Pump Export and Import into the same databaseC、conventional export and import into the same databaseD、the BACKUP DATABASE and RESTORE DATABASE commands of RMANE、the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN
You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（） A、 You will need to open the database with the resetlogs command.B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C、 You will use the resetlogs version of the create controlfile command.D、 You will use the noresetlogs version of the create controlfile command.E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command
You need to generate the utilization report for the application servers. What should you use to generate the report？（）A、Microsoft Assessment and Planning Toolkit （MAP）B、Microsoft Desktop Optimization Pack （MDOP）C、Microsoft System Center Virtual Machine ManagerD、Microsoft System Center Operations Manager
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. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further. Which tool should you use? （） A、You should use Dynamic Management Views B、You should use SQL Server Resource Governor C、You should use SQL Server Profiler D、You should use Windows System Monitor
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
单选题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？（）ADecrease the time between transaction log backups of the database.BDelete report snapshot history each week.CMinimize the use of session caching in the reports.DMinimize the use of report snapshots in the reports.
单选题Which command do you use to display the status of an antivirus database update?（）Ashow security utm anti-virus statusBshow security anti-virus database statusCshow security utm anti-virus databaseDshow security utm anti-virus update
单选题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 commandB CROSSCHECK commandC REPORT commandD SHOW command
多选题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？（）Athe CONVERT command of RMANBData Pump Export and Import into the same databaseCconventional export and import into the same databaseDthe BACKUP DATABASE and RESTORE DATABASE commands of RMANEthe BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN
多选题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？（）Athe CONVERT command of RMANBData Pump Export and Import into the same databaseCconventional export and import into the same databaseDthe BACKUP DATABASE and RESTORE DATABASE commands of RMANEthe BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN
单选题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. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further. Which tool should you use? （）AYou should use Dynamic Management Views BYou should use SQL Server Resource Governor CYou should use SQL Server Profiler DYou should use Windows System Monitor
单选题Which command do you use to go from the shell prompt to the CLI prompt?（）Arun cliBcliCstart cliDedit
单选题Which command do you use to navigate to [edit interfaces]?（）Acd interfacesBdir edit interfacesCedit interfacesDinterfaces
单选题You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（）A You will need to open the database with the resetlogs command.B All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C You will use the resetlogs version of the create controlfile command.D You will use the noresetlogs version of the create controlfile command.E You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command
单选题In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data?（）AComplete Recovery with online redo logBComplete Recovery with archived redo logCTablespace Point-in-Time Recovery (TSPITR)DIncomplete Recovery with system change number (SCN)
单选题In your production database， users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason， you realize that another user executed the TRUNCATE TABLE command， which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data？（）A Complete Recovery with online redo logB Complete Recovery with archived redo logC Tablespace Point-in-Time Recovery （TSPITR）D Incomplete Recovery with system change number （SCN）
单选题Which command would you use to determine what database backups are currently available for restore？（）A list database backupB report database backupC list backup of databaseD list summary backupE report backup of database
单选题Which command would you use to determine what database backups are currently available for restore?（）Alist database backupBreport database backup Clist backup of databaseDlist summary backupEreport backup of database