Latest Banking jobs   »   IT Officer Quiz on DBMS

IT Officer Quiz on DBMS



00:00:00



1. A subset of data in a data warehouse in the form of summary data, related to a particular department or business function:

Meta Data
Archive data
Operational Data Store
Data Marts
All of the above


2. A scheme describe :

Data Elements
Record and files
Record relationship
all of the above
none of the above


3. The collection of information stored in a database at a particular moment is?

Instance
View
Scheme
All of the above
None of the above

4. Tuple in relational algebra refers to:

table
relation
column
row
None of these

5. A logical schema

Describes how data is actually stored on disk.
is the entire Database
is a standard way of organizing information into accessible parts.
all of the above
None of the above

6. ................. clause is an additional filter that is applied to the result.

order by
group by
select
Having
None of the above

7. Which one is a DCL command?

drop
call
revoke
pop
select

8. The tables generated on compilation of data definition language are stored in?

Data dictionary
Data abstraction
Data File
Data meta
All of the mentioned

9. The distinguishable parts of a record are called :

Field
Files
Data
All of the above
None of these


10. ...........Command extracts data from a database?

open
select
get
extract
None of these

                                       




Leave a comment

Your email address will not be published. Required fields are marked *