Database Management System We Also Provide SYNOPSIS AND PROJECT. Contact www.kimsharma.co.in for best and lowest cost solution or Email: amitymbaassignment@gmail.com Call: +91 82907-72200 (Call/WhatsApp) or +91 88003-52777 (WhatsApp Only) QUESTION 1 A table on the many side of a one to many or many to many relationship must: Be in Second Normal Form (2NF) Be in Third Normal Form (3NF) Have a single attribute key Have a composite key QUESTION 2. DBMS is a collection of .. that enables user to create and maintain a database. Keys Translators Program Language Activity QUESTION 3. " Inst_dept (ID, name, salary, dept name, building, budget) is decomposed into; instructor (ID, name, dept name, salary), department (dept name, building, budget). This comes under" Lossy-join decomposition Lossy decomposition Lossless-join decomposition Both a and b QUESTION 4. The attribute AGE is calculated from DATE_OF_BIRTH . The attribute AGE is Single valued Multi valued Composite Derived QUESTION 5. The term _______ is used to refer to a row. Attribute Tuple Field Instance QUESTION 6. Key to represent relationship between tables is called primary key secondary key foreign key none of the above QUESTION 7. "For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute." Domain Relation Set Schema QUESTION 8. The entity relationship set is represented in E-R diagram as Double diamonds Undivided rectangles Dashed lines Diamond QUESTION 9. … is a preferred method for enforcing data integrity Constraints Stored procedure Triggers Cursors QUESTION 10. Which of the following is a single valued attribute Register_number Address SUBJECT_TAKEN Reference QUESTION 11. " Empdt1(empcode, name, street, city, state,pincode).; For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in" 1 NF only 2 NF and hence also in 1 NF 3NF and hence also in 2NF and 1NF "BCNF and hence also in 3NF, 2NF and 1NF" QUESTION 12. Data items grouped together for storage purposes are called a record title list string QUESTION 13. DFD stands for Data Flow Document Data File Diagram Data Flow Diagram None of the above QUESTION 14. "In an ER model, . is described in the database by storing its data." Entity Attribute Relationship Notation QUESTION 15. An advantage of the database management approach is data is dependent on programs data redundancy increases data is integrated and can be accessed by multiple programs none of the above QUESTION 16. Which of the following is not a logical database structure? Chain Network Tree Relational QUESTION 17. Which-one ofthe following statements about normal forms is FALSE? BCNF is stricter than 3 NF "Lossless, dependency -preserving decomposition into 3 NF is always possible" "Loss less, dependency preserving decomposition into BCNF is always possible" Any relation with two attributes is BCNF QUESTION 18. "Course(course_id,sec_id,semester); Here the course_id,sec_id and semester are __________ and course is a _________" "Relations, Attribute" "Attributes, Relation" "Tuple, Relation" "Tuple, Attributes" QUESTION 19. A is used to define overall design of the database schema application program data definition language code QUESTION 20. A relational database consists of a collection of Tables Fields Records Keys We Also Provide SYNOPSIS AND PROJECT. Contact www.kimsharma.co.in for best and lowest cost solution or Email: amitymbaassignment@gmail.com Call: +91 82907-72200 (Call/WhatsApp) or +91 88003-52777 (WhatsApp Only)