网友您好, 请在下方输入框内输入要搜索的题目:

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

During tablespace creation, which filename format is NOT used for creating datafiles associated with a tablespace?()

  • A、 incomplete names
  • B、 incomplete names with templates
  • C、 alias with template names
  • D、 numeric names

参考答案

更多 “During tablespace creation, which filename format is NOT used for creating datafiles associated with a tablespace?()A、 incomplete namesB、 incomplete names with templatesC、 alias with template namesD、 numeric names” 相关考题
考题 Which option is best practice for creating a recovery catalog owner in the catalog database?() A. Granting UNLIMITED QUOTA on the SYSTEM tablespace to the ownerB. Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the userC. Creating a new tablespace, allocating this as the default, and granting UNLIMITED QUOTA on this tablespace to the userD. Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user

考题 CEL文件的表头是() A.990 TEMS_-_Cell_namesB.991 TEMS_-_Cell_namesC.992 TEMS_-_Cell_namesD.993 TEMS_-_Cell_names

考题 国际非专利名是( )A.official names B.INN C.registered names D.trade names E.generic names

考题 CEL文件的表头是() A、990 TEMS_-_Cell_namesB、991 TEMS_-_Cell_namesC、992 TEMS_-_Cell_namesD、993 TEMS_-_Cell_names

考题 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?()A、 the datafiles associated with the SYSTEM tablespaceB、 the datafiles associated to the DATA1 tablespaceC、 the datafiles associated to the SYSTEM and DATA1 tablespacesD、 all the datafiles in the database

考题 For an incomplete recovery, which four backup types can be used by Recovery Manager (RMAN) to restore data files? ()A、RMAN image copiesB、RMAN database backupsC、RMAN tablespace backupsD、user­managed backups placed in the flash recovery areaE、user­managed backups that have been cataloged with RMANF、user­managed data file backups for which the full path name is specified

考题 Consider the following command to create a tablespace in your production database (which is using an Automatic Storage Management [ASM] instance to manage the database files):  CREATE TABLESPACE user_tbsp  DATAFILE ’+dgroup3(user_temp)/user_files/user_tbsp’ SIZE 200M;  What would be the result of this command?()A、It would result in an error because the template cannot be used along with the disk group.B、It would result in an error because the path cannot be specified while creating a tablespace in a disk group.C、It would create a tablespace with a data file that has an alias, and its attributes are set by the user-defined template.D、It would create a tablespace with a data file that does not have an alias, and its attributes are set by the user-defined template.

考题 You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()A、 online redo log filesB、 alert log filesC、 control fileD、 datafiles associated with the SYSTEM tablespace

考题 When performing an incomplete recover of the whole database, which data files must you restore? ()A、Only the damaged or lost data files.B、All of the data files of the database.C、Only the data files belonging to the SYSTEM tablespace.D、The data files belonging to the SYSTEM tablespace and the damaged or lost data files.

考题 Which option is best practice for creating a recovery catalog owner in the catalog database?()  A、 Granting UNLIMITED QUOTA on the SYSTEM tablespace to the ownerB、 Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the userC、 Creating a new tablespace,allocating this as the default, and granting UNLIMITED QUOTA on this tablespace to the userD、 Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user

考题 Connection Manager features cannot be used with which of the following naming method? ()A、Oracle namesB、Local NamingC、Host NamingD、Names Server

考题 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.

考题 You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace?()A、 by using the Flashback Database featureB、 by using RMAN incomplete recoveryC、 by performing a user-managed incomplete recoveryD、 by dropping and re-creating the index 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? ()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.

考题 Your database contains two temporary tablespaces named TEMP and TEMP1. The TEMP tablespace is the default temporary tablespace for the database, and the TEMP1 tablespace was created at database creation. You want to increase the size of the tempfile for the TEMP tablespace and drop the TEMP1 tablespace from the database. The database is not using Oracle-Managed Files (OMF). Which statement must you use to ensure that when you drop the TEMP1 tablespace from the database, its corresponding operating system file is also deleted?()A、 DROP TABLESPACE temp1;B、 DROP TABLESPACE temp1 INCLUDING CONTENTS;C、 DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES;D、 DROP TABLESPACE temp1 INCLUDING CONTENTS CASCADE CONSTRAINTS;

考题 You took the DATA1 tablespace offline at 10:00 A.M. At 12:30 P.M., a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2:00 P.M. and decided to perform an incomplete recovery.  Which datafiles will you recover?()A、 all the datafiles in the databaseB、 the datafiles associated with the SYSTEM tablespaceC、 the datafiles associated with the DATA1 tablespaceD、 all the datafiles in the database except those associated with the DATA1 tablespace

考题 单选题CEL文件的表头是()A 990 TEMS_-_Cell_namesB 991 TEMS_-_Cell_namesC 992 TEMS_-_Cell_namesD 993 TEMS_-_Cell_names

考题 单选题You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()A  online redo log filesB  alert log filesC  control fileD  datafiles associated with the SYSTEM tablespace

考题 单选题Consider the following command to create a tablespace in your production database (which is using an Automatic Storage Management [ASM] instance to manage the database files): CREATE TABLESPACE user_tbsp DATAFILE ’+dgroup3 (usder_temp) /user_files/user_tbsp’ SIZE 200M; What would be the result of this command?()A  It would result in an error because the template cannot be used along with the disk group.B  It would result in an error because the path cannot be specified while creating a tablespace in a disk group.C  It would create a tablespace with a data file that has an alias, and its attributes are set by the user-defined template.D  It would create a tablespace with a data file that does not have an alias, and its attributes are set by the user-defined template.

考题 单选题During tablespace creation, which filename format is NOT used for creating datafiles associated with a tablespace?()A  incomplete namesB  incomplete names with templatesC  alias with template namesD  numeric names

考题 单选题When performing an incomplete recover of the whole database, which data files must you restore? ()A Only the damaged or lost data files.B All of the data files of the database.C Only the data files belonging to the SYSTEM tablespace.D The data files belonging to the SYSTEM tablespace and the damaged or lost data files.

考题 单选题You lost the PRODSTD tablespace, which was read-only. The tablespace was read-only when the last backup was taken. How would you recover the tablespace?()A  restore the tablespace from the backup, and then perform an incomplete recoveryB  restore the tablespace from the backup, and then apply all the redo informationC  restore all the data files in the database, and then perform an incomplete recoveryD  restore the tablespace from the backup

考题 单选题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?()A  the datafiles associated with the SYSTEM tablespaceB  the datafiles associated to the DATA1 tablespaceC  the datafiles associated to the SYSTEM and DATA1 tablespacesD  all the datafiles in the database

考题 多选题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.

考题 多选题For an incomplete recovery, which four backup types can be used by Recovery Manager (RMAN) to restore data files? ()ARMAN image copiesBRMAN database backupsCRMAN tablespace backupsDuser­managed backups placed in the flash recovery areaEuser­managed backups that have been cataloged with RMANFuser­managed data file backups for which the full path name is specified

考题 单选题You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace?()A  by using the Flashback Database featureB  by using RMAN incomplete recoveryC  by performing a user-managed incomplete recoveryD  by dropping and re-creating the index tablespace

考题 单选题You took the DATA1 tablespace offline at 10:00 A.M. At 12:30 P.M., a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2:00 P.M. and decided to perform an incomplete recovery.  Which datafiles will you recover?()A  all the datafiles in the databaseB  the datafiles associated with the SYSTEM tablespaceC  the datafiles associated with the DATA1 tablespaceD  all the datafiles in the database except those associated with the DATA1 tablespace