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
- TNTET 2021 - Practice
- SSC CGL 2021 - Practice
- TNPSC Group 2A 2021 - Practice
- IIT JEE
- IIT JEE Q&A
- TNPSC Answer Keys
- TNPSC Group 2 Syllabus
- TNPSC Q&A
- Online Tests - TNPSC
- Online Tests - GK
- IBPS 2020-2021
- Online Tests - Bank
- Online Tests - RRB NTPC
- Online Tests - UGC NET
- Online Tests - TANCET
- Online Aptitude Test
- Engineering
- Programming
- Basic Science
- Quiz
- Plus Two Question Papers
- SSLC Question Bank
- Aptitude Tests
- Logical Reasoning
- General Knowledge-Hindi
- Indian History MCQ
- Indian Geography MCQ
- Indian Civics MCQ
- Indian Economics MCQ
- CTET Biology MCQ
- CTET Chemistry MCQ
- CTET Physics Solved MCQ
- Arithmetic Tests
- Press Release
- FAQ
- Coaching Centres
- TNPSC Group 1 Syllabus
- TNPSC Group IV Syllabus
- TRB 2017 in English PDF
- TRB 2017 in Tamil PDF
- TET
- TNTET