单选题You have executed this command to change the size of the database buffer cache： SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582； System altered. To verify the change in size， you executed this command：SQL> SHOW PARAMETER DB_CACHE_SIZENAME TYPE VALUE -----

题目

单选题

You have executed this command to change the size of the database buffer cache： SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582； System altered. To verify the change in size， you executed this command：SQL> SHOW PARAMETER DB_CACHE_SIZENAME TYPE VALUE ------------------- ----------- ------------------ db_cache_size big integer 4194304 Why is the value set to 4194304 and not to 2516582（）

Because 4194304 is the granule size

Because 4194304 is the standard block size

Because 4194304 is the largest nonstandard block size defined in the database

Because 4194304 is the total size of data already available in the database buffer cache

参考答案和解析

正确答案： C

解析：暂无解析

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）

A、guarantee undo retention
B、add one more redo log group
C、size the redo log files appropriately
D、size the UNDO tablespace appropriately
E、size the SYSTEM tablespace appropriately
F、configure an appropriate undo retention interval
G、change automatic undo management to manual

正确答案:A,D,F

第2题：

You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? （）(Choose two.)

A、The backup piece size will be limited to 300 MB
B、The RMAN uses multiplexing to perform backup
C、The operation is accomplished using the default channel available
D、The RMAN parallelizes the backup although the parallelism is not set for a channel

正确答案:A,C

第3题：

Examine the output of the query that you executed to list the objects in the recycle bin:You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:SQL> PURGE TABLE sales_tab;What would be the outcome of this command?（）

A. All three tables in the recycle bin are purged

B. Only the table with the oldest DROPSCN is purged

C. The command returns an error because multiple entries with the same name exist in the recycle bin

D. Only the table with the latest DROPSCN is purged

参考答案：B

第4题：

Your database instance is started using the server parameter file （SPFILE）. You executed acommand to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH； What would be the outcome of this command（）

A、The command succeeds only if Automatic Memory Management is not enabled.
B、The command succeeds， but you need to restart the database for changes to take effect.
C、The command returns an error because the size of the redo log buffer cannot be changed dynamically.
D、The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area （SGA）.

正确答案:C

第5题：

You decided to change the location of the flash recovery area. You executed the following command： ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+disk1’ SCOPE=BOTH SID=’*’； Which statement is true？（）

A、 The location can be changed only if the flash recovery area is empty.
B、 After executing the command， all new flash recovery area files will be created in the new location.
C、 The command will generate an error because you cannot change the flash recovery area while the database is open.
D、 All the existing files in the flash recovery area will be moved to the new location and all new Flash Recovery Area files will be created in the new location.

正确答案:B

第6题：

The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager （RMAN） against your database： RMAN> REPORT OBSOLETE； What would you see in the output？（）

A、 a list of all those files that have been deleted in the last two days
B、 a list of all those files that have been recovered within the last two days
C、 a list of all the expired backups and copies
D、 a list of backups and copies that are outside the range covered by the current retention policy

正确答案:D

第7题：

Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）

A、The SKD user cannot log in to the database instance.
B、The objects owned by the SKD user are not accessible to any user.
C、The other users can access the objects owned by the SKD user， on which they have access.
D、The password for the SKD user expires and the user is forced to change the password at the next log in

正确答案:A,C

第8题：

View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN> REPAIR FAILURE;Which statement describes the consequence of the command?（）

A. The command performs the recovery and closes the failures.

B. The command only displays the advice and the RMAN script required for repair.

C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.

D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

参考答案：C

第9题：

Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？（）

A、 when you change the name of a datafile
B、 when you drop a table from the database
C、 when you take an export of the database
D、 when you back up the database using OS utilities
E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
F、 when you issue a BACKUP command from inside the RMAN run block

正确答案:A,E,F

第10题：

our database instance is started using the server parameter file （SPFILE）. You executed a command tochange the value of the LOG_BUFFER initialization parameter：ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH； What would be the outcome of this command（）

A、The command succeeds only if Automatic Memory Management is not enabled.
B、The command succeeds， but you need to restart the database for changes to take effect.
C、The command returns an error because the size of the redo log buffer cannot be changed dynamically.
D、The parameter value is changed and it comes into effect as soon as space becomes available in theSystem Global Area （SGA）

正确答案:C

You have executed this command to change the size of the dat

题目

参考答案和解析

相似问题和答案

更多相关问题

相关内容