Banking Computers Science Database Concepts Sample Paper

done Sample Paper - Database Managment System Total Questions - 50    [Download]

• question_answer1)
  A field that uniquely identifies which person, thing, or event the record describes is a______.
  A)
   File     
  done clear
  B)
          data
  done clear
  C)
   Field                
  done clear
  D)
   key
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer2)
  The ability to find an individual item in a file immediately -
  A)
   Sequential access
  done clear
  B)
          File allocation table
  done clear
  C)
   Direct access
  done clear
  D)
   Directory
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer3)
  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 these
  done clear
  View Answer play_arrow

• question_answer4)
  Files are organised by storing them in
  A)
   Tables 
  done clear
  B)
   databases
  done clear
  C)
   Folders
  done clear
  D)
   graphs
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer5)
  A collection of unprocessed items is ______.
  A)
   Information      
  done clear
  B)
   data
  done clear
  C)
   Memory           
  done clear
  D)
   reports
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer6)
  Example of non-numeric data is
  A)
   Employee address
  done clear
  B)
   Examination score
  done clear
  C)
   Bank balance   
  done clear
  D)
   All of these
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

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

• question_answer8)
  Which of the Following statements best describes the batch method of input?
  A)
   Data is processed as soon as it is input
  done clear
  B)
   Data is input at the time it is collected
  done clear
  C)
   Data is collected in the form of source documents, placed into groups, and then input to the computer
  done clear
  D)
   Source documents are not used
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer9)
  _______ represents raw facts, whereas ________ is data made meaningful.
  A)
   Information, reporting    
  done clear
  B)
   Data, information
  done clear
  C)
   Information, bits
  done clear
  D)
   Records, bytes
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer10)
  An ad hoc query is a ________.
  A)
   Pre-planned question
  done clear
  B)
   Pre-scheduled question
  done clear
  C)
   Spur-of-the-moment question
  done clear
  D)
   Question that will not return any results
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer11)
  A telephone number, a birth date, and a customer name are all examples of
  A)
   a record           
  done clear
  B)
   data
  done clear
  C)
   a file               
  done clear
  D)
   a database
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer12)
  A collection of interrelated files, in a computer is a ______.
  A)
   File manager    
  done clear
  B)
   field
  done clear
  C)
   Record 
  done clear
  D)
   database
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer13)
  Collecting personal information and effectively posing as another individual is known as the crime of_______.
  A)
   Spooling          
  done clear
  B)
   identity theft
  done clear
  C)
   Spoofing          
  done clear
  D)
   hacking
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer14)
  The first step in the transaction processing cycle is _______.
  A)
   Database operations
  done clear
  B)
   audit
  done clear
  C)
   Data entry       
  done clear
  D)
   user inquiry
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer15)
  A tuple is a
  A)
   column of a table
  done clear
  B)
   Two-dimensional table
  done clear
  C)
   Row of a table
  done clear
  D)
   Key of a table
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer16)
  The method of file organization in which data records in a file are arranged in a specified order according to key filed is known as the
  A)
   Direct access method
  done clear
  B)
   Queuing method
  done clear
  C)
   Predetermined method
  done clear
  D)
   Sequential access method
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer17)
  Numbers in table columns are usually
  A)
   right-aligned
  done clear
  B)
   left-aligned
  done clear
  C)
   Justified           
  done clear
  D)
   centered
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer18)
  The simultaneous execution of two or more instructions is called
  A)
   Sequential access
  done clear
  B)
   Reduced instruction set computing
  done clear
  C)
   Multiprocessing
  done clear
  D)
   Disk mirroring
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer19)
  A collection of interrelated records is called a
  A)
   Management information system
  done clear
  B)
   Spreadsheet
  done clear
  C)
   Database
  done clear
  D)
   Text file
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer20)
  How many options does a binary choice offer?
  A)
   One
  done clear
  B)
   Two
  done clear
  C)
   Three
  done clear
  D)
   It depends on the amount of memory in the computer
  done clear
  E)
   None of the above
  done clear
  View Answer play_arrow

