
SQL3-建表、新增

Quiz
•
Computers
•
11th Grade
•
Medium
邱建誌 邱建誌
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
畫面中所示,從checkv到webbbs,
是甚麼的名稱?
資料庫名稱
資料表名稱
函式庫名稱
8.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
根據圖片,
目前正在操作的資料庫名稱為?
127.0.0.1
test
SQL
伺服器
9.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
若要在test資料庫裡以SQL指令建立資料表,
則要按如圖的哪個按鍵?
結構
SQL
搜尋
查詢
Similar Resources on Wayground
10 questions
Computer Software and Game Development Quiz

Quiz
•
11th Grade
10 questions
BÀI KIỂM TRA 15P HK2 TIN HỌC 11

Quiz
•
11th Grade
10 questions
Fundamentos de Tabelas em SQL

Quiz
•
11th Grade
10 questions
SQL Programming

Quiz
•
4th Grade - Professio...
8 questions
Database fundamentals III

Quiz
•
11th Grade
6 questions
Tin 11_CĐ6_Bài 19. Thực hành tạo lập CSDL và các bảng

Quiz
•
11th Grade
10 questions
DATABASE SQL

Quiz
•
9th - 12th Grade
10 questions
SQL Data Types Quiz

Quiz
•
11th Grade
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
10 questions
UPDATED FOREST Kindness 9-22

Lesson
•
9th - 12th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
20 questions
US Constitution Quiz

Quiz
•
11th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade