Online Computer Science Test - Database Systems Test

Instruction:

This is a FREE online test. Beware of scammers who ask for money to attend this test.
Total number of questions: 20.
Time allotted: 30 minutes.
Each question carries 1 mark; there are no negative marks.
DO NOT refresh the page.
All the best!

If a calculation is embedded in a form

the result of the calculations are stored with the form

the calculations are stored with the form

the result of the calculations are printed in report

All of the above

None of the above

[#]

A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be

the pin code

the last name

a compound key consisting of the first name and the last name

All of the above

None of the above

[#]

A large computer information system maintains many different computer files. Which amongst them is called a perpetual file?

Specialized file

Log file

Master file

Update file

None of the above

[#]

In SQL, which command(s) is(are) used to enable/disable a database trigger?

MODIFY USER

CHANGE USER

ALTER TRIGGER

All of the above

None of the above

[#]

When you have finished entering information into a form

the template is written to the data file

the contents of the form are written to the data file

the contents of the form can be printed

All of the above

None of the above

[#]

A number of related records that are treated as a unit is called

file

field

data

batch

None of the above

[#]

In SQL, which command is used to add a column/integrity constraint to a table

ADD COLUMN

INSERT COLUMN

MODIFY TABLE

ALTER TABLE

None of the above

[#]

In the DBM approach, application programs perform the

storage function

processing functions

access control

All of the above

None of the above

[#]

Internal auditors should review data system design before they are

developed

implemented

modified

All of the above

None of the above

[#]

10.

An audit trail

is used to make back-up copies

is the recorded history of operations performed on a file

can be used to restore lost information

All of the above

None of the above

[#]

11.

A database management system might consist of application programs and a software package called

FORTRAN

AUTOFLOW

BPL

TOTAL

None of the above

[#]

12.

What name is given to the collection of facts, items of information or data which are related in some way?

Database

Directory information

Information tree

Information provider

None of the above

[#]

13.

The model for a _____ resembles the hierarchical model in many respects.

Network database

Relational database

Distributed database

Hierarchical database

None of the above

[#]

14.

Which language has recently become the de-facto standard for interfacing application programs with relational database system?

Oracle

SQL

dBASE

4GL

None of the above

[#]

15.

Which command is used to select distinct subject (SUB) from the table (BOOK)?

SELECT ALL FROM BOOK

SELECT DISTINCT SUB FROM BOOK

SELECT SUB FROM BOOK

All of the above

None of the above

[#]

16.

Versatile report generators can provide

Columnar totals

Subtotals

Calculations

All of the above

None of the above

[#]

17.

A report form

appears on the computer monitor during data entry

is used during report generation to format data

both (a) and (b)

All of the above

None of the above

[#]

18.

A file that is organized in uniform format is formally referred to as a _____ or a database file.

Document

Database

Record

Structured data file

None of the above

[#]

19.

It is more accurate to define a _____ as a variety of different record types that are treated as a single unit

Database

Table

Record

Flat File

None of the above

[#]

20.

Subschema can be used to

create very different, personalized views of the same data

present information in different formats

hide sensitive information by omitting fields from the subÂ¬schema's description

All of the above

None of the above

[#]

Quick links

Quantitative Aptitude

Verbal (English)

Reasoning

Programming

Interview

Placement Papers

Online Computer Science Test - Database Systems Test

Marks : 2/20

Test Review : View answers and explanation for this test.

Current Affairs

Interview Questions

Group Discussions