查看teacher表的表结构，语句为（）
A: select * from teacher;
B: show create table teacher;
C: show table teacher;
D: desc teacher;
A: select * from teacher;
B: show create table teacher;
C: show table teacher;
D: desc teacher;
举一反三
- In front of the classroom______. A: is the table for the teacher B: B. the table is there for the teacher C: it is a table for the teacher D: D. has a table for the teacher
- 创建teacher表,包含教工号,姓名和工龄字段,其中教工号字段为主键,命令为( )。 A: CREATE TABLE teacher (教工号 C(10) PRIMARY,姓名 C(20),工龄 N(6,2)) B: CREATE TABLE teacher (教工号 C(10) FOREIGN,姓名 C(20),工龄 N(6,2)) C: CREATE TABLE teacher (教工号 C(10) FOREIGN KEY,姓名 C(20),工龄 N(6,2)) D: CREATE TABLE teacher(教工号 C(10) PRIMARY KEY,姓名 C(20),工龄 N(6,2))
- 用如下的SQL语句创建一个Teacher表 CREATE TABLE Teacher ( TNO Char(6) NOT NULL, NAME Char(8) NOT NULL, SEX Char(2), SAL INT, SDETP char(12) check (SDEPT IN(‘IS’,’MA’,’CS’))) 可以插入到Teacher表中的元组是_________
- 以下（ ）方式可查看外键约束名称。 A: DESC B: SHOW TABLE STATUS C: SELECT * FROM D: SHOW CREATE TABLE
- 在Oracle中，有一个教师表teacher的结构如下： 下面哪个语句显示没有Email地址的教师的姓名（）。 A: select name from teacher where email=null B: select name from teacher where email<>null C: select name from teacher where email is null D: select name from teacher where email is not null