DATABASE MANAGEMENT MCQs with Answers
Q1.What do you mean by one to many relationship between Teacher and Class table?
Q1.What do you mean by one to many relationship between Teacher and Class table?
A.One class may have many teachers
B.One teacher can have many classes
C.Many classes may have many teachers
D.Many teachers may have many classes
Answer : One teacher can have many classes [Option : B]
Q2. What are the different view to present a Table ?
A.Datasheet View
B.Design View
C.Pivote TableView
D.All Of Above
Answer : All Of Above [Option : D]
Q3 In which state one gathers and list all the necessary fields for the database design project.
A.Data Definition
B.Data Refinement
C.Establishing Relationship
D.None Of The Above
Answer : Data Definition [Option : A]
Q4. Which of the following enables us to view data from a table based on a specific criterion
A.Form
B.Query
C.Macro
D.Report
Answer : Query [Option : B]
Q5. Which database object is ideal to view, change, andanalyze datain different ways ?
A.Table
B.Form
C.Query
D.Report
Answer : Query [Option : C]
Q6. In one-to-many relationship the table in 'one' side is called _______
A.Child
B.Owner
C.Parent
D.Owner
Answer : Parent [Option : C]
Q7. Which data type allows alphanumeric characters and special symbols to be entered?
A.Text
B.Memo
C.Auto number
D.Mixed
Answer : Text [Option : A]
Q8. It is used to establish an association between related tables.
A.Line
B.Relationship
C.Primary Key
D.Records
Answer : Relationship [Option : B]
Q9. This key that uniquely identifies each record is called :
A.Primary Key
B.Key Record
C.Unique Key
D.Field Name
Answer : Primary Key [Option : A]
Q10. Which name must be unique within a database ?
A.Table
B.Field
C.Record
D.Character
Answer : Table [Option : A]
Q11. The third stage of designing a database is when we create___________ between tables
A.Relationship
B.Join
C.Query
D.None of These
Answer : Relationship [Option : A]
