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.
| 401. |
A database makes it unreadable in MS-Access is called? |
| A. | Encode |
| B. | Database |
| C. | Decode |
| D. | None |
| Answer» B. Database | |
| 402. |
Which of the following the AutoCalc command on the toolbar provides in MS-Access? |
| A. | Sum |
| B. | Count |
| C. | Min |
| D. | All of the above |
| Answer» E. | |
| 403. |
In MS-Access the maximum length of validation text is? |
| A. | 126 |
| B. | 129 |
| C. | 234 |
| D. | 255 |
| Answer» E. | |
| 404. |
_____ property is used to specify requirements for data entered into a record, field or control? |
| A. | Validation text |
| B. | Validation rule |
| C. | Both a and b |
| D. | None of these |
| Answer» C. Both a and b | |
| 405. |
Caption is a string that can contain up to _________ characters in MS-Access? |
| A. | 2025 |
| B. | 2031 |
| C. | 2037 |
| D. | 2048 |
| Answer» E. | |
| 406. |
Which of the following is valid text and memo format in MS-Access? |
| A. | @ |
| B. | < |
| C. | & |
| D. | All of the above |
| Answer» E. | |
| 407. |
_____ property is used to set the maximum size for data stored in a field? |
| A. | Data entry |
| B. | Field size |
| C. | Format |
| D. | Rows |
| Answer» C. Format | |
| 408. |
Which of the following is not a valid relationship in MS-Access? |
| A. | One to one relationship |
| B. | One to many relationship |
| C. | One to two relationship |
| D. | Many to many relationship |
| Answer» D. Many to many relationship | |
| 409. |
_______ is a field property that determines what kind of data a field can store? |
| A. | File type |
| B. | Data type |
| C. | Data select |
| D. | None of these |
| Answer» D. None of these | |
| 410. |
Which of the following is not a data type in MS-Access? |
| A. | Table |
| B. | Number |
| C. | Text |
| D. | OLE object |
| Answer» B. Number | |
| 411. |
_______ defines a data type for a set of values in a table? |
| A. | Field |
| B. | File |
| C. | Record |
| D. | None of these |
| Answer» B. File | |
| 412. |
_________ provides the tools for creating fields in a table? |
| A. | Drawing View |
| B. | Table View |
| C. | Both a and b |
| D. | Design View |
| Answer» E. | |
| 413. |
_______ is a component of database such as a table, query, form and macro? |
| A. | Record |
| B. | Object |
| C. | Table |
| D. | None of these |
| Answer» C. Table | |
| 414. |
MS-Access database files have a default extension? |
| A. | DBM |
| B. | PRG |
| C. | MDE |
| D. | BBE |
| Answer» D. BBE | |
| 415. |
Which of the following is latest version of MS-Access? |
| A. | MS-Access 2002 |
| B. | MS-Access 2000 |
| C. | MS-Access ME |
| D. | MS-Access XP |
| Answer» E. | |
| 416. |
MS-Access is a? |
| A. | Programming Tool |
| B. | Database Tool |
| C. | Web Page Creation Tool |
| D. | None of the Above |
| Answer» C. Web Page Creation Tool | |
| 417. |
In MS-Access, what Are The Different Views To Display a table? |
| A. | Datasheet View |
| B. | Design View |
| C. | Pivot Table & Pivot Chart View |
| D. | All of the above |
| Answer» E. | |
| 418. |
How we save database file in MS Access 2007 for Ms Access 2000? |
| A. | Save As MS Access 2000 Database |
| B. | Save Only |
| C. | Save Object As |
| D. | None of these |
| Answer» B. Save Only | |
| 419. |
How many save as option in MS Access 2007? |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» D. 4 | |
| 420. |
Which of the following is not a data base application? |
| A. | Access |
| B. | dBase |
| C. | edit |
| D. | FoxPro |
| Answer» D. FoxPro | |
| 421. |
How do you rearrange the date in ascending or descending order? |
| A. | Data, table |
| B. | Data, sort |
| C. | Data, form |
| D. | Data, subtotals |
| Answer» C. Data, form | |
| 422. |
To merge the cells which tab do you use from the format, cells menu? |
| A. | Merge tab |
| B. | Number tab |
| C. | Alignment tab |
| D. | Font tab |
| Answer» D. Font tab | |
| 423. |
There are three types of data found in a spreadsheet: |
| A. | Numbers, formulas, labels |
| B. | Data, words, numbers |
| C. | Words, numbers, labels |
| D. | Equations, data, numbers |
| Answer» B. Data, words, numbers | |
| 424. |
Query can be use to select data from |
| A. | Single Table |
| B. | Multiple Tables |
| C. | Both Single & Multiple Tables |
| D. | None of the above |
| Answer» D. None of the above | |
| 425. |
Validation Rule in a field will |
| A. | Defines the appearance for the text |
| B. | Displays the value in specified format when user leaves the field |
| C. | Checks the value entered when user leaves the field |
| D. | None of the above |
| Answer» D. None of the above | |
| 426. |
Which of the following is use to get data from user ? |
| A. | Query |
| B. | Form |
| C. | Report |
| D. | Table |
| Answer» C. Report | |
| 427. |
In MS Access “Lookup Wizard” is used to |
| A. | to select value from another table |
| B. | to select values from Excel Sheet |
| C. | to select from previous values |
| D. | None of the above |
| Answer» B. to select values from Excel Sheet | |
| 428. |
Which of the following data type is used to store logical value in MS Access ? |
| A. | Yes/No |
| B. | On/Off |
| C. | True/False |
| D. | All of the above |
| Answer» B. On/Off | |
| 429. |
The advantage of using a spreadsheet is |
| A. | Calculations can be done automatically |
| B. | Changing data automatically updates calculations |
| C. | More flexibility |
| D. | All of the above |
| Answer» E. | |
| 430. |
You can create hyperlinks from the Excel workbook to |
| A. | A webpage on company internet |
| B. | A web page on the internet |
| C. | Other office 97 application documents |
| D. | All of the above |
| Answer» E. | |
| 431. |
To add two cells (A1 and A2) together you use the following formula: |
| A. | A1 plus A2 |
| B. | |
| C. | |
| D. | |
| Answer» C. | |
| 432. |
In an excel sheet the active cell is indicated by: |
| A. | A blinking border |
| B. | A dotted border |
| C. | A dark wide boarder |
| D. | None of These |
| Answer» D. None of These | |
| 433. |
Which symbol must all formula begin with: |
| A. | @ |
| B. | = |
| C. | + |
| D. | % |
| Answer» C. + | |
| 434. |
The basic elements of a form or a report are called: |
| A. | Windows |
| B. | Controls |
| C. | Objects |
| D. | Table |
| Answer» C. Objects | |
| 435. |
Which data type is better to use for storing the price of an item ? |
| A. | Number |
| B. | Text |
| C. | Currency |
| D. | Hyperlink |
| Answer» D. Hyperlink | |
| 436. |
What is the full form of SQL ? |
| A. | Structured Query Language |
| B. | Structured Question List |
| C. | Sophisticated Question List |
| D. | None of the above |
| Answer» B. Structured Question List | |
| 437. |
What do you call a primary key field included in another table ? |
| A. | Child key |
| B. | Composite key |
| C. | Parent key |
| D. | Foreign key |
| Answer» E. | |
| 438. |
In a datasheet, what does each row represent ? |
| A. | Field |
| B. | Database |
| C. | Record |
| D. | All of the above |
| Answer» D. All of the above | |
| 439. |
HSAM stands for ________ |
| A. | Hierarchic Standard and Method |
| B. | Hierarchic Sequential and Method |
| C. | Hierarchic Standard Access Method |
| D. | Hierarchic Sequential Access Method |
| Answer» E. | |
| 440. |
An organized collection of logically related data is known as |
| A. | Database |
| B. | Meta data |
| C. | Information |
| D. | None of the above |
| Answer» B. Meta data | |
| 441. |
A composite key is |
| A. | The primary key with AutoNumber as the field type |
| B. | Is a foreign key that uniquely identifies records |
| C. | Made up of two or more fields to uniquely identify records |
| D. | None of the above |
| Answer» D. None of the above | |
| 442. |
The task of arranging data in order is called |
| A. | Ordering |
| B. | Searching |
| C. | Sorting |
| D. | Ascending |
| Answer» D. Ascending | |
| 443. |
The complete information about an entity in a database is called |
| A. | Field |
| B. | Record |
| C. | Information |
| D. | All of the above |
| Answer» C. Information | |
| 444. |
Collection of rlated records in a database is known as |
| A. | Record |
| B. | Relationship |
| C. | File |
| D. | Table |
| Answer» E. | |
| 445. |
A database can be best described as |
| A. | Useful presentation of data |
| B. | Organized collection of data |
| C. | Graphical representation of data |
| D. | None of the above |
| Answer» C. Graphical representation of data | |
| 446. |
A part of database that stores only one type of data is |
| A. | Record |
| B. | Table |
| C. | Field |
| D. | Report |
| Answer» D. Report | |
| 447. |
Which of the following store command to retrieve data from database ? |
| A. | Queries |
| B. | Forms |
| C. | Record |
| D. | Reports |
| Answer» B. Forms | |
| 448. |
24 Microsoft Access is a |
| A. | OODBMS |
| B. | ORDBMS |
| C. | RDBMS |
| D. | None of the above |
| Answer» D. None of the above | |
| 449. |
What is the maximum length a text field can be ? |
| A. | 255 |
| B. | 256 |
| C. | 257 |
| D. | 355 |
| Answer» B. 256 | |
| 450. |
Which field type can store photos ? |
| A. | Hyperlink |
| B. | OLE |
| C. | Memo |
| D. | Text |
| Answer» C. Memo | |