Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer

a. presentation

b. dialogue

c. all of the mentioned

d. none of the mentioned

a. compose a document

b. create a spread sheet

c. send mail

d. all of the mentioned

a. replacing the presentation toolkit

b. replacing the application toolkit

c. replacing the dialogue toolkit

d. replacing the presentation & application toolkit

a. sequence

b. remote link

c. database link

d. data link

a. insert

b. update

c. create

d. both insert and update

a. data

b. trigger

c. view

d. sequence

a. by using alter system log

b. by using alter system switch logfile

c. by using alter system switch logs

d. by using alter sys logfiles

a. select queries

b. insert queries

c. group by queries

d. having queries

a. column and functional

b. multiple column and functional

c. column, multiple column and functional

d. none of the mentioned

a. select deptno, count(deptno) from emp group by ename;

b. select deptno, count(deptno), job from emp group by deptno;

c. select deptno, avg(sal) from emp;

d. select deptno, avg(sal) from emp group by deptno;

a. select job, sum(sal) from emp where sum(sal) > 2500 and comm is null;

b. select job, sum(sal) from emp where comm is null group by job having sum(sal) > 2500;

c. select job, sum(sal) from emp where sum(sal) > 2500 and comm is null group by job;

d. select job, sum(sal) from emp group by job having sum(sal) > 2500 and comm is not null;

a. arrays

b. linked lists

c. arrays & linked lists

d. none of the mentioned

a. trees

b. graphs

c. arrays

d. none of the mentioned

a. sorting

b. merging

c. inserting

d. traversal

a. traversal

b. search

c. sort

d. none of the mentioned