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 ',';
举一反三
- hive里创建表test,表里添加两个字段id和name,以下哪个HQL是正确的（ ） 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)
- 下来定义表的约束语法,错误的是() 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))
- 下列关于主键约束的语句哪个不正确 A: CREATE TABLE STU(no INT PRIMARY KEY,name VARCHAR2(20)) B: CREATE TABLE STU(no INT,name VARCHAR2(20),PRIMARY KEY(no)) C: CREATE TABLE SCORE(sno INT,cno INT,score INT,PRIMARY KEY(sno,cno)) D: CREATE TABLE SCORE(sno INT PRIMARY KEY,cno INT PRIMARY KEY,score INT)
- 创建表book(id,name,price)，其中id为主键。create table book(id varchar __________ not null,.....);横线里进行填空。
- 有如下数据表create table student(name varchar(10),gender varchar(10),number varchar(10),)charset utf8;现要给学生表增加ID(int)放到name后的位置，语句为？
内容
- 0
下面的方法是在类中定义的重载的方法，哪几组是正确的重载方法？ 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);
- 1
【单选题】以下哪个 sql 语句表示在 mysql 中创建 book 表,并添加 id 字段和 title 字段? A. create table book{ id varchar(32), title varchar(50) }; B. create table book( id varchar2(32), title varchar2(50) ); C. create table book( id varchar(32), title varchar(50) ); D. create table book[ id varchar(32), title varchar(50) ];
- 2
已知函数getStudent()定义为public Student getStudent(int ID)，下列四个选项中可以与getStudent构成重载的方法是 A: private Student getStudent(int ID) B: public String getStudent(int ID) C: Student getStudent(String name) D: public Student get(int ID)
- 3
以下自定义数据类型的语句中，正确的是 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
- 4
create table book(id varchar(10) not null,name varchar(10) not null,price float not null);该SQL语句语法正确。