• question_answer21)
  The name of the location of a particular piece of data is its ________.
  A)
   Address
  done clear
  B)
   memory name
  done clear
  C)
   Storage site      
  done clear
  D)
   data location
  done clear
  E)
   None of the above
  done clear
  View Answer play_arrow

• question_answer22)
  A Field is a related group of________.
  A)
   Records
  done clear
  B)
   Files
  done clear
  C)
   Characters       
  done clear
  D)
   Cables
  done clear
  E)
   None of the above
  done clear
  View Answer play_arrow

• question_answer23)
  A prescribed set of well-defined instructions for solving mathematical problems is called
  A)
   a compiler        
  done clear
  B)
   a code
  done clear
  C)
   a description     
  done clear
  D)
   an algorithm
  done clear
  E)
   None of the above
  done clear
  View Answer play_arrow

• question_answer24)
  A record is related to a file as a statement is related to a ________.
  A)
   Procedure
  done clear
  B)
   file
  done clear
  C)
   Program          
  done clear
  D)
   data
  done clear
  E)
   None of the above
  done clear
  View Answer play_arrow

• question_answer25)
  Meaningful filename helps in easy file ____.
  A)
   Storing
  done clear
  B)
   Accessing
  done clear
  C)
   Identification    
  done clear
  D)
   Printing
  done clear
  E)
   None of the above
  done clear
  View Answer play_arrow

• question_answer26)
  You organise files by storing them in
  A)
   Archives          
  done clear
  B)
   folders
  done clear
  C)
   Indexes
  done clear
  D)
   lists
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer27)
  Distributed processing involves
  A)
   Solving computer component problems from a different computer
  done clear
  B)
   Solving computing problems by breaking them into smaller parts that are separately processed by different computers
  done clear
  C)
   Allowing users to share files on a network
  done clear
  D)
   Allowing users to access network resources away from the office
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer28)
  When data changes in multiple lists and all lists are not updated, this causes
  A)
   Data redundancy
  done clear
  B)
   Information overload
  done clear
  C)
   Duplicate data
  done clear
  D)
   Data inconsistency
  done clear
  E)
   Data repetition
  done clear
  View Answer play_arrow

• question_answer29)
  The issues that deals with the collection and use of data about individuals is
  A)
   Access
  done clear
  B)
   publicity
  done clear
  C)
   Accuracy         
  done clear
  D)
   property
  done clear
  E)
   Privacy
  done clear
  View Answer play_arrow

• question_answer30)
  Participants can see and hear each other in a/an
  A)
   Electronic mail system
  done clear
  B)
   Message system
  done clear
  C)
   Teleconference
  done clear
  D)
   Bulletin board
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer31)
  How do businesses protect their databases?
  A)
   Security guards are hired to watch the databases at all times.
  done clear
  B)
   Databases are protected by file swapping.
  done clear
  C)
   Databases are naturally protected.
  done clear
  D)
   Databases are kept physically and electronically secure.
  done clear
  E)
   The computer room is kept locked after office hours.
  done clear
  View Answer play_arrow

• question_answer32)
  The path of creation of an executable is
  A)
   Coding, linking, compiling, parsing
  done clear
  B)
   Coding, parsing, compiling, linking.
  done clear
  C)
   Coding, compiling, parsing, linking
  done clear
  D)
   Coding, compiling, linking, parsing.
  done clear
  E)
   Coding, parsing, linking, compiling
  done clear
  View Answer play_arrow

• question_answer33)
  _______ increase the accuracy of a search by fine-tuning the keywords in the search.
  A)
   Indexes
  done clear
  B)
   Italics
  done clear
  C)
   Compounds     
  done clear
  D)
   Links
  done clear
  E)
   Operators
  done clear
  View Answer play_arrow

• question_answer34)
  The main purpose(s) of a database management program is to
  A)
   Allow users to retrieve and analyze stored records.
  done clear
  B)
   Provide a way to store information about specified entities.
  done clear
  C)
   Make it possible for users to store information as interrelated records.
  done clear
  D)
   Translate hard-to-read data into more legible formats.
  done clear
  E)
   a, b, and c above
  done clear
  View Answer play_arrow

