Database Management System Set 17
Computer Science Engineering (CSE),
Bachelor of Science in Computer Science FY (BSc CS),
Bachelor of Science in Computer Science SY (BSc CS),
Bachelor of Science in Information Technology SY (BSc IT),
Bachelor of Computer Applications (BCA),
Bachelor of Business Administration in Computer Applications (BBA [CA]),
Bachelor of Science in Information Technology (BSc IT),
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