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 2015 examinations :
1.The basic SQL aggregate function that gives the number of rows containing not null values for the given column is
ANSWER : COUNT
Explanation : : Count function gives the number of rows containing not null values for the given column
2.A unit of storage that can store one or more records in a hash file organization is denoted as
ANSWER : Buckets
Explanation : Buckets are used to store one or more records in a hash file organization.
3.A condition that occurs when two transactions wait for each other to unlock data is known as a(n)
ANSWER : Deadlock.
Explanation : : Deadlock occurs when two transactions wait for each other to unlock data
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
ANSWER : 4NF
Explanation : : Answer is obvious
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
ANSWER : Database-level lock
Explanation : Data base-level lock prevents the use of any tables in the data base from one transaction while other transaction is being processed.
More Database Management QUESTIONS AND ANSWERS available in next pages
Health is the greatest gift, contentment is the greatest wealth -Buddha