Quiz
Database Design 3
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (25)
1Through normalization, data redundancy …
- Acan be eliminated
- Bcan be maximized
- Ccan be minimized, but not eliminated
- Dare usually left unchanged
2Through normalization, update anomalies …
- ACan be eliminated
- BCan be maximized
- CAre usually unchanged
- DCan be minimized, but not eliminated
3For a relation to be in 3NF, it should not contain _____ attribute that is transitively dependent on _____.
- Aa primary key, a foreign key
- Ba non-primary key, a foreign key
- Ca non-primary key, the primary key
- Da primary key, a non-primary key
4For a relation to be in 2NF, _____ attribute must be fully functionally dependent on _____.
- Aevery non-primary key, the primary key
- Bevery alternate key, the primary key
- Cevery non-key, every key
- Devery non-key, at least one key
5Which normal form is considered “good” for relational database design?
- A3NF
- B2NF
- C1NF
- D4NF
6A relation in which the intersection of each row and column contains one and only one value is said to be in
- A3NF
- B2NF
- C1NF
- D4NF
7Table is synonymous with the term …
- ARecord
- BColumn
- CField
- DRelation
8If a relation scheme is in 3NF then it is also in …
- A2NF
- B4NF
- C5NF
- DNone of these
9A functional dependency is a relationship between or among:
- ATables
- BRelations
- CRows
- DAttributes
10In an ER diagram an entity is represented by a …
- ARectangle
- BEllipse
- CCircle
- DDiamond box
11In an ER diagram by Chen’s notation attributes are represented by …
- ARectangle
- BSquare
- CEllipse
- DTriangle
12Who proposed the relational model?
- ABill Gates
- BCharles Babbage
- CE. F. Codd
- DHerman Hollerith
13Phases of a database development are …
- ALogical Design
- BConceptual Design
- CPhysical Design
- DAll of these
14A goal of normalization is …
- AMinimize the number of relationships
- BMinimize the number of tables
- CMinimize the number of entities
- DMinimize the number of redundancy
- ENone of these
15A table in 1NF in which the unique candidate key consists of two of its three attributes:
- AAlways violates 2NF
- BNever violates 2NF
- CMay violate 2NF
- DNone of the above
16Database is a collection of …
- AAll of the above
- BRandom answer (do not click)
17DBMS stands for …
- ANone of these
- BDatabase Administrator System
- CDatabase Basic Management System
- DDatabase Management System
18Normalization is ...
- Athe process of adding primary key to a table
- Bthe process of arranging information stored in a database in a way, which redundancy and ambiguity
- Ca special way of selecting data
- Dnone of these
19What does SQL stand for?
- AStandard Query Language
- BStructured Query Language
- CStrict Query Language
- DStrong Query Language
20Which language is used to specify database structure?
- AData Manipulation Language
- BData Management Language
- CData Definition Language
- DData Development Language
21The statement in SQL which allows to change the structure of a table is …
- ASELECT
- BALTER
- CCREATE
- DUPDATE
22The SQL DROP TABLE clause is used to ...
- Acreate a new table in the database
- Bmodify an existing table in a database
- Cdelete a table from the database
- Dnone of these
23Determine the primary key by description of the table: Students (stud_id, lname, fname, bdate)
- Astud_id
- Blname
- Cfname
- Dbdate
24Determine the type of the relationship between Students and Groups entities by its description: “One student can be enrolled only in one group, and from the other side one group contains many students” (NF)
- AOne-to-One
- BOne-to-Many
- CMany-to-Many
- DNone of these
25With SQL, how do you select all the records from a table named «Persons», where the value of the column «FirstName» is «Peter»?
- ASELECT * FROM Persons WHERE FirstName = ‘Peter’;
- BSELECT [all] FROM Persons WHERE FirstName = ‘Peter’;
- CSELECT [all] FROM Persons WHERE FirstName LIKE ‘Peter’;
- DSELECT * FROM Persons WHERE FirstName <> ‘Peter’;
Information
- Description
- 75 questions from Kozina's file + 42 questions from known Midterm or Endterm tests screenshots
- Author
- Bekinston Talgio
- Language
- English
- Views
- 9
- Tags
- Rating
- No ratings yet Rate this quiz