SQL FINAL QUIZ

• 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