Which tablespaces are mandatory in an Oracle database for it to be operational（）

相似题目

• 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.

  查看最佳答案

• You are configuring your index to be stored in a tablespace. Which of the following storage parameters are NOT appropriate for indexes?（）

  A . OPTIMAL  B . INITIAL  C . PCTINCREASE  D . NEXT

  查看最佳答案

• Which statements are true regarding the USERS tablespace（）https://assets.asklib.com/images/image2/2018080116530878860.jpg

  A . A bitmap is used to record free extents. B . Free extents information is managed within the tablespace. C . Free extents information is managed in the SYSAUX tablespace. D . The data dictionary tables are updated when extents are allocated or deallocated

  查看最佳答案

• View the Exhibit. https://assets.asklib.com/images/image2/2018080210301383494.jpg You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS; Which three types of files are backed up？ （）

  A . password file B . online redo log files C . the current control file D . archived redo log files E . the current server parameter file F . all the data files belonging to the USERS tablespace G . data files belonging to the USERS tablespace and all the default tablespace

  查看最佳答案

• 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.

  查看最佳答案

• Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）

  A .  The target database must be in NOARCHIVELOG mode. B .  No backup is required of the database before you perform a TSPITR. C .  You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set. D .  If you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred. E .  If you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.

  查看最佳答案

• Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）

  A .  open the database with the RESTRICTED option B .  open the database with the RESETLOGS option C .  recover to the required SCN only that data file in which the error occurred D .  recover all the data files to the same system change number （SCN）

  查看最佳答案

• 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.

  查看最佳答案

• Your boss at Certkiller .com wants you to clarify Oracle 10g. Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correcte？（）

  A . This clause is not valid for a temporary or undotablespace. B . If thetablespaceis in the NOLOGGING mode， no operation on thetablespacewill generate redo. C . Thetablespacewill be IntheNOLOGGING mode by default， if not specified while creating atablespace. D . Thetablespace-level logging attribute can be overridden by logging specification at the table， index， materialized view， materialized view log， and partition levels.

  查看最佳答案

• Which of the following are included in a transportable tablespace set？（）  

  A .  The datafiles that make up a self-contained group of tablespaces required for copy B .  The system tablespace C .  An export of the tablespace metadata D .  The spfile E .  All of the above

  查看最佳答案

• You are trying to alter the initial segment size given to a table in a dictionary-managed tablespace. Which of the following keywords would be used as part of this process?（）

  A . DROP TABLE  B . ALTER TABLE  C . RESIZE  D . COALESCE

  查看最佳答案

• Which two statements are true regarding the MRKT tablespace（）https://assets.asklib.com/images/image2/201808011650151744.jpg

  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.

  查看最佳答案

• Which two statements are true regarding undo tablespaces（）

  A . The database can have more than one undo tablespace. B . The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management. C . Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions. D . An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.

  查看最佳答案

• 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 （）

  A . The database automatically determines the extent-sizing policy for the tablespace. B . The segments are automatically shrunk when the contents are removed from them. C . The allocation of extents within the tablespace is managed through the dictionary tables. D . The space utilization description of the data blocks in segments is recorded inbitmapblocks. E . The space utilization description of the data blocks in segments is managed through free lists.MANUAL

  查看最佳答案

• Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode？（）

  A .  Archive log generation is suspended until the tablespaces are taken out of hot backup mode.  B .  Datafiles are not written to during hot backups. C .  Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered. D .  The datafile headers are not updated during the backup. E .  The way data is written to the online redo logs is unchanged during the backup.

  查看最佳答案

• Which three pieces of information are considered while deciding the size of the undo tablespace in your database？（）

  A . the size of an undo block B . the size of the redo log files C . undo blocks generated per second D . the size of the database buffer cache E . the value of the UNDO_RETENTION parameter

  查看最佳答案

• View the Exhibit. Which statements are true regarding the USERS tablespace（）https://assets.asklib.com/images/image2/2018080117542643082.jpg

  A . A bitmap is used to record free extents. B . Free extents information is managed within the tablespace. C . Free extents information is managed in the SYSAUX tablespace. D . The data dictionary tables are updated when extents are allocated or deallocated

  查看最佳答案

•  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

  查看最佳答案

• Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct？（）

  A . This clause is not valid for a temporary or undo tablespace. B . If the tablespace is in the NOLOGGING mode，no operation on the tablespace will generate redo. C . The tablespace will be in the NOLOGGING mode by default，if not specified while creating a tablespace. D . The tablespace-level logging attribute can be overridden by logging specifications at the table，index， materialized view，materialized view log，and partition levels.

  查看最佳答案

• View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS；  Which three types of files are backed up？ （）

  A .  all the data files belonging to the USERS tablespace B .  password file C .  online redo log files D .  the current control file E .  archived redo log files F .  the current server parameter file G .  data files belonging to the USERS tablespace and all the default tablespace

  查看最佳答案

• You executed the following command to create a tablespace called SALES_DATA： SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace（）

  A . The database automatically determines the extent-sizing policy for the tablespace. B . The segments are automatically shrunk when the contents are removed from them. C . The allocation of extents within the tablespace is managed through the dictionary tables. D . The space utilization description of the data blocks in segments is recorded in bitmap blocks. E . The space utilization description of the data blocks in segments is managed through free lists.

  查看最佳答案

• You are performing an incomplete recovery because a tablespace is dropped and purged from the Recycle Bin. In which mode will you execute the following code？（）  RMAN>RUN  {   SET UNTIL SEQUENCE  THREAD ；   RESTORE DATABASE；   RECOVER DATABASE；  }

  A .  NOMOUNT B .  MOUNT C .  OPEN D .  RESTRICTED

  查看最佳答案

• Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery.  Which two tasks would you be required to perform in the recovery process？ （）

  A . open the database with the RESETLOGS option B . open the database with the RESTRICTED option C . recover all the data files to the same system change number （SCN） D . recover to the required SCN only that data file in which the error occurred

  查看最佳答案

• You issued the following command:An index is then created on the ADMIN_WORK_AREA temporary table. Which two statements are true regarding the TBS_T1 tablespace in the above command？ （）

  <img src='https://img2.soutiyun.com/shangxueba/ask/64263001-64266000/64265568/67e67a73b604e73a7d1e2def2ff7dcea.jpg' /> A. It stores only the temporary table but not its indexes. B. It stores both the temporary table as well as its indexes. C. It must be a nondefault temporary tablespace for the database. D. It can be a default or nondefault temporary tablespace for the database. E. It must be the default temporary tablespace of the user who issues the command.

  查看最佳答案