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

ANSWER: Database administrator




2. Data security threats include ?

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

ANSWER: privacy invasion




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

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

ANSWER: Input mask




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

ANSWER: Many to many




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

ANSWER: Many to many




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

ANSWER: Junction table




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

ANSWER: In row of a relational table, an attribute have more than one value.




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

ANSWER: Both (a) and (b)




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

ANSWER: 1 and 2 only




10. A table joined with itself is called

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

ANSWER: Self Join



Post your comment