Database Languages Quiz with Answers PDF Download – Test 201

MCQ 1001: The storage structure and access methods used by the database system, is specified by a:

1. Type Of DML
2. Type of Procedural DML
3. Type of Declarative DML
4. Type of DDL

MCQ 1002: In cloud computing server time, network storage and human interaction can be provisioned through:

1. Measured service
2. Broad network access
3. Resource pooling
4. On demand self service

MCQ 1003: The entire set of tuples satisfying the where predicate is treated as being in one group, if the:

1. Having clause is present
2. Having clause is not present
3. Group by clause is present
4. Group by clause is not present

MCQ 1004: The term that provides the ability to query information from the database, is known as:

1. SQL DML
2. SQL DDL
3. Embedded SQL
4. View definition

MCQ 1005: For those attributes that appear in only one of the two schemas, we shall usually drop the:

1. Relation name schema
2. Relation name prefix
3. Attribute name prefix
4. Tuple address prefix