网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
多选题
在oracle数据库中,检查用于创建表的命令:SQL>CREATE TABLEorders(oid NUMBER(6)PRIMARY KEY,odate DATE,ccode NUMBER(6),oamt NUMBER(10,2))TABLESPACE users;下列哪两种说法正确()。
A
Orders表是在USERS表空间中创建的唯一对象
B
一个NOTNULL约束的OID列上创建
C
CHECK约束是在OID列上创建
D
Orders表和唯一索引都在USERS表空间中创建
参考答案
参考解析
解析:
暂无解析
更多 “多选题在oracle数据库中,检查用于创建表的命令:SQLCREATE TABLEorders(oid NUMBER(6)PRIMARY KEY,odate DATE,ccode NUMBER(6),oamt NUMBER(10,2))TABLESPACE users;下列哪两种说法正确()。AOrders表是在USERS表空间中创建的唯一对象B一个NOTNULL约束的OID列上创建CCHECK约束是在OID列上创建DOrders表和唯一索引都在USERS表空间中创建” 相关考题
考题
( 23 )在 Access 数据库中创建一个新表,应该使用的 SQL 语句是( ) 。A ) Create TableB ) Create IndexC ) Alter TableD ) Create Database
考题
以下关于SQL语句及其用途的叙述,正确的是( )。A.CREATE TABLE用于修改一个表的结构B.CREATE INDEX为字段或字段组创建视图C.DROP表示从数据库中删除表、或者从字段或字段组中删除索引D.ALTER TABLE用于创建表
考题
在Access数据库中创建一个新表,应该使用的SQL语句是______。A.Create TableB.Create IndexC.Alter TableD.Create Database
考题
下列关于SQL语句及其用途的叙述中,正确的是( )。A.CREATE TABLE用于修改一个表的结构B.CREATE INDEX为字段或字段组创建视图C.DROP表示从数据库中删除表或者从字段或字段组中删除索引D.ALTER TABLE用于创建表
考题
在oracle数据库中,检查用于创建表的命令:SQL>CREATETABLE orders(oidNUMBER(6)PRIMARYKEY,odateDATE,ccodeNUMBER(6),oamtNUMBER(10,2))TABLESPACEusers;下列哪两种说法正确()。
A.Orders表是在USERS表空间中创建的唯一对象B.一个NOTNULL约束的OID列上创建C.CHECK约束是在OID列上创建D.Orders表和唯一索引都在USERS表空间中创建
考题
在标准SQL中,建立数据库结构(模式)的命令为______。A.CREATE SCHEMA命令B.CREATE TADLE命令C.CREATE VIEW命令D.CREATE INDEX命令
考题
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.
考题
在SQL Sever中,创建数据库student,使用的语句是()。A、CREATE TABLE studentB、CREATE VIEW studentC、CREATE PROC studentD、CREATE DATABASE student
考题
在oracle数据库中,检查用于创建表的命令:SQLCREATE TABLEorders(oid NUMBER(6)PRIMARY KEY,odate DATE,ccode NUMBER(6),oamt NUMBER(10,2))TABLESPACE users;下列哪两种说法正确()。A、Orders表是在USERS表空间中创建的唯一对象B、一个NOTNULL约束的OID列上创建C、CHECK约束是在OID列上创建D、Orders表和唯一索引都在USERS表空间中创建
考题
Examine the command that is used to create a table: SQL CREATE TABLE orders(oid NUMBER(6) PRIMARY KEY, odate DATE, ccode NUMBER(6), oamt NUMBER(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 OIDcolumn in the SYSTEM tablespace.
考题
Orcacle提供了(),用于支持采用向导方式创建数据库。A、SQL*PlusB、Oracle NetC、Oracle ListnerD、Oracle Database Configuration Assistant
考题
多选题在oracle数据库中,检查用于创建表的命令:SQLCREATE TABLEorders(oid NUMBER(6)PRIMARY KEY,odate DATE,ccode NUMBER(6),oamt NUMBER(10,2))TABLESPACE users;下列哪两种说法正确()。AOrders表是在USERS表空间中创建的唯一对象B一个NOTNULL约束的OID列上创建CCHECK约束是在OID列上创建DOrders表和唯一索引都在USERS表空间中创建
考题
多选题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()AA CHECK constraint is created on the OID column.BA NOT NULL constraint is created on the OID column.CThe ORDERS table is the only object created in the USERS tablespace.DThe ORDERS table and a unique index are created in the USERS tablespace.EThe ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.
考题
多选题Examine the command that is used to create a table: SQL CREATE TABLE orders(oid NUMBER(6) PRIMARY KEY, odate DATE, ccode NUMBER(6), oamt NUMBER(10,2)) TABLESPACE users; Which two statements are true about the effect of the above command) ()AA CHECK constraint is created on the OID column.BA NOT NULL constraint is created on the OID column.CThe ORDERS table is the only object created in the USERS tablespace.DThe ORDERS table and a unique index are created in the USERS tablespace.EThe ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.
考题
问答题试述SQL Server的CREATE DATABASE命令在创建数据库时是如何申请物理存储空间的?
热门标签
最新试卷