• 2022-07-01
    创建名为course的数据库的命令是( )。
    A: creat database course;
    B: creat course;
    C: create database course;
    D: create course;
  • C

    内容

    • 0

      ‍对 Course表,使用课程号,课程名,学分,及额外增加的iXueshi字段创建视图,学时为学分乘以16,正确的SQL语句是( )。​ A: Create View ShiTu As Select Cno,Cname ,Ccredit ,Ccredit *16 as iXueshi from Course B: Create View ShiTu As Select Cno,Cname ,Ccredit ,Ccredit *16 from Course C: Create Proc ShiTu As Select Cno,Cname ,Ccredit ,Ccredit *16 as iXueshi from Course D: Create Index ShiTu As Select Cno,Cname ,Ccredit ,Ccredit *16 as iXueshi from Course

    • 1

      考虑到参照完整性的外码设计,如图所示的student,course,sc三张表的创建顺序应为()。 A: sc,course,student B: sc,student,course C: student,sc,course D: student,course,sc

    • 2

      删除表course的记录。其SQL语句为( )。 A: DELETE from course where * B: DELETE * from course C: DELETE course D: DELETE FROM course

    • 3

      创建数据库的命令是( ) A: create database B: create C: database D: final

    • 4

      下列创建名为'test'的数据库的语句正确的是? A: create database 'test' B: CREATE DATABASE test C: create database test; D: create database 'test';