单选题You are creating tablespaces in Oracle. Which of the following keywords or clauses permits the datafiles of a database to grow automatically in order to accommodate data growth?（）A DEFAULT STORAGE B EXTENT MANAGEMENT C AUTOEXTEND D DATAFILE

题目内容(请给出正确答案)

单选题

You are creating tablespaces in Oracle. Which of the following keywords or clauses permits the datafiles of a database to grow automatically in order to accommodate data growth?（）

DEFAULT STORAGE

EXTENT MANAGEMENT

AUTOEXTEND

DATAFILE

参考答案和解析

正确答案： C

解析：暂无解析

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

更多相关问题

第1题

单选题Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands： RMAN>RESTORE DATABASE； RMAN>RECOVER DATABASE； After successfully executing these RMAN commands， you issue the following statement using SQL*Plus： SQL>ALTER DATABASE OPEN； You receive the following errors when attempting to open the database： ORA-01157： cannot identify/lock data file 10 see DBWR trace file ORA-01110： data file 10： ’D:///USERS.DBF’ What is the cause of these errors？（）AThe USERS.DBF datafile is corrupted and cannot be restored by RMAN.BThe USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.CThe USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.DThe USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.

点击查看答案
第2题

单选题A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message： Which is the recommended sequence of operations you need to perform for the query successfully？（）ADrop the affected tablespace，re-create the tablespace，restore the datafiles，and the tablespace.BTake the affected datafile offline（if not already offline），restore the damaged image of the datafile，and then bring it online.CRestart the database in MOUNT mode，restore the damaged datafile，recover the datafile and then open the database with resetlogs.DPut the database in RESTRICTED mode，restore all the datafiles in the affected datafile and recover the tablespace，and then put the database in normal operational mode.

点击查看答案
第3题

多选题You executed the following command to create a tablespace called SALES_DATA： > CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace （）AThe database automatically determines the extent-sizing policy for the tablespace.BThe segments are automatically shrunk when the contents are removed from them.CThe allocation of extents within the tablespace is managed through the dictionary tables.DThe space utilization description of the data blocks in segments is recorded inbitmapblocks.EThe space utilization description of the data blocks in segments is managed through free lists.MANUAL

点击查看答案
第4题

单选题Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement： SQL> DROP TABLE SCOTT.EMP PURGE； After one hour， you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup？（）Athe datafiles associated with the SYSTEM tablespaceBthe datafiles associated to the DATA1 tablespaceCthe datafiles associated to the SYSTEM and DATA1 tablespacesDall the datafiles in the database

点击查看答案
第5题

单选题You want the size of the tablespace to increase when it is full. Which option would you use？（）A use automatic extent allocationB disable threshold for the tablespaceC use freelists to manage the free spaceD use automatic segment space managementE create the tablespace as a bigfile tablespaceF use the RESIZE clause while creating the tablespaceG enable AUTOEXTEND for at least one of the data files in the tablespace

点击查看答案
第6题

单选题Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode？（）AArchive log generation is suspended until the tablespaces are taken out of hot backup mode. BDatafiles are not written to during hot backups.CChanges to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.DThe datafile headers are not updated during the backup.EThe way data is written to the online redo logs is unchanged during the backup.

点击查看答案
第7题

单选题You are the Database Administrator for WonderWeb， which has recently acquired a media company TXGlobal. You have been assigned the task to migrate all the database applications of TXGlobal to the database server of WonderWeb. To accommodate more database applications， you need to add disks to the existing disk group. Whenever you add or remove disks from the disk group， Automatic Storage Management （ASM） rebalancing distributes the data evenly across all the disks of the disk group. Which background process performs this actual rebalancing activity， resulting in the movement of data extents in the disk groups？（）AASMBBARBnCRBAL in the ASM instanceDRBAL in the database instance

点击查看答案

单选题You are creating tablespaces in Oracle. Which of the following keywords or clauses permits the datafiles of a database to grow automatically in order to accommodate data growth?（）A DEFAULT STORAGE B EXTENT MANAGEMENT C AUTOEXTEND D DATAFILE

题目内容(请给出正确答案)

参考答案和解析

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容