GK One-Line Question & Answer

The database design that consists of multiple tables that are linked together through matching data stored in each table is called

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

Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.

The association role defines:

Ensuring isolation property is the responsibility of the

Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________

The purpose of an N-Ary association is:

Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.

Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary) Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.

In ordered indices the file containing the records is sequentially ordered, a ___________ is an index whose search key also defines the sequential order of the file.

For select operation the ________ appear in the subscript and the ___________ argument appears in the paranthesis after the sigmA:)

A domain is atomic if elements of the domain are considered to be ____________ units.

Indices whose search key specifies an order different from the sequential order of the file are called ___________ indices.

The ___________ operation, denoted by −, allows us to find tuples that are in one relation but are not in another.

An ____________ consists of a search-key value and pointers to one or more records with that value as their search-key value.

In precedence of set operators, the expression is evaluated from

In a _______ clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers.

Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?

In a __________ index, an index entry appears for only some of the search-key values.

Consider attributes ID, CITY and NAME. Which one of this can be considered as a super key?

Incase the indices values are larger, index is created for these values of the index. This is called

A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.

A search key containing more than one attribute is referred to as a _________ search key.

An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.

Insertion of a large number of entries at a time into an index is referred to as __________ of the index.

The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called ______________

While inserting the record into the index, if the search-key value does not appear in the index.

The ______ is the one in which the primary key of one relation is used as a normal attribute in another relation.

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

A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.

Which of the following is the oldest database model?

A relational database consists of a collection of

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

A ________ in a table represents a relationship among a set of values.

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

The term _______ is used to refer to a row.

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

The term attribute refers to a ___________ of a table.

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

For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.