Banking Computers Database Concepts Question Bank

done Database Concepts

• question_answer1) Devices that could be used to input data into a database are

  A) keyboard, fax roller ball done clear

  B) mouse, keyboard, monitor done clear

  C) mouse, keyboard, touch screen done clear

  D) All of the above done clear

  E) None of the above done clear

  View Solution play_arrow

• question_answer2) DBMS is comprised of tables that made up of rows called ......... and columns called ......

  A)  fields, records                done clear

  B)  records, fields done clear

  C)  address, fields                done clear

  D)  ranges, sheet done clear

  E)  records, ranges done clear

  View Solution play_arrow

• question_answer3) A database that contains tables linked by common fields is called a

  A) centralised database done clear

  B) flat file database done clear

  C) relational database done clear

  D) All of these done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer4) Which of the following places the common data elements in order from smallest to largest?

  A) Character, File, Record, Field, Database done clear

  B) Character, Record, Field, File, Database done clear

  C) Character, Field, Record, File, Database done clear

  D) Bit, Byte, Character, Record, Field, File, Database done clear

  E) None of the above done clear

  View Solution play_arrow

• question_answer5) The primary key must be

  A) numeric done clear

  B) unique done clear

  C) multiple done clear

  D) related done clear

  E) object done clear

  View Solution play_arrow

• question_answer6) Periodically adding, changing and deleting file records is called ......... file.

  A) updating done clear

  B) upgrading done clear

  C) restructuring done clear

  D) renewing done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer7) Items such as names and addresses are considered as

  A) input done clear

  B) data done clear

  C) output done clear

  D) records done clear

  E) information done clear

  View Solution play_arrow

• question_answer8) Which of the following objects is/are contained in database?

  A) Table done clear

  B) Query done clear

  C) Form done clear

  D) All of these done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer9) A ......... is a collection of data that is stored electronically as a series of records in a table.

  A) spreadsheet done clear

  B) presentation done clear

  C) database done clear

  D) Web page done clear

  E) None of the above done clear

  View Solution play_arrow

• question_answer10) 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 done clear

  B) prime attribute done clear

  C) index key done clear

  D) primary key done clear

  E) null key done clear

  View Solution play_arrow

• question_answer11) Rows of a relation are called

  A) relation done clear

  B) tuples done clear

  C) data structure done clear

  D) an entity done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer12) Which of the following types of table constraints will prevent the entry of duplicate rows?

  A) Primary key done clear

  B) Unique done clear

  C) Null done clear

  D) Foreign key done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer13) The dBASE III Plus is mostly used for

  A) office automation done clear

  B) database management problems done clear

  C) scientific problems done clear

  D) calculations only done clear

  E) None of the above done clear

  View Solution play_arrow

• question_answer14) Which out of the following is not a DBMS software?

  A) dBASE done clear

  B) FoxPro done clear

  C) Oracle done clear

  D) SyBase done clear

  E) Database 2000 done clear

  View Solution play_arrow

• question_answer15) The primary key must be a (n)......... field.

  A) numeric done clear

  B) object done clear

  C) unique done clear

  D) related done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer16) Architecture of database can be viewed as

  A) two levels done clear

  B) four levels done clear

  C) three levels done clear

  D) one level done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer17) In an ER diagram, attributes are represented by

  A) rectangle done clear

  B) square done clear

  C) ellipse done clear

  D) triangle done clear

  E) circle done clear

  View Solution play_arrow

• question_answer18) In case of entity integrity, the primary key may be

  A) not null done clear

  B) null done clear

  C) Both a and b done clear

  D) any value done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer19) In an ER diagram, an entity set is represented by a

  A) rectangle done clear

  B) ellipse done clear

  C) diamond box done clear

  D) circle done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer20) An advantage of the database management approach is

  A) data is dependent on programs done clear

  B) data redundancy increases done clear

  C) data is integrated and can be accessed by multiple programs done clear

  D) All of the above done clear

  E) None of the above done clear

  View Solution play_arrow

• question_answer21) DBMS helps to achieve

  A) data independence done clear

  B) centralised control of data done clear

  C) selection of data done clear

  D) Both a and b done clear

  E) None of the above done clear

  View Solution play_arrow

