多选题Examine these two statements:Which three are true about the MRKT tablespace?()AThe MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.BThe MRKT tablespace may be dropped if it has no contents.CUsers who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.DNo more data files can be added to the tablespace.EThe relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.

多选题
Examine these two statements:Which three are true about the MRKT tablespace?()
A

The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.

B

The MRKT tablespace may be dropped if it has no contents.

C

Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.

D

No more data files can be added to the tablespace.

E

The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.


参考解析

解析: 暂无解析

相关考题:

In which situation is the UNDO_RETENTION parameter be ignored, even if it is set to a value()A、When the data file of the undo tablespace is autoextensibleB、When there are more than one undo tablespaces available in the databaseC、When the undo tablespace is of a fixed size and retention guarantee is not enabledD、When the undo tablespace is autoextensible and retention guarantee is not enabled

The user HR receives the following error while inserting data into the TTK table: ERROR at line 1:  ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMDUpon  investigation, you find that SMD is a small file tablespace.  Which three action would allow the user to insert data()A、Add a data file to the SMD tablespace.B、Add a data file to the temporary tablespace associated with the user HR.C、Resize the data file associated with the SMD tablespace to make it larger.D、Alter the data file associated with the SMD tablespace to grow automatically.E、Change the segment space management for the SMD tablespace to automatic. n segments is managed through free lists.

In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value()A、when the data file of the undo tablespace is autoextensibleB、when there are more than one undo tablespaces available in the databaseC、when the undo tablespace is of a fixed size and retention guarantee is not enabledD、when the undo tablespace is autoextensible and retention guarantee is not enabled

Which two statements about bigfile tablespaces are true? ()A、The bigfile tablespace have only one data file.B、The segment space management is automatic.C、The extent management is dictionary managed.D、The database can have only one bigfile tablespace.E、The bigfile tablespace can be converted to a smallfile tablespace.

Examine the command that is used to create a table:  SQL CREATE TABLE orders(oid NUMBER(6) PRIMARY KEY, odate DATE, ccode NUMBER(6), oamt NUMBER(10,2)) TABLESPACE users;  Which two statements are true about the effect of the above command) ()A、A CHECK constraint is created on the OID column.B、A NOT NULL constraint is created on the OID column.C、The ORDERS table is the only object created in the USERS tablespace.D、The ORDERS table and a unique index are created in the USERS tablespace.E、The ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.

Which two statements are true about the use of the procedures listed in the vsysaux_occupants.move_procedure column?()A、The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.B、The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.C、All the components may be moved into SYSAUX tablespace.D、All the components may be moved from the SYSAUX tablespace.

The user HR receives the following error while inserting data into the TTK table:ERROR at line 1: ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation, you find that SMDis a small file tablespace. Which three action would allow the user to insert data()A、Add a data file to the SMD tablespace.B、Add a data file to the temporary tablespace associated with the user HR.C、Resize the data file associated with the SMD tablespace to make it larger.D、Alter the data file associated with the SMD tablespace to grow automatically.E、Change the segment space management for the SMD tablespace to automatic

View this parameter setting in your database:   DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’  You created a tablespace by using this command:   CREATE TABLESPACE USERS;  Which two statements are true about the USERS tablespace?()A、The tablespace has two data files.B、An error is reported and tablespace creation fails.C、Data files are created with names generated by the instance.D、The tablespace can be extended without specifying the data file.E、Data files belonging to the USERS tablespace cannot be renamed.

Examine the commands executed in a DBA session:SQL CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO; Tablespace created. SQL ALTER DATABASE DEFAULT TABLESPACE MRKT; Database altered.  Which two statements are trueregarding the MRKT tablespace()A、No more data files can be added to the tablespace.B、Segment space is managed by free lists in the tablespace.C、A user created without being assigned a default tablespace uses this tablespace.D、The tablespace can be dropped with the current setting with segments present in it

You lost a data file that belongs to an index tablespace in your database, which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem? ()A、 Restore the lost data file from the backup, and then flash back the database.B、 Restore the data file pertaining to index tablespace, and then recover the tablespace.C、 Restore all the data files, and then perform an incomplete recovery to get the tablespace back.D、 Restore all the data files, and then perform an incomplete recovery using the backup control file.E、 Drop and re-create the index tablespace, and then re-create all of the indexes in that tablespace.

Examine these two statements:Which three are true about the MRKT tablespace?()A、The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.B、The MRKT tablespace may be dropped if it has no contents.C、Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.D、No more data files can be added to the tablespace.E、The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.

In which of the following scenarios is a tablespace recovery required?()A、 when recovering a lost read-only tablespace from a read-only tablespace backupB、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  ARCHIVELOG modeC、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  NOARCHIVELOG mode and the changes in the online redo log files have been overwrittenD、 when recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file, the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement, and this statement was issued when the tablespace was read-only

Your database block size is 4 KB. In this database, you are required to create a tablespace with a block size of 8 KB. Which is the prerequisite for creating this tablespace?()A、 The parameter DB_CACHE_SIZE must be a multiple of 8.B、 The value of the parameter SGA_MAX_SIZE must be increased.C、 The tablespace must be created with a uniform extent size of 8 KBD、 The parameter DB_8K_CACHE_SIZE must be defined in the parameter file.

