As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead？（）A、Coalesce the application

题目

As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead？（）

A、Coalesce the application tables at a regular interval.
B、Export and Import the application tables a regular interval.
C、Drop and recreate the application tables at a regular interval.
D、Move the application tables to a tablespace with less space usage.
E、Distribute the application tables across multiple tablespaces depending on usage.
F、Move the application tables to automatic segment space management tablespace.

更多“As a database ”相关问题

第1题

If you lost your entire database，including the database spfile，control files，online redo logs，and database datafiles，what kind of recovery would be required with RMAN？（） A、 Complete database recovery.B、 Incomplete database recovery.C、 Approximate database recovery.D、 Archived database recovery.E、 The database could not be recovered with RMAN.

点击查看答案
第2题

You plan to execute the following command to perform a Flashback Database operation in your database： SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）； Which two statements are true about this？（）A、 The database must have multiplexed redo log filesB、 The database must be in the MOUNT state to execute the commandC、 The database must be in the NOMOUNT state to execute the commandD、 The database must be opened in RESTRICTED mode before this operationE、 The database must be opened with the RESETLOGS option after the flashback operation

点击查看答案
第3题

What two are the prerequisites for enabling Flashback Database？（） A、 The database must be in ARCHIVELOG modeB、 The database must be in MOUNT EXCLUSIVE modeC、 The database must be opened in RESTRICTED modeD、 The database instance must be started in the NOMOUNT stateE、 The database instance must have the keep buffer pool defined

点击查看答案
第4题

You are managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）A、 STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；B、 STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；C、 STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；D、 STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；

点击查看答案
第5题

What are the prerequisites for enabling Flashback Database？（）A、 The database must be started in the MOUNT EXCLUSIVE state.B、 The database must have multiplexed control files.C、 The database must be opened by using a text-based parameter file instead of a server parameter file （SPFILE）.D、 The database must be in ARCHIVELOG mode.E、 The database must be in the NOMOUNT state.F、 The database must be opened in RESTRICTED mode.

点击查看答案
第6题

多选题You plan to execute the following command to perform a Flashback Database operation in your database: SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?（）AThe database must have multiplexed redo log filesBThe database must be in the MOUNT state to execute the commandCThe database must be in the NOMOUNT state to execute the commandDThe database must be opened in RESTRICTED mode before this operationEThe database must be opened with the RESETLOGS option after the flashback operation

点击查看答案
第7题

单选题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 SQL Server 7.0 database. You upgrade the database to the SQL Server instance. According to the company requirement, you must make sure that suspect pages can be detected in the database. So what action should you perform to achieve this goal?（）A For the database, you should turn on the TRUSTWORTHY database optionB For the database, the PAGE_VERIFY database option should be set to CHECKSUMC For the database, the database compatibility level option should be set to 10D For the model database, the PAGE_VERIFY database option should be set to TORN_PAGE_DETECTION.

点击查看答案

As a database

题目

更多“As a database ”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容