• question_answer22) A set of possible data values is called

  A) attribute done clear

  B) degree done clear

  C) tuple done clear

  D) domain done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer23) Which type of database, organised the data in the form of tree with nodes?

  A) Network Database done clear

  B) Hierarchical Database done clear

  C) Relational Database done clear

  D) Multiple Database done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer24) The code that relational database management systems use to perform their database task is referred to as

  A) QBE done clear

  B) SQL done clear

  C) OLAP done clear

  D) Sequel Server done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer25) In which the database can be restored up to the last consistent state after the system failure?

  A) Backup done clear

  B) Recovery done clear

  C) Redundancy done clear

  D) Security done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer26) The cardinality property of a relation, refers to the

  A) number of database done clear

  B) number of columns done clear

  C) number of rows done clear

  D) number of tables done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer27) The smallest unit of information about a record in a database is called a

  A) cell done clear

  B) field done clear

  C) record done clear

  D) query done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer28) ......... means that the data contained in a database is accurate and reliable.

  A) Data redundancy done clear

  B) Data integrity done clear

  C) Data reliability done clear

  D) Data consistency done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer29) Which of the following contains information about a single 'entity' in the database like a person, place, event or thing?

  A) Query done clear

  B) Form done clear

  C) Record done clear

  D) Table done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer30) A program that generally has more user-friendly interface than a DBMS is called a

  A) front end done clear

  B) repository done clear

  C) back end done clear

  D) form done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer31) The database stores information in [SBI PO 2010]

  A) rows and columns done clear

  B) blocks done clear

  C) tracks and sectors done clear

  D) All of these done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer32) 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 done clear

  B) to be responsible for the executive level aspects of decision regarding the information management done clear

  C) to show the relationship among entity classes in a data warehouse done clear

  D) to define which data mining tools must be used to extract data done clear

  E) None of the above done clear

  View Solution play_arrow

• question_answer33) Key to represent relationship between tables is called [SBI Clerk 2010]

  A) primary key done clear

  B) secondary key done clear

  C) foreign key done clear

  D) composite key done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer34) A collection of related files is called a [SBI PO 2011]

  A) character done clear

  B) field done clear

  C) database done clear

  D) record done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer35) A logical schema [SBI PO 2011]

  A) is the entire database done clear

  B) is a standard way of organising information into accessable part done clear

  C) describes how data is actually stored on disk done clear

  D) All of the above done clear

  E) None of the above done clear

  View Solution play_arrow

• question_answer36) In the relational modes, cardinality is termed as [IBPS Clerk 2011]

  A) number of tuples done clear

  B) number of attributes done clear

  C) number of tables done clear

  D) number of constraints done clear

  E) None of the above done clear

  View Solution play_arrow

• question_answer37) An E-R diagram is a graphic method of presenting [IBPS Clerk 2011]

  A) primary keys and their relationships done clear

  B) primary keys and their relationships to instances done clear

  C) entity classes and their relationships done clear

  D) entity classes and their relationships to primary keys done clear

  E) None of the above done clear

  View Solution play_arrow

• question_answer38) A computer checks the ...... of username and password for a match before granting access. [SBI Clerk 2011]

  A) Website done clear

  B) network done clear

  C) backup file done clear

  D) database done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer39) An entity set that does not have sufficient attributes to form a primary key, is a [IBPS Clerk 2011]

  A) strong entity set done clear

  B) weak entity set done clear

  C) simple entity set done clear

  D) primary entity set done clear

  E) None of the above done clear

  View Solution play_arrow

• question_answer40) 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 done clear

  B) record done clear

  C) tuple done clear

  D) table done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer41) In ER diagram, relationship type is represented by [IBPS Clerk 2012]

  A) ellipse done clear

  B) dashed ellipse done clear

  C) rectangle done clear

  D) diamond done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer42) To locate a data item for storage is [IBPS PO 2012]

  A) field done clear

  B) feed done clear

  C) database done clear

  D) fetch done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer43) ......... are distinct items that don't have much meaning to you in a given context. [SBI PO 2012]

  A) Fields done clear

  B) Data done clear

  C) Queries done clear

  D) Properties done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer44) The particular field of a record that uniquely identifies each record is called the [SBI PO 2012]

  A) key field done clear

  B) primary field done clear

  C) master field done clear

  D) order field done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer45) ............ provides total solutions to reduce data redundancy, inconsistency, dependence and unauthorised access of data. [IBPS Clerk 2012]

  A) DBMS done clear

  B) Tables done clear

  C) Database done clear

  D) Protection password done clear

  E) Centralisation of data done clear

  View Solution play_arrow

• question_answer46) ......... is one reason for problems of data integrity. [IBPS Clerk 2012]

  A) Data availability constraints done clear

  B) Data inconsistency done clear

  C) Security constraints done clear

  D) Unauthorised access of data done clear

  E) Data redundancy done clear

  View Solution play_arrow

