McqMate
These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: MCQ on Computer Softwares , Common Topics in Competitive and Entrance exams , Microsoft Office .
| 451. |
After entering all fields required for a table, if you realize that the third field is not needed, how will you remove? |
| A. | You need to delete the whole table. There is no method to remove a particular field only. |
| B. | Delete all the fields from third downwards and reenter the required fields again. |
| C. | Select the third column in datasheet view then delete |
| D. | Select the third row in table design view then delete |
| Answer» D. Select the third row in table design view then delete | |
| 452. |
Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find relationship command |
| A. | File menu |
| B. | View menu |
| C. | Database menu |
| D. | Tools menu |
| Answer» D. Tools menu | |
| 453. |
What do you mean by one to many relationship between student and class table? |
| A. | One student can have many classes |
| B. | One class may have many student |
| C. | Many classes may have many students |
| D. | Many students may have manu classes |
| Answer» A. One student can have many classes | |
| 454. |
Referential integrity means |
| A. | 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 table |
| B. | Do not enter a value in the primary key field of chield table if that value does not exist in the primary key of the parent table |
| C. | Do not enter a value in the foreign key field of a parent table if that value does not exist in the primary key of the child table |
| D. | All of above |
| Answer» A. 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 table | |
| 455. |
Cascade delete option |
| A. | Is used to delete all the records of all tables in a database |
| B. | Will repeat the recent delete operation to all the records of current table |
| C. | Is available in edit relatiionship dialog box which makes sure that all the related records will be deleted automatically whn the record from parent table is deleted |
| D. | None of above |
| Answer» C. Is available in edit relatiionship dialog box which makes sure that all the related records will be deleted automatically whn the record from parent table is deleted | |
| 456. |
When a picture or other graphic image is placed in the report header section it will appear____ |
| A. | Once in the bugging of the report |
| B. | At the top of every page |
| C. | Every after record break |
| D. | On the 1st and last pages of the report |
| Answer» A. Once in the bugging of the report | |
| 457. |
Which of the following database object is created first before any other created? |
| A. | Table |
| B. | Form |
| C. | Report |
| D. | Query |
| Answer» A. Table | |
| 458. |
This type of database contains multiple tables that are connected to produce combined output from all tables. |
| A. | Bound |
| B. | Linked |
| C. | Relational |
| D. | Joined |
| Answer» C. Relational | |
| 459. |
The ‘filter by selection’ allows you to filter those records |
| A. | That match the selected field |
| B. | That match the criteria specified |
| C. | That meet any of several criteria specified |
| D. | All of above |
| Answer» A. That match the selected field | |
| 460. |
The operation of checking input data against specified criteria is known as? |
| A. | Data verification |
| B. | Data validation |
| C. | Cross check |
| D. | Data control |
| Answer» B. Data validation | |
| 461. |
Some rules are set in databases to check and permit only correct values. What is this feature called? |
| A. | Data verification |
| B. | Auditing |
| C. | Data filtering |
| D. | Data validation |
| Answer» D. Data validation | |
| 462. |
Database access levels are specified so as to define who can access what in a database. It is identified through |
| A. | User id |
| B. | Password |
| C. | Status |
| D. | None of above |
| Answer» A. User id | |
| 463. |
What it is called to present information in a particular order based on numeric or alphabetical value? |
| A. | Sorting |
| B. | Searching |
| C. | Arranging |
| D. | Cropping |
| Answer» A. Sorting | |
| 464. |
A collection of related records in database is known as a |
| A. | Table |
| B. | Database |
| C. | File |
| D. | None of above |
| Answer» C. File | |
| 465. |
A part of database that stores complete information about an entity such as employee, sales, orders etc. |
| A. | File |
| B. | Record |
| C. | Field |
| D. | Query |
| Answer» B. Record | |
| 466. |
To create this, you enter an expression in the design grid that instructs access to perform a calculation using the current field values. |
| A. | Formulated field |
| B. | Numeric field |
| C. | Formula field |
| D. | Calculated field |
| Answer» D. Calculated field | |
| 467. |
The ascending order of data hierarchy is? |
| A. | Bit - byte - field - record - file - databse |
| B. | Bit - byte - record - field - file - database |
| C. | Byte - bit - field - record - file - database |
| D. | Bit - byte - field - record - database - file |
| Answer» A. Bit - byte - field - record - file - databse | |
| 468. |
Which of the following database object can be used if you need to mail the invoice to customers? |
| A. | A form |
| B. | A query |
| C. | A report |
| D. | A table |
| Answer» C. A report | |
| 469. |
When creating an input mask this character does not require an entry, but if an entry is made it must be a letter from a-z |
| A. | ? |
| B. | ! |
| C. | # |
| D. | \ |
| Answer» A. ? | |
| 470. |
In access, this displays the results of a calculation in a query |
| A. | Lookup field |
| B. | Calculated field |
| C. | Source field |
| D. | Child field |
| Answer» B. Calculated field | |
| 471. |
In access, this operation copies a backup file from the storage medium back onto the computer |
| A. | Recreate |
| B. | Restore |
| C. | Copy |
| D. | Structure |
| Answer» B. Restore | |
| 472. |
If you make an invalid entry in the input mask wizard dialog box, this will display to advise you that the entry is not correct |
| A. | Text error |
| B. | Validation error |
| C. | Literal error |
| D. | Entry error |
| Answer» B. Validation error | |
| 473. |
In the form wizard dialog box, the fields from the selected table are displayed in this list box. |
| A. | All fields |
| B. | All records |
| C. | Available records |
| D. | Available fields |
| Answer» D. Available fields | |
| 474. |
This form displays the field name labels down the left side of the column, with the data for each field just to the right of its corresponding label. |
| A. | Tabular |
| B. | Justified |
| C. | Columnar |
| D. | Datasheet |
| Answer» C. Columnar | |
| 475. |
This form displays data in a table layout with field name labels across the top of the page and the corresponding data in rows and columns under each heading. |
| A. | Columnar |
| B. | Justified |
| C. | Datasheet |
| D. | Tabular |
| Answer» D. Tabular | |
| 476. |
This form displays multiple records, one per row, in the form window |
| A. | Datasheet |
| B. | Tabular |
| C. | Columnar |
| D. | Justified |
| Answer» A. Datasheet | |
| 477. |
In this form, a single record may appear in multiple rows in the form window in order to fully display the field name label and data. |
| A. | Datasheet |
| B. | Tabular |
| C. | Justified |
| D. | Columnar |
| Answer» C. Justified | |
| 478. |
Which of the following is not a form style available in the form wizard dialog box. |
| A. | Blends |
| B. | Standard |
| C. | Stone |
| D. | Highlights |
| Answer» D. Highlights | |
| 479. |
You can move between fields in a form by using any of these keys except |
| A. | Tab |
| B. | Enter |
| C. | Shift+tab |
| D. | Page up |
| Answer» D. Page up | |
| 480. |
Queries are based on this, allowing you to use a query as the source for forms and reports |
| A. | Filters |
| B. | Tables |
| C. | Records |
| D. | Fields |
| Answer» B. Tables | |
| 481. |
This type of query summarizes large amounts of data in easy-to-read, row-and-column format. |
| A. | Crosstab |
| B. | Columnar |
| C. | Select |
| D. | Action |
| Answer» A. Crosstab | |
| 482. |
Which of the following is not one of the methods available in the new query dialog box to create queries? |
| A. | Design view |
| B. | Crosstab query wizard |
| C. | Simple query wizard |
| D. | Datasheet view |
| Answer» D. Datasheet view | |
| 483. |
This query wizard will create a select query. |
| A. | Crosstab |
| B. | Find duplicates |
| C. | Simple |
| D. | Design view |
| Answer» C. Simple | |
| 484. |
The quickest way to add a field to the selected fields list is to double-click its field name in this list. |
| A. | Find fields |
| B. | Search fields |
| C. | Search record |
| D. | Available fields |
| Answer» D. Available fields | |
| 485. |
The result of a query is displayed in a |
| A. | Record |
| B. | Query datasheet |
| C. | Query table |
| D. | Form |
| Answer» B. Query datasheet | |
| 486. |
Changing the order of this in the query datasheet does not affect the field order in the table. |
| A. | Record |
| B. | Row |
| C. | Column |
| D. | Sort |
| Answer» C. Column | |
| 487. |
In the second subform wizard dialog box you specify the table to use as the data source and the |
| A. | Records from the selected form |
| B. | Form from the selected table |
| C. | Fields from the selected table |
| D. | Content from the selected form |
| Answer» C. Fields from the selected table | |
| 488. |
This is not one of the sections of the form design window |
| A. | Form footer |
| B. | Form content |
| C. | Form header |
| D. | Form detail |
| Answer» B. Form content | |
| 489. |
When you select this control, its associated text control is also selected and the two controls will act as one when manipulated. |
| A. | Text |
| B. | Form |
| C. | Label |
| D. | Field |
| Answer» B. Form | |
| 490. |
In access, this view is used to create and modify the structure of a form. |
| A. | Normal |
| B. | Datasheet |
| C. | Form design |
| D. | Control |
| Answer» C. Form design | |
| 491. |
To set a password for the database, select ____________ in the Microsoft Access open window. |
| A. | Open read only |
| B. | Open write only |
| C. | Open explicit |
| D. | Open exclusive |
| Answer» D. Open exclusive | |
| 492. |
To enter the input mask wizard |
| A. | Click on the three dots to the right of the caption entry field |
| B. | Click on the three dots to the right of the format entry field |
| C. | Click on the input mask toolbar |
| D. | Click on the three dots to the right of the input mask entry field |
| Answer» D. Click on the three dots to the right of the input mask entry field | |
| 493. |
Saving a database in access is done |
| A. | At the beginning of the database |
| B. | The first time you save data |
| C. | When closing the application |
| D. | During auto save |
| Answer» A. At the beginning of the database | |
| 494. |
The file extension for an access 2003 database is |
| A. | Exe |
| B. | Doc |
| C. | Exc |
| D. | Mdb |
| Answer» D. Mdb | |
| 495. |
Which of the following best describes the grouped report? |
| A. | A part of report that can be generated by the report wizard |
| B. | A report that displays data that has been sorted in ascending or descending order |
| C. | A report that displays data grouped by fields you specify |
| D. | None of a the above |
| Answer» C. A report that displays data grouped by fields you specify | |
| 496. |
What is the use of description field in table design window? |
| A. | The description will be displayed on status bar when entering data in datasheet view |
| B. | The description will be displayed on status bar when entering data in form |
| C. | Both of above |
| D. | None of a the above |
| Answer» C. Both of above | |
| 497. |
How can you display the related records from other tables in datasheet view? |
| A. | Click on the expand indicator next to the record |
| B. | Double click on the record to expand it |
| C. | Apply filter by command to display related records |
| D. | All of above |
| Answer» A. Click on the expand indicator next to the record | |
| 498. |
Which of the following query type is best suitable to analyze data? |
| A. | Cross tab queries |
| B. | Parameter queries |
| C. | Action queries |
| D. | None of above |
| Answer» A. Cross tab queries | |
| 499. |
Which of the following is a database management system? |
| A. | Ms word |
| B. | Ms excel |
| C. | Oracle |
| D. | Lotus 1-2-3 |
| Answer» C. Oracle | |
| 500. |
In relational database schema each tuple is divided into fields known as? |
| A. | Relations |
| B. | Queries |
| C. | Records |
| D. | Domains |
| Answer» D. Domains | |
Done Studing? Take A Test.
Great job completing your study session! Now it's time to put your knowledge to the test. Challenge yourself, see how much you've learned, and identify areas for improvement. Don’t worry, this is all part of the journey to mastery. Ready for the next step? Take a quiz to solidify what you've just studied.