SQL Data Definition MCQs with Answers PDF Download – Test 342

MCQ 1706: 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 1707: 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 1708: 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 1709: The SQL standard includes the privileges:

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

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

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