• question_answer47) Dr. E F Codd represented .......... rules that a database must obey if it has to be considered truly relational. [IBPS Clerk 2012]

  A) 10 done clear

  B) 8 done clear

  C) 12 done clear

  D) 6 done clear

  E) 5 done clear

  View Solution play_arrow

• question_answer48) A collection of conceptual tools for describing data, relationships, semantics and constraints is referred to as [IBPS Clerk 2012]

  A) ER model done clear

  B) database done clear

  C) data model done clear

  D) DBMS done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer49) What is the overall term for creating, editing, formatting, storing, retrieving a text document? [IBPS PO 2012]

  A) Word processing done clear

  B) Spreadsheet design done clear

  C) Web design done clear

  D) Database management done clear

  E) Presentation generation done clear

  View Solution play_arrow

• question_answer50) When data changes in multiple lists and all lists are not updated. This causes. [RBI Grade B 2012]

  A) Data redundancy done clear

  B) Information overload done clear

  C) Duplicate data done clear

  D) Data consistency done clear

  E) Data inconsistency done clear

  View Solution play_arrow

• question_answer51) A collection of interrelated records is called a [RBI Grade B 2012]

  A) utility file done clear

  B) management information system done clear

  C) database done clear

  D) spreadsheet done clear

  E) datasheet done clear

  View Solution play_arrow

• question_answer52) ......... is a primary key of one file that also appears in another file. [IBPS Clerk 2013]

  A) Physical key done clear

  B) Primary key done clear

  C) Foreign key done clear

  D) Logical key done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer53) ......... is an invalid type of database key. [IBPS Clerk 2013]

  A) Structured primary key done clear

  B) Atomic primary key done clear

  C) Primary key done clear

  D) Composite primary key done clear

  E) None of the above done clear

  View Solution play_arrow

• question_answer54) Which name is suitable to run a macro at starting time of database? [RBI Grade B 2014]

  A) Start, exe done clear

  B) Auto.exec done clear

  C) Mocro.exe done clear

  D) Any of these done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer55) A field is a related group of.......... [IBPS Clerk 2013]

  A) cables done clear

  B) records done clear

  C) files done clear

  D) characters done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer56) Oracle is a (n) [IBPS Clerk 2014]

  A) hardware done clear

  B) high level language done clear

  C) operating system done clear

  D) system software done clear

  E) RDBMS done clear

  View Solution play_arrow

• question_answer57) ......... 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 done clear

  B) RFID done clear

  C) PPS done clear

  D) GPS done clear

  E) Other than those given as options done clear

  View Solution play_arrow

• question_answer58) What is a stored question about information in a database? [SBI Clerk 2015]

  A) Query done clear

  B) Sort done clear

  C) Report done clear

  D) Record done clear

  E) Field done clear

  View Solution play_arrow

• question_answer59) Data duplication wastes the space, but also promotes a more serious problem called [IBPS PO 2015]

  A) isolated called done clear

  B) data inconsistency done clear

  C) other than those given as: options done clear

  D) program dependency done clear

  E) separated data done clear

  View Solution play_arrow

• question_answer60) The purpose of the primary key in a database is to [IBPS Clerk 2015]

  A) unlock the database done clear

  B) provide a map of the data done clear

  C) uniquely identity a record done clear

  D) establish constraints on database operations done clear

  E) None of the above done clear

  View Solution play_arrow

• question_answer61) 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 done clear

  B) Data table done clear

  C) Data record done clear

  D) Data field done clear

  E) None of these done clear

  View Solution play_arrow

• question_answer62) A range checks [IBPS Clerk 2015]

  A) that only the correct data type is entered into a field done clear

  B) that all required data are present done clear

  C) whether a number is within a specified limit done clear

  D) if the data in two or more associated fields is logical done clear

  E) None of the above done clear

  View Solution play_arrow

• question_answer63) Which of the following will not eliminate the ambiguities of a null value? [IBPS Clerk 2015]

  A) Define the attribute as required done clear

  B) Define subtypes done clear

  C) Define each attribute as having an initial value that is recognised as blank done clear

  D) Define super types done clear

  E) None of the above done clear

  View Solution play_arrow

• question_answer64) Which of the following statements is true? [IBPS Clerk 2015]

  A) Logical design is software dependent. done clear

  B) In a distributed database, database is stored in one physical location done clear

  C) Conceptual design translates the logical design into internal model. done clear

  D) Logical design is software independent. done clear

  E) None of the above done clear

  View Solution play_arrow