Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called
Foreign key
Native key
Composite key
Primary key
Also checkout these categories
Auto CAD 2D MCQ Time and Work MCQ Lower urinary tract trauma MCQ Transformation of Sentences MCQ Phylum - Echinodermata MCQ Solids, Liquides, Gases MCQ Surface Chemistry MCQ Metabolism MCQ Tumors of the prostate MCQ The Living World MCQ Sexual dysfunctions MCQ Ethers MCQ
- We can remove a relationship defined between two tables by
- This is the stage in database design where one gathers and lists all the necessary fields for the database…
- The database language that allows you to access or maintain data in a database
- What do you mean by one to many relationship between Student and Class table?
- If I create Student field in Fees table to store student_id of Students table, then this Student field…
- Microsoft Access is a
- Which of the following may not be a database?
- This option allows you to build a new table by entering data directly into the datasheet.
- Which of the following is not a field type in Access
- What happens when you release mouse pointer after you drop the primary key of a table into foreign key…
- A __ name must be unique within a database
- Which is not a view to display a table in Access?
- When a picture or other graphic image is placed in the report header section it will appear____
- The two form layout types will display multiple records at one time are tabular and___
- Queries in Access can be used as
- The command center of access file that appears when you create or open the MS Access database file.
- Cascade update option
- Which of the following expresses correct order?
- What do you mean by one to many relationship between Student and Class table?
- To create queries in Access
- An Access database object that is used to enter, view or edit records
- A database object in MS Access that stores a question about the data in database?
- A __________ enables you to view data from a table based on a specific criterion
- To sort records in a table
- Referential integrity means
- It is a query that when run displays its own dialog box prompting you for information, such as
- The default and maximum size of text field in Access
- The third stage in designing a database is when we analyze our tables more closely and create a ___________…
- In one-to-many relationship the table in one side is called _______ and on many side is called _______
- To create relationship between two tables