Banking Computers Science Database Concepts Question Bank

done Database Concepts Total Questions - 64

• 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