CS409 Practical Solved Paper

FINALTERM EXAMINATION CS409P

Mubeen Mustafa

Fall 2022 CS409P – Introduction to Database Administration (Practical)

Marks: 40

Q1. ________ are PL/SQL programs that are set up to execute in response to a particular event on a table in the database. (01 marks)

1. Package
2. Functions
3. Triggers
4. Procedure

Correct answer: Triggers

Q2. A program that resides inside an oracle database that manipulates data in the database before the data is used outside the database is known as __________. (01 marks)

1. Triggers
2. Function
3. Stored procedure
4. Package

Correct answer: Stored procedure

Q3. Which command is used to fetch records from database? (01 marks)

1. Fetch
2. Select
3. Use
4. Get

Correct answer: Select

Q4. A ________ is a group of PL/SQL statements that can be called by name. (01 marks)

1. View
2. Trigger
3. Procedure
4. Function

Correct answer: Procedure

Q5. How many CREATE TRIGGER statements are there? ANSWER is 2 (01 marks)

1. 4
2. 5
3. 6
4. 7

Q6. TRUNCATE TABLE statement is used to remove the table. (01 marks)

1. TRUE
2. FALSE
3. Can be true or false
4. Can not say

Correct answer: TRUE

Q7. Which is the smallest unit of storage in an Oracle database? (01 marks)

1. Segment
2. Data Block
3. Extent
4. Data File

Correct answer: Data Block

Q8. How many types of procedure are there? (01 marks)

1. 1
2. 2(Stored and Anonymous Procedures)
3. 3
4. 4

Correct answer: 2(Stored and Anonymous Procedures)

Q9. What is the syntax to Drop Procedure? (01 marks)

1. DELETE PROCEDURE procedure_name;
2. DROP PROCEDURE procedure_name;
3. RETRIEVE PROCEDURE procedure_name;
4. END PROCEDURE procedure_name;

Correct answer: DROP PROCEDURE procedure_name;

Q10. How many types of exceptions are there? (01 marks)

1. 2
2. 3
3. 4
4. 5

Correct answer: 3

Q11. Errors that are encountered during the execution of the program are referred to as ____ in PL/SQL. (01 marks)

1. FUNCTION
2. CURSOR
3. EXCEPTION
4. PROCEDURE

Correct answer: EXCEPTION

Q12. Which command is used in order to raise an exception explicitly? (01 marks)

1. RISE
2. ROSE
3. RAISE
4. RINSE

Correct answer: RAISE