On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 17

Q1 | What is bytecode?
  • machine-specific code
  • java code
  • machine-independent code
  • none of the mentioned
Q2 | Where is metadata stored in MySQL?
  • in the mysql database metadata
  • in the mysql database metasql
  • in the mysql database mysql
  • none of the mentioned
Q3 | Which of the following is true for Seeheim model?
  • presentation is abstracted from dialogue and application
  • presentation and dialogue is abstracted from application
  • presentation and application is abstracted from dialogue
  • none of the mentioned
Q4 | Which of the unit operation is used in Model view controller?
  • is a decomposition
  • part whole decomposition
  • all of the mentioned
  • none of the mentioned
Q5 | Memory address refers to the successive memory words and the machine is called as
  • word addressable
  • byte addressable
  • bit addressable
  • terra byte addressable
Q6 | The                            layer, which provides a high-level view of data and actions on data.
  • business logic
  • presentation
  • user interaction
  • data access
Q7 | The                              layer, which provides the interface between the business-logic layer and the underlying database.
  • business logic
  • presentation
  • user interaction
  • data access
Q8 | The                            system is widely used for mapping from Java objects to relations.
  • hibernate
  • object oriented
  • objective
  • none of the mentioned
Q9 | Which among the following are the functions that any system with a user interface must provide?
  • presentation
  • dialogue
  • all of the mentioned
  • none of the mentioned
Q10 | Which of the following is the main task accomplished by the user?
  • compose a document
  • create a spread sheet
  • send mail
  • all of the mentioned
Q11 | What are the portability concerns founded in Seeheim model?
  • replacing the presentation toolkit
  • replacing the application toolkit
  • replacing the dialogue toolkit
  • replacing the presentation & application toolkit
Q12 | Which schema object instructs Oracle to connect to a remotely access an object of a database?
  • sequence
  • remote link
  • database link
  • data link
Q13 | DML changes are
  • insert
  • update
  • create
  • both insert and update
Q14 | Which of the following object types below cannot be replicated?
  • data
  • trigger
  • view
  • sequence
Q15 | How to force a log switch?
  • by using alter system log
  • by using alter system switch logfile
  • by using alter system switch logs
  • by using alter sys logfiles
Q16 | The ORDER BY clause can only be used in
  • select queries
  • insert queries
  • group by queries
  • having queries
Q17 | Which of the following rule below are categories of an index?
  • column and functional
  • multiple column and functional
  • column, multiple column and functional
  • none of the mentioned
Q18 | Which of the following queries are legal?
  • select deptno, count(deptno) from emp group by ename;
  • select deptno, count(deptno), job from emp group by deptno;
  • select deptno, avg(sal) from emp;
  • select deptno, avg(sal) from emp group by deptno;
Q19 | Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500?
  • select job, sum(sal) from emp where sum(sal) > 2500 and comm is null;
  • select job, sum(sal) from emp where comm is null group by job having sum(sal) > 2500;
  • select job, sum(sal) from emp where sum(sal) > 2500 and comm is null group by job;
  • select job, sum(sal) from emp group by job having sum(sal) > 2500 and comm is not null;
Q20 | Which of the following data structure is not linear data structure?
  • arrays
  • linked lists
  • arrays & linked lists
  • none of the mentioned
Q21 | Which of the following data structure is linear data structure?
  • trees
  • graphs
  • arrays
  • none of the mentioned
Q22 | The operation of processing each element in the list is known as
  • sorting
  • merging
  • inserting
  • traversal
Q23 | Finding the location of the element with a given value is:
  • traversal
  • search
  • sort
  • none of the mentioned
Q24 | Arrays are best data structures
  • for relatively permanent collections of data
  • for the size of the structure and the data in the structure are constantly changing
  • all of the mentioned
  • none of the mentioned
Q25 | Linked lists are best suited
  • for relatively permanent collections of data
  • for the size of the structure and the data in the structure are constantly changing
  • all of the mentioned
  • none of the mentioned