Database Management Questions and Answers

Software Programming : Database Management QUESTIONS AND ANSWERS :: part8 : 11 to 15

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

11.Which of the following set of operations represent a complete set of relational algebra operations?

{ s, p, U}

{ � , x }

{ s, p, n }

{p , n, x}

{ � , x }.

12.Which of the following SQL aggregate function gives the number of rows containing not null values for the given column?

MIN

COUNT

MAX

SUM

AVG.

13.Which Model describes entities, relationships and attributes?

E � R Model

Functional

Relational

Network

Info logical.

14.The following are the three language components of a database management system (DBMS). I. Data Definition Language (DDL). II. Sub-schema DDL. III. Data Manipulation Language (DML). Two different types of people (users and practioners) are concerned with them. Which of them do users of a DBMS usually deal with?

Only (I) above

Only (III) above

Both (I) and (II) above

Both (II) and (III) above

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

More Database Management QUESTIONS AND ANSWERS available in next pages