SQL Data Definition Practice Test PDF Download eBook p. 342

MCQ: SQL provides the nvarchar type to store multilingual data using the

1. Binary code representation
2. ANSI representation
3. Char-code representation
4. Unicode representation

MCQ: In order to get the prospective database users, the database designer needs to interact extensively with the

1. Users
2. Domain experts
3. System engineers
4. Both A and B

MCQ: The component of storage manager, which ensures that the concurrent transaction executions proceed without conflicting, is referred as

1. Transaction manager
2. Buffer manager
3. Authorization and integrity manager
4. File manager

MCQ: The SQL standard includes the privileges

1. Insert and select
2. Update and delete
3. Both A and B
4. Granting and ungranting

MCQ: The term in the MVC architecture that receives events is called

1. Receiver
2. Controller
3. Transmitter
4. Modulator