GK One-Line Question & Answer

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.

State true or false: If a relation consists of a foreign key, then it is called a referenced relation of the foreign key dependency.

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 information does an SQL DDL not specify?

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.

Which of the following data types does the SQL standard not support?

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.

Which command is used to create a new relation in SQL

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.

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 _________

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.

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.

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

The tuples of the relations can be of ________ order.

In precedence of set operators, the expression is evaluated from

Choose the correct statement regarding superkeys

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

What is an Instance of a Database?

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

What is a foreign key?

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

What action does ⋈ operator perform in relational algebra

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

What does the “x” operator do in relational algebra?

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 ______________

An attribute is a __________ in a relation.

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

What is the method of specifying a primary key in a schema description?

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.

Statement 1: A tuple is a row in a relation Statement 2: Existence of multiple foreign keys in a same relation is possible

A relational database consists of a collection of

Choose the option that correctly explains in words, the function of the following relational algebra expression σyear≥2009 (book ⋈ borrow)