You want to create a tablespace to contain objects with block size 16 KB. But while configuring thestorage you find that the block size that you can provide is only 8 KB. Which configuration could have enabled the block selection of 16 KB()
Achoosing the extent allocation type to uniform
Bchoosing the Segment Space Management option to manual
Csetting autoextension on for the data file mentioned for the tablespace
Dsetting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value
正确答案
答案解析
相似试题
(单选题)
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?()
(单选题)
Your boss at Certkiller .com wants you to clarify Oracle 10g. What statement about the Shared Server configuration is valid?()
(单选题)
You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this?()
(单选题)
You want to configure and schedule offline database backups to run automatically. Which tool or utilitywould you use to achieve this()
(单选题)
You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically. Which tool or utility would you use to achieve this? ()
(单选题)
You are maintaining the SALES database. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity. Which parameter should you specify to control the speed of the rebalancing activity?()
(单选题)
You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure. Which configuration will you do to accomplish the task()
(单选题)
You want to create a copy of the DEPARTMENTS table. When that is complete, you want to truncate the new DEPARTMENTS table, then restore the data with a direct-load insert from the old DEPARTMENTS table. Which CREATE statement should you use?()
(单选题)
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?()
(单选题)
You want to use RMAN to create compressed backups. Which statement is true about the compression algorithms that RMAN can use?()