多选题Examine the statement：   SQL> CREATE TABLESPACE user_data  2> EXTENT MANAGEMENT LOCAL  3> SEGMENT SPACE MANAGEMENT AUTO；   Which twp assumptions must be true for this statement to execute successfully？（）AOracle Managed Files are used for this instance.

题目
多选题
Examine the statement：   SQL> CREATE TABLESPACE user_data  2> EXTENT MANAGEMENT LOCAL  3> SEGMENT SPACE MANAGEMENT AUTO；   Which twp assumptions must be true for this statement to execute successfully？（）
A

Oracle Managed Files are used for this instance.

B

The USER_DATA tablespace is managed using FET$/UET$ tables.

C

The COMPATIBLE initialization parameter must be 9.0.0 or higher.

D

Space within segments in the USER_DATA tablespace is managed with freelists.

相似考题

1.View the Exhibit to examine the Automatic SQL Tuning result details.Which action would you suggest for the selected SQL statement in the Exhibit?()A. Accept the recommended SQL profile.B.Collect statistics for the related objects.C. Run the Access Advisor for the SQL statement.D. Run the Segment Advisor for recommendations.

2.Examine the structure of the STUDENTS table:You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999.Which SQL statement accomplishes this task?（）A.B.C.D.

3.Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?()A.B.C.D.

4.USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format.Which methodswould you use to achieve this?（）A. Use Data Pump to transfer the existing data to a new encrypted tablespaceB. Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespaceC. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespaceD. Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespaceE. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted

更多“Examine the statement：   SQL> CREATE TABLESPACE user_data  2”相关问题

  • 第1题：

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

    • 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 OID columnin the SYSTEM tablespace.

    正确答案:B,D

  • 第2题：

    You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes？（）

    • A、 SQL scripts
    • B、 Recovery Manager （RMAN） script
    • C、 Data Pump
    • D、 SQL*Loader
    • E、 Flashback database

    正确答案:A,C

  • 第3题：

    Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered  SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees；  Table created.  Further， you executed the following command to drop the table：  SQL> DROP TABLE emp；Table dropped.  What happens in this scenario？（）

    • A、The table is moved to the SYSAUX tablespace.
    • B、The table is moved to the SYSTEM tablespace.
    • C、The table is removed from the database permanently.
    • D、The table is renamed and remains in the TBSFD tablespace.

    正确答案:D

  • 第4题：

    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

  • 第5题：

    单选题
    Examine the commands executed in the following sequence：  1：SQL> CREATE ROLE mgrrole；  2：SQL> GRANT create user，select any table，connect，resource TO mgrrole；  3：SQL> GRANT select，update ON sh.sales TO mgrrole；  4：SQL> CREATE ROLE ceo IDENTIFIED BY boss；  5：SQL> GRANT mgrrole，drop any table，create any directory TO ceo；  6：SQL> GRANT ceo TO mgrrole；  Which statement is true about the above commands（）
    A

    The commands execute successfully.

    B

    Command 6 produces an error because of circular role grant.

    C

    Command 5 produces an error because a role cannot be granted to another role.

    D

    Command 3 produces an error because the MGRROLE role already contains system privileges.

    E

    The table created by HR remains and HR still has the CREATE TABLE system privilege.

    F

    The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.


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

  • 第6题：

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


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

  • 第7题：

    多选题
    Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN ('CREDIT', 'CASH')), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date)); For which columns would an index be automatically created when you execute the above SQL statement? （）
    A

    SER_NO

    B

    ORDER_ID

    C

    STATUS

    D

    PROD_ID

    E

    ORD_TOTAL

    F

    composite index on ORDER_ID and ORDER_DATE


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

  • 第8题：

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


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

  • 第9题：

    多选题
    Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN ('CREDIT', 'CASH')), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date)); For which columns would an index be automatically created when you execute the above SQL statement? （）
    A

    SER_NO

    B

    ORDER_ID

    C

    STATUS

    D

    PROD_ID

    E

    ORD_TOTAL

    F

    composite index on ORDER_ID and ORDER_DATE


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

  • 第10题：

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

    E

    It will throw an error with message 'specified group is not available

    F

    It will create a new group with a system-generated name and add the tablespace TEMP1 to it.


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

  • 第11题：

    多选题
    USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methodswould you use to achieve this?（）
    A

    Use Data Pump to transfer the existing data to a new encrypted tablespace

    B

    Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespace

    C

    Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace

    D

    Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespace

    E

    Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted


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

  • 第12题：

    单选题
    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
    解析： 暂无解析

  • 第13题：

    You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE；  What does the statement generate？（）

    • A、A text copy of the control file.
    • B、A binary copy of the control file.
    • C、A file containing a SQL statement which will re-create the database.
    • D、A file containing a SQL statement which will re-create the control file.

    正确答案:D

  • 第14题：

    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’；

    正确答案:D

  • 第15题：

    You find pockets of empty space in the USER_DATA tablespace due to a lot of DML operations on the objects in the USER_DATAtablespace. The pockets of empty spaces are too small to be reused individually. This is leading to wastage of space. You decide to perform the shrink operation to reclaim the wasted space. Which advisor will you use to determine the objects in the USER_DATA tablespace that are good candidates for the shrink operation？（）

    • A、 SQL Tuning Advisor
    • B、 SQL Access Advisor
    • C、 Undo Advisor
    • D、 Segment Advisor

    正确答案:D

  • 第16题：

    单选题
    You find pockets of empty space in the USER_DATA tablespace due to a lot of DML operations on the objects in the USER_DATAtablespace. The pockets of empty spaces are too small to be reused individually. This is leading to wastage of space. You decide to perform the shrink operation to reclaim the wasted space. Which advisor will you use to determine the objects in the USER_DATA tablespace that are good candidates for the shrink operation？（）
    A

     SQL Tuning Advisor

    B

     SQL Access Advisor

    C

     Undo Advisor

    D

     Segment Advisor


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

  • 第17题：

    多选题
    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（）
    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 OID columnin the SYSTEM tablespace.


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

  • 第18题：

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


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

  • 第19题：

    单选题
    You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE；  What does the statement generate？（）
    A

    A text copy of the control file.

    B

    A binary copy of the control file.

    C

    A file containing a SQL statement which will re-create the database.

    D

    A file containing a SQL statement which will re-create the control file.


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

  • 第20题：

    单选题
    Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered  SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees；  Table created.  Further， you executed the following command to drop the table：  SQL> DROP TABLE emp；Table dropped.  What happens in this scenario？（）
    A

    The table is moved to the SYSAUX tablespace.

    B

    The table is moved to the SYSTEM tablespace.

    C

    The table is removed from the database permanently.

    D

    The table is renamed and remains in the TBSFD tablespace.


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

  • 第21题：

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


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

  • 第22题：

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


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

  • 第23题：

    单选题
    Examine the statement： DROP TABLESPACE IND2  INCLUDING CONTENTS  AND DATAFILES；   What is the result of the statement？（）
    A

    A

    B

    B

    C

    C

    D

    D


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

相关内容