GK One-Line Question & Answer

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 number of entities to which another entity can be associated via a relationship set is expressed as:

What will be the number of columns of CARTESIAN PRODCUT if the participating relations have 5 and 7 columns respectively?

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

The view of total database content is

What will be the number of columns of CARTESIAN PRODCUT if the participating relations have 5 and 20 rows respectively?

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

The file organization that provides very fast access to any arbitrary record of a file is:

Which of the following is the operation that is used if we are interested in only certain attributes or columns of a table?

Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?

What is not true about a view?

Which of the following is not a procedural language?

The following are components of a database except ________

The database schema is written in

An application where only one user accesses the database at a given time is an example of a(n) ________ .

Who developed SEQUEL?

An on-line commercial site such as Amazon.com is an example of a(n) ________ .

Which of the following is used to get all the columns of a table?

SQL stands for ________ .

The first commercial RDBMS is:

Because it contains a description of its own structure, a database is considered to be ________

Which of the following is not a DCL statement?

The following are functions of a DBMS except ________ .

Which of the following is the result of a select statement?

Helping people keep track of things is the purpose of a(n) ________ .

Which of the following clause specifies the table or tables from where the data has to be retrieved?

A DBMS that combines a DBMS and an application generator is ________ .

How many tables can be joined to create a view?

Let us consider phone_number ,which can take single or several values . Treating phone_numberasan _________ permits instructors to have several phone numbers (including zero) associated with them.

Which of the following can be used to get those items that fall within a range?

In an object-oriented model, one object can access data of another object by passing:

Which of the following constitutes a basic set of operations for manipulating relational data?

A view of database that appears to an application program is known as:

Which of the following is not a relational algebraic operation that is not form the set theory?

An abstraction concept for building composite object from their component object is called:

Which of the following is not a relational algebraic operation that is developed specifically for the relational databases?

A set of objects that share a common structure and a common behavior is called:

Which is the symbol used to denote the SELECT operation?

Every weak entity set can be converted into a strong entity set by:

Which of the following operations need the participating relations to be union compatible?