MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 38 Mcqs, each offering curated multiple-choice questions to sharpen your Computer knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Which type of database, organised the data in the form of tree with nodes ? |
| A. | Network Database |
| B. | Hierarchical Database |
| C. | Relational Database |
| D. | Multiple Database |
| E. | None of these |
| Answer» C. Relational Database | |
| 2. |
Which of the following types of table constraints will prevent the entry of duplicate rows ? |
| A. | Primary key |
| B. | Unique |
| C. | Null |
| D. | Foreign key |
| E. | None of these |
| Answer» B. Unique | |
| 3. |
DBMS ic comprised of tables that made up of rows called ...... and columns called ............ |
| A. | fields, records |
| B. | records, fields |
| C. | address, fields |
| D. | ranges, sheet |
| E. | records, ranges |
| Answer» C. address, fields | |
| 4. |
Which out of the following is not a DBMS software ? |
| A. | dBASE |
| B. | FixPro |
| C. | Oracle |
| D. | SyBase |
| E. | Database 2000 |
| Answer» F. | |
| 5. |
The primary key must be a (n) ...... field. |
| A. | numeric |
| B. | object |
| C. | unique |
| D. | related |
| E. | None of these |
| Answer» D. related | |
| 6. |
Which of the following objects is/are contained in database ? |
| A. | Table |
| B. | Query |
| C. | Form |
| D. | All of these |
| E. | None of these |
| Answer» E. None of these | |
| 7. |
A ............ is a collection of data that is stored electronically as a series of records in a table. |
| A. | spreadsheet |
| B. | presentation |
| C. | database |
| D. | Web page |
| E. | None of the above |
| Answer» D. Web page | |
| 8. |
In files, there is a key associated with each record which is used to differentiate among different records, For every file, there is atleast one set of keys that is unique. Such a key is called |
| A. | unique key |
| B. | prime attribute |
| C. | index key |
| D. | primary key |
| E. | null key |
| Answer» E. null key | |
| 9. |
In which the database can be restored up to the last consistent state after the system failure ? |
| A. | Backup |
| B. | Recovery |
| C. | Redundancy |
| D. | Security |
| E. | None of these |
| Answer» C. Redundancy | |
| 10. |
Which of the following places the common data elements in order from smallest to largest ? |
| A. | Character, File Record, Field, Database |
| B. | Character, Record, Field, File, Database |
| C. | Character, Field, Record, File, Database |
| D. | Bit, Byte, Character, Record, Field, File, Database |
| E. | None of the above |
| Answer» D. Bit, Byte, Character, Record, Field, File, Database | |
| 11. |
The database administrator's function in an organisation is |
| A. | to be responsible for the technical aspects of managing the information contained in organisational databases |
| B. | to be responsible for the executive level aspects of decision regarding the information management |
| C. | to show the relationship among entity classes in a data warehouse |
| D. | to define which data mining tools must be used to extract data |
| E. | None of the above |
| Answer» B. to be responsible for the executive level aspects of decision regarding the information management | |
| 12. |
The database stores information in |
| A. | rows and columns |
| B. | blocks |
| C. | tracks and sectors |
| D. | All of these |
| E. | None of these |
| Answer» B. blocks | |
| 13. |
...... are distinct items that don't have much meaning to you in a given context. |
| A. | Fields |
| B. | Data |
| C. | Queries |
| D. | Properties |
| E. | None of these |
| Answer» B. Data | |
| 14. |
The particular field of a record that uniquely identifies each record is called the |
| A. | key field |
| B. | primary field |
| C. | master field |
| D. | order field |
| E. | None of these |
| Answer» C. master field | |
| 15. |
Which of the following contains information about a single 'entity' in the database like a person, place, event or thing ? |
| A. | Query |
| B. | Form |
| C. | Record |
| D. | Table |
| E. | None of these |
| Answer» D. Table | |
| 16. |
An |E-R diagram is a graphic method of presenting |
| A. | primary keys and their relationships |
| B. | primary keys and their relationships to instances |
| C. | entity classes and their relationships |
| D. | entity classes and their relationships to primary keys |
| E. | None of the above |
| Answer» D. entity classes and their relationships to primary keys | |
| 17. |
A computer checks the ...... of username and password for a match before granting access. |
| A. | Website |
| B. | network |
| C. | backup file |
| D. | database |
| E. | None of these |
| Answer» E. None of these | |
| 18. |
An entity set that does not have sufficient attributes to form a primary key, is a |
| A. | strong entity set |
| B. | weak entity set |
| C. | simple entity set |
| D. | primary entity set |
| E. | None of the above |
| Answer» C. simple entity set | |
| 19. |
In a relational database, a data structure that organises the information about a single topic into rows and columns, is |
| A. | block |
| B. | record |
| C. | tuple |
| D. | table |
| E. | None of these |
| Answer» E. None of these | |
| 20. |
A collection of related files is called a |
| A. | character |
| B. | field |
| C. | database |
| D. | record |
| E. | None of these |
| Answer» E. None of these | |
| 21. |
In ER diagram, relationship type is represented by |
| A. | ellipse |
| B. | dashed ellipse |
| C. | rectangle |
| D. | diamond |
| E. | None of these |
| Answer» E. None of these | |
| 22. |
.......... provides total solutions to reduce data redundancy, inconsistency, dependence and unautorised access of data. |
| A. | DBMS |
| B. | Tables |
| C. | Database |
| D. | Protection password |
| E. | Centralisation of data |
| Answer» E. Centralisation of data | |
| 23. |
........ is one reason for problems of data integrity. |
| A. | Data availability constraints |
| B. | Data inconsistency |
| C. | Security constraints |
| D. | Unauthorised access of data |
| E. | Data redundancy |
| Answer» B. Data inconsistency | |
| 24. |
Dr. E F Codd represented ...... rules that a database must obey if it has to be considered truly relational. |
| A. | 10 |
| B. | 8 |
| C. | 12 |
| D. | 6 |
| E. | 5 |
| Answer» D. 6 | |
| 25. |
A collection of conceptual tools for describing data, relationships, semantics and constraints is referred to as |
| A. | ER model |
| B. | database |
| C. | data model |
| D. | DBMS |
| E. | None of these |
| Answer» D. DBMS | |
| 26. |
What is the overall term for creating, editing, formatting, storing, retrieving a text document ? |
| A. | Word processing |
| B. | Spreadsheet design |
| C. | Web design |
| D. | Database management |
| E. | Presentation generation |
| Answer» E. Presentation generation | |
| 27. |
When data change in multiple lists and all lists are not updated. This causes. |
| A. | Data redundancy |
| B. | Information overload |
| C. | Duplicate data |
| D. | Data consistency |
| E. | Data inconsistency |
| Answer» F. | |
| 28. |
Which name is suitable to run a macro at starting time of database ? |
| A. | Start. exe |
| B. | Auto.exec |
| C. | Mocro.exe |
| D. | Any of these |
| E. | None of these |
| Answer» E. None of these | |
| 29. |
......... is a primary key of one file that also appears in another file. |
| A. | Physical key |
| B. | Primary key |
| C. | Foreign key |
| D. | Logical key |
| E. | None of these |
| Answer» D. Logical key | |
| 30. |
......... is an invalid type of database key. |
| A. | Structured primary key |
| B. | Atomic primary key |
| C. | Primary key |
| D. | Composite primary key |
| E. | None of the above |
| Answer» B. Atomic primary key | |
| 31. |
A field is a related group of ........ |
| A. | cables |
| B. | records |
| C. | files |
| D. | characters |
| E. | None of these |
| Answer» C. files | |
| 32. |
Oracle is a (n) |
| A. | hardware |
| B. | high level language |
| C. | operating system |
| D. | system software |
| E. | RDBMS |
| Answer» F. | |
| 33. |
....... tags, placed on animal's body can be used to record and track in a database all of the animal's movements. |
| A. | POS |
| B. | RFID |
| C. | PPS |
| D. | GPS |
| E. | Other than those given as options |
| Answer» C. PPS | |
| 34. |
What is a stored question about information in a database ? |
| A. | Query |
| B. | Sort |
| C. | Report |
| D. | Record |
| E. | Field |
| Answer» B. Sort | |
| 35. |
Data duplication wastes the space, but also promotes a more serious problem called |
| A. | isolated called |
| B. | data inconsistency |
| C. | other than those given as options |
| D. | program dependency |
| E. | separated data |
| Answer» C. other than those given as options | |
| 36. |
Which of the following contains data descriptions and defines the name, data type and length of each field in the database ? |
| A. | Data dictionary |
| B. | Data table |
| C. | Data record |
| D. | Data field |
| E. | None of these |
| Answer» B. Data table | |
| 37. |
A range checks |
| A. | that only the correct data type is entered into a field |
| B. | that all required data are present |
| C. | whether a number is within a specified limit |
| D. | if the data in two or more associated fields is logical |
| E. | None of the above |
| Answer» D. if the data in two or more associated fields is logical | |
| 38. |
Which of the following will not eliminate the ambiguities of a null value ? |
| A. | Define the attribute as required |
| B. | Define subtypes |
| C. | Define each attribute as having an initial value that is recognised as blank |
| D. | Define super types |
| E. | None of the above |
| Answer» E. None of the above | |