• question_answer35)
  Files are organised by storing them in
  A)
   Tables 
  done clear
  B)
   databases
  done clear
  C)
   Folders
  done clear
  D)
   graphs
  done clear
  E)
   Diagrams
  done clear
  View Answer play_arrow

• question_answer36)
  Which of the following contains permanent data and gets updated during the processing of transactions?
  A)
   Operating System File
  done clear
  B)
   Transaction file
  done clear
  C)
   Software File
  done clear
  D)
   Master file
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer37)
  The DBMS acts as an interface between what two components of an enterprise-class database system?
  A)
   Database application and the database
  done clear
  B)
   Data and the database
  done clear
  C)
   The user and the database application
  done clear
  D)
   Database application and SQL
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer38)
  The following are components of a database except _____.
  A)
   User data
  done clear
  B)
   metadata
  done clear
  C)
   Reports
  done clear
  D)
   indexes
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer39)
  An application where only one user accesses the database at a given time is an example of a (n) ______.
  A)
   single-user database application
  done clear
  B)
   Multiuser database application
  done clear
  C)
   e-commerce database application
  done clear
  D)
   Data mining database application
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer40)
  A DBMS that combines a DBMS and an application generator is ______.
  A)
   Microsoft's SQL Server
  done clear
  B)
   Microsoft's Access
  done clear
  C)
   IBM's DB2
  done clear
  D)
   Oracle Corporation's Oracle
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer41)
  The DBMS that is most difficult to use
  A)
   Microsoft's SQL Server
  done clear
  B)
   Microsoft's Access
  done clear
  C)
   IBM's DB2
  done clear
  D)
   Oracle Corporation's Oracle
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer42)
  In order to understand DBMS, it is important to understand?
  A)
   The physical schema
  done clear
  B)
   All sub schema that are system support
  done clear
  C)
   One sub schema
  done clear
  D)
   Both [a] and [b]
  done clear
  E)
   On demand report
  done clear
  View Answer play_arrow

• question_answer43)
  Databases overall structure is maintained m a file called
  A)
   Redolog file      
  done clear
  B)
               Data file
  done clear
  C)
   Control file       
  done clear
  D)
   all of the above
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer44)
  E-R modeling technique is a
  A)
   top-down approach
  done clear
  B)
   bottom-up approach
  done clear
  C)
   left-right approach
  done clear
  D)
   Both top-down and bottom-up
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer45)
  Data independency in DBMS is known as
  A)
   Data modeling
  done clear
  B)
   Data hiding
  done clear
  C)
   Data capturing
  done clear
  D)
   Data consistency
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer46)
  A data dictionary doesn't provide information  about
  A)
   Where data is located
  done clear
  B)
   The size of the disk storage disk
  done clear
  C)
   Who owns or is responsible for the data
  done clear
  D)
   How the data is used
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer47)
  The database administrator is, in effect, the coordinator between the ___ and the________.
  A)
   DBMS; database
  done clear
  B)
   Application program; database
  done clear
  C)
   Database, users
  done clear
  D)
   Application programs; users
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer48)
  What does the data dictionary identify?
  A)
   Fieldnames       
  done clear
  B)
   Field types
  done clear
  C)
   Field formats
  done clear
  D)
   All of the above
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer49)
  Which is one function of a database management system (DBMS)?
  A)
   Ensuring usability
  done clear
  B)
   Identifying what a user needs
  done clear
  C)
   Deciding what to do with legacy systems
  done clear
  D)
   Preventing errors arising, while enabling multiple, simultaneous users
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow

• question_answer50)
  A relation (from the relational database model) consists of a set of tuples, which implies that
  A)
   Relational model supports multi-valued attributes whose values can be represented in sets.
  done clear
  B)
   For any two tuples, the values associated with all of their attributes may be the same.
  done clear
  C)
   For any two tuples, the value associated with one or more of their attributes must differ.
  done clear
  D)
   All tuples in particular relation may have different attributes.
  done clear
  E)
   None of these
  done clear
  View Answer play_arrow