RDBMS
==============

1) When a single entity is related to itself then the relationship is
termed as
A) ONE -TO-ONE
B) ONE-TO-MANY
C) RECURSIVE
D) MANY-TO-MANY

2)_____ means allowing objects of different types to be
considered as examples of higher level set
A) AGGREGATION
B) SPECIALIZATION
C) GENERALIZATION
D) DECOMPOSITION

3) The primary characteristic of a key field as that it must be
A) A NAME
B) TEXT
C) UNIQUE
D) ALL OF THE OTHER OPTION LISTED FOR THIS QUESTION

4) What kind of relationship exist between customers and salespersons if
each customer may have one or more salespersons, and each salesperson
may have one or more customers?
A) one-to-one
B) one to many
C) many to many
D) many to one

5) The following is a valid SET operation.
A) Join
B) Insert
C) Select
D) Difference

6) In an employ table, the field which can be taken as a Primary key
A) name
B) employ_id
C) age


7) A relation R is said to be in the , if it is in BCNF and
there are non-trivial multi valued dependencies.
A) 1st NF
B) 2nd NF
C) 3rd NF
D) 4th NF

8) A occurs when a weak entity does not have a
candidate key and its instances are indistinguishable without a
relationship with another entity.
A) Existence dependency
B) Identifier dependency
C) Referential dependency
D) None of the other option listed for this question

9) ____ is /are sample(s) of data model.
A) Relational
B) Rational
C) Entity- relationship
D) None of the other option listed for this question

10) In hierarchical database,
A) There is one to many relationship
B) A child may have more than one parent
C) A parent may have more than one child
D) There is no restriction on the number of parents a child may have or
the number of children a parent may have

11) The term "inner join" refers to:
A) Joins between two tables in the same schema.
B) An equality join based on one column from each table.
C) A table joined with itself.
D) A Cartesian product join.

12) Which type of join is used in this query?

SELECT last_name "Name", hire_date "Hire Date", loc "Location"
FROM employee, department
WHERE employee.deptno = department.deptno.
A) Outer join
B) Self join
C) Equijoin
D) Non-equijoin

13) A sales database has two table - SALESPERSON and CUSTOMERS as below:

SALESPEOPLE
------------------------------------------------------
snum NUMBER
sname VARCHAR2(10)

CUSTOMER
------------------------------------------------------
snum NUMBER
cname VARCHAR2(10)

The management wants to know the mapping of salespersons to their
Customers without excluding those salespersons that are not currently assigned.
What would be the most appropriate condition, which can be applied on the
Query to accomplish the above task?

A) salespeople.snum(+) = customers.snum
B) salespeople.snum = customers.snum(+)
C) salespeople.snum = customers.snum
D) salespeople.snum(+) = customers.snum(+)

14) join returns those rows from a table which have
no direct match in the other table.

A) Outer join
B) Inner join
C) Equi join
D) Self join

15) To produce a meaningful result set without any Cartesian products,
What is the minimum number of conditions that should appear in the WHERE
clause of a four table join?

A) 1
B) 4
C) 2
D) 8