Banking Computers Science Database Concepts Sample Paper

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

1)

A field that uniquely identifies which person, thing, or event the record describes is a______.

A)

File

B)

       data

C)

Field

D)

key

E)

None of these

View Answer
2)

The ability to find an individual item in a file immediately -

A)

Sequential access

B)

File allocation table

C)

Direct access

D)

Directory

E)

None of these

View Answer
3)

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 these

View Answer
4)

Files are organised by storing them in

A)

Tables

B)

databases

C)

Folders

D)

graphs

E)

None of these

View Answer
5)

A collection of unprocessed items is ______.

A)

Information

B)

data

C)

Memory

D)

reports

E)

None of these

View Answer
6)

Example of non-numeric data is

A)

Employee address

B)

Examination score

C)

Bank balance

D)

All of these

E)

None of these

View Answer
7)

Periodically adding, changing and deleting file records is called file

A)

Updating

B)

upgrading

C)

Restructuring

D)

renewing

E)

None of these

View Answer
8)

Which of the Following statements best describes the batch method of input?

A)

Data is processed as soon as it is input

B)

Data is input at the time it is collected

C)

Data is collected in the form of source documents, placed into groups, and then input to the computer

D)

Source documents are not used

E)

None of these

View Answer
9)

_______ represents raw facts, whereas ________ is data made meaningful.

A)

Information, reporting

B)

Data, information

C)

Information, bits

D)

Records, bytes

E)

None of these

View Answer
10)

An ad hoc query is a ________.

A)

Pre-planned question

B)

Pre-scheduled question

C)

Spur-of-the-moment question

D)

Question that will not return any results

E)

None of these

View Answer
11)

A telephone number, a birth date, and a customer name are all examples of

A)

a record

B)

data

C)

a file

D)

a database

E)

None of these

View Answer
12)

A collection of interrelated files, in a computer is a ______.

A)

File manager

B)

field

C)

Record

D)

database

E)

None of these

View Answer
13)

Collecting personal information and effectively posing as another individual is known as the crime of_______.

A)

Spooling

B)

identity theft

C)

Spoofing

D)

hacking

E)

None of these

View Answer
14)

The first step in the transaction processing cycle is _______.

A)

Database operations

B)

audit

C)

Data entry

D)

user inquiry

E)

None of these

View Answer
15)

A tuple is a

A)

column of a table

B)

Two-dimensional table

C)

Row of a table

D)

Key of a table

E)

None of these

View Answer
16)

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

B)

Queuing method

C)

Predetermined method

D)

Sequential access method

E)

None of these

View Answer
17)

Numbers in table columns are usually

A)

right-aligned

B)

left-aligned

C)

Justified

D)

centered

E)

None of these

View Answer
18)

The simultaneous execution of two or more instructions is called

A)

Sequential access

B)

Reduced instruction set computing

C)

Multiprocessing

D)

Disk mirroring

E)

None of these

View Answer
19)

A collection of interrelated records is called a

A)

Management information system

B)

Spreadsheet

C)

Database

D)

Text file

E)

None of these

View Answer
20)

How many options does a binary choice offer?

A)

One

B)

Two

C)

Three

D)

It depends on the amount of memory in the computer

E)

None of the above

View Answer
21)

The name of the location of a particular piece of data is its ________.

A)

Address

B)

memory name

C)

Storage site

D)

data location

E)

None of the above

View Answer
22)

A Field is a related group of________.

A)

Records

B)

Files

C)

Characters

D)

Cables

E)

None of the above

View Answer
23)

A prescribed set of well-defined instructions for solving mathematical problems is called

A)

a compiler

B)

a code

C)

a description

D)

an algorithm

E)

None of the above

View Answer
24)

A record is related to a file as a statement is related to a ________.

A)

Procedure

B)

file

C)

Program

D)

data

E)

None of the above

View Answer
25)

Meaningful filename helps in easy file ____.

A)

Storing

B)

Accessing

C)

Identification

D)

Printing

E)

None of the above

View Answer
26)

You organise files by storing them in

A)

Archives

B)

folders

C)

Indexes

D)

lists

E)

None of these

View Answer
27)

Distributed processing involves

A)

Solving computer component problems from a different computer

B)

Solving computing problems by breaking them into smaller parts that are separately processed by different computers

C)

Allowing users to share files on a network

D)

Allowing users to access network resources away from the office

E)

None of these

View Answer
28)

When data changes in multiple lists and all lists are not updated, this causes

A)

Data redundancy

B)

Information overload

C)

Duplicate data

