Database Management Questions & Answers: part18

Software Programming : Database Management QUESTIONS AND ANSWERS :: part18 : 1 to 5

Following Software Programming language Entrance Multiple choice objective type questions and answers will help you in Software Programming 2024 examinations :

1.Which of the following Relational Algebra operations require that both tables (or virtual tables) involved have the exact same attributes/data types?

Join, Projection, Restriction
Multiplication and Division
Union, Intersection, Minus
Minus, Multiplication, Intersection
Projection, Selection, Rename.

2.Out of the following activities, which is the one that normally performed by DBMS, without the interference of the DBA?

Granting the Privileges

3.A type of query that is placed within a WHERE or HAVING clause of another query is called

Master query
Sub query
Super query
Co-related query.

4.The protocol that ensures conflict serializability is

Time stamp ordering protocol
Two phase locking protocol
Concurrency protocol
Tree protocol
Layered Protocol.

5.Indexes are created in most RDBMS�s to

Provide a quicker way to store data
Decrease the amount of disk space utilized
Provide rapid, random and sequential access to base-table data
Increase the cost of implementation
Decrease the cost of implementation.

More Database Management QUESTIONS AND ANSWERS available in next pages

    Health is the greatest gift, contentment is the greatest wealth -Buddha
Opportunity is missed by most people because it is dressed in overalls and looks like work.- Thomas Edison