Software Programming : Database Management QUESTIONS AND ANSWERS :: part17 : 11 to 15
Following Software Programming language Entrance Multiple choice objective type questions and answers will help you in Software Programming 2024 examinations :
11.Which of the following is correct? |
Function dependencies are not associated with relations; they are based on the semantics of information that we are dealing with |
If a relation has no redundant information its attributes must not have any function dependencies |
Functional dependencies may be determined if we are given several instances of a relation |
The FDs that hold for attributes of a relation need not be satisfied at all times |
BCNF is a fourth normal form. |
12.When converting one (1) to many (N) binary relationship into tables, the recommended solution is usually |
One big table with all attributes from both entities included |
Foreign key added on the Child (many side) referencing the parent |
Foreign key added on the Parent (one side) referencing the child |
Foreign key added on both sides (both tables) |
Primary Key is added on one side. |
13.A property or characteristic of an entity type that is of interest to the organization is called an |
Attribute |
Coexisting entity |
Relationship |
Cross-function |
Weak entity. |
14.What are the correct features of a distributed database? #270.What are the correct features of a distributed database? |
Is always connected to the internet |
Always requires more than three machines |
Users see the data in one global schema. |
Have to specify the physical location of the data when an update is done |
All DBMS have to be homogenous. |
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