网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Create table是（）
- A、数据定义语言
- B、数据操纵语言
- C、数据控制语言
- D、数据查询语言
参考答案
更多 “ Create table是（） A、数据定义语言B、数据操纵语言C、数据控制语言D、数据查询语言” 相关考题
考题
下列SQL语句中，包含了不正确定义语句的组是（ ）。Ⅰ. CREATE TABLE CREATE VIEW CREATE INDEXⅡ. DROP TABLE DROP VIEW DROP INDEXⅢ. ALTER TABLE ALTER VIEW ALTER INDEXA)只有IB)只有ⅡC)只有ⅢD)Ⅰ和Ⅱ
考题
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***
考题
SQL语言定义完整性约束条件的功能主要体现在( )。A．CREATE TABLE 语句B．ALTER TABLE 语句C．CREATE TABLE 语句或 ALTER TABLE语句D．CREATE TABLE 语句和 ALTER TABLE语句
考题
下列SQL的数据定义语句组中，哪一组是正确的？A．CREATE SCHEMA...，DROP SCHEMA…，ALTER SCHEMA…B．CREATE TABLE......，DROP TABLE....，ALTER TABLE....C．CREATE VIEW..:，DROP VIEW...，ALTER VIEW…D．CREATE INDEX...，DROP INDEX…，ALTER INDEX…
考题
你定义了一个对象类型myOBJ,要基于该类型来创建表tab1,语句为()。
A.CREATE TABLE tab1 OF myOBJB.CREATE TABLE myOBJ OF tab1C.CREATE TABLE tab1 AS myOBJD.CREATE TABLE tab1 TYPE OF myOBJ
考题
假设在数据库中创建了用户test,需要为其授予CREATE ANY TABLE系统权限,可以使用如下()语句。
A.GRANT CREATE ANY TABLE testB.GRANT CREATE ANY TABLE TO testC.TAKE CREATE ANY TABLE TO testD.ALTER CREATE ANY TABLE TO test
考题
在下列SQL语句中，（ ）包含了不正确的定义语句。Ⅰ、CREATE TABLE CREATE VIEW CREATE INDEXⅡ、DROP TABLE DROP VIEW DROP INDEXⅢ、ALTER TABLE ALTER VIEW ALTER INDEXA）Ⅰ和ⅡB）只有ⅡC）只有ⅢD）Ⅱ和Ⅲ
考题
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.
考题
你定义了一个对象类型myOBJ，要基于该类型来创建表tab1，语句为（）。A、CREATE TABLE tab1 OF myOBJB、CREATE TABLE myOBJ OF tab1C、CREATE TABLE tab1 AS myOBJD、CREATE TABLE tab1 TYPE OF myOBJ
考题
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.
考题
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.
考题
You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which 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***
考题
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
考题
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));
考题
单选题You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which 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***
考题
单选题假设需要回收为用户test授予的CREATE ANY TABLE系统权限，可以使用如下（）语句。A
TAKE BACK CREATE ANY TABLE FROM testB
REVOKE CREATE ANY TABLE FROM testC
REVOKE CREATE ANY TABLE testD
TAKE BACK CREATE ANY TABLE test
考题
单选题假设在数据库中创建了用户test，需要为其授予CREATE ANY TABLE系统权限，可以使用如下（）语句。A
GRANT CREATE ANY TABLE testB
GRANT CREATE ANY TABLE TO testC
TAKE CREATE ANY TABLE TO testD
ALTER CREATE ANY TABLE TO test
考题
单选题You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which 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***
考题
单选题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.
考题
单选题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.
考题
单选题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.
热门标签
最新试卷