Software Programming : Database Management QUESTIONS AND ANSWERS :: part7 : 11 to 15
Following Software Programming language Entrance Multiple choice objective type questions and answers will help you in Software Programming 2024 examinations :
11.State the unit of storage that can store one or more records in a hash file organization |
Buckets |
Disk pages |
Blocks |
Nodes |
Baskets. |
12.Which of the following concept is applicable with respect to 2NF? |
Full functional dependency |
Partial dependency |
Transitive dependency |
Non-transitive dependency |
Data independence. |
13.Consider the following ER diagram depicting the relationship of an employee and supervisor: What is the possible relation if the above ERD is mapped into a relational model? |
Employee (EmpID, BirthDate, Salary, Name(FirstName, MiddleName, LastName)) |
Employee (EmpID, BirthDate, Salary, Name(FirstName, MiddleName, LastName)} |
Supervision (EmpID, BirthDate, Salary, Name(FirstName, MiddleName, LastName), EmpID) |
Supervisor (SupervisorID, BirthDate, Salary, Name(FirstName, MiddleName, LastName),EmpID), {EmpID}) |
Employee (EmpID, BirthDate, Salary, Name(FirstName, MiddleName, LastName), SupervisorID). |
14.If K is a foreign key in a relation R1, then |
Every tuple of R1 has a distinct value for K |
K cannot have a null value for tuples in R1 |
K is a key for some other relation |
K is a Primary key for R1 |
K is a Composite key for R1. |
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