DATABASE MANAGEMENT MCQs with Answers
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]