单选题Which is a valid CREATE TABLE statement? （）A CREATE TABLE EMP9$# AS (empid number(2));B CREATE TABLE EMP*123 AS (empid number(2));C CREATE TABLE PACKAGE AS (packid number(2));D CREATE TABLE 1EMP_TEST AS (empid number(2));

题目
单选题
Which is a valid CREATE TABLE statement? （）
A

CREATE TABLE EMP9$# AS (empid number(2));

B

CREATE TABLE EMP*123 AS (empid number(2));

C

CREATE TABLE PACKAGE AS (packid number(2));

D

CREATE TABLE 1EMP_TEST AS (empid number(2));

相似考题

1.Which is a valid CREATE TABLE statement? ()A. CREATE TABLE EMP9$# AS (empid number(2));B. CREATE TABLE EMP*123 AS (empid number(2));C. CREATE TABLE PACKAGE AS (packid number(2));D. CREATE TABLE 1EMP_TEST AS (empid number(2));

2.A DBA has been asked to create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal of the oldest month’s data?（）A、Create an MQT that selects the oldest month of data with the REFRESH IMMEDIATE option.B、Create 12 separate tables, create a view based on all 12, drop the table with the oldest month's data then drop and re- create the view.C、Create a range partitioned table, partitioned by month, and use the ALTER TABLE statement to detach the oldest month and attach storage for new data.D、Create a single table, extract the data to be retained using UNLOAD with a SELECT statement, drop and re-create the table then load only the data to be retained.

3.You navigate to "UAC" > "Infranet Enforcer" > "Auth Table Mapping" in the admin GUI. You see one policy, which is the unmodified, original default policy.Which statement is true?（）A、Dynamic auth table mapping is not enabled.B、A successful authentication attempt will result in a new authentication table entry, which will be delivered only to the Junos enforcer protecting the network from which the user has authenticated.C、To create a static auth table mapping, you must delete the default policy.D、The default policy applies only to the factory-default role User.

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

