违法和不良信息举报 联系客服
免费注册 登录

Which command do you use to generate a report of database in

题目
单选题
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 executed

B．Use the sp_who stored procedure to discover who is logged in as spid 52

C．Use SQL Profiler to capture the activity of the user who is logged in as spid 52

D．Use System Monitor to log the locks that are granted in the database


正确答案：A
解析：Explanation: The current activity window in SQL Server Enterprise Manager can be used to perform. ad hoc monitoring of an instance of SQL Server. This allows for the quick analysis of the volume and general types of activity on the system and can indicate current blocked and blocking transactions, currently connected users on an instance of SQL Server and the last statement executed and locks that are in effect on the database.

In the screen shot of current activity window the icon, labeled spid 51, indicates that a database lock is in place; the second icon, labeled spid 52, can be used to identify the process that is blocking one or more connections; and the third icon, labeled spid 53, can be used to identify the process that is being blocked by another connection

Incorrect Answers:
B: The system stored procedure sp_lock can be used to return a result set that contains information about resources that are locked and the sp_who stored procedure provides information about current SQL Server 2000 users and processes. The information returned by the sp_who procedure can be filtered to return only current non-idle processes. This makes it possible to identify which resources are being locked and which processes are responsible for creating those locks. These stored procedures require more resources and more administrative effort than the Current Activity window. It is therefore not the best answer.

C: The SQL profiler is not the best tool to immediately solve the locking problem. It could be used at a later moment if a long-term solution to the problem is required. SQL profiler would require more system resources and might impact normal database activities.

Note: SQL Profiler is a graphical tool that allows system administrators to monitor events in an instance of SQL Server. Data pertaining to an event can be captured and saved to a file or SQL Server table to be analyzed at a later date. It can be is used to step through problem queries to find the cause of the problem; to find and diagnose slow-running queries; to capture the series of SQL statements that led to a problem; and to monitor the performance of SQL Server to tune workloads.

D: SQL Server provides objects and counters that can be used by System Monitor in a Windows 2000 or by Performance Monitor in Windows NT 4.0 to monitor the system performance of computers running an instance of SQL Server. However, these counters are used for statistics and alerts and they cannot, in a direct way, be used to track down the cause of the locking problem.

第2题：

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

第3题：

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.


参考答案：A, D

第4题：

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

第5题：

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 Import
  • B、 conventional export and import
  • C、 the CONVERT command of RMAN
  • D、 the BACKUP AS COPY. command of RMAN

正确答案:D

第6题：

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

正确答案:A

第7题：

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.

正确答案:D

第8题：

Which command do you use to display the status of an antivirus database update?()

A. show security utm anti-virus status

B. show security anti-virus database status

C. show security utm anti-virus database

D. show security utm anti-virus update


参考答案：A

第9题：

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.

正确答案:B

第10题：

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

更多相关问题
相关内容