Database Management Questions & Answers: part20



Software Programming : Database Management QUESTIONS AND ANSWERS :: part20 : 1 to 5

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

1.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.

2.A unit of storage that can store one or more records in a hash file organization is denoted as

Buckets
Disk pages
Blocks
Nodes
Baskets.

3.A condition that occurs when two transactions wait for each other to unlock data is known as a(n)

Shared lock
Exclusive lock
Binary lock
Two-phase lock
Deadlock.

4.A table where all attributes are dependent on the primary key and are independent of each other, and no row contains two or more multivalued facts about an entity, is said to be in

1NF
2NF
3NF
4NF
BCNF.

5.A lock that prevents the use of any tables in the database from one transaction while another transaction is being processed is called a

Database-level lock
Table-level lock
Page-level lock
Row-level lock
Field-level lock.

More Database Management QUESTIONS AND ANSWERS available in next pages

    Health is the greatest gift, contentment is the greatest wealth -Buddha
Innovation distinguishes between a leader and a follower.-Steve Jobs