参考答案和解析
正确答案： B
解析： 暂无解析
更多“Which is a valid CREATE TABLE statement? （）”相关问题

  • 第1题：

    Evaluate the CREATE TABLE statement：   CREATE TABLE products   （product_id NUMBER （6）  CONSTRAINT prod_id_pk PRIMARY KEY，  product_name VARCHAR2 （15））；   Which statement is true regarding the PROD_ID_PK constraint？（）

    • A、 It would be created only if a unique index is manually created first.
    • B、 It would be created and would use an automatically created unique index.
    • C、 It would be created and would use an automatically created nonunique index.
    • D、 It would be created and remains in a disabled state because no index is specified in the command.

    正确答案:B

  • 第2题：

    Which two operations can be performed on an external table（）

    • A、Create a view on the table.
    • B、Create an index on the table.
    • C、Create a synonym on the table.
    • D、Add a virtual column to the table.
    • E、Update the table using the UPDATE statement.
    • F、Delete rows in the table using the DELETE command.

    正确答案:A,C

  • 第3题：

    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.

    正确答案:A,D

  • 第4题：

    Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）

    • A、The constraint remains valid.
    • B、The index on the constraint is dropped.
    • C、It allows the loading of data into the table using SQL*Loader.
    • D、New data conforms to the constraint， but existing data is not checked
    • E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

    正确答案:A,B,C

  • 第5题：

    Which is a valid CREATE TABLE statement?（）

    • A、CREATE TABLE EMP9$# AS (empid number(2));
    • B、CREATE TABLE EMP*123 AS (empid number(2));
    • C、CREATE TABLE PACKAGE AS (packid number(2));
    • D、CREATE TABLE 1EMP_TEST AS (empid number(2));

    正确答案:A

  • 第6题：

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


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

  • 第7题：

    单选题
    Examine the following query output: You issue the following command to import tables into the hr schema: $ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?（）
    A

    All database operations performed by the impdp command are logged.

    B

    Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.

    C

    Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.

    D

    None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.


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

  • 第8题：

    多选题
    You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition: Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?（）
    A

    The valid time columns employee_time_start and employee_time_end are automatically created.

    B

    The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

    C

    The valid time columns are not populated by the Oracle Server automatically.

    D

    The valid time columns are visible by default when the table is described.

    E

    Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulatio


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

  • 第9题：

    单选题
    A DBA has been asked to create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal of the oldest month’s data?（）
    A

    Create an MQT that selects the oldest month of data with the REFRESH IMMEDIATE option.

    B

    Create 12 separate tables, create a view based on all 12, drop the table with the oldest month's data then drop and re- create the view.

    C

    Create a range partitioned table, partitioned by month, and use the ALTER TABLE statement to detach the oldest month and attach storage for new data.

    D

    Create a single table, extract the data to be retained using UNLOAD with a SELECT statement, drop and re-create the table then load only the data to be retained.


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

  • 第10题：

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


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

  • 第11题：

    单选题
    Which is a valid CREATE TABLE statement?（）
    A

    CREATE TABLE EMP9$# AS (empid number(2));

    B

    CREATE TABLE EMP*123 AS (empid number(2));

    C

    CREATE TABLE PACKAGE AS (packid number(2));

    D

    CREATE TABLE 1EMP_TEST AS (empid number(2));


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

  • 第12题：

    单选题
    You want to create a temporary table while executing a procedure in a form. Which statement is true?（）
    A

    You cannot create a table form within Forms. 

    B

    You must use the FORMS_DDL built-in to create the table. 

    C

    You must use the DBMS_DYNAMIC_DDL package to create the table. 

    D

    You can write the CREATE TABLE statement directly into the trigger.


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

  • 第13题：

    Which three are true?（）

    • A、A MERGE statement is used to merge the data of one table with data from another.
    • B、A MERGE statement replaces the data of one table with that of another.
    • C、A MERGE statement can be used to insert new rows into a table.
    • D、A MERGE statement can be used to update existing rows in a table.

    正确答案:A,C,D

  • 第14题：

    Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 isperformed（）

    • A、The table created by SKD is not accessible and SKD cannot create new tables.
    • B、The tables created by SKD and HR remain， but both cannot create new tables.
    • C、The table created by HR remains and HR still has the CREATE TABLE system privilege.
    • D、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

    正确答案:C

  • 第15题：

    Which two operations can be performed on an external table（）

    • A、Create a view on the table.
    • B、Create an index on the table.
    • C、Create a synonym on the table.
    • D、Add a virtual column to the table.
    • E、Update the table using the UPDATE statement.
    • F、Delete rows in the table using the DELETE command

    正确答案:A,C

  • 第16题：

    You executed this command to create a temporary table： SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area （startdate DATE， enddateDATE， class CHAR（20）） ON COMMIT PRESERVE ROWS； Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction（）

    • A、The rows stay in the table only until session termination.
    • B、The rows stay in the table only until the next transaction starts on the table.
    • C、The rows are visible to all current sessions after the transaction is committed.
    • D、The rows stay available for subsequent sessions after the transaction is committed

    正确答案:A

  • 第17题：

    单选题
    Examine the statement:Create synonym emp for hr. employees;What happens when you issue the statement?（）
    A

    An error is generated.

    B

    You will have two identical tables in the HR schema with different names.

    C

    You create a table called employees in the HR schema based on you EMP table.

    D

    You create an alternative name for the employees table in the HR schema in your own schema.


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

  • 第18题：

    单选题
    Examine the following steps performed on a database instance：  1：The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION.  2：The SKD usercreates a table.  3：The SKD user grants theCREATETABLE system privilege to the HR user.  4：The HR user creates a table.  5：The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 is performed（）
    A

    The table created by SKD isnot accessibleand SKD cannot create new tables.

    B

    The tables created by SKD and HR remain， but both cannot create new tables.

    C

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

    D

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


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

  • 第19题：

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


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

  • 第20题：

    多选题
    Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）
    A

    The constraint remains valid.

    B

    The index on the constraint is dropped.

    C

    It allows the loading of data into the table using SQL*Loader.

    D

    New data conforms to the constraint， but existing data is not checked

    E

    It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.


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

  • 第21题：

    单选题
    You executed this command to create a temporary table： SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area （startdate DATE， enddateDATE， class CHAR（20）） ON COMMIT PRESERVE ROWS； Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction（）
    A

    The rows stay in the table only until session termination.

    B

    The rows stay in the table only until the next transaction starts on the table.

    C

    The rows are visible to all current sessions after the transaction is committed.

    D

    The rows stay available for subsequent sessions after the transaction is committed


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

  • 第22题：

    单选题
    You navigate to "UAC" > "Infranet Enforcer" > "Auth Table Mapping" in the admin GUI. You see one policy, which is the unmodified, original default policy.Which statement is true?（）
    A

    Dynamic auth table mapping is not enabled.

    B

    A successful authentication attempt will result in a new authentication table entry, which will be delivered only to the Junos enforcer protecting the network from which the user has authenticated.

    C

    To create a static auth table mapping, you must delete the default policy.

    D

    The default policy applies only to the factory-default role User.


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

  • 第23题：

    多选题
    Which three are true?（）
    A

    A MERGE statement is used to merge the data of one table with data from another.

    B

    A MERGE statement replaces the data of one table with that of another.

    C

    A MERGE statement can be used to insert new rows into a table.

    D

    A MERGE statement can be used to update existing rows in a table.


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

  • 第24题：

    单选题
    Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 isperformed（）
    A

    The table created by SKD is not accessible and SKD cannot create new tables.

    B

    The tables created by SKD and HR remain， but both cannot create new tables.

    C

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

    D

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


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

相关内容