Aggregate Functions Quiz with Answers PDF Download – Test 357

MCQ 1781: The following query
select count (*)
from course; is used to find:

1. Printing (*) as the attribute of the course relation
2. Printing (*) in the course relation
3. the number of attributes in the course relation
4. the number of tuples in the course relation

MCQ 1782: A single computer system that do not interact with other computer systems is called:

1. Processed database systems
2. Decentralized database systems
3. Centralized database systems
4. Distributed database systems

MCQ 1783: A database may also have several schemas at the view level, known as:

1. Optimized schema
2. Virtual Schema
3. Model Schema
4. Subschemas

MCQ 1784: The concurrency control in which all the data on a specific page is locked is known to be:

1. Page-level locking
2. Cluster level locking
3. Data-level locking
4. System-level locking

MCQ 1785: AN SQL view is said to be updatable, if the Select clause contains:

1. Only 1 attribute names
2. Only 2 attribute names
3. Only 3 attribute names
4. Only 4 attribute names