MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 496 Mcqs, each offering curated multiple-choice questions to sharpen your Computer Fundamentals knowledge and support exam preparation. Choose a topic below to get started.
| 351. |
In table design view what are the first column of buttons used for |
| A. | Indicate Primary Key |
| B. | Indicate Current Row |
| C. | Both of above |
| D. | None of above |
| Answer» D. None of above | |
| 352. |
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» E. | |
| 353. |
The following method you can use to add a new table to your database |
| A. | Use Design View to create a table |
| B. | Enter data directly by using a datasheet |
| C. | Both of above |
| D. | All of the above |
| Answer» D. All of the above | |
| 354. |
What is the use of Referential Integrity in MS Access? |
| A. | It allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table |
| B. | It does not allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table |
| C. | It allow to enter a value in the Primary key field of a child table if that value exist in the Foreign key of the parent table |
| D. | None of above |
| Answer» B. It does not allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table | |
| 355. |
What is the process of eliminating redundant fields by separating data into tables called? |
| A. | Renormalizations |
| B. | Filtering |
| C. | Normalization |
| D. | Sorting |
| Answer» D. Sorting | |
| 356. |
In Access, to Exit Office Access 2007Access |
| A. | CTRL+N |
| B. | CTRL+O |
| C. | ALT+F4 |
| D. | None of these |
| Answer» D. None of these | |
| 357. |
You created a query with two tables that did NOT have a join line. The first table has 12 records and the second has 5. The resulting recordset would have how many records? |
| A. | 7 |
| B. | 17 |
| C. | 60 |
| D. | Not enough information to tell |
| Answer» D. Not enough information to tell | |
| 358. |
A(n) ____ in the Record Selector indicates a new record. |
| A. | check mark |
| B. | pencil |
| C. | asterisk |
| D. | arrow |
| Answer» D. arrow | |
| 359. |
In Access press to Cycle through the field grid, field properties, Navigation Pane, access keys in the Keyboard Access System, Zoom controls, and the security bar (Design view of tables) |
| A. | F6 |
| B. | F7 |
| C. | F8 |
| D. | None of these |
| Answer» B. F7 | |
| 360. |
In Access press ALT+F11 to |
| A. | Display the Control menu |
| B. | Display the shortcut menu |
| C. | Close the active window |
| D. | None of these |
| Answer» E. | |
| 361. |
The most popular commercial DBMS. |
| A. | Microsoft SQL Server |
| B. | Microsoft Access |
| C. | MySQL |
| D. | Oracle |
| Answer» E. | |
| 362. |
In MS Access, Field Value may contain |
| A. | Text |
| B. | Date & Time |
| C. | Picture |
| D. | All of the Above |
| Answer» E. | |
| 363. |
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» E. | |
| 364. |
To display sales grouped by country, region, and salesperson, all at the same time |
| A. | Use the Sort Descending command. |
| B. | Use the Pivot table view command |
| C. | Use the find command on specified groups |
| D. | All of above |
| Answer» C. Use the find command on specified groups | |
| 365. |
In a table, ______(s) are displayed in the order in which they were entered. Most often this order is not useful. |
| A. | formula |
| B. | format |
| C. | layout |
| D. | record |
| Answer» E. | |
| 366. |
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 child 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» B. Do not enter a value in the primary key field of child table if that value does not exist in the primary key of the parent table | |
| 367. |
An application that executes on separate PCs like this is called a(n) __________ application. |
| A. | enterprise |
| B. | distributed |
| C. | tier |
| D. | global |
| Answer» C. tier | |
| 368. |
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» B. ! | |
| 369. |
A global join will be created automatically when using tables in a(n) _____. |
| A. | form |
| B. | report |
| C. | query |
| D. | field |
| Answer» C. query | |
| 370. |
The __________ performs document tracking. |
| A. | distributed application |
| B. | enterprise software |
| C. | Oracle software |
| D. | EDM software |
| Answer» E. | |
| 371. |
For _________ data to be useful, both the sender and the receiver need to be able to read and use the data. |
| A. | standardized |
| B. | fixed |
| C. | delimited |
| D. | shared |
| Answer» E. | |
| 372. |
After creating the table which of the following is correct? |
| A. | Fields cannot be added |
| B. | Fields cannot be deleted |
| C. | Fields can added but only once |
| D. | Fields can added and deleted as needed |
| Answer» E. | |
| 373. |
Relationship can be establish between two tables by |
| A. | Drag Primary key of a table into Foreign key of another table |
| B. | Drag Foreign key of a table into Primary key of another table |
| C. | Drag any key of a table into any key of another table |
| D. | All of the above |
| Answer» B. Drag Foreign key of a table into Primary key of another table | |
| 374. |
The _____ Smart Tag launches Microsoft Outlook to schedule an appointment or display a calendar. |
| A. | Date |
| B. | Time |
| C. | Calendar |
| D. | Appointment |
| Answer» B. Time | |
| 375. |
Database Management Systems are featured with: |
| A. | The facility to easy editing, spelling check, auto pagination, lay out and printing reports |
| B. | The ability to store large amount of data to facilitate easy update, sort and retrieval |
| C. | The ability to calculate efficiently with the help of built-in functions and analyze |
| D. | All of above |
| Answer» C. The ability to calculate efficiently with the help of built-in functions and analyze | |
| 376. |
In a module, a(n) _______ is a series of commands and properties that perform a specific task. |
| A. | event |
| B. | property |
| C. | procedure |
| D. | macro |
| Answer» D. macro | |
| 377. |
What type of relationship is created when you select a primary key in both related tables? |
| A. | One-To-One |
| B. | Indeterminate |
| C. | One-To-Many |
| D. | Many-To-Many |
| Answer» B. Indeterminate | |
| 378. |
The Table _______________ Wizard analyzes a database and recommends changes for normalization. |
| A. | Analyzer |
| B. | Documenter |
| C. | Cleanup |
| D. | Normalization |
| Answer» B. Documenter | |
| 379. |
Which of the following is NOT a report section? |
| A. | Report Header section |
| B. | Summary section |
| C. | Page header section |
| D. | Details section |
| Answer» C. Page header section | |
| 380. |
In Access to open new database press |
| A. | CTRL+N |
| B. | CTRL+O |
| C. | ALT+F4 |
| D. | None of these |
| Answer» B. CTRL+O | |
| 381. |
How to make a date field DOB store the dates like "2002/10/17" ? |
| A. | By setting the input mask property to "yyyy/mm/dd" |
| B. | By setting the format property to "yyyy/mm/dd" |
| C. | By entering dates in yyyy, mm, dd order |
| D. | none of the above |
| Answer» C. By entering dates in yyyy, mm, dd order | |
| 382. |
You can not import data into access database from |
| A. | Dbase iii database files |
| B. | Excel spreadsheets |
| C. | Comma delimited text files |
| D. | None of the above |
| Answer» E. | |
| 383. |
It is an association established between common fields of two tables. |
| A. | line |
| B. | relationship |
| C. | primary key |
| D. | records |
| Answer» C. primary key | |
| 384. |
In Access press to Open the Choose Builder dialog box (Design view window of forms and reports) |
| A. | F6 |
| B. | F7 |
| C. | F8 |
| D. | None of these |
| Answer» C. F8 | |
| 385. |
In Access press …………………….to Paste the contents of the Clipboard in the upper- left corner of the selected section |
| A. | CTRL+C |
| B. | CTRL+X |
| C. | CTRL+V |
| D. | None of these |
| Answer» D. None of these | |
| 386. |
Which of the following may not be a database? |
| A. | Data presented in table in MS Word document |
| B. | Data entered in Excel spreadsheet |
| C. | A presentation created in PowerPoint |
| D. | A telephone diary |
| Answer» D. A telephone diary | |
| 387. |
A ____ is a major database object used to display information in an attractive, easy-to-read screen format. |
| A. | form |
| B. | query |
| C. | report |
| D. | table |
| Answer» B. query | |
| 388. |
The procedure for selecting multiple controls on a report? |
| A. | Hold down the Shift key as you click each object that you want to select |
| B. | If the controls are aligned along a horizontal or vertical line, click the horizontal or vertical ruler above or to the left of the controls |
| C. | Hold down the Ctrl key as you click each object that you want to select |
| D. | All of these above are true |
| Answer» B. If the controls are aligned along a horizontal or vertical line, click the horizontal or vertical ruler above or to the left of the controls | |
| 389. |
Which of the following is not a layout in the form design? |
| A. | Autoform Layout |
| B. | Justified Layout |
| C. | Columnar |
| D. | Database |
| Answer» B. Justified Layout | |
| 390. |
In MS-Access, minimum of _________data types can be assigned to a field? |
| A. | 2 |
| B. | 6 |
| C. | 7 |
| D. | 10 |
| Answer» E. | |
| 391. |
_______ a series of lines and data appear in the form in Design view? |
| A. | Order of tabs |
| B. | Grid lines |
| C. | Label |
| D. | None of these |
| Answer» C. Label | |
| 392. |
_______shows multiple records at a time on a page with fields in columns and records in rows? |
| A. | Database |
| B. | Justified |
| C. | Tabular |
| D. | Database |
| Answer» D. Database | |
| 393. |
______shows a single record at a time? |
| A. | Datasheet |
| B. | Tabular |
| C. | Columnar |
| D. | None of these |
| Answer» B. Tabular | |
| 394. |
What Are The Different Views To Display A Table |
| A. | Datasheet View |
| B. | Design View |
| C. | Pivote Table & Pivot Chart View |
| D. | All of the above |
| Answer» E. | |
| 395. |
MS-Access is used to develop a? |
| A. | Database design |
| B. | XLS file |
| C. | TXT file |
| D. | None of these |
| Answer» B. XLS file | |
| 396. |
MS-Access is a component of? |
| A. | Microsoft Office |
| B. | Windows XP |
| C. | Windows |
| D. | None of these |
| Answer» B. Windows XP | |
| 397. |
MS-Access is a type of? |
| A. | Utility software |
| B. | Application Software |
| C. | System software |
| D. | None |
| Answer» C. System software | |
| 398. |
Which key is used to join the two table in MS-Access? |
| A. | Primary key |
| B. | Special key |
| C. | Foreign key |
| D. | None of these |
| Answer» D. None of these | |
| 399. |
MDE file does not contain? |
| A. | Macros |
| B. | Tables |
| C. | Queries |
| D. | Source code |
| Answer» E. | |
| 400. |
MDE file is a? |
| A. | Memory Database Encrypt |
| B. | Memory Database Encode |
| C. | Microsoft Database Encrypt |
| D. | Microsoft Access Database |
| Answer» E. | |