Database Management Questions & Answers: part14



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.

E � R Model
Functional
Relational
Network
Info logical.

More Database Management QUESTIONS AND ANSWERS available in next pages

    Health is the greatest gift, contentment is the greatest wealth -Buddha
If your ship doesn’t come in, swim out to meet it!-Jonathan Winters