RDBMS - General Knowledge Question and Answer

RDBMS - Question and Answer

A relational database management system (RDBMS) is a collection of programs and capabilities that enable IT teams and others to create, update, administer and otherwise interact with a relational database. Most commercial RDBMSes use Structured Query Language (SQL) to access the database, although SQL was invented after the initial development of the relational model and is not necessary for its use. This is the questions and answers section on "RDBMS" with an explanation for various interview, competitive examination and entrance test. Solved examples with detailed answer description, explanation are given and it would be easy to understand.

A relational database consists of a collection of  


Tables
Fields
Records
Keys

Answer:

Fields are the column of the relation or tables. Records are each row in a relation. Keys are the constraints in a relation.

Share Me:

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


Column
Key
Row
Entry

Answer:

The column has only one set of values. Keys are constraints and row is one whole set of attributes. Entry is just a piece of data.

Share Me:

The term _______ is used to refer to a row.  


Attribute
Tuple
Field
Instance

Answer:

Tuple is one entry of the relation with several attributes which are fields.

Share Me:

The term attribute refers to a ___________ of a table.  


Record
Column
Tuple
Key

Answer:

Attribute is a specific domain in the relation which has entries of all tuples.

Share Me:

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


Domain
Relation
Set
Schema

Answer:

The values of the attribute should be present in the domain.A domain is a set of values permitted.

Share Me:

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.  


Instance, Schema
Relation, Schema
Relation, Domain
Schema, Instance

Answer:

Instance is a instance of time and schema is a representation.

Share Me:

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


Different
Indivisbile
Constant
Divisible

Answer:

Indivisbile

Share Me:

The tuples of the relations can be of ________ order.  


Any
Same
Sorted
Constant

Answer:

The values only count .The order of the tuples does not matter.

Share Me:

Using which language can a user request information from a database?  


Query
Relational
Structural
Compiler

Answer:

Query language is a method through which the database entries can be accessed.

Share Me:

Student(ID, name, dept name, tot_cred) In this query which attribute form the primary key?  


Name
Dept
Tot_cred
ID

Answer:

ID The attributes name, dept and tot_cred can have same values unlike ID.

Share Me:

Which one of the following is a procedural language?  


Domain relational calculus
Tuple relational calculus
Relational algebra
Query language

Answer:

Domain and Tuple relational calculus are non-procedural language. Query language is a method through which the database entries can be accessed.

Share Me:

The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.  


Select
Join
Union
Intersection

Answer:

Join finds the common tuple in the relations and combines it.

Share Me:

The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.  


Join
Cartesian product
Intersection
Set difference

Answer:

Cartesian product is the multiplication of all the values in the attributes.

Share Me:

The _______operation performs a set union of two “similarly structured” tables  


Union
Join
Product
Intersect

Answer:

Union just combines all the values of relations of same attributes.

Share Me:

The most commonly used operation in relational algebra for projecting a set of tuple from a relation is  


Join
Projection
Select
Union

Answer:

Select is used to view the tuples of the relation with or without some constraints.

Share Me:

The _______ operator takes the results of two queries and returns only rows that appear in both result sets.  


Union
Intersect
Difference
Projection

Answer:

The union operator gives the result which is the union of two queries and difference is the one where query which is not a part of second query.

Share Me:

A ________ is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.  


Schema diagram
Relational algebra
Database diagram
Schema flow

Answer:

Schema diagram

Share Me:

The _________ provides a set of operations that take one or more relations as input and return a relation as an output  


Schematic representation
Relational algebra
Scheme diagram
Relation flow

Answer:

Relational algebra

Share Me: