MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 34 Mcqs, each offering curated multiple-choice questions to sharpen your Computer Science knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Multiple mismatching copies of the same data is known as _________. |
| A. | Data standardisation |
| B. | Data sharing |
| C. | Data inconsistency |
| D. | Data dependency |
| Answer» D. Data dependency | |
| 2. |
A piece of code or a statement that gives you filtered data according to some conditions and specifications is called a _________. |
| A. | Table |
| B. | Form |
| C. | Query |
| D. | Report |
| Answer» D. Report | |
| 3. |
Design view in MS-Access does NOT allow you to _______. |
| A. | Edit field values |
| B. | Change data type |
| C. | Assign validation rule |
| D. | Change field name |
| Answer» B. Change data type | |
| 4. |
A system in which database is maintained in the form of tables and in which all records are stored in rows is called _________. |
| A. | Relational database |
| B. | Object oriented database |
| C. | Flat database |
| D. | Varied database |
| Answer» B. Object oriented database | |
| 5. |
A database system in which relationships among data are established in such a way that one data item is present as a child of another, is said to be a/an _________ DBMS. |
| A. | Relational |
| B. | Isolated |
| C. | Hierarchical |
| D. | Virtual |
| Answer» D. Virtual | |
| 6. |
Rearrange the given steps in a CORRECT order to design a database. (i) Determine the fields you need. (ii) Determine the tables you need. (iii) Determine the purpose of your database. (iv) Identify the fields with unique values in each record.(v) Determine the relationships between tables. |
| A. | (i) \[\to \] (ii) \[\to \] (iii)\[\to \] (iv) \[\to \](v) |
| B. | (i)\[\to \] (ii) \[\to \] (iv) \[\to \](iii) \[\to \](v) |
| C. | (iii) \[\to \](ii) \[\to \](i)\[\to \] (iv) \[\to \] (v) |
| D. | (iii) \[\to \](v) \[\to \](iv)\[\to \](ii) \[\to \] (i) |
| Answer» D. (iii) \[\to \](v) \[\to \](iv)\[\to \](ii) \[\to \] (i) | |
| 7. |
Which of the following data types is suitable for storing alpha-numeric information, that contain more than 255 characters in MS-Access? |
| A. | Number |
| B. | Text |
| C. | Memo |
| D. | Yes/No |
| Answer» D. Yes/No | |
| 8. |
Which of the following contains data descriptions and defines the name, data type and length of each field in the database? [IBPS Clerk 2015] |
| A. | Data dictionary |
| B. | Data table |
| C. | Data record |
| D. | Data field |
| E. | None of these |
| Answer» B. Data table | |
| 9. |
The purpose of the primary key in a database is to[IBPS Clerk 2015] |
| A. | unlock the database |
| B. | provide a map of the data |
| C. | uniquely identity a record |
| D. | establish constraints on database operations |
| E. | None of the above |
| Answer» D. establish constraints on database operations | |
| 10. |
Data duplication wastes the space, but also promotes a more serious problem called [IBPS PO 2015] |
| 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 | |
| 11. |
What is a stored question about information in a database? [SBI Clerk 2015] |
| A. | Query |
| B. | Sort |
| C. | Report |
| D. | Record |
| E. | Field |
| Answer» B. Sort | |
| 12. |
......... tags, placed on animal's body can be used to record and track in a database all of the animal's movements. [IBPS Clerk 2014] |
| A. | POS |
| B. | RFID |
| C. | PPS |
| D. | GPS |
| E. | Other than those given as options |
| Answer» C. PPS | |
| 13. |
Oracle is a (n) [IBPS Clerk 2014] |
| A. | hardware |
| B. | high level language |
| C. | operating system |
| D. | system software |
| E. | RDBMS |
| Answer» F. | |
| 14. |
......... is an invalid type of database key. [IBPS Clerk 2013] |
| 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 | |
| 15. |
......... is a primary key of one file that also appears in another file. [IBPS Clerk 2013] |
| A. | Physical key |
| B. | Primary key |
| C. | Foreign key |
| D. | Logical key |
| E. | None of these |
| Answer» D. Logical key | |
| 16. |
A collection of interrelated records is called a [RBI Grade B 2012] |
| A. | utility file |
| B. | management information system |
| C. | database |
| D. | spreadsheet |
| E. | datasheet |
| Answer» D. spreadsheet | |
| 17. |
When data changes in multiple lists and all lists are not updated. This causes. [RBI Grade B 2012] |
| A. | Data redundancy |
| B. | Information overload |
| C. | Duplicate data |
| D. | Data consistency |
| E. | Data inconsistency |
| Answer» F. | |
| 18. |
What is the overall term for creating, editing, formatting, storing, retrieving a text document? [IBPS PO 2012] |
| A. | Word processing |
| B. | Spreadsheet design |
| C. | Web design |
| D. | Database management |
| E. | Presentation generation |
| Answer» E. Presentation generation | |
| 19. |
A collection of conceptual tools for describing data, relationships, semantics and constraints is referred to as [IBPS Clerk 2012] |
| A. | ER model |
| B. | database |
| C. | data model |
| D. | DBMS |
| E. | None of these |
| Answer» D. DBMS | |
| 20. |
............ provides total solutions to reduce data redundancy, inconsistency, dependence and unauthorised access of data. [IBPS Clerk 2012] |
| A. | DBMS |
| B. | Tables |
| C. | Database |
| D. | Protection password |
| E. | Centralisation of data |
| Answer» E. Centralisation of data | |
| 21. |
The particular field of a record that uniquely identifies each record is called the [SBI PO 2012] |
| A. | key field |
| B. | primary field |
| C. | master field |
| D. | order field |
| E. | None of these |
| Answer» C. master field | |
| 22. |
......... are distinct items that don't have much meaning to you in a given context. [SBI PO 2012] |
| A. | Fields |
| B. | Data |
| C. | Queries |
| D. | Properties |
| E. | None of these |
| Answer» B. Data | |
| 23. |
To locate a data item for storage is [IBPS PO 2012] |
| A. | field |
| B. | feed |
| C. | database |
| D. | fetch |
| E. | None of these |
| Answer» E. None of these | |
| 24. |
In ER diagram, relationship type is represented by [IBPS Clerk 2012] |
| A. | ellipse |
| B. | dashed ellipse |
| C. | rectangle |
| D. | diamond |
| E. | None of these |
| Answer» E. None of these | |
| 25. |
In a relational database, a data structure that organises the information about a single topic into rows and columns, is [RBI PO 2011] |
| A. | block |
| B. | record |
| C. | tuple |
| D. | table |
| E. | None of these |
| Answer» E. None of these | |
| 26. |
A collection of related files is called a [SBI PO 2011] |
| A. | character |
| B. | field |
| C. | database |
| D. | record |
| E. | None of these |
| Answer» E. None of these | |
| 27. |
Key to represent relationship between tables is called [SBI Clerk 2010] |
| A. | primary key |
| B. | secondary key |
| C. | foreign key |
| D. | composite key |
| E. | None of these |
| Answer» D. composite key | |
| 28. |
The database administrator's function in an organization is[SBI PO 2010] |
| A. | to be responsible for the technical aspects of managing the information contained in organizational 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 | |
| 29. |
The cardinality property of a relation, refers to the |
| A. | number of database |
| B. | number of columns |
| C. | number of rows |
| D. | number of tables |
| E. | None of these |
| Answer» D. number of tables | |
| 30. |
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 | |
| 31. |
The code that relational database management systems use to perform their database task is referred to as |
| A. | QBE |
| B. | SQL |
| C. | OLAP |
| D. | Sequel Server |
| E. | None of these |
| Answer» C. OLAP | |
| 32. |
In case of entity integrity, the primary key may be |
| A. | not null |
| B. | null |
| C. | Both a and b |
| D. | any value |
| E. | None of these |
| Answer» B. null | |
| 33. |
In an ER diagram, attributes are represented by |
| A. | rectangle |
| B. | square |
| C. | ellipse |
| D. | triangle |
| E. | circle |
| Answer» D. triangle | |
| 34. |
Architecture of database can be viewed as |
| A. | two levels |
| B. | four levels |
| C. | three levels |
| D. | one level |
| E. | None of these |
| Answer» D. one level | |