Database Management Questions & Answers: part10

Software Programming : Database Management QUESTIONS AND ANSWERS :: part10 : 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 aggregate function is used to give the number of records present in a table?


2.What does a multi level index lead to? #142.What does a multi level index lead to?

Binary Tree
Transaction Failure
Dead Lock.

3.State the methodology for documenting databases illustrating the relationship between various entities in the database?

Data flow diagram
State transition diagram
Entity-relationship diagram
Entity sequence diagram
Object model.

4.A database management software (DBMS) includes

Automated tools (CASE) used to design databases and application programs
A software application that is used to define, create, maintain and provide controlled access to user databases
Application programs that are used to provide information to users
Database that contains occurrences of logically organised data or information
Repository of meta data, which is a central storehouse for all data definitions, data relationships, screen and report formats and other system components.

5.Fill in the blanks by selecting the correct option(s) given below: �In a relational data model, the columns of a table are called and the rows are called tuples. The primary key index does not allow data in a field. Views has characteristics of tables and can be used for .�

(i) keys (ii) multiple (iii) queries
(i) fields (ii) enter (iii) reports
(i) fields (ii) duplicate (iii) queries
(i) data (ii) enter (iii) form
(i) attributes (ii) duplicate (iii) reports.

More Database Management QUESTIONS AND ANSWERS available in next pages

    Health is the greatest gift, contentment is the greatest wealth -Buddha
Trust because you are willing to accept the risk, not because it’s safe or certain