SQL3-建表、新增

SQL3-建表、新增

11th Grade

9 Qs

quiz-placeholder

Similar activities

Spirit Hunters

Spirit Hunters

KG - University

10 Qs

วันวิทยาศาสตร์ ประจำปี 2565

วันวิทยาศาสตร์ ประจำปี 2565

10th - 12th Grade

10 Qs

scratch

scratch

11th - 12th Grade

10 Qs

Bluetooth&Wifi

Bluetooth&Wifi

9th - 11th Grade

10 Qs

資安檢測_7

資安檢測_7

7th Grade - University

12 Qs

คอมพิวเตอร์

คอมพิวเตอร์

KG - Professional Development

10 Qs

Fundamentos de Java

Fundamentos de Java

11th Grade

10 Qs

What is the internet?

What is the internet?

9th - 12th Grade

10 Qs

SQL3-建表、新增

SQL3-建表、新增

Assessment

Quiz

Computers

11th Grade

Practice Problem

Medium

Created by

邱建誌 邱建誌

Used 9+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

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,

是甚麼的名稱?

資料庫名稱

資料表名稱

函式庫名稱

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?