Database Management Questions and Answers

Software Programming : Database Management QUESTIONS AND ANSWERS :: part13 : 6 to 10

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

6.Which of the following lock prevents the use of any tables in the database from one transaction while another transaction is being processed?

Database-level lock

Table-level lock

Page-level lock

Row-level lock

Field-level lock.

7.Which of the following is/are the basic operation(s) used to develop useful sets of data in a relational database?

Sort, select and report

Combine, relate and sort

Select, project and join

Project, combine and report

Join, relate and sort.

8.The basic SQL aggregate function that gives the number of rows containing not null values for the given column is #190.The basic SQL aggregate function that gives the number of rows containing not null values for the given column is

MIN

COUNT

MAX

SUM

AVG.

9.The purpose of a relational DBMS model is to

Combine the hierarchical model and the network model

Treat data as if they were stored in two-dimensional tables

Make reports more difficult to program

Share common data elements with application programs

Combine Network model and Object oriented model.

10.When implementing security in a DBMS, which of the following is not supported by the GRANT command?