DBMS MCQ-1

image_pdfimage_print

1)A set of programs that handle firm’s database responsibilities is called a
a)Database Management System(DBMS)
b)Database Processing System(DBPS)
c)Data Management System(DMS)
d)All of the above
e)None of these

2)Which of the following is used with database?
a)EDI
b)Credit card
c)ATM
d)Payment Gateway
e)Data mining

3)In Oracle, who owns the data dictionary?
a)Oracle
b)SYS
c)The DBA
d)System
e)None of these

4)The language used in application programs to request data from the DBMS is referred to as the
a)DML
b)DDL
c)Query Language
d)DCL
e)None of these

5)An indexing operation
a)Sorts a file using a single key
b)Sorts file using two keys
c)Establishes an index for a file
d)Both a and c
e)None of these

6)In SQL, which command is used to changes data in a data table?
a)Update
b)Insert
c)Browse
d)Append
e)None of these

7)An Oracle server index……..
a)Is a schema object
b)Is used to speed up the retrieval of rows by using a pointer
c)Is independent of the table it indexes
d)All of the above
e)None of these

8)Aggregation is special form of ……..
a)Object
b)Specialization
c)Generalization
d)Association
e)None of these

9)Which command is used to redefine a column of the table in SQL?
a)Alter Table
b)Modify Table
c)All of the Above
d)Define Table
e)None of these

10)Data mining evolve as a mechanism to cater the limitations of ……….system to deal massive data sets with high dimensionality, new data type, multiple heterogenous data resources etc.
a)OLTP
b)OLAP
c)DSS
d)DWH
e)None of these

Answers:
1)d
2)e
3)b
4)a
5)c
6)a
7)d
8)d
9)a
10)a