Database Management System Set 17

Learning Mode Previous Next

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-speciﬁc 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

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

Previous Next