A: create test(id int, name string);
B: create test(int id, string name);
C: create table test(int id, string name);
D: create table test(id int, name string)
举一反三
- hive创建表并指定列分隔符的正确的HQL是( )。 A: create table dbtest(id int, name string) row format delimited terminate by ','; B: create table dbtest(int id, string name) row format delimited by ','; C: create table dbtest(id int, name string) row format delimited fields terminated by ','; D: create table dbtest(int id, string name) row format delimited columns fields terminated by ',';
- 为表TEST中ID列添加主键约束的语法是() A: ALTER TABLE TEST CHANGE( ID INT PRIMARY KEY) B: ALTER TABLE TEST ADD( ID INT PRIMARY KEY) C: ALTER TABLE TEST MODIFY( ID INT PRIMARY KEY) D: ALTER TABLE TEST ADD CONSTRAINT PK PRIMARY KEY (ID)
- 下来定义表的约束语法,错误的是() A: create table t1(id number primary key,name varchar2(10)) B: create table t1(id number constraint p_k primary key(id),name varchar2(10)) C: create table t1(id number constraint p_k primary key,name varchar2(10)) D: create table t1(id number,name varchar2(10),primary key(id))
- 创建表book(id,name,price),其中id为主键。create table book(id varchar __________ not null,.....);横线里进行填空。
- 表的创建命令:create table test( id int auto_increment primary key, name varchar(10) not null, password varchar(32) not null);如果在表中插入一条记录,语法正确的是: A: insert into test value(0,'张三',md5('123456')); B: insert into test values(0,张三,md5(123456)); C: insert into test value('张三',md5('123456')); D: insert into test values('张三',md5('123456'));
内容
- 0
下列选项中,采用指定表的所有字段名的方式给test表插入“id”为“1”,“name”为“小王” 的记录,正确语句是( )。 A: INSERT INTO test(“id”,”name”) VALUES(1,"小王"); B: INSERT INTO test VALUE(1,"小王"); C: INSERT INTO test VALUES(1, '小王'); D: INSERT INTO test(id,name)VALUES(1, '小王');
- 1
以下存储过程,正确的叙述是( )create procedure proc1@id int, @name char(10) outputasselect @name=name from students where id=@id A: @id是输出参数,@name是输出参数 B: @id是输入参数,@name是输出参数 C: @id是输入参数,@name是输入参数 D: @id是输出参数,@name是输入参数
- 2
以下自定义数据类型的语句中,正确的是 A: A.Type student ID As String * 20 name As String * 10 age As Integer End student B: B.Type student ID As String * 20 name As String * 10 age As Integer End Type C: C.Type student ID As String name As String age As Integer End student D: C.Type ID As String * 20 name As String * 10 age As Integer End Type student
- 3
以下自定义数据类型的语句中,正确的是______________。 A: Type student ID As String*20 name As String*10 age As Integer Endstudent B: Type student ID As String name As String age As IntegerEnd student C: Type student ID As String*20 name As String*10 age As Integer EndType D: Type student IDAs String*20 name As String*10 age As IntegerEnd Type student
- 4
下面的方法是在类中定义的重载的方法,哪几组是正确的重载方法? A: method1(int a);method1(float a); B: method2(int a);method2(int a, int b); C: method3(string name, double score);method3(int id, double score); D: method4(string name, double score);method4(string id, double credit);