Font size
WorksheetsSQL FINAL QUIZ
Total questions: 25
Worksheet time: 19mins
A. Microsoft SQL Server
B. Microsoft Access
C. MySQL
D. Oracle
A. Is the database readable?
B. Is the collected data correct and accurate?
C. Is the data organised and formatted correctly?
D. Does it make enough money?
A. Table
B. Column
C. Field
D. All of the mentioned
A. A table constraint is declared independently from a column definition and can apply to more than one column in a table
B. A column constraint is specified as part of a column definition and applies only to that column
C. Primary keys allow for NULL as one of the unique values
D. Table constraints must be used when more than one column must be included in a constraint
A. !=
B. <>
C. &&
D. >=
A. prints 80
B. prints garbage
C. is illegal
D. prints 075.971
A. COUNT()
B. NUMBER()
C. SUM()
D. COUNT(*)
A. 20
B. 10
C. 200
D. 0
A. Update only one row at a time
B. Delete more than one row at a time
C. Update more than one row at a time
D. Delete only one row at a time
A. DML
B. DDL
C. DCL
D. TCL
D. TCL
B. employee
C. from
D. "IT"
A. Primary key
B. Foreign key
C. Secondary key
D. None of the above
A. Add columns
B. Edit columns
C. Add constraints
D. All the above
A. One
B. Three
C. Five
D. Seven
A. Select count(Address) from HocSinh
B. Select sum(1) from HocSinh
C. Select count(*) from HocSinh
D. Select count(ClassID) from HocSinh
A. Flowchart
B. Table
C. Relational model
D. ER diagram
A. Network model
B. Relational model
C. ER model
D. Hierarchical model
A. Define clause
B. From clause
C. Where clause
D. Select clause
A. Float
B. Numeric
C. Decimal
D. Character
A. When existing rows are modified.
B. When a table is deleted.
C. When add primary key into table
D. All of the above
A. DELETE free the table space while TRUNCATE does not.
B. Both TRUNCATE and DELETE statements free the table's space.
C. Both TRUNCATE and DELETE statement does not free the table's space.
D. All is incorrect.
A. =
B. Not in
C. Between
D. <>
A. Unique
B. Union
C. Distinct
D. Group by
A. Primary key can store null value, whereas a unique key cannot store null value.
B. We can have only one primary key in a table while we can have multiple unique keys
C. Primary key cannot be a date variable whereas unique key can be
D. Foreign key cannot store null value
A. Attribute
B. Tuple
C. Relation
D. Entity field
