单选题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？（）AIt would be created only if a uniqu

题目

单选题

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

It would be created only if a unique index is manually created first.

It would be created and would use an automatically created unique index.

It would be created and would use an automatically created nonunique index.

It would be created and remains in a disabled state because no index is specified in the command.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第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));

参考答案：A

第2题：

假设在数据库中创建了用户test,需要为其授予CREATE ANY TABLE系统权限,可以使用如下()语句。

A.GRANT CREATE ANY TABLE test

B.GRANT CREATE ANY TABLE TO test

C.TAKE CREATE ANY TABLE TO test

D.ALTER CREATE ANY TABLE TO test

参考答案：B

第3题：

Evaluate the following SQL statement used to create the PRODUCTS table:Which statement is true regarding this command?()

A. It executes successfully but partition pruning cannot happen for this partition key.

B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.

C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.

D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.

参考答案：D

第4题：

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

第5题：

在Products数据库中建立一个新表Authors，表中应该包含name列和每个作者的ID列，下列语法正确的是（）。

A、CREATE TABLE AUTHORS ON Prpducts(name varchar(50),IDsmallint)
B、ALTER DATABASE products ADD TABLE Authors(name varchar(50),IDsmallint)
C、CREATE TABLE Products.Authors(name varchar(50),IDsmallint)
D、Create TABLE Products.Authors(name,ID)

正确答案:C

第6题：

SQL语言定义完整性约束条件的功能主要体现在( )。

A．CREATE TABLE 语句

B．ALTER TABLE 语句

C．CREATE TABLE 语句或 ALTER TABLE语句

D．CREATE TABLE 语句和 ALTER TABLE语句

正确答案：D

第7题：

Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT What is true about the set?（）

A、The DESCRIBE DEPT statement displays the structure of the DEPT table.
B、The ROLLBACK statement frees the storage space occupied by the DEPT table.
C、The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
D、The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.

正确答案:A

第8题：

You need to perform these tasks:1. Create and assign a MANAGER role to Blake and Clark2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and ClarkWhich set of SQL statements achieves the desired results? （）

A. CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;

B. CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;

C. GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***

参考答案：A

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

正确答案:C

第10题：

你定义了一个对象类型myOBJ，要基于该类型来创建表tab1，语句为（）。

A、CREATE TABLE tab1 OF myOBJ
B、CREATE TABLE myOBJ OF tab1
C、CREATE TABLE tab1 AS myOBJ
D、CREATE TABLE tab1 TYPE OF myOBJ

正确答案:C

Evaluate the CREATE TABLE statement： CREATE TABLE products

题目

相似问题和答案

更多相关问题

相关内容