A table was created using the following DDL: CREATE TABLE employee (id SMALLINT NOT NULL, name VARCHAR(9), dept SMALLINT CHECK (dept BETWEEN 10 AND 100), job CHAR(10) CHECK (job IN ('Sales','Mgr','Clerk')), hiredate DATE, salary DECIMAL(7,2), comm DECIMA

题目

A table was created using the following DDL: CREATE TABLE employee (id SMALLINT NOT NULL, name VARCHAR(9), dept SMALLINT CHECK (dept BETWEEN 10 AND 100), job CHAR(10) CHECK (job IN ('Sales','Mgr','Clerk')), hiredate DATE, salary DECIMAL(7,2), comm DECIMAL(7,2), PRIMARY KEY (id), CONSTRAINT yearsal CHECK (YEAR(hiredate) > 2004 OR salary > 80500) ); Which of the following INSERT statements will fail?（）

  • A、INSERT INTO employee VALUES (2, 'Smith', 80, 'Mgr', '09/03/2006', 80000, NULL)
  • B、INSERT INTO employee VALUES (4, 'Smith', 86, 'Mgr', '07/14/2003', 90000, NULL)
  • C、INSERT INTO employee VALUES (1, 'Smith', 55, 'Sales', '07/14/2003', NULL, NULL)
  • D、INSERT INTO employee VALUES (3, 'Smith', 33, 'Analyst', '11/26/2006', 90000, NULL)
相似考题

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.

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

3. You created the DEPT table by using the following command：   CREATE TABLE scott.dept   （deptno NUMBER（3），   dname VARCHAR2（15），   loc VARCHAR2（15） ）   STORAGE （INITIAL 100K NEXT 50K  MAXEXTENTS 10 PCTINCREASE 5  FREELIST GROUPS 6 FREELISTS 4）；You are required to shrink the DEPT table. While performing the shrink operation， you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table？（）A、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT； statement.B、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE； statement.C、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE； statement.D、 You cannot shrink the SCOTT.EMP table.

4.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 table was created using the f”相关问题

  • 第1题：

    An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command: SQL>CREATE INDEX ord_custname_ix ON orders(custname); The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.Which is the most efficient method of performing this task?（）

    • A、disabling the index
    • B、making the index invisible
    • C、making the index unusable
    • D、using the MONITORING USAGE clause for the index

    正确答案: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题：

    单选题
    You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names， data types， sizes of the columns， and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return？（）
    A

     space allocated in the tablespace

    B

     space required for the bitmap index on a column of the table

    C

     space remaining in the tablespace after creating the table

    D

     estimated value of the PCTFREE storage parameter


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

  • 第4题：

    多选题
    Your database in running in the ARCHIVELOG mode. You issue the following command to back up datafile 2 in your database.   RMAN> COPY DATAFILE 2 TO ’D:///ORACLE/ORA90/MYNEWDB/DA2.DBF’；   Which two statements are true regarding the backup created using this command？（）
    A

    The copy of the datafile created is stored in the RMAN repository.

    B

    The copy of the datafile created can be viewed using the LIST BACKUP command.

    C

    The copy of the datafile created using this COPY command can be placed only on the disk.

    D

    The copy of the datafile created is similar to the backup of the file created using the BACKUP command.

    E

    The copy of the datafile created can be used for recovering the database using the user-managed recovery method.


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

  • 第5题：

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

  • 第6题：

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

  • 第7题：

    单选题
    You have created an Oracle 10g database named SALES， which will be used by an application named SalesOrders. Users of the SalesOrders application complain that application response time is slow when they generate reports. The SalesOrders application accesses a table that contains 10 million rows. You decide to create an index on this table using the NOLOGGING option so that the index creation process is completed in the least amount of time. Which of the following is NOT true about an index created with the NOLOGGING option？（）
    A

     The index can be changed from NOLOGGING to LOGGING

    B

     The index cannot be recovered even in the ARCHIVELOG mode.

    C

     The index can only be created if the base table is created with the NOLOGGING option.

    D

     The index can be recovered if you perform a backup after the CREATE INDEX statement.


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

  • 第8题：

    单选题
    An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command：   SQL>CREATE INDEX ord_custname_ix ON orders（custname）；   The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.  Which is the most efficient method of performing this task？（）
    A

     disabling the index

    B

     making the index invisible

    C

     making the index unusable

    D

     using the MONITORING USAGE clause for the index


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

  • 第9题：

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


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

  • 第10题：

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

  • 第11题：

    单选题
    An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command: SQL>CREATE INDEX ord_custname_ix ON orders(custname); The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.Which is the most efficient method of performing this task?（）
    A

    disabling the index

    B

    making the index invisible

    C

    making the index unusable

    D

    using the MONITORING USAGE clause for the index


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

  • 第12题：

    You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names， data types， sizes of the columns， and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return？（）

    • A、 space allocated in the tablespace
    • B、 space required for the bitmap index on a column of the table
    • C、 space remaining in the tablespace after creating the table
    • D、 estimated value of the PCTFREE storage parameter

    正确答案:A

  • 第13题：

    What is true about sequences?（）

    • A、Once created, a sequence belongs to a specific schema.
    • B、Once created, a sequence is linked to a specific table.
    • C、Once created, a sequence is automatically available to all users.
    • D、Only the DBA can control which sequence is used by a certain table.
    • E、Once created, a sequence is automatically used in all INSERT and UPDATE statements.

    正确答案:A

  • 第14题：

    单选题
    View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table：   ALTER TABLE emp   ADD CONSTRAINT emp_id_pk  PRIMARY KEY （emp_id）   USING INDEX emp_id_idx；   Which statement is true regarding the effect of the command？（）
    A

     The PRIMARY KEY is created along with a new index.

    B

     The PRIMARY KEY is created and it would use an existing unique index.

    C

     The PRIMARY KEY would be created in a disabled state because it is using an existing index.

    D

     The statement produces an error because the USING clause is permitted only in the CREATE TABLE command.


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

  • 第15题：

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

  • 第16题：

    单选题
    You execute the following command toauditdatabase activities：  SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command（）
    A

    Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.

    B

    Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.

    C

    One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.

    D

    One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.

    E

    One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.


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

  • 第17题：

    单选题
    Which describes the default behavior when you create a table? （）
    A

    The table is accessible to all users.

    B

    Tables are created in the public schema.

    C

    Tables are created in your schema.

    D

    Tables are created in the DBA schema.

    E

    You must specify the schema when the table is created.


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

  • 第18题：

    单选题
    You created the DEPT table by using the following command：   CREATE TABLE scott.dept   （deptno NUMBER（3），   dname VARCHAR2（15），   loc VARCHAR2（15） ）   STORAGE （INITIAL 100K NEXT 50K  MAXEXTENTS 10 PCTINCREASE 5  FREELIST GROUPS 6 FREELISTS 4）；You are required to shrink the DEPT table. While performing the shrink operation， you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table？（）
    A

     Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT； statement.

    B

     Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE； statement.

    C

     Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE； statement.

    D

     You cannot shrink the SCOTT.EMP table.


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

  • 第19题：

    单选题
    What is true about sequences? （）
    A

    Once created, a sequence belongs to a specific schema.

    B

    Once created, a sequence is linked to a specific table.

    C

    Once created, a sequence is automatically available to all users.

    D

    Only the DBA can control which sequence is used by a certain table.

    E

    Once created, a sequence is automatically used in all INSERT and UPDATE statements.


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

  • 第20题：

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


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

  • 第21题：

    单选题
    On Monday， you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin.  Which statement is correct？（）
    A

    You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.

    B

    You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.

    C

    You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.

    D

    You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of  the recycle bin are purged every 12 hours by default.


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

相关内容