Database Management Questions and Answers

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

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

1.What is the result of the following query? SELECT FLOOR(3.6) FROM DUAL? #205.What is the result of the following query? SELECT FLOOR(3.6) FROM DUAL?

3.5

3.0

4.0

3.7

3.4.

2.Application programs that are used to create and maintain the database and provide information to users is called as ______________

FILE

DBMS

Database

Data

System File.

3.Which of the following statement(s) is/are true for two-phase locking? I. Lock acquisition is the second phase II. Locks can be acquired at any time III. Keys are acquired in the first phase IV. Locks can only be acquired on primary keys

Only (I) above

Both (I) and (II) above

Both (II) and (III) above

Both (II) and (IV) above

All (I), (II), (III) and (IV) above.

4.A relation that has no partial dependencies is in __________ normal form.

First

Second

Third

Fourth

BCN.

5._________ Model describes entities, relationships and attributes.