M.L.PARMAR COLLEGE OF COMPUTER SCIENCE & I.T.
F.Y.B.C.A. (Sem. 2nd):2024-25
Concepts of Relational Database Management System(205)
ASSIGNMENT
Assignment-1
Choose Appropriate option.
1. A Variable name in PL/SQL should not exceed –
A. 10 B. 20 C. 30 D. 40
2. Which of the following is correct syntax of IF statement?
A. IF-THEN statement B. IF-THEN-ELSE statement C. IF-THEN-ELSIF statement D.
All of the above
3. Which of the following PL/SQL Cursor is automatically generated by Oracle?
A. Implicit B. Explicit C. Both a and b D. None of the above
4. The _____ returns all rows from both tables where there is a match.
A. INNER JOIN B. LEFT OUTER JOIN C. RIGHT OUTER JOIN D. CROSS JOIN
5. What is the syntax of User-defined exceptions?
A. DECLARE my-exception EXCEPTION; B. DECLARE EXCEPTION; C. DECLARE
my-exception; D.EXCEPTION
6. LAST_DAY function returns the last date of the month of specified date.
A. True B. False
7. Which of the following statements can be used to terminate a PL/SQL loop?
A. GOTO B. EXIT WHEN C. CONTINUE WHEN D. KILL
8. Which of the following is NOT an attribute of implicit cursor?
A. %FOUND B. %TOO_MANY_ROWS C. %ROWCOUNT D. %ISOPEN
9. Which of the following is not a valid aggregate function?
A. COUNT B. COMPUTE C. SUM D. MAX
10.What operator tests column for absence of data?
A. NOT Operator B. Exists Operator C. IS NULL Operator D. LIKE Operator
11. Which of the following is an assignment operator in PL/SQL?
A. := B. INTO C. = D. =:
12. According to ________________________ rule all data should be accessible without
ambiguity.
A. The Information Rule Access Rule B. Guaranteed C. Comprehensive Data
Sublanguage Rule D. View Updating
13. IN RDBMS, Which of the following level of security exist?
A. O/S Level B. Command Level C. Object Level D. All of the Above
14. Which symbol is used to show the select in relational algebra?
A. B. π C. D. ρ 12
15. Which of the following keyword is used to decrement loop counter in for loop?
A. Reverse B. decrement C. decrease D. desc
16. Revoke is a ___________ type of SQL command.
A. Data Definition Language B. Data Manipulation Language C. Transaction Control
Language D.Data Control Language
17. The __________________________ attribute is used to declare variables based on
definitions of columns in a table.
A. %DATATYPE B. %COLUMNTYPE C. %TYPE D. %ROWTYPE
18. Character data type can store maximum _____________ bytes.
A. 1000 B. 2000 C. 3000 D. 4000 9.
19. Which of the following is not a relational algebra function?
A. Select B. Manipulate C. Project D. Rename
20.Which of the following statements can be used to terminate a PL/SQL loop?
A. GOTO B. EXIT WHEN C. CONTINUE WHEN D. KILL
21.The dual table is a special _________ row and _________ column table.
A. 2,2 B. 1,1 C. 1,2 D. 2,1
22.The ___________________________________ returns all rows from both tables where
there is a match.
A. INNER JOIN B. LEFT OUTER JOIN C. RIGHT OUTER JOIN D. CROSS JOIN
23. What is the maximum value that can be store in this Balance column? Balance NUMBER
(7,2).
A. 9999999.99 B. 999999.99 C. 99999.99 D. 9999.999
24.Which one of the following is NOT the aggregate function?
A. AVG B. MAX C. COUNT D. LEAST
Assignment-2
Answer in detail
A. List out Codd's Rule. Explain any four in details.
B. What is Exception? Discuss custom Exception in detail.
C. What is cursor? Explain types of cursors with example.
D. Explain For...Loop by giving suitable example.
E.Explain TO_CHAR, ROUND, SYSDATE, ADD_MONTHS, TRUNC Functions with Example.
F. Explain Grant and Revoke statement in detail.
G. Explain types of Join in detail
H. Explain commit, savepoint, rollback, grant and revoke with syntax and example.
I. Explain Union, Intersect and Minus Clause with example in Relational Algebra.
Assignment-3
Write a note on following
A. Exception handling.
B. Explain CASE Statements by giving suitable examples.
C. Write a short note on Sub queries.
D. What is Index? How to create and Drop index? Explain with example.
E. Advantages and disadvantages of PL/SQL.
F. Explain Primary Key, Candidate Key, Alternate key.
