创建数据库表,下列语句中正确的是()。
A: create table stu(no integer, name text, sex text, age integer)
B: table stu(no integer, name text, sex text, age integer)
C: create stu(no integer, name text, sex text, age integer)
D: 以上都不对
A: create table stu(no integer, name text, sex text, age integer)
B: table stu(no integer, name text, sex text, age integer)
C: create stu(no integer, name text, sex text, age integer)
D: 以上都不对
举一反三
- 中国大学MOOC: 关于下面代码段的说法错误的是( )。sql=@create table if not exists student(sID text,sName text,sAge integer); if (![db executeUpdate:sql]) { NSLog(@create table failed!); return; } NSLog(@create table successed!);
- 以下自定义数据类型的语句中,正确的是 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
- 哪条语句将导致创建索引? A: CREATE TABLE Employee (EmployeeID INTEGER PRIMARY KEY) B: CREATE TABLE Employee (EmployeeID INTEGER INDEX) C: CREATE TABLE Employee (EmployeeID INTEGER NULL) D: CREATE TABLE Employee(EmployeeID INREGER DISTINCT)
- <;input type=”()” name=”sex” value=”0” checked>;男<;input type=”()” name=sex value=”2”>;女上面代码,添加了一组单选按钮,用于选择性别。 A: radio,radio B: text,text C: checkbox,checkbox D: radio,text
- SQLite只支持NULL、INTEGER、REAL、TEXT和BLOB等5种数据类型