Placement papers on Database - Set 5

Placement papers on Database - Set 5

1. Administrate supervision of database activity is the responsibility of ?

Database administrator
DP Manager
DB Manager
DP Administration
View Answer / Hide Answer


2. Data security threats include ?

hardware failure
privacy invasion
fraudulent manipulation of data
All of above
View Answer / Hide Answer


3. Mechanism developed to enforce users to enter data in required format is:

Data validation
Input mask
Criteria
Data verification
View Answer / Hide Answer


4. Identify the relationship between a Movie table and Stars table:

One to one
One to many
Many to many
None of above
View Answer / Hide Answer


5. What type of relationship exists between a Teacher table and Class table?

One to one
One to many
Many to many
None of above
View Answer / Hide Answer


6. What do you need if you should enforce many-to-many relationship between two tables?

Parent table
Child table
Junction table
Many-to-many relationship can't be created in database
View Answer / Hide Answer


7. Given the basic ER and relational model which of the following is incorrect?

An entity can have more than one attrbute
An attribute of an entity can be composite.
In row of a relational table, an attribute have more than one value.
In row of a relational table, an attribute can have exactly one vlaue or a NULL value.
View Answer / Hide Answer


8. Why do we have to create a primary index on a primary key

Ease of searching
Sequential ordering of a file
Both (a) and (b)
None of these
View Answer / Hide Answer


9. In context with relational Algebra. Which of the following are unary operatiors. 1. Select 2. Project 3. Union 4. Product

1 and 3 only
2 and 4 only
1 and 2 only
All are binary
View Answer / Hide Answer


10. A table joined with itself is called

Join
Self Join
Outer Join
Equi Join
View Answer / Hide Answer