SQL QUIZ
1 .
Which SQL statement is used to create a table in a database?

Correct Answer : Option (B)

CREATE TABLE
  Show Answer
2 .
Which of the following is not true about creating constraints?

Correct Answer : Option (A)

Constraints are defined using the CREATE CONSTRAINT statement.
  Show Answer
3 .
A systematic collection of data stored in a central location is known as?

Correct Answer : Option (B)

Database
  Show Answer
4 .
Which of the following is true about a role?

Correct Answer : Option (D)

All of the above.
  Show Answer
5 .
Which type of database management system represents relations using tables?

Correct Answer : Option (C)

Relational DBMS
  Show Answer
6 .
What is a composite key?

Correct Answer : Option (D)

it is a primary key that consists of more than one field that uniquely identifies a record
  Show Answer
7 .
Which of the following is not YES regarding ER modeling.

Correct Answer : Option (D)

ER models waste the database developer's time
  Show Answer
8 .
What command is used to permanently remove a record from a database table?

Correct Answer : Option (A)

DROP
  Show Answer
9 .
Which of the following is a valid aggregate function.

Correct Answer : Option (B)

COUNT
  Show Answer
10 .
Wildcards are

Correct Answer : Option (A)

used to perform pattern matches
  Show Answer