Solved papers for Banking Computers Science Database Concepts Solved Paper - Database Managment System

done Solved Paper - Database Managment System Total Questions - 26

• question_answer1) Part number, part description, and number of parts ordered are examples of               [IBPS PO, 2011]
  A)
   Control
  done clear
  B)
   output
  done clear
  C)
   Processing        
  done clear
  D)
   feedback
  done clear
  E)
   Input
  done clear
  View Answer play_arrow

• question_answer2) Grouping and processing all of a firm's transactions at one time is called                                 [IBPS PO, 2011]
  A)
   A database management system
  done clear
  B)
   Batch processing
  done clear
  C)
   A real-time system
  done clear
  D)
   An on-line system
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer3) Forms that are used to organize business data into rows and columns are called _______.        [IBPS PO, 2012]
  A)
   Transaction sheets         
  done clear
  B)
   registers
  done clear
  C)
   Business forms
  done clear
  D)
          sheet-spreads
  done clear
  E)
   Spreadsheets
  done clear
  View Answer play_arrow

• question_answer4) What refers to a set of characters of a particular design?                                                                   [IBPS PO, 2012]
  A)
   Key face          
  done clear
  B)
   formation
  done clear
  C)
   Calligraphy
  done clear
  D)
   stencil
  done clear
  E)
   Typeface
  done clear
  View Answer play_arrow

• question_answer5) ______ is used by public and private enterprises to publish and share financial information with each other and industry analysts across all computer platforms and the Internet.                                           [IBPS PO, 2012]
  A)
   Extensible Markup Language (EML)
  done clear
  B)
   Extensible Business Reporting Language (XBRL)
  done clear
  C)
   Enterprise Application Integration (EAI)
  done clear
  D)
   Sales Force Automation (SFA) software
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer6) ROLLBACK in a database is _______ statement                                                                [IBPS Clerk, 2012]
  A)
   TCL                
  done clear
  B)
   DCL
  done clear
  C)
   DML               
  done clear
  D)
   DDL
  done clear
  E)
   SDL
  done clear
  View Answer play_arrow

• question_answer7) _____ provides total solutions to reduce data redundancy, inconsistency, dependence and unauthorized access of data                                                                                                                            [IBPS Clerk, 2012]
  A)
   DBMS           
  done clear
  B)
   Tables
  done clear
  C)
   Database
  done clear
  D)
   Protection passwords
  done clear
  E)
   Centralization of data
  done clear
  View Answer play_arrow

• question_answer8) ______ 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)
   Unauthorized access of data
  done clear
  E)
   Data redundancy
  done clear
  View Answer play_arrow

• question_answer9) 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 Answer play_arrow

• question_answer10) A data warehouse                                                                                                           [IBPS Clerk, 2012]
  A)
   Contains numerous naming conventions and formats
  done clear
  B)
   Is organized around important subject areas
  done clear
  C)
   Contains only current data
  done clear
  D)
   Can be updated by end users
  done clear
  E)
   Explains some observed event or conditiot
  done clear
  View Answer play_arrow

• question_answer11) Which of these is considered intelligent CASE tool                                                               [IBPS Clerk, 2012]
  A)
   Toolkit
  done clear
  B)
   Methodology companion
  done clear
  C)
   Workbench
  done clear
  D)
   Upper CASE
  done clear
  E)
   Lower CASE
  done clear
  View Answer play_arrow

• question_answer12) 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 Answer play_arrow

• question_answer13) _______ search method is conducted for a specific title, domain, URL, or host                        [IBPS Clerk, 2012]
  A)
   Keyword          
  done clear
  B)
   Field
  done clear
  C)
   Boolean           
  done clear
  D)
   Miscellaneous
  done clear
  E)
   Logical
  done clear
  View Answer play_arrow

• question_answer14) Attributes can be defined for                                                                                             [IBPS PO, 2013]
  A)
   Entity  
  done clear
  B)
   switchboard
  done clear
  C)
   Macro 
  done clear
  D)
   pages
  done clear
  E)
   None of the above
  done clear
  View Answer play_arrow

• question_answer15) Where will we find the referential integrity command?                                                           [IBPS PO, 2013]
  A)
   Tools   
  done clear
  B)
   View
  done clear
  C)
   Format
  done clear
  D)
   Table
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer16) Unlike filters queries can be saved as in a database.                                                             [IBPS PO, 2013]
  A)
   Objects
  done clear
  B)
   filters
  done clear
  C)
   Database         
  done clear
  D)
   Any of the above
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer17) What is a database?                                                                                                       [IBPS PO, 2013]
  A)
   It is a collection of data arranged in rows
  done clear
  B)
   It is a collection of data arranged in columns
  done clear
  C)
   It is a collection of data arranged in rows and columns
  done clear
  D)
   All of the above
  done clear
  E)
   None of the above
  done clear
  View Answer play_arrow

• question_answer18) External database is                                                                                                                    [IBPS PO, 2013]
  A)
   Database created in EXCEL
  done clear
  B)
   Database created using DBMS package
  done clear
  C)
   Database created in MS-Word
  done clear
  D)
   All of the above
  done clear
  E)
   None of the above
  done clear
  View Answer play_arrow

• question_answer19) Which command we will give if we want to show the database objects with its decription?         [IBPS PO, 2013]
  A)
   Details 
  done clear
  B)
   Show
  done clear
  C)
   List                 
  done clear
  D)
   Any of the above
  done clear
  E)
   None of the above
  done clear
  View Answer play_arrow

• question_answer20) The software that is used to create text-based- documents are referred to as ________.            [SBI PO, 2013]
  A)
   DBMS
  done clear
  B)
   Suites
  done clear
  C)
   Spreadsheets    
  done clear
  D)
          Presentation software
  done clear
  E)
   Word processors
  done clear
  View Answer play_arrow

• question_answer21) In database, a field is a                                                                                                    [SBI Clerk, 2014]
  A)
   Label
  done clear
  B)
   Table of information
  done clear
  C)
   Group of related records
  done clear
  D)
   Category of information
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer22) The particular field of a record that uniquely identifies each record is called the                        [SBI Clerk, 2014]
  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 Answer play_arrow

• question_answer23) Data in database at a particular point of time is called as?                                                    [SSC CGL, 2016]
  A)
   Intension          
  done clear
  B)
   Extension
  done clear
  C)
   Backup
  done clear
  D)
   Application
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer24) A relational database consists of a collection of                                                       [IBPS Clerk Mains, 2016]
  A)
   Tables 
  done clear
  B)
   Entities
  done clear
  C)
   Records
  done clear
  D)
   Keys
  done clear
  E)
   ROM
  done clear
  View Answer play_arrow

• question_answer25) Database ____ which is the logical design of the database, and the database _____ which is snapshot of the data in the database at given instant in time.                                                                           [IBPS Clerk Mains, 2016]
  A)
   Instance, Schema
  done clear
  B)
   Relation, Schema
  done clear
  C)
   Relation, Domain
  done clear
  D)
   Schema, Instance
  done clear
  E)
   Trees, Attributes
  done clear
  View Answer play_arrow

• question_answer26) Which of the following is the organized collection of large amount of interrelated data stored in a meaningfully way used for manipulation and updating?                                                                     [IBPS Clerk Mains, 2016]
  A)
   Database         
  done clear
  B)
   File
  done clear
  C)
   Folder  
  done clear
  D)
   Data-mining
  done clear
  E)
   Data source
  done clear
  View Answer play_arrow