Solapur University Question Paper
P.G.D.C.A. (Semester – II) Examination, 2014
DBMS AND RDBMS USING ORACLE (Old) (Paper – VII)
Day and Date : Monday, 21-4-2014 Total Marks : 80
Time : 3.00 p.m. to 6.00 p.m.
Instructions : 1) Q. 1 and Q. 7 are compulsory.
2) Attempt any two questions from Q. No. 2, 3 and 4.
3) Attempt any one question from Q. No. 5 and 6.
4) Figures to the right indicate full marks.
1. A) Choose the single correct alternative : 16
1) _____________ is a process that helps analysts or database designers to
design table structures for an application.
a) SQL b) Sub-Query c) Normalization d) All of these
2) SQL starts with a _____________
a) Verb b) Adjective c) Noun d) Pronoun
3) _____________ is the area of SQL that allows changing data within the
database.
a) DDL b) DML c) DCL d) DQL
4) The unique column constraint permits multiple entries of NULL into the
column.
a) True b) False
5) The _____________ operator allows the selection of rows that contain
values within a specified lower and upper limit.
a) ** (Exponentiation) b) AND
c) OR d) BETWEEN
6) A _____________ is a form of an SQL statement that appears inside
another SQL statement.
a) PL/SQL b) Join c) View d) Sub-query
7) The PL/SQL code block starts with a _____________ section.
a) BEGIN b) START c) DECLARE d) None of these
8) IF ..... THEN .... ELSE .... END IF; is a valid iterative control structure in
PL/SQL.
a) True b) False
9) _____________ changes the flow of control within a PL/SQL block.
a) If .. Then .. else ... end if. b) While
c) Goto d) All of these
10) In PL/SQL, _____________ is valid assignment operator.
a) := b) = c) =: d) = =
11) In a cursor, _____________ statement moves the data held in the Active
Data Set into the memory variables.
a) Copy b) Open c) Move d) Fetch
12) Database triggers can be used to prevent invalid transactions.
a) True b) False
B) Suppose there is a table named CLIENT_MASTER exist on the disk. The
columns of the table are – clientno, name, address, city, pincode, state. 4
Write SQL statements for the following :
1) Change the city of clientno ‘C0005’ TO ‘Bangalore’.
2) List the names of all clients having ‘a’ as the second letter in their names.
3) List the clients who stay in a city whose first letter is ‘M’.
4) Add a column called TELEPHONE of data type ‘Number’ and size = 10 to
the CLIENT_MASTER table.
2. a) What is data ? How DBMS is differ from RDBMS ? 6
b) Who is oracle DBA ? Explain the responsibilities of oracle DBA. 6
c) Explain “Classification of SQL Commands”. 4
3. a) Explain group by and having clause with suitable example. 6
b) Explain any three aggregate functions with example of each. 6
c) What is the term privilege ? How will you give and take out privileges to other
users ? 4
SLR-R – 9 -2-
4. Write short notes on the following :
1) Normalization 4
2) Multiple sub-queries 4
3) Iterative Control Structures 4
4) Historical development of oracle. 4
5. a) Write a PL/SQL code to accept, calculate and store the details of employees
into the table EMPLOYEE. Columns of the table will be EMPNO, EMPNAME,
BASIC_SALARY, DA, HRA and NET_SALARY. Rules for DA. HRA etc.
calculation : 8
• DA should be 75% on BASIC_SALARY
• HRA should be 10% on BASIC_SALARY
• NET_SALARY = BASIC_SALARY + DA + HRA.
b) Why triggers are used ? Explain with suitable example. 8
6. a) Discuss on ‘Codd’s Rules. 8
b) Explain Explicit Cursor Management. 8
7. a) Discuss on “Integrity Constraints”. 8
b) Explain Like Operator, Between Operator, Where Clause and Order By clause. 8
_______________
P.G.D.C.A. (Semester – II) Examination, 2014
DBMS AND RDBMS USING ORACLE (Old) (Paper – VII)
Day and Date : Monday, 21-4-2014 Total Marks : 80
Time : 3.00 p.m. to 6.00 p.m.
Instructions : 1) Q. 1 and Q. 7 are compulsory.
2) Attempt any two questions from Q. No. 2, 3 and 4.
3) Attempt any one question from Q. No. 5 and 6.
4) Figures to the right indicate full marks.
1. A) Choose the single correct alternative : 16
1) _____________ is a process that helps analysts or database designers to
design table structures for an application.
a) SQL b) Sub-Query c) Normalization d) All of these
2) SQL starts with a _____________
a) Verb b) Adjective c) Noun d) Pronoun
3) _____________ is the area of SQL that allows changing data within the
database.
a) DDL b) DML c) DCL d) DQL
4) The unique column constraint permits multiple entries of NULL into the
column.
a) True b) False
5) The _____________ operator allows the selection of rows that contain
values within a specified lower and upper limit.
a) ** (Exponentiation) b) AND
c) OR d) BETWEEN
6) A _____________ is a form of an SQL statement that appears inside
another SQL statement.
a) PL/SQL b) Join c) View d) Sub-query
7) The PL/SQL code block starts with a _____________ section.
a) BEGIN b) START c) DECLARE d) None of these
8) IF ..... THEN .... ELSE .... END IF; is a valid iterative control structure in
PL/SQL.
a) True b) False
9) _____________ changes the flow of control within a PL/SQL block.
a) If .. Then .. else ... end if. b) While
c) Goto d) All of these
10) In PL/SQL, _____________ is valid assignment operator.
a) := b) = c) =: d) = =
11) In a cursor, _____________ statement moves the data held in the Active
Data Set into the memory variables.
a) Copy b) Open c) Move d) Fetch
12) Database triggers can be used to prevent invalid transactions.
a) True b) False
B) Suppose there is a table named CLIENT_MASTER exist on the disk. The
columns of the table are – clientno, name, address, city, pincode, state. 4
Write SQL statements for the following :
1) Change the city of clientno ‘C0005’ TO ‘Bangalore’.
2) List the names of all clients having ‘a’ as the second letter in their names.
3) List the clients who stay in a city whose first letter is ‘M’.
4) Add a column called TELEPHONE of data type ‘Number’ and size = 10 to
the CLIENT_MASTER table.
2. a) What is data ? How DBMS is differ from RDBMS ? 6
b) Who is oracle DBA ? Explain the responsibilities of oracle DBA. 6
c) Explain “Classification of SQL Commands”. 4
3. a) Explain group by and having clause with suitable example. 6
b) Explain any three aggregate functions with example of each. 6
c) What is the term privilege ? How will you give and take out privileges to other
users ? 4
SLR-R – 9 -2-
4. Write short notes on the following :
1) Normalization 4
2) Multiple sub-queries 4
3) Iterative Control Structures 4
4) Historical development of oracle. 4
5. a) Write a PL/SQL code to accept, calculate and store the details of employees
into the table EMPLOYEE. Columns of the table will be EMPNO, EMPNAME,
BASIC_SALARY, DA, HRA and NET_SALARY. Rules for DA. HRA etc.
calculation : 8
• DA should be 75% on BASIC_SALARY
• HRA should be 10% on BASIC_SALARY
• NET_SALARY = BASIC_SALARY + DA + HRA.
b) Why triggers are used ? Explain with suitable example. 8
6. a) Discuss on ‘Codd’s Rules. 8
b) Explain Explicit Cursor Management. 8
7. a) Discuss on “Integrity Constraints”. 8
b) Explain Like Operator, Between Operator, Where Clause and Order By clause. 8
_______________
0 comments:
Pen down your valuable important comments below