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（）
A. ecause 4194304 is the granule size
B. ecause 4194304 is the standard block size
C. ecause 4194304 is the largest nonstandard block size defined in the database
D. ecause 4194304 is the total size of data already available in the database buffer cache
查看答案
相关试题
换一换
You executed the following command in Recovery Manager （RMAN）： RMAN> RESTORE CONTROLFILE; Which operation must you perform before this command is executed？（）
A.back up the control file to trace B.bring database to the MOUNT state C.open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database D.set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
答案
You decided to change the location of the flash recovery area. You executed the following command： Which statement is true？（）
A.The location can be changed only if the flash recovery area is empty. B.fter 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.ll 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.
答案
Have&8194;you&8194;ever&8194;traveled&8194;on&8194;____&8194;train？&8194;
A.&8194;the&8194; B.&8194;a&8194;’&8194; C.&8194;an&8194; D.&8194;/
答案
You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）
A. The time when the last flashback operation in your database was performed. B. The time when the first flashback operation in your database was performed. C. A list of flashback operations performed in your database using SCN and time. D. The approximate time and the lowest system change number （SCN） to which you can flash back your database.
答案
You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）
A. The time when the last flashback operation in your database was performed. B. The time when the first flashback operation in your database was performed. C. A list of flashback operations performed in your database using SCN and time. D. The approximate time and the lowest system change number （SCN） to which you can flash back your database.
答案
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（）
A.ecause 4194304 is the granule size B.ecause 4194304 is the standard block size C.ecause 4194304 is the largest nonstandard block size defined in the database D.ecause 4194304 is the total size of data already available in the database buffer cache
答案
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 files B.dropping a user in your database C.enabling or disabling redo log archiving D.dropping a tablespace in your database E.re-creating the control files， after you lost all the control files in your database
答案
You executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）
A.Image of the control file B.Location of the control file C.ontents of the control file in text format D.SQL command to re-create the database E.SQL command to re-create the control file F.ontents of the control file in binary format
答案
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
答案
Which built-in would you use to test whether the CREATE TABLE command issued in the SALES form executed successfully?（）
A.FORMS_DDL B.DO_SQL C.FORM_SUCCESS D.FORM_NOT_SUCCESS E.DBMS.ERROR_CODE
答案
热门试题
Which built-in would you use to test whether the CREATE TABLE command issued in the SALES form executed successfully?（）
You executed the following FLASHBACK TABLE command： FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）； Which two statements are correct？ （）
You executed the following FLASHBACK TABLE command： FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）； Which two statements are correct？ （）
You executed the following FLASHBACK TABLE command： FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）; Which two statements are correct？（）
You executed the following FLASHBACK TABLE command： FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）; Which two statements are correct？（）
You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）
You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）
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？（）
You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to（）.
You work as a database administrator for Certkiller .com. You suspect that in one of your applications the customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries being executed on the customer table？（）
You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）
You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）
You work as a database administrator for Certkiller .com. You suspect that in one of your applications the customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries being executed on the customer table？（）
You work as a database administrator for Supportcenter.cn. You suspect that in one of your applications the customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries being executed on the customer table？（）
You work as a database administrator for Supportcenter.cn. You suspect that in one of your applications the customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries being executed on the customer table？（）
Which of the following commands cannot be executed when the database open？（）
You are working on an online transaction processing （OLTP） system. You notice that a PL/SQL procedure got executed twice at 2） 00 p.m. This has incorrectly updated the EMP_SAL table. How would you revert the table to its state at 2） 00 p.m.？（）
You are working on an online transaction processing （OLTP） system. You notice that a PL/SQL procedure got executed twice at 2） 00 p.m. This has incorrectly updated the EMP_SAL table. How would you revert the table to its state at 2） 00 p.m.？（）
You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database：RMAN> REPORT NEED BACKUP days 3；What would be the output of this command？（）
While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）
使用微信扫一扫登录
