Database Management System Set 16

Database Management System

Questions 151 to 160


151.
A database management software (DBMS) includes
(a)
Automated tools (CASE) used to design databases and application programs
(b)
A software application that is used to define, create, maintain and provide controlled
access to user databases
(c)
Application programs that are used to provide information to users
(d)
Database that contains occurrences of logically organised data or information
(e)
Repository of meta data, which is a central storehouse for all data definitions, data relationships, screen and report formats and other system components.
152.
“In 1978 -----------(i)------------ committee proposed a generalized framework for 
 database systems and it provides a three-level architecture. 
The ---------(ii)-------------- of the architecture defines user views of the database.
 The ------------(iii)---------- defines the physical view of  the database.
 The ---------(iv)--------- defines the logical schema of the database.”
Which of the following sets is suitable to fill the blanks in the above paragraph?
(a)
i).    ANSI/ARPANET
ii).    Conceptual Level
iii).   External Level
iv).   Internal Level
(b)
i).    ANSI/SPARC
ii).    Conceptual Level
iii).   External Level
iv).   Internal Level
(c)
i).    ANSI/ARPANET
ii).    External Level
iii).   Internal Level
iv).   Conceptual Level
(d)
i).    ANSI/SPARC
ii).    External Level
iii).   Internal Level
iv).   Conceptual Level
(e)
i).    W3C
ii).    Internal Level
iii).   External Level
iv).   Conceptual Level.
153.
State the methodology for documenting databases illustrating the relationship
 between various entities in the database?
(a)
Data flow diagram
(b)
State transition diagram
(c)
Entity-relationship diagram
(d)
Entity sequence diagram
(e)
Object model.
154.
Which aggregate function is used to give the number of records present in a table?
(a)
MIN
(b)
COUNT
(c)
MAX
(d)
SUM
(e)
AVG.
155.
A Relational operator that yields all possible pairs of rows from two tables is known as a
(a)
Union
(b)
Intersect
(c)
Difference
(d)
Project
(e)
Product.
156.
How DBMS allows you to extrapolate information from your data?
(a)
Query language
(b)
Table generator
(c)
Security system
(d)
Access control
(e)
Modeling language.
157.
The following output is to be generated:

Fname
Minit
Ssn
Sex
Salary
SupperSsn
Dno
Sunil
Amila
Mahepala
T
S
K
334555
987615
668445
M
F
M
40000
43000
38000
88866
54321
33455
5
4
5
Which of the following would produce the above output?
(a)


Employee)
(Dno=4 AND Salary>30000) OR (Dno=5 AND Salary>30000)
(b)
(Employee)
(Ssn>30000) AND (Sex=’M’)
(c)
(Employee) 
     U       (Employee)
Fname,Minit,Ssn,Sex,SupperSsn,Dno                         Salary
(d)

(Employee)       U(Employee)
(Dno=4 AND Salary>30000)                                                      (Dno=5 AND Salary>30000)
(e)
                                         (Employee)                                     (Employee)
Fname,Minit,Ssn,Sex,SupperSsn,Dno                                                     Salary.
158.
The term used to identify a row of a table in the relational data model is
(a)
Cardinality
(b)
Data
(c)
Data set
(d)
+Tuple
(e)
Record.
159.
Consider the following Employee table.

Which of the following statements give the list of departments having average salary greater than 20000 from employee table?
(a)
SELECT Dept_No,AVG(Salary) FROM Employee ORDER BY Dept_No HAVING AVG(Salary)>20000
(b)
SELECT Dept_No,AVG(Salary) FROM Employee HAVING AVG(Salary)>20000
(c)
SELECT Dept_No,AVG(Salary) FROM Employee GROUP BY Dept_No HAVING AVG(Salary)>20000
(d)
SELECT Dept_No,AVG(Salary) FROM Employee WHERE AVG(Salary)>20000
(e)
SELECT Dept_No,AVG(Salary) FROM Employee GROUP BY Dept_No WHERE AVG(Salary)>20000.
160.
The following are the three language components of a database management system (DBMS).
I.     Data Definition Language (DDL).
II.     Sub-schema DDL.
III.    Data Manipulation Language.
Two different types of people (users and practioners) are concerned with them. Which of them do users of a DBMS usually deal with?
(a)
Only (I) above
(b)
Only (III) above
(c)
Both (I) and (II) above
(d)
Both (II) and (III) above
(e)
All (I), (II) and (III) above.

Answers



Answer
Reason
151.
b
A software application that is used to define, create, maintain 
and provide controlled access to user databases.
152.
d
i).ANSI/SPARC ii) External Level iii)Internal Level iv) Conceptual Level.
153.
c
ER diagram describes the relationships among the various entit
ies in the database.
154.
b
Count function gives the number of rows containing not null values 
for the given column.
155.
e
Product is the Relational operator that yields all possible pairs of 
row s from two tables.
156.
a
DBMS allows you to extrapolate information from your data using 
query language.
157.
c
Employee
UEmployee
Fname,Minit,Ssn,Sex,SupperSsn,Dno                         Salary
158.
d
In relational model the row of a table is called as tuple.
159.
c
SELECT Dept_No,AVG(Salary) FROM Employee GROUP BY Dept_No HAVING AVG(Salary)>20000.
160.
b
The users and practioners are concerned with only Data manipulation language component of DBMS.

<< Prev  1...  2...  3...  4...  5...  6...  7...  8...  9...  10...  11...  12...  13...  14...  15...  16...  17...  18...  19...  20...  21...  22...  23...  24...  25...  26...  27...  28...  29...  30...  31...  32...  33...  34...  35...  36...  Next >>


1 comment :