In your database， the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting？（）A、The optimizer statistics are collected automatically.B、Only the timed operating system （OS） statistics and plan execution statistics a

题目

In your database， the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting？（）

A、The optimizer statistics are collected automatically.
B、Only the timed operating system （OS） statistics and plan execution statistics are collected.
C、The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
D、The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.
E、Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.

更多“In your database，”相关问题

第1题

Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database？（） A、 Yes， if the database is in ARCHIVELOG modeB、 Yes， if the database is in NOARCHIVELOG modeC、 No， the backup is not usable in any wayD、 Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE

点击查看答案
第2题

You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）A、the time when the last flashback operation in your database was performedB、the time when the first flashback operation in your database was performedC、a list of flashback operations performed in your database using SCN and timeD、the approximate time and the lowest system change number （SCN） to which you can flash back your database

点击查看答案
第3题

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 allB、 backup compressed databaseC、 backup as compressed backupset databaseD、 backup as compressed backup database plus archivelog allE、 backup as compressed backupset database plus compress archivelog all

点击查看答案
第4题

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

点击查看答案
第5题

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A user database named Products is included by your SQL Server 2005 computer. SQL Server Integration Services （SSIS） packages are utilized to export data from the Products database to a text file. You deliver the text file to your company’s trading partners by utilizing FTP. You are required to make sure that your SSIS packages can be recovered from the occurrence of a disaster. Which action should be performed to finish the task？（）A、To finish the task，the Products database should be backed up.B、To finish the task，your server should be set to utilize the full recovery model.C、To finish the task，your server should be set to utilize the bulk-logged recovery model.D、To finish the task， the msdb database should be backed up.

点击查看答案
第6题

单选题For which database operation would you need the database to be in the MOUNT state（）A renaming the control filesB re-creating the control filesC dropping a user in your databaseD dropping a tablespace in your databaseE configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes

点击查看答案
第7题

单选题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 filesB dropping a user in your databaseC enabling or disabling redo log archivingD dropping a tablespace in your databaseE re-creating the control files， after you lost all the control files in your database

点击查看答案

In your database，

题目

更多“In your database，”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容

In your database，

更多“In your database，”相关问题