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)