Database Management Questions and Answers

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?

Integrity

Retention

Security

Granting the Privileges

Recovery.

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

Multi-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

If you are not willing to risk the usual you will have to settle for the ordinary- Jim Rohn

Related Online Test

Bank General Knowledge - Online Test 1
Bank General Knowledge - Online Test 3
Bank General Knowledge - Online Test 4
Bank General Knowledge - Online Test 5
Bank General Knowledge - Online Test 6
Bank Model question Paper - Online Test 1
Bank Numerical Ability - Online Test 1

Database Management Questions & Answers: part18

Database Management Questions and Answers

Related Online Test