DATABASE AND RELATIONSHIP BETWEEN CLASSES.rtf - MICROSOFT ACCESS DATABASE BASIC CONCEPTS Q What do you mean by one to many relationship between Teacher

DATABASE AND RELATIONSHIP BETWEEN CLASSES.rtf - MICROSOFT...

This preview shows page 1 - 4 out of 11 pages.

MICROSOFT ACCESS DATABASE BASIC CONCEPTS: Q. What do you mean by one to many relationship between Teacher and Class table? A.One class may have many teachersB.One teacher can have many classesC.Many classes may have many teachersD.Many teachers may have many classesAnswer : Option AQ.Which of the following enables us to view data from a table based on a specific criterionA.FormB.QueryC.MacroD.ReportAnswer : Option BQ.Which database object is ideal to view, change, andanalyze datain different ways ?A.TableB.FormC.Query Answer : Option B Q. What are the different view to present a Table ? A.Datasheet View B.Design View C.Pivote TableView D.All Of Above Answer : Option D Q. In one-to-many relationship the table on 'many' side is called _______ A.Parent B.Child C.Sister D.Master Answer : Option B Q. 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
Image of page 1
D.ReportAnswer : Option CQ.In one-to-many relationship the table in 'one' side is called _______A.ChildB.OwnerC.ParentD.OwnerAnswer : Option CQ.Which data type allows alphanumeric characters and special symbols to be entered?A.TextB.MemoC.Auto numberD.MixedAnswer : Option AQ.It is used to establish an association between related tables.A.LineB.RelationshipC.Primary KeyD.RecordsAnswer : Option BQ.This key that uniquely identifies each record is called :A.Primary KeyB.Key RecordC.Unique KeyD.Field NameAnswer : Option AQ.Which name must be unique within a database ?A.TableB.FieldC.RecordD.CharacterAnswer : Option AQ.The third stage of designing a database is when we create___________ between tablesA.RelationshipB.JoinC.QueryD.None of TheseAnswer : Option A
Image of page 2
Q.Two tables can be linked with relationship to _____A.Ensure data entryB.Ensure data integrityC.Create Primary KeyD.Ensure Foreign KeyAnswer : Option BQ.In a database Table, the each category of information Is called __________A.TupleB.FieldC.RecordD.All Of AboveAnswer : Option BQ.Which of the following fields has width of 8 bytes?A.MemoB.NumberC.Date/timeD.HyperlinkAnswer : Option CQ.which of the following is not a database object?A.TablesB.QueriesC.RelationshipsD.ReportsAnswer : Option CQ.Which one is the guideline of Referential integrity in a relationship ?A.Do not enter a value in the primary key field of chield table if that value does not exist inthe primary key of the parent tableB.Do not enter a value in the foreign key field of a parent table if that value doesnot exist in the primary key of the child tableC.Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent tableD.Do not enter a value in the foreign key field of child table if that value does not exist inthe
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 11 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes