單項選擇題

You want the size of the tablespace to increase when it is full. Which option would you use？（）

A.use automatic extent allocation
B.disable threshold for the tablespace
C.use freelists to manage the free space
D.use automatic segment space management
E.create the tablespace as a bigfile tablespace
F.use the RESIZE clause while creating the tablespace
G.enable AUTOEXTEND for at least one of the data files in the tablespace

你可能感興趣的試題

單項選擇題

Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning， media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday. What would you do in this situation？（）

A.recover using Oracle Flashback Database technology
B.restore the data files from backup and perform a complete recovery
C.restore only the corrupted data file and perform tablespace recovery
D.restore the data files from backup and perform cancel-based recovery
E.restore the entire database from the most recent backup and start the instance and open the database

多項選擇題

Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true？（）

A.The destination must be global only.
B.A maximum of five destinations can be assigned.
C.A maximum of ten different destinations can be assigned.
D.All the destinations are determined by the server automatically.
E.The destination may be local or remote for a Standby Database.
F.The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区 狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

You want the size of the tablespace to increase when it is full. Which option would you use？（）

你可能感興趣的試題

Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning， media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday. What would you do in this situation？（）

Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true？（）

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning， media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday. What would you do in this situation？（）

Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true？（）