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 ?

Data redundancy is a term used for ………..

how many level will be displayed for arrangement of sorting base data ?

How many types you can arrange data residing in table ?

The process of correcting the data entered previously is known as …………..

How many reason are ther to edit table record ?

Which menu is used to delete the record from the table ?

How to delete record ?

How many type, you can delete record from the table ?

to delete any record from the table…………….

After deleting unnecessary or incorrect records from the table data base it will become a …….

The process of deleting data is known as …………

which work is not done on record of database?

when we have made changes to a record then how  are they saved ?

If we click on Boolean type field, a square box of which symbol will be shown ?

if the Boolean type field ,a square box is not marked with tick mark then the value of the field is…….

………box will be shown in the field.

base will give  which type of facility if field datatype and field property defined in table ?

if we have detained each field for table table the data entry in base is controlled and restricted based on the ?

how many buttons are there on navigation bar ?

navigation bar knows  the current position of the…….

navigation bar contains some navigation buttons to scroll the records…….

which part is staeted with record word in datasheet view ?

the data entry in base is controlled and  restricted based on the?

which key is used to get original information after deleting correction ?

when we click on any of the field  to edit the dara, which icon is show ?

4icon is known as ?

In datasheet view of table the black pointing arrow is known as ………

Which type of symbol displas edit icon ?

If you want to enter new record in table, which button is used ?

The job of filing all the empty boxes with appropriate data is known as…………….

If  you want to go current after record of  which button is used ?

If  you want to go on last record of table, which button is used ?

If you want to go on first record of table, which button is used ?

From the following which option display current record ?

…………. Indicates a current record of the table at any given moment of time.

data sheet can show only some …………… fields on the screen.

The line consisting of field name is known as …….. in data sheet view of table

Which of the following menu is shown in datasheet view of table ?

How many menu is shown in datasheet view of table ?

Which symbol is shown on Record Selector Icon ?

Scrollbar is seen at the …………… of the screen in datasheet view

Below the title line, there is a ………….. consisting of empty box.

can use ………….. for those field which can not seen on the screen in datasheet view.

Table structure will be displayed in ………….. view.

Table icon is shown in which pen ?

What to do for inserting record in table ?

Which  type of process you can do in database ?

To get the correct information at right time, we have to prepare ………

Which view is used for data entry in table ?

From the following which option display table view ?

When we open table, its displayed in …………..

We have to take many decisions daily and for that we need.