Query Processing Techniques

This sets of MCQs describes about Query Processing Techniques which includes translations on high level Queries into low level expressions that can be used at physical level of file system, query optimization and actual execution of query to get the actual result.

Start Quiz

Which of the following is the oldest database model?

Relational Deductive Physical Network

Which of the following schemas does define a view or views of the database for particular users?

Internal schema Conceptual schema Physical schema External schema

Which of the following is an attribute that can uniquely identify a row in a table?

Secondary key Candidate key Foreign key Alternate key

Which of the following are the process of selecting the data storage and data access characteristics of the database?

Logical database design Physical database design Testing and performance tuning Evaluation and selecting

Which of the following terms does refer to the correctness and completeness of the data in a database?

Data security Data constraint Data independence Data integrity

Which of the following is a group of one or more attributes that uniquely identifies a row?

Key Determinant Tuple Relation

Table is synonymous with the term:

record. relation. column. field.

A collection of data designed to be used by different people is called a/an,

Organization

Database

Relationship

Schema

If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called,

Consistent state

Parallel state

Durable state

Inconsistent state

The relationship between DEPARTMENT and EMPLOYEE is a,

One-to-one relationship

One-to-many relationship

Many-to-many relationship

Many-to-one relationship

A table can be logically connected to another table by defining a,

Super key

Candidate key

Primary key

Unique key

Ensuring isolation property is the responsibility of the_______.

Recovery-management component of the DBMS

Concurrency-control component of the DBMS

Transaction-management component of the DBMS

Buffer management component in DBMS

A relation is considered a:

Column.

One-dimensional table.

Two-dimensional table.

Three-dimensional table.

In the relational model, relationships between relations or tables are created by using:

Composite keys.

Determinants.

Candidate keys.

Foreign keys.

A functional dependency is a relationship between or among:

Tables.

Rows.

Relations.

Attributes.

Quiz/Test Summary

Title: Query Processing Techniques

Questions: 15

Contributed by:

Steve Tue, Mar 29, 2022 07:18 AM UTC

Book a Trial Class

Related Quizzes

Concurrency Control in DBMS