MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 2205 Mcqs, each offering curated multiple-choice questions to sharpen your Banking And Financial Awareness knowledge and support exam preparation. Choose a topic below to get started.
| 1151. |
Which of the following computer languages is appropriate for commercial purpose? |
| A. | Fortran |
| B. | Basic |
| C. | Cobol |
| D. | Pascal |
| E. | None of these |
| Answer» D. Pascal | |
| 1152. |
Computer language FORTRAN is appropriate for......... |
| A. | Business |
| B. | Graphic |
| C. | Science |
| D. | Commercial |
| E. | None of these |
| Answer» D. Commercial | |
| 1153. |
Computer language Cobol is appropriate for - |
| A. | Commercial Purpose |
| B. | Graphic Purpose |
| C. | Scientific Purpose |
| D. | All |
| E. | None of these |
| Answer» B. Graphic Purpose | |
| 1154. |
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 | |
| 1155. |
Which of the following statements is true? [IBPS Clerk 2015] |
| A. | Logical design is software dependent. |
| B. | In a distributed database, database is stored in one physical location |
| C. | Conceptual design translates the logical design into internal model. |
| D. | Logical design is software independent. |
| E. | None of the above |
| Answer» F. | |
| 1156. |
Which of the following will not eliminate the ambiguities of a null value? [IBPS Clerk 2015] |
| 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 | |
| 1157. |
A range checks [IBPS Clerk 2015] |
| 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 | |
| 1158. |
Items such as names and addresses are considered as |
| A. | input |
| B. | data |
| C. | output |
| D. | records |
| E. | information |
| Answer» B. data | |
| 1159. |
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 | |
| 1160. |
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 | |
| 1161. |
Oracle is a (n) [IBPS Clerk 2014] |
| A. | hardware |
| B. | high level language |
| C. | operating system |
| D. | system software |
| E. | RDBMS |
| Answer» F. | |
| 1162. |
A field is a related group of.......... [IBPS Clerk 2013] |
| A. | cables |
| B. | records |
| C. | files |
| D. | characters |
| E. | None of these |
| Answer» C. files | |
| 1163. |
Which name is suitable to run a macro at starting time of database? [RBI Grade B 2014] |
| A. | Start, exe |
| B. | Auto.exec |
| C. | Mocro.exe |
| D. | Any of these |
| E. | None of these |
| Answer» E. None of these | |
| 1164. |
......... 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 | |
| 1165. |
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 | |
| 1166. |
Periodically adding, changing and deleting file records is called ......... file. |
| A. | updating |
| B. | upgrading |
| C. | restructuring |
| D. | renewing |
| E. | None of these |
| Answer» B. upgrading | |
| 1167. |
Dr. E F Codd represented .......... rules that a database must obey if it has to be considered truly relational. [IBPS Clerk 2012] |
| A. | 10 |
| B. | 8 |
| C. | 12 |
| D. | 6 |
| E. | 5 |
| Answer» D. 6 | |
| 1168. |
......... is one reason for problems of data integrity. [IBPS Clerk 2012] |
| A. | Data availability constraints |
| B. | Data inconsistency |
| C. | Security constraints |
| D. | Unauthorised access of data |
| E. | Data redundancy |
| Answer» B. Data inconsistency | |
| 1169. |
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 | |
| 1170. |
The primary key must be |
| A. | numeric |
| B. | unique |
| C. | multiple |
| D. | related |
| E. | object |
| Answer» C. multiple | |
| 1171. |
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 | |
| 1172. |
An entity set that does not have sufficient attributes to form a primary key, is a [IBPS Clerk 2011] |
| 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 | |
| 1173. |
A computer checks the ...... of username and password for a match before granting access. [SBI Clerk 2011] |
| A. | Website |
| B. | network |
| C. | backup file |
| D. | database |
| E. | None of these |
| Answer» E. None of these | |
| 1174. |
An E-R diagram is a graphic method of presenting [IBPS Clerk 2011] |
| 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 | |
| 1175. |
In the relational modes, cardinality is termed as [IBPS Clerk 2011] |
| A. | number of tuples |
| B. | number of attributes |
| C. | number of tables |
| D. | number of constraints |
| E. | None of the above |
| Answer» B. number of attributes | |
| 1176. |
A logical schema [SBI PO 2011] |
| A. | is the entire database |
| B. | is a standard way of organising information into accessable part |
| C. | describes how data is actually stored on disk |
| D. | All of the above |
| E. | None of the above |
| Answer» C. describes how data is actually stored on disk | |
| 1177. |
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 | |
| 1178. |
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 | |
| 1179. |
The database stores information in [SBI PO 2010] |
| A. | rows and columns |
| B. | blocks |
| C. | tracks and sectors |
| D. | All of these |
| E. | None of these |
| Answer» B. blocks | |
| 1180. |
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 | |
| 1181. |
A program that generally has more user-friendly interface than a DBMS is called a |
| A. | front end |
| B. | repository |
| C. | back end |
| D. | form |
| E. | None of these |
| Answer» E. None of these | |
| 1182. |
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 | |
| 1183. |
......... means that the data contained in a database is accurate and reliable. |
| A. | Data redundancy |
| B. | Data integrity |
| C. | Data reliability |
| D. | Data consistency |
| E. | None of these |
| Answer» C. Data reliability | |
| 1184. |
The smallest unit of information about a record in a database is called a |
| A. | cell |
| B. | field |
| C. | record |
| D. | query |
| E. | None of these |
| Answer» C. record | |
| 1185. |
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 | |
| 1186. |
A set of possible data values is called |
| A. | attribute |
| B. | degree |
| C. | tuple |
| D. | domain |
| E. | None of these |
| Answer» E. None of these | |
| 1187. |
DBMS helps to achieve |
| A. | data independence |
| B. | centralised control of data |
| C. | selection of data |
| D. | Both a and b |
| E. | None of the above |
| Answer» E. None of the above | |
| 1188. |
A database that contains tables linked by common fields is called a |
| A. | centralised database |
| B. | flat file database |
| C. | relational database |
| D. | All of these |
| E. | None of these |
| Answer» D. All of these | |
| 1189. |
An advantage of the database management approach is |
| A. | data is dependent on programs |
| B. | data redundancy increases |
| C. | data is integrated and can be accessed by multiple programs |
| D. | All of the above |
| E. | None of the above |
| Answer» D. All of the above | |
| 1190. |
In an ER diagram, an entity set is represented by a |
| A. | rectangle |
| B. | ellipse |
| C. | diamond box |
| D. | circle |
| E. | None of these |
| Answer» B. ellipse | |
| 1191. |
The primary key must be a (n)......... field. |
| A. | numeric |
| B. | object |
| C. | unique |
| D. | related |
| E. | None of these |
| Answer» D. related | |
| 1192. |
Which out of the following is not a DBMS software? |
| A. | dBASE |
| B. | FoxPro |
| C. | Oracle |
| D. | SyBase |
| E. | Database 2000 |
| Answer» F. | |
| 1193. |
The dBASE III Plus is mostly used for |
| A. | office automation |
| B. | database management problems |
| C. | scientific problems |
| D. | calculations only |
| E. | None of the above |
| Answer» D. calculations only | |
| 1194. |
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 | |
| 1195. |
Rows of a relation are called |
| A. | relation |
| B. | tuples |
| C. | data structure |
| D. | an entity |
| E. | None of these |
| Answer» C. data structure | |
| 1196. |
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 | |
| 1197. |
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 | |
| 1198. |
DBMS is 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 | |
| 1199. |
Devices that could be used to input data into a database are |
| A. | keyboard, fax roller ball |
| B. | mouse, keyboard, monitor |
| C. | mouse, keyboard, touch screen |
| D. | All of the above |
| E. | None of the above |
| Answer» D. All of the above | |
| 1200. |
Which of the following is octal number equivalent to binary number (110101)2? |
| A. | 12 |
| B. | 65 |
| C. | 56 |
| D. | 1111 |
| E. | 00 |
| Answer» C. 56 | |