1 |
Which of the following file is used to store additional copy of data? |
Master file
Transaction file
Backup file
None
|
2 |
Which file is used to store information that remains constant for a long time? |
Master file
Transaction file
Backup file
None
|
3 |
The type of files from functional point of view include: |
Program file
Data file
a and b
None of these
|
4 |
The type of files from usage point of view include: |
Master file
Transaction file
Backup file
All
|
5 |
SQL can be used to: |
Create database structures only
Query database only
Modify database data only
All
|
6 |
SQL stands for: |
Sort Query Language
Self Query language
Seek Query language
Structured Query Language
|
7 |
SQL is a(n): |
Unstructured language
Structured language
Object oriented language
Software
|
8 |
Which of the following may be a temporary file? |
Master file
Transaction file
Back up file
None
|
9 |
Which of the following type of file require largest processing time? |
Sequential file
Random file
Indexed sequential file
Direct access file
|
10 |
Which of the following represents a collection of concepts that are used to describe the structure of a database: |
Data warehouse
Data model
Data structure
Data type
|
11 |
Which of the following is an example of a database? |
Liberary management system
Accounts & inventory system
College management system
All
|
12 |
A set of related created and managed by a (DBMS) is called: |
Field
Record
Database
Module
|
13 |
Which of the following is also known as data set? |
Record
Field
File
Module
|
14 |
A database containing all students in a class would store the information of individual students in: |
Record
Field
Cell
File
|
15 |
A database containing all students in a class would store basic data of students in: |
Record
Field
Cell
File
|
16 |
A field is to a record as: |
Data are to files
A column is to a row
Files are to tables
Attributes are to columns
|
17 |
A logical grouping of characters is a: |
Field
Record
File
All
|