单选题You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifi

题目
单选题
You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?（）
A

DB_CREATE_FILE_DEST 

B

DB_CREATE_ONLINE_LOG_1 

C

DB_CREATE_ONLINE_LOG_2

D

The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed

相似考题

1.You executed the following command:RMAN> RECOVER COPY OF DATAFILE ‘／u01／app／oracle／oradata／orcl／users01.dbf‘;Which statement regarding the above command is correct?()A. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the image copyB. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the last incremental backupC. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are updated with all changes up to incremental backup SCN. ‘/ u01/app/oracle/oradata/orcl/users01.dbfD. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are recovered using the above command if data file recovery fails

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

3. You opened the encryption wallet and then issued the following command：   SQL>CREATE TABLESPACE securespace DATAFILE ’/home/user/oradata/secure01.dbf’ SIZE 150M  ENCRYPTION USING ’3DES168’ DEFAULT STORAGE（ENCRYPT）；   Then you closed the wallet. Later， you issued the following command to create theEMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.  What is the outcome？（）  A、 It creates the table and encrypts the data in it.B、 It generates an error because the wallet is closed.C、 It creates the table but does not encrypt the data in it.D、 It generates an error because the NO SALT option cannot be used with the ENCRYPT option.

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

更多“单选题You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifi”相关问题

  • 第1题：

    You want to drop the TBS1 tablespace from your database.  You also want to delete the corresponding data files automatically， and not have to do it manually.  What should you do？（）

    • A、Use the DROP DATAFILE command.
    • B、Use the DROP TABLESPACE command.
    • C、Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.
    • D、Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.

    正确答案:B

  • 第2题：

    You executed the following command: RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf'; Which statement regarding the above command is correct?（）

    • A、The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copy
    • B、The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backup
    • C、  Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN. '/ u01/app/oracle/oradata/orcl/users01.dbf
    • D、Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails

    正确答案:C

  • 第3题：

    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.

    正确答案:C,D

  • 第4题：

    You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?（）

    • A、DB_CREATE_FILE_DEST 
    • B、DB_CREATE_ONLINE_LOG_1 
    • C、DB_CREATE_ONLINE_LOG_2
    • D、The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed

    正确答案:A

  • 第5题：

    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：    SQL>DROP 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、 PCTFREE
    • B、 MAXTRANS
    • C、 PCTINCREASE
    • D、 INITIAL
    • E、 NOLOGGING
    • F、 PARALLEL

    正确答案:E,F

  • 第6题：

    单选题
    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.


    正确答案： E
    解析： 暂无解析

  • 第7题：

    单选题
    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. 


    正确答案： B
    解析： 暂无解析

  • 第8题：

    单选题
    A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?（）
    A

    Acquire locks on table queried 

    B

    Generate redo for statement 

    C

    Fetch data from disk into memory 

    D

    Write changes to disk


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    You executed the following command：   RMAN> RECOVER COPY OF DATAFILE ’/u01/app/oracle/oradata/orcl/users01.dbf’；   Which statement regarding the above command is correct？（）
    A

     The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the image copy.

    B

     The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the last incremental backup.

    C

     Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are updated with all changes up to incremental backup SCN.

    D

     Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are recovered using the above command if data file recovery fails.


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    You want to drop the TBS1 tablespace from your database.  You also want to delete the corresponding data files automatically， and not have to do it manually.  What should you do？（）
    A

    Use the DROP DATAFILE command.

    B

    Use the DROP TABLESPACE command.

    C

    Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.

    D

    Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    You executed the following command: RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf'; Which statement regarding the above command is correct?（）
    A

    The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copy

    B

    The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backup

    C

      Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN. '/ u01/app/oracle/oradata/orcl/users01.dbf

    D

    Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?（）
    A

    DB_CREATE_FILE_DEST 

    B

    DB_CREATE_ONLINE_LOG_1 

    C

    DB_CREATE_ONLINE_LOG_2

    D

    The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed


    正确答案： A
    解析： 暂无解析

  • 第13题：

    You executed the following command：   RMAN> RECOVER COPY OF DATAFILE ’/u01/app/oracle/oradata/orcl/users01.dbf’；   Which statement regarding the above command is correct？（）  

    • A、 The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the image copy.
    • B、 The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the last incremental backup.
    • C、 Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are updated with all changes up to incremental backup SCN.
    • D、 Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are recovered using the above command if data file recovery fails.

    正确答案:C

  • 第14题：

    You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB.  You issue the following command from the RMAN prompt to perform a backup of the tablespace：   RMAN> BACKUP TABLESPACE TS1 MAXSETSIZE 100M；  Which statement is true about executing this command？（）

    • A、 The command generates an error.
    • B、 The command backs up the tablespace and creates a backup set of size 200 MB
    • C、 The command backs up the tablespace and creates two backup sets of size 100 MB each.
    • D、 The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.

    正确答案:A

  • 第15题：

    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

    正确答案:A,C

  • 第16题：

    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.

    正确答案:E

  • 第17题：

    You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?（）

    • A、SYSTEM 
    • B、OUTLN 
    • C、INTERNAL 
    • D、SYS

    正确答案:D

  • 第18题：

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


    正确答案： B,A
    解析： 暂无解析

  • 第19题：

    单选题
    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， f

    B

    c， a， e， b， d， f， g

    C

    c， e， d， g

    D

    b， d， f 

    E

    e， d， g


    正确答案： E
    解析： 暂无解析

  • 第20题：

    单选题
    You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB.  You issue the following command from the RMAN prompt to perform a backup of the tablespace：   RMAN> BACKUP TABLESPACE TS1 MAXSETSIZE 100M；  Which statement is true about executing this command？（）
    A

     The command generates an error.

    B

     The command backs up the tablespace and creates a backup set of size 200 MB

    C

     The command backs up the tablespace and creates two backup sets of size 100 MB each.

    D

     The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.


    正确答案： B
    解析： 暂无解析

  • 第21题：

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


    正确答案： B,D
    解析： 暂无解析

  • 第22题：

    单选题
    You opened the encryption wallet and then issued the following command：   SQL>CREATE TABLESPACE securespace DATAFILE ’/home/user/oradata/secure01.dbf’ SIZE 150M  ENCRYPTION USING ’3DES168’ DEFAULT STORAGE（ENCRYPT）；   Then you closed the wallet. Later， you issued the following command to create theEMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.  What is the outcome？（）
    A

     It creates the table and encrypts the data in it.

    B

     It generates an error because the wallet is closed.

    C

     It creates the table but does not encrypt the data in it.

    D

     It generates an error because the NO SALT option cannot be used with the ENCRYPT option.


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?（）
    A

    SYSTEM 

    B

    OUTLN 

    C

    INTERNAL 

    D

    SYS


    正确答案： A
    解析： 暂无解析

  • 第24题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

相关内容