单选题You are attempting to create an Oracle-Managed Files （OMF） tablespace in a production database with the following statement and receive the following error message： CREATE TABLESPACE tbsl； ORA-02199： missing DATAFILE/TEMPFILE clause oerr ora 2199 02199， 00000， “missing DATAFILE/TEMPFILE clause” *Cause： A CREATE TABLESPACE statement has no DATAFILE/TEMPFTLE clause. *Action： specify DATAFILE/TEMPFILE clause. What is the corrective action to create the OMF based tablespace？（）A AB BC CD D
单选题
You are attempting to create an Oracle-Managed Files （OMF） tablespace in a production database with the following statement and receive the following error message： CREATE TABLESPACE tbsl； ORA-02199： missing DATAFILE/TEMPFILE clause oerr ora 2199 02199， 00000， “missing DATAFILE/TEMPFILE clause” *Cause： A CREATE TABLESPACE statement has no DATAFILE/TEMPFTLE clause. *Action： specify DATAFILE/TEMPFILE clause. What is the corrective action to create the OMF based tablespace？（）
A
A
B
B
C
C
D
D
参考解析
解析：
暂无解析
相关考题：
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?（）A. Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.B. Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online.C. Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.D. Put 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.
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?（）A、Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace. B、Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online. C、Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.D、Put 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.
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.
The database is currently open and the temp03.dbf tempfile belonging to the default temporarytablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner？（） A、 Allow the database to continue running，drop the TEMP tablespace，and then re-create it with new tempfilesB、 Shut down the database， restore and recover the tempfile from backup，and then open the database with RESETLOGSC、 Allow the database to continue running，take the TEMP tablespace offline，drop the missing tempfile，and then create a new tempfileD、 Allow the database to continue running，add a new tempfile to TEMP tablespace with a new name，and drop the tempfile that has been corrupted
A user sends you an email with the following error message： create table idtable（id number） * ERROR at line 1： ORA- 01110： data file 4： ，，/oracle01/oradata/orcl/users01.dbf ORA-27041： 01116： error in opening database file 4 ORA-unable to open file Linux Error： 2： No such file or directory Additional information： 3 You can choose from the following steps： a. Restore the missing database datafiles. b. Take the missing datafile offline. c. Shut down the database. d. Issue the recover tablespace USERS command. e. Issue the Startup Mount command to mount the database. f. Bring the USERS tablespace online. g. Issue the alter database open command. Which is the correct order of these steps in this case？（）A、b， a， d， fB、c， a， e， b， d， f， gC、c， e， d， gD、b， d， f E、e， d， g
What is the proper procedure to recover a lost tempfile？（） A、 Restore the backup copy of the tempfile from the backup media.B、 Re-create the tempfile with the create tempfile command.C、 Copy an existing tempfile from another database.D、 Re-create the tempfile with the create tablespace command.E、 Re-create the tempfile with the alter tablespace command.
Which statement will NOT create a tablespace？（）A、 CREATE TABLESPACE DATA1 DATAFILE ’+grp1/abc（datafile）’；B、 CREATE TABLESPACE DATA1 DATAFILE ’+grp1’；C、 CREATE TABLESPACE DATA1 DATAFILE ’+data1（tempfile）’；D、 CREATE TABLESPACE DATA1 DATAFILE ’+grp1.256.34359’；
Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table： ERROR at line 1： ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES.While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）A、 Drop and re-create the inbox.B、 Coalesce the ORDERS_IND index.C、 Coalesce the INDEXES tablespace.D、 Drop and re-create the ORDERS table.E、 Rebuild the index online and move it to another tablespace.
You execute the following set of commands to create a database user and to grant the system privileges in your production environment. SQL CREATE USER user01 IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1 TEMPORARY TABLESPACE temp PROFILE default / SQL GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails. ERROR at line 1： ORA-01950： no privileges on tablespace What could be the possible reason for this error message？（）A、The tablespace TBS1 is full.B、The user is not the owner of the SYSTEM tablespace.C、The user does not have quota on the TBS1 tablespace.D、The user does not have sufficient system privileges to create table in the TBS1 tablespace.E、The user does not have sufficient privileges to create table on the default permanent tablespace.
Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table： ERROR at line 1： ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）A、drop and re-create the indexB、coalesce the ORDERS_IND indexC、coalesce the INDEXES tablespaceD、drop and re-create the ORDERS tableE、rebuild the index online and move it to another 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；
The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?（）A、Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfilesB、Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGSC、Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfileD、Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.
Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command: SQL CREATE UNDO TABLESPACE undotb01 DATAFILE ‘u01/oracle/rddb1/undotbs01.dbf’ SIZE 60M AUTOEXTEND ON; What is the result?（）A、It executes successfully and creates an UNDO tablespace in hr_pdb.B、It falls and reports an error because there can be only one undo tablespace in a cdb.C、It fails and reports an error because the CONTAINER=ALL clause is not specified in the command.D、It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.E、It executes successfully but neither tablespace nor the data file is created.
The ORDERS table in the database of a company contains one million records. The table is stored in the DATA tablespace and the index created on the ORDERS table is stored in the index tablespace named INDEXES. On Monday， you failed to start the database because the datafiles of the INDEXES tablespace were missing. You dropped and recreated the INDEXES tablespace by issuing the following command： SQLDROP TABLESPACE INDEXES INCLUDING CONTENTS； SQL CREATE TABLESPACE INDEXES DATAFILE ’C:///ORACLE/ORADATA/ORA101t/INDEX01.DBF’ SIZE 50m； After that， you issued the following command to recreate the index： CREATE UNIQUE INDEX sales_index_pk ON sales （order_id） PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE indexes STORAGE （ INITIAL 1m NEXT 1m PCTINCREASE 0 MINEXTENTS 1 MAXEXTENTS 8192 ） NOLOGGING PARALLEL（ degree 4） Which two clauses are responsible for reducing the time for the recreation of the index？（）A、 PCTFREEB、 MAXTRANSC、 PCTINCREASED、 INITIALE、 NOLOGGINGF、 PARALLEL
单选题Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command: SQL CREATE UNDO TABLESPACE undotb01 DATAFILE ‘u01/oracle/rddb1/undotbs01.dbf’ SIZE 60M AUTOEXTEND ON; What is the result?（）AIt executes successfully and creates an UNDO tablespace in hr_pdb.BIt falls and reports an error because there can be only one undo tablespace in a cdb.CIt fails and reports an error because the CONTAINER=ALL clause is not specified in the command.DIt fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.EIt executes successfully but neither tablespace nor the data file is created.
单选题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.
单选题You have three temporary tablespace groups named G1， G2， and G3 in your database. You are creating a new temporary tablespace as follows： CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE ’/u1/data/temp1.dbf’ SIZE 10M TABLESPACE GROUP ； Which statement regarding the above command is correct？（）A It will create the tablespace TEMP1 in group G1.B It will create the tablespace TEMP1 in group G3.C It will not add the tablespace TEMP1 to any group.D It will create the tablespace TEMP1 in the default group.
单选题A user sends you an email with the following error message： create table idtable（id number） * ERROR at line 1： ORA- 01110： data file 4： ，，/oracle01/oradata/orcl/users01.dbf ORA-27041： 01116： error in opening database file 4 ORA-unable to open file Linux Error： 2： No such file or directory Additional information： 3 You can choose from the following steps： a. Restore the missing database datafiles. b. Take the missing datafile offline. c. Shut down the database. d. Issue the recover tablespace USERS command. e. Issue the Startup Mount command to mount the database. f. Bring the USERS tablespace online. g. Issue the alter database open command. Which is the correct order of these steps in this case？（）Ab， a， d， fBc， a， e， b， d， f， gCc， e， d， gDb， d， f Ee， d， g
单选题What is the proper procedure to recover a lost tempfile?（）ARestore the backup copy of the tempfile from the backup media. BRe-create the tempfile with the create tempfile command. CCopy an existing tempfile from another database. DRe-create the tempfile with the create tablespace command. ERe-create the tempfile with the alter tablespace command.
单选题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？（）A Drop the affected tablespace，re-create the tablespace，restore the datafiles，and the tablespace.B Take the affected datafile offline（if not already offline），restore the damaged image of the datafile，and then bring it online.C Restart the database in MOUNT mode，restore the damaged datafile，recover the datafile and then open the database with resetlogs.D Put 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.
单选题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.
单选题You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE /u1/data/temp1.dbf SIZE 10M TABLESPACE GROUP ;Which statement regarding the above command is correct?（）AIt will create the tablespace TEMP1 in group G1BIt will create the tablespace TEMP1 in group G3 CIt will not add the tablespace TEMP1 to any groupDIt will create the tablespace TEMP1 in the default groupEIt will throw an error with message 'specified group is not availableFIt will create a new group with a system-generated name and add the tablespace TEMP1 to it.
单选题You execute the following set of commands to create a database user and to grant the system privileges in your production environment. SQL CREATE USER user01 IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1 TEMPORARY TABLESPACE temp PROFILE default / SQL GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails. ERROR at line 1： ORA-01950： no privileges on tablespace What could be the possible reason for this error message？（）AThe tablespace TBS1 is full.BThe user is not the owner of the SYSTEM tablespace.CThe user does not have quota on the TBS1 tablespace.DThe user does not have sufficient system privileges to create table in the TBS1 tablespace.EThe user does not have sufficient privileges to create table on the default permanent tablespace.
单选题The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?（）AAllow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfilesBShut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGSCAllow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfileDAllow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.
单选题Which statement will NOT create a tablespace？（）A CREATE TABLESPACE DATA1 DATAFILE ’+grp1/abc（datafile）’；B CREATE TABLESPACE DATA1 DATAFILE ’+grp1’；C CREATE TABLESPACE DATA1 DATAFILE ’+data1（tempfile）’；D CREATE TABLESPACE DATA1 DATAFILE ’+grp1.256.34359’；
单选题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；
单选题The database is currently open and the temp03.dbf tempfile belonging to the default temporarytablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner？（）A Allow the database to continue running，drop the TEMP tablespace，and then re-create it with new tempfilesB Shut down the database， restore and recover the tempfile from backup，and then open the database with RESETLOGSC Allow the database to continue running，take the TEMP tablespace offline，drop the missing tempfile，and then create a new tempfileD Allow the database to continue running，add a new tempfile to TEMP tablespace with a new name，and drop the tempfile that has been corrupted