Database Management System (DBMS) MCQs with answers Page - 69

Here, you will find a collection of MCQ questions on Database Management System (DBMS). Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 833.24K Points
Coach

Q. Which of the following is the main task accomplished by the user?

  • (A) compose a document
  • (B) create a spread sheet
  • (C) send mail
  • (D) all of the mentioned

A

Admin • 833.24K Points
Coach

Q. What are the portability concerns founded in Seeheim model?

  • (A) replacing the presentation toolkit
  • (B) replacing the application toolkit
  • (C) replacing the dialogue toolkit
  • (D) replacing the presentation & application toolkit

A

Admin • 833.24K Points
Coach

Q. Which schema object instructs Oracle to connect to a remotely access an object of a database?

  • (A) sequence
  • (B) remote link
  • (C) database link
  • (D) data link

A

Admin • 833.24K Points
Coach

Q. DML changes are

  • (A) insert
  • (B) update
  • (C) create
  • (D) both insert and update

A

Admin • 833.24K Points
Coach

Q. Which of the following object types below cannot be replicated?

  • (A) data
  • (B) trigger
  • (C) view
  • (D) sequence

A

Admin • 833.24K Points
Coach

Q. How to force a log switch?

  • (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

Admin • 833.24K Points
Coach

Q. The ORDER BY clause can only be used in

  • (A) select queries
  • (B) insert queries
  • (C) group by queries
  • (D) having queries

A

Admin • 833.24K Points
Coach

Q. Which of the following rule below are categories of an index?

  • (A) column and functional
  • (B) multiple column and functional
  • (C) column, multiple column and functional
  • (D) none of the mentioned

A

Admin • 833.24K Points
Coach

Q. Which of the following queries are legal?

  • (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

Admin • 833.24K Points
Coach

Q. is increasingly being used in server systems to improve performance by caching frequently used data, since it provides faster access than disk, with larger storage capacity than main memory.

  • (A) flash memory
  • (B) disk
  • (C) main memory
  • (D) secondary memory

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.