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.
| 451. |
The______ operator will cause a record to be selected only if two or more conditions are satisfied |
| A. | NOT |
| B. | XOR |
| C. | OR |
| D. | AND |
| Answer» E. | |
| 452. |
What are the columns in a Microsoft Access table called ? |
| A. | Reports |
| B. | Rows |
| C. | Fields |
| D. | Records |
| Answer» D. Records | |
| 453. |
A ______ name must be unique within a database |
| A. | Table |
| B. | Record |
| C. | Field |
| D. | All of the above |
| Answer» B. Record | |
| 454. |
Which of the following database object produces the final result to present ? |
| A. | Tables |
| B. | Reports |
| C. | Reports |
| D. | None of the above |
| Answer» C. Reports | |
| 455. |
A _______ enables you to view data from a table based on a specific criterion |
| A. | Query |
| B. | Report |
| C. | Form |
| D. | All of the above |
| Answer» B. Report | |
| 456. |
Which of the following database object hold data ? |
| A. | Reports |
| B. | Tables |
| C. | Forms |
| D. | All of the above |
| Answer» C. Forms | |
| 457. |
Which of the following is a/are view/views to display a table in Access ? |
| A. | Datasheet View |
| B. | Design View |
| C. | Both (A) and (B) |
| D. | None of the above |
| Answer» D. None of the above | |
| 458. |
Which of the field has width 8 bytes ? |
| A. | Currency |
| B. | Memo |
| C. | Hyperlink |
| D. | Date/Time |
| Answer» E. | |
| 459. |
Which of the following is not a type of relationship that can be applied in Access database |
| A. | One to One |
| B. | One to Many |
| C. | Many to Many |
| D. | All of the above |
| Answer» E. | |
| 460. |
Which field type will you select when creating a new table if you require to enter long text in that field ? |
| A. | Text |
| B. | Currency |
| C. | Memo |
| D. | All of the above |
| Answer» D. All of the above | |
| 461. |
To create relationship between two tables |
| A. | drag any field from parent table and drop on child table |
| B. | drag the foreign key of a table into the primary key of another table |
| C. | drag the primary key of a table into foreign key of another table |
| D. | None of the above |
| Answer» D. None of the above | |
| 462. |
The size of Yes No field is always |
| A. | 1 bit |
| B. | 1 byte |
| C. | 1 kilobyte |
| D. | 1 megabyte |
| Answer» B. 1 byte | |
| 463. |
The size of a field with Number data type can not be |
| A. | 2 |
| B. | 4 |
| C. | 8 |
| D. | 16 |
| Answer» E. | |
| 464. |
This is the stage in database design where one gathers and lists all the necessary fields for the database project. |
| A. | data dictionary |
| B. | data refinement |
| C. | data definition |
| D. | none of the above |
| Answer» D. none of the above | |
| 465. |
In one-to-many relationship the table in ‘one’ side is called _______ and on ‘many’ side is called _______ |
| A. | Parent , Child |
| B. | Child , Parent |
| C. | Row , Column |
| D. | None of the above |
| Answer» B. Child , Parent | |
| 466. |
Which of the following is not a database object ? |
| A. | Form |
| B. | Tables |
| C. | Reports |
| D. | Relationships |
| Answer» E. | |
| 467. |
Query design window has two parts. The upper part shows |
| A. | Name of fields, field type and size |
| B. | Sorting check boxes |
| C. | Tables with fields and relationships between tables |
| D. | None of the above |
| Answer» D. None of the above | |
| 468. |
What Is The Maximum Length A Text Field Can Be? |
| A. | 120 |
| B. | 255 |
| C. | 265 |
| D. | 75 |
| Answer» C. 265 | |
| 469. |
The Database Language That Allows You To Access Or Maintain Data In A Database |
| A. | DCL |
| B. | DML |
| C. | DDL |
| D. | None Of Above |
| Answer» B. DML | |
| 470. |
DCL Provides Commands To Perform Actions Like |
| A. | Change The Structure Of Tables |
| B. | Insert, Update Or Delete Records And Data Values |
| C. | Authorizing Access And Other Control Over Database |
| D. | None Of Above |
| Answer» D. None Of Above | |
| 471. |
Microsoft Access Is A |
| A. | RDBMS |
| B. | ORDBMS |
| C. | OODBMS |
| D. | Network Database Model |
| Answer» B. ORDBMS | |
| 472. |
Following Is Not A Database Model |
| A. | Network Database Model |
| B. | Relational Database Model |
| C. | Object Oriented Database Model |
| D. | None |
| Answer» E. | |
| 473. |
Which Of The Following Statement Is True? |
| A. | Foreign Key Fields Don\'t Allow Duplicate Values |
| B. | In Primary Key Field You Can Enter Duplicate Value |
| C. | In An Indexed Field You May Or May Not Enter Duplicate Value Depending Upon Setting |
| D. | All Statements Are True |
| Answer» D. All Statements Are True | |
| 474. |
Which Of The Field Has Width 8 Bytes? |
| A. | Memo |
| B. | Number |
| C. | Date/time |
| D. | Hyperlink |
| Answer» D. Hyperlink | |
| 475. |
A Database Language Concerned With The Definition Of The Whole Database Structure And Schema Is ________ |
| A. | DCL |
| B. | DML |
| C. | DDL |
| D. | All Of Above |
| Answer» D. All Of Above | |
| 476. |
This Is The Stage In Database Design Where One Gathers And List All The Necessary Fields For The Database Project. |
| A. | Data Definition |
| B. | Data Refinement |
| C. | Establishing Relationship |
| D. | None Of The Above |
| Answer» B. Data Refinement | |
| 477. |
It Is An Association Established Between Common |
| A. | Line |
| B. | Relationship |
| C. | Primary Key |
| D. | Records |
| Answer» C. Primary Key | |
| 478. |
This Key Uniquely Identifies Each Record |
| A. | Primary Key |
| B. | Key Record |
| C. | Unique Key |
| D. | Field Name |
| Answer» B. Key Record | |
| 479. |
In A Database Table, The Category Of Information Is Called __________ |
| A. | Tuple |
| B. | Field |
| C. | Record |
| D. | All of the above |
| Answer» C. Record | |
| 480. |
The Third Stage In Designing A Database Is When We Analyze Our Tables More Closely And Create A ___________ Between Tables |
| A. | Relationship |
| B. | Join |
| C. | Query |
| D. | None of these |
| Answer» B. Join | |
| 481. |
The Command Center Of Access File That Appears When You Create Or Open The Ms Access Database File. |
| A. | Database Window |
| B. | Query Window |
| C. | Design View Window |
| D. | Switchboard |
| Answer» B. Query Window | |
| 482. |
Which Of The Following Creates A Drop Down List Of Values To Choose From? |
| A. | Ole Object |
| B. | Hyperlink |
| C. | Memo |
| D. | Lookup Wizard |
| Answer» E. | |
| 483. |
In MS-Access to open new database press |
| A. | CTRL+N |
| B. | CTRL+O |
| C. | ALT+F4 |
| D. | None of these |
| Answer» B. CTRL+O | |
| 484. |
In MS-Access to Open a combo box |
| A. | F4 or ALT+DOWN ARROW |
| B. | DOWN ARROW |
| C. | PAGE DOWN |
| D. | F9 |
| Answer» B. DOWN ARROW | |
| 485. |
In MS-Access to open an existing database press |
| A. | CTRL+N |
| B. | CTRL+O |
| C. | ALT+F4 |
| D. | None of these |
| Answer» C. ALT+F4 | |
| 486. |
In MS-Access to Refresh the contents of a Lookup field (Lookup field: A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or |
| A. | F4 or ALT+DOWN ARROW |
| B. | DOWN ARROW |
| C. | PAGE DOWN |
| D. | F9 |
| Answer» E. | |
| 487. |
In MS-Access press CTRL+O to |
| A. | Open a new database |
| B. | Open an existing database |
| C. | Exit MS-Access |
| D. | None of these |
| Answer» C. Exit MS-Access | |
| 488. |
An attempt to access a location not owned by a Program is called |
| A. | Bus conflict |
| B. | Address fault |
| C. | Page fault |
| D. | Operating system fault |
| Answer» C. Page fault | |
| 489. |
A computer checks the _____ of user names and passwords for a match before granting access. |
| A. | Website |
| B. | Network |
| C. | Backup file |
| D. | Data base |
| Answer» E. | |
| 490. |
Which of the following network access standard disassembler is used for connection station to a packet switched network ? |
| A. | X.3 |
| B. | X.21 |
| C. | X.25 |
| D. | X.75 |
| Answer» D. X.75 | |
| 491. |
A stored link to a webpage, in order to have a quick and easy access to it later, it called : |
| A. | Bookmark |
| B. | WP-link |
| C. | Favourite |
| D. | Both (1) and (3) |
| Answer» E. | |
| 492. |
The difference between people with access to computers and the Internet and those without this access is known as the: |
| A. | digital divide. |
| B. | Internet divide. |
| C. | Web divide. |
| D. | broadband divide. |
| Answer» B. Internet divide. | |
| 493. |
Granting an outside organisation access to Internet web pages is often implemented using a (an) |
| A. | Extranet |
| B. | Intranet |
| C. | Internet |
| D. | Hacker |
| Answer» B. Intranet | |
| 494. |
We access the World Wide Web using : |
| A. | Browsers |
| B. | Instant messaging applications |
| C. | High bandwidth |
| D. | Search engine |
| Answer» B. Instant messaging applications | |
| 495. |
Which of the following network access standard is used for connecting station to a circuit switched network ? |
| A. | X.3 |
| B. | X.21 |
| C. | X.25 |
| D. | X.75 |
| Answer» C. X.25 | |
| 496. |
In Ethernet CSMA/CD, the special bit sequence transmitted by media access management collision handling is called |
| A. | preamble |
| B. | postamble |
| C. | jam |
| D. | None of these |
| Answer» D. None of these | |