COMPUTER MCQ . (1 Marks)

There are…..options available to allow to maintain referentian integrity in database.

……..Principal an statet as no unmatched foreign key valies should exist in the database.

there must not be any entry in the state table without a related in the country table the consept is known as…….

Transaction able is also known as…….

Master table is also known as…….

To create relationship between two table………

How many option are shown based on delete option in referential intrgrity dialog box?

which option are shown based on update options in referential  integrity dialog box ?

which type of work options available to allow to maintain referential integrity in database ?

…….Is displayed the foreign key side to make relationship between two table.

……….is displayed on the primary key side to make relationship between two table.

to make relationship which table text are shown near the field ?

when there is no relationship between two tables of the datatype of referencing field and referenced field then we will see……

To create a relationship between two tables the data type of …… must be same

where one vale of referred table is associated with multiple values in referencing table is called…..relationship.

Primary key repeated……… n number times in foreign key.

To create relationship between two table text n is displayed on……..side.

To create relationship between two table text 1 is displayed  on…… side.

In Ordershipment table shippingstatus field is used to maintain the atatus of the product  delivery initial its data type is …………. 

to make relationship between two tables, how many table text shown near the field ?

to make relationship between two table……. Connecting both field

to create a relationship just use…… opration.

in relationship window to add it display with which information?

you can click on…….button seen to  add tables dialog with list of tables created in the active database will be display.

click on which button for adding table in relationship dialog box window?

to insert a table in relationship dialog box which menu option can you use?

To establish the appropriate relationship which menu-option is used ?

Which menu is used to established the appropriate relationship among the different tables of the database ?

………… can be defined as field or combination of fields whose values are borrowed from another table.

Two tables are related to each other using a …………….

Establising relationship between tables we will restrict the user from entering garbage data in the field .

Primary key symbol will be displayed in the ………… of the two selected rows.

The table which contains primary key is known as …………..

If we want to select two field simultaneuously in composite primary key, which key you have to press ?

To eliminate redundant data from the database, we must take special care to organize the data…………

Combination of more than one field when designed as a primary key is also known as ……………..

What is the value of primary key ?

The field which contains a primary key whose values is not ………………

To create a realationship between two tables of primary key the data types of field is …………….

When a master table has composite primary key than tables related with it will hold ……….

How many button are displayed for sorting the data in base table ?

By Which method you can arrange data which is residing in table ?

If we click on ……………. Button, then the selected record will not be deleted from the table but it will be redisplayed in the view.

If we click on the …………… button, then the selected record will be deleted from the table permanently.

What made data normalization ?

When you delete the record, base will display …………….

Database designer attempt to eliminate it as far as possible  by using a technique called ……………..

Data Redundancy is ……………..

Unnecessary duplication or repetition of data is called ………….

In the following what display data redundancy ?