1-1 database columnrow record field 不 DBMS Access Paradox SQL Server Linux MySQL Oracle IBM Informix IBM DB2 Sybase 1-2

Size: px

Start display at page:

Download "1-1 database columnrow record field 不 DBMS Access Paradox SQL Server Linux MySQL Oracle IBM Informix IBM DB2 Sybase 1-2"

死妹时
6 years ago
Views:

1 CHAPTER 1 Understanding Core Database Concepts

2 1-1 database columnrow record field 不 DBMS Access Paradox SQL Server Linux MySQL Oracle IBM Informix IBM DB2 Sybase 1-2

3 1 Understanding Core Database Concepts Hierarchical Data Model Pointer Network Data Model Relational Data Model 2 1-3

4 1-2 Hierarchical Database Root Subtree Network Database Relational Database 1. Tabilar Relation Record 2. Entity Integrity Referential Integrity 3. Closure 1-4

5 1 Understanding Core Database Concepts Object-Oriented Database Method 5. class entity 6. function method 7. message passing message method lock :1 1:m m:n

6 ( )1. SQL (A) DAL (B) DCL (C) DDL (D) DML ( )2. SELECT SQL (A) DAL (B) DCL (C) DDL (D) DML ( )3. (A) (B) (C) (D) ( )4. : (A) (B) (C) (D) ( )5. (A) (B) (C) (D) 1-14

7 CHAPTER 2 Creating Database Objects views

8 2-2 CREATE DATABASE DB1 DB1 CREATE TABLE dbo.products (PID int PRIMARY KEY NOT NULL, PName varchar(20) NOT NULL, Price money NULL, PDesc text NULL) Products dbo.products table_name

9 ( ) 2 Creating Database Objects PID PName Price Product ID Product Name PDesc Product Description column_name PRIMARY KEY UNIQUE CREATE TABLE Product (ProductID INTEGER, ProductItemID INTEGER, PRIMARY KEY (ProductID, ProductItemID)) Product ProductID ProductItemID ProductID ProductItemID 2-7

10 CREATE TABLE CREATE TABLE CREATE TABLE [database_name.[schema_name]. schema_name.]table_name ({<column_definition> <computed_column_definition> <column_set_definition>} [<table_constraint>][,...n]) [ON{partition_scheme_name(partition_column_name) filegroup "default"}] [{TEXTIMAGE_ON{filegroup "default"}] [FILESTREAM_ON{partition_scheme_name filegroup "default"}] [WITH(<table_option>[,...n])] [;] <column_definition>::= column_name <data_type> [FILESTREAM] [COLLATE collation_name] [NULL NOT NULL] [ [CONSTRAINT constraint_name]default constant_expression] [IDENTITY[(seed, increment)][not FOR REPLICATION] ] [ROWGUIDCOL][<column_constraint>[...n]] [SPARSE] <data type>::= [type_schema_name.]type_name [(precision[,scale] max [{CONTENT DOCUMENT}]xml_schema_collection)] <column_constraint>::= [CONSTRAINT constraint_name] 2-8

11 { {PRIMARY KEY UNIQUE} [CLUSTERED NONCLUSTERED] [ WITH FILLFACTOR=fillfactor WITH(<index_option>[,...n]) ] 2 Creating Database Objects [ON{partition_scheme_name(partition_column_name) filegroup "default"}] [FOREIGN KEY] REFERENCES[schema_name.]referenced_table_name[(ref_ column)] [ON DELETE{NO ACTION CASCADE SET NULL SET DEFAULT}] [ON UPDATE{NO ACTION CASCADE SET NULL SET DEFAULT}] [NOT FOR REPLICATION] CHECK[NOT FOR REPLICATION](logical_expression) } ƼƼ CONSTRAINT NULL NOT NULL PRIMARY KEY UNIQUE PRIMARY KEY NOT NULL UNIQUE FOREIGN KEY CHECK NULL NULL NOT NULL PERSISTED NOT NULL PRIMARY KEY UNIQUE 2-9

12 CASCADE [ASC DESC] ASC CREATE TABLE CREATE TABLE Constraint Management Studio 2-10

13 ( )15. ( ) (A) (B) (C) (D) ( )16. (A) (B) (C) (D) T-SQL ( )17. (A)INSERT (C)DROP (B)UPDATE (D)DELETE ( )18. tri_name (A)DROP TRIGGER tri_name (B)DROP TRIGGER 'tri_name' (C)DROP tri_name TRIGGER (D)DROP('tri_name') TRIGGER ( )19. (A) (B) (C) (D) ( )20. (A) (B) (C) (D) 2-26

學科 100% ( 為單複選題, 每題 2.5 分, 共 100 分 ) 1. 請參閱附圖作答 : (A) 選項 A (B) 選項 B (C) 選項 C (D) 選項 D Ans:D 2. 下列對於資料庫正規化 (Normalization) 的敘

學科 100% ( 為單複選題, 每題 2.5 分, 共 100 分 ) 1. 請參閱附圖作答 : (A) 選項 A (B) 選項 B (C) 選項 C (D) 選項 D Ans:D 2. 下列對於資料庫正規化 (Normalization) 的敘 ITE 資訊專業人員鑑定資料庫系統開發與設計實務試卷編號 :IDS101 注意事項一本測驗為單面印刷試題, 共計十三頁第二至十三頁為四十道學科試題, 測驗時間 90 分鐘 : 每題 2.5 分, 總測驗時間為 90 分鐘二執行 CSF 測驗系統 -Client