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

第2题：

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

第3题：

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

第4题：

单选题

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

space allocated in the tablespace

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

space remaining in the tablespace after creating the table

estimated value of the PCTFREE storage parameter

正确答案： C

解析：暂无解析

第5题：

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

第6题：

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.

正确答案:D

第7题：

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

第8题：

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

第9题：

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

第10题：

单选题

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

The PRIMARY KEY is created along with a new index.

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

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

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

正确答案： D

解析：暂无解析

A table was created using the f

题目

相似问题和答案

更多相关问题

相关内容