多选题The user HR receives the following error while inserting data into the TTK table: ERROR at line 1:  ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMDUpon  investigation, you find that SMD is a small file tablespace.  Which three action would allow the user to insert data()AAdd a data file to the SMD tablespace.BAdd a data file to the temporary tablespace associated with the user HR.CResize the data file associated with the SMD tablespace to make it larger.DAlter the data file associated with the SMD tablespace to grow automatically.EChange the segment space management for the SMD tablespace to automatic. n segments is managed through free lists.

多选题Examine the commands executed in a DBA session:SQL CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO; Tablespace created. SQL ALTER DATABASE DEFAULT TABLESPACE MRKT; Database altered.  Which two statements are trueregarding the MRKT tablespace()ANo more data files can be added to the tablespace.BSegment space is managed by free lists in the tablespace.CA user created without being assigned a default tablespace uses this tablespace.DThe tablespace can be dropped with the current setting with segments present in it

多选题The user HR receives the following error while inserting data into the TTK table:ERROR at line 1: ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation, you find that SMDis a small file tablespace. Which three action would allow the user to insert data()AAdd a data file to the SMD tablespace.BAdd a data file to the temporary tablespace associated with the user HR.CResize the data file associated with the SMD tablespace to make it larger.DAlter the data file associated with the SMD tablespace to grow automatically.EChange the segment space management for the SMD tablespace to automatic

多选题Examine the command that is used to create a table: SQL CREATE TABLE orders(oid NUMBER(6) PRIMARY KEY, odate DATE, ccode NUMBER (6), oamtNUMBER(10,2)) TABLESPACE users; Which two statements are true about the effect of the above command()AA CHECK constraint is created on the OID column.BA NOT NULL constraint is created on the OID column.CThe ORDERS table is the only object created in the USERS tablespace.DThe ORDERS table and a unique index are created in the USERS tablespace.EThe ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.

多选题You lost a data file that belongs to an index tablespace in your database, which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem? ()ARestore the lost data file from the backup, and then flash back the database.BRestore the data file pertaining to index tablespace, and then recover the tablespace.CRestore all the data files, and then perform an incomplete recovery to get the tablespace back.DRestore all the data files, and then perform an incomplete recovery using the backup control file.EDrop and re-create the index tablespace, and then re-create all of the indexes in that tablespace.

多选题Which two statements are true regarding the MRKT tablespace()ANo more data files can be added to the tablespace.BSegment space is managed by free lists in the tablespace.CA user created without being assigned a default tablespace uses this tablespace.DThe tablespace can be dropped with the current setting with segments present in it.

多选题Which two statements are true about the use of the procedures listed in the vsysaux_occupants.move_procedure column?()AThe procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.BThe procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.CAll the components may be moved into SYSAUX tablespace.DAll the components may be moved from the SYSAUX tablespace.

多选题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.)AThe backup piece size will be limited to 300 MBBThe RMAN uses multiplexing to perform backupCThe operation is accomplished using the default channel availableDThe RMAN parallelizes the backup although the parallelism is not set for a channel

多选题Which two statements about bigfile tablespaces are true? ()AThe bigfile tablespace have only one data file.BThe segment space management is automatic.CThe extent management is dictionary managed.DThe database can have only one bigfile tablespace.EThe bigfile tablespace can be converted to a smallfile tablespace.

单选题There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow.  There was only one data file on this disk; it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available?()AOnly bring the tablespace back online.BOnly recover the tablespace and then bring the tablespace back online.CShut down the database, recover the data file and then start up the database.DIssue the ALTER DATABASE RENAME FILE command, recover the tablespace, and then bring the tablespace online.ERecover the tablespace, issue the ALTER DATABASE RENAME FILE command, and then bring the tablespace online.

多选题View this parameter setting in your database:   DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’  You created a tablespace by using this command:   CREATE TABLESPACE USERS;  Which two statements are true about the USERS tablespace?()AThe tablespace has two data files.BAn error is reported and tablespace creation fails.CData files are created with names generated by the instance.DThe tablespace can be extended without specifying the data file.EData files belonging to the USERS tablespace cannot be renamed.

多选题You execute the following command to change the status of the SALES tablespace:SQL ALTER TABLESPACE sales OFFLINE; Which statements describe the effect of the command()AThe tablespace would require recovery to go back online.BA checkpoint is taken on all data files that are associated with the SALES tablespace.CThe sessions that subsequently try to access the objects in the SALES tablespace receive an errorDThe new status of the SALES tablespace is recorded in the control file when the database instance isclosed

多选题You execute the following command to change the status of the SALES tablespace:  SQL ALTER TABLESPACE sales OFFLINE;  Which statements describe the effect of the command()AThe tablespace would require recovery to go back online.BA checkpoint is taken on all data files that are associated with the SALES tablespace.CThe sessions that subsequently try to access the objects in the SALES tablespace receive an error.DThe new status of the SALES tablespace is recorded in the control file when the database instance is closed.

单选题Your database block size is 4 KB. In this database, you are required to create a tablespace with a block size of 8 KB. Which is the prerequisite for creating this tablespace?()A The parameter DB_CACHE_SIZE must be a multiple of 8.B The value of the parameter SGA_MAX_SIZE must be increased.C The tablespace must be created with a uniform extent size of 8 KBD The parameter DB_8K_CACHE_SIZE must be defined in the parameter file.