D)

Data inconsistency

E)

Data repetition

View Answer
29)

The issues that deals with the collection and use of data about individuals is

A)

Access

B)

publicity

C)

Accuracy

D)

property

E)

Privacy

View Answer
30)

Participants can see and hear each other in a/an

A)

Electronic mail system

B)

Message system

C)

Teleconference

D)

Bulletin board

E)

None of these

View Answer
31)

How do businesses protect their databases?

A)

Security guards are hired to watch the databases at all times.

B)

Databases are protected by file swapping.

C)

Databases are naturally protected.

D)

Databases are kept physically and electronically secure.

E)

The computer room is kept locked after office hours.

View Answer
32)

The path of creation of an executable is

A)

Coding, linking, compiling, parsing

B)

Coding, parsing, compiling, linking.

C)

Coding, compiling, parsing, linking

D)

Coding, compiling, linking, parsing.

E)

Coding, parsing, linking, compiling

View Answer
33)

_______ increase the accuracy of a search by fine-tuning the keywords in the search.

A)

Indexes

B)

Italics

C)

Compounds

D)

Links

E)

Operators

View Answer
34)

The main purpose(s) of a database management program is to

A)

Allow users to retrieve and analyze stored records.

B)

Provide a way to store information about specified entities.

C)

Make it possible for users to store information as interrelated records.

D)

Translate hard-to-read data into more legible formats.

E)

a, b, and c above

View Answer
35)

Files are organised by storing them in

A)

Tables

B)

databases

C)

Folders

D)

graphs

E)

Diagrams

View Answer
36)

Which of the following contains permanent data and gets updated during the processing of transactions?

A)

Operating System File

B)

Transaction file

C)

Software File

D)

Master file

E)

None of these

View Answer
37)

The DBMS acts as an interface between what two components of an enterprise-class database system?

A)

Database application and the database

B)

Data and the database

C)

The user and the database application

D)

Database application and SQL

E)

None of these

View Answer
38)

The following are components of a database except _____.

A)

User data

B)

metadata

C)

Reports

D)

indexes

E)

None of these

View Answer
39)

An application where only one user accesses the database at a given time is an example of a (n) ______.

A)

single-user database application

B)

Multiuser database application

C)

e-commerce database application

D)

Data mining database application

E)

None of these

View Answer
40)

A DBMS that combines a DBMS and an application generator is ______.

A)

Microsoft's SQL Server

B)

Microsoft's Access

C)

IBM's DB2

D)

Oracle Corporation's Oracle

E)

None of these

View Answer
41)

The DBMS that is most difficult to use

A)

Microsoft's SQL Server

B)

Microsoft's Access

C)

IBM's DB2

D)

Oracle Corporation's Oracle

E)

None of these

View Answer
42)

In order to understand DBMS, it is important to understand?

A)

The physical schema

B)

All sub schema that are system support

C)

One sub schema

D)

Both [a] and [b]

E)

On demand report

View Answer
43)

Databases overall structure is maintained m a file called

A)

Redolog file

B)

            Data file

C)

Control file

D)

all of the above

E)

None of these

View Answer
44)

E-R modeling technique is a

A)

top-down approach

B)

bottom-up approach

C)

left-right approach

D)

Both top-down and bottom-up

E)

None of these

View Answer
45)

Data independency in DBMS is known as

A)

Data modeling

B)

Data hiding

C)

Data capturing

D)

Data consistency

E)

None of these

View Answer
46)

A data dictionary doesn't provide information about

A)

Where data is located

B)

The size of the disk storage disk

C)

Who owns or is responsible for the data

D)

How the data is used

E)

None of these

View Answer
47)

The database administrator is, in effect, the coordinator between the ___ and the________.

A)

DBMS; database

B)

Application program; database

C)

Database, users

D)

Application programs; users

E)

None of these

View Answer
48)

What does the data dictionary identify?

A)

Fieldnames

B)

Field types

C)

Field formats

D)

All of the above

E)

None of these

View Answer
49)

Which is one function of a database management system (DBMS)?

A)

Ensuring usability

B)

Identifying what a user needs

C)

Deciding what to do with legacy systems

D)

Preventing errors arising, while enabling multiple, simultaneous users

E)

None of these

View Answer
50)

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.

B)

For any two tuples, the values associated with all of their attributes may be the same.

C)

For any two tuples, the value associated with one or more of their attributes must differ.

D)

All tuples in particular relation may have different attributes.

E)

None of these

View Answer

Banking Computers Science Database Concepts Sample Paper

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

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