SQL3-建表、新增

SQL3-建表、新增

11th Grade

9 Qs

quiz-placeholder

Similar activities

Quiz 1 Bases de datos Facundo Navas Mantilla

Quiz 1 Bases de datos Facundo Navas Mantilla

11th Grade

12 Qs

basis data 11 rpl

basis data 11 rpl

11th Grade

10 Qs

SysAdmin: Patch Management

SysAdmin: Patch Management

10th Grade - University

10 Qs

PowerPoint测验

PowerPoint测验

KG - 12th Grade

12 Qs

雲端從業人員Module 1 知識點檢查

雲端從業人員Module 1 知識點檢查

9th - 12th Grade

10 Qs

Error Checking

Error Checking

10th - 12th Grade

10 Qs

Database(1)

Database(1)

10th Grade - University

10 Qs

Banco de dados 3. ano

Banco de dados 3. ano

3rd Grade - University

10 Qs

SQL3-建表、新增

SQL3-建表、新增

Assessment

Quiz

Computers

11th Grade

Medium

Created by

邱建誌 邱建誌

Used 9+ times

FREE Resource

9 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

若要建立書籍資料表book,

需要isbn欄位,寬度13字,

書名欄位bookname,寬度100字,

以isbn為主鍵,則,

建表book指令何者正確?

create table book(

)

build table book(

)

create book table(

)

build book table(

)

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

若要建立書籍資料表book,

需要isbn欄位,寬度13字,

書名欄位bookname,寬度100字,

以isbn為主鍵,則,

isbn的欄位指令為?(不考慮加主鍵的not null問題)

isbn varchar(13)

isbn int

isbn float

isbn 13

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

若要建立書籍資料表book,

需要isbn欄位,寬度13字,

書名欄位bookname,寬度100字,

以isbn為主鍵,則,

完整建表指令為?

create table book(

isbn varchar(13),

bookname varchar(100)

)

create table book(

isbn varchar(13),

bookname varchar(100),

primary key(isbn)

)

create table book(

isbn varchar(13),

bookname varchar(100),

primary key(isbn),

)

create table book(

isbn varchar(13) not null,

bookname varchar(100),

primary key(isbn)

)

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

若要建立書籍資料表book,

需要增加作者author欄位,文字寬度100,

則下列指令何者正確?

create table book(

isbn varchar(13) not null,

bookname varchar(100),

author int(100),

primary key(isbn)

)

create table book(

isbn varchar(13) not null,

bookname varchar(100),

primary key(isbn),

author varchar(100),

)

create table book(

isbn varchar(13) not null,

bookname varchar(100),

primary key(isbn)

)

author varchar(100),

create table book(

isbn varchar(13) not null,

bookname varchar(100),

author varchar(100),

primary key(isbn)

)

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

若要建立書籍資料表book,

需要增加價格price,格式為int,

則下列指令何者正確?

create table book(

isbn varchar(13) not null,

bookname varchar(100),

price int(100)

primary key(isbn)

)

create table book(

isbn varchar(13) not null,

bookname varchar(100),

primary key(isbn),

price int,

)

create table book(

isbn varchar(13) not null,

bookname varchar(100),

primary key(isbn)

)

price int,

create table book(

isbn varchar(13) not null,

bookname varchar(100),

price int,

primary key(isbn)

)

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

下載安裝xampp後,要能看到資料庫界面,

需要?

按Apache的Start

按MySQL的Start

按MySQL的Admin

按MySQL的Admin按Apache的Start

按MySQL的Start

按Apache的Start

按MySQL的Start

按Apache的Start

按MySQL的Admin

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

畫面中所示,從checkv到webbbs,

是甚麼的名稱?

資料庫名稱

資料表名稱

函式庫名稱

8.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

根據圖片,

目前正在操作的資料庫名稱為?

127.0.0.1

test

SQL

伺服器

9.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

若要在test資料庫裡以SQL指令建立資料表,

則要按如圖的哪個按鍵?

結構

SQL

搜尋

查詢