Database Management Questions and Answers

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?

MIN

COUNT

MAX

SUM

AVG.

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

Binary Tree

B-tree

Mapping

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