Database functions and procedure MCQs Answers

By Prof. Fazal Rehman Shamil
Last modified on September 12th, 2020

Let us see the list of important Database functions and procedure MCQs Answers.

1. Which statement is used to produce a stored function?
A. Procedure procedure
B. Create procedure
C. Produce function
D. Create function
Answer:

Answer - Click Here:
D

2. How many values can be returned from a stored function?
A. 1
B. 2
C. 3
D. 0
Answer:
Answer - Click Here:
B

3. PSM stands for?
A. Prepared statement module
B. Prepare storage module
C. Permanent storage value
D. Persistent storage value
Answer:
Answer - Click Here:
D

4. To identify the procedure, the name is used along with it?
A. Attributes
B. Values
C. Arguments
D. Initialization
Answer:
Answer - Click Here:
C

5. CRL stands for?
A. Common language runtime
B. Communication language runtime
C. Conditional language runtime
D. Computing language runtime
Answer:
Answer - Click Here:
A

6. Compound statement format is?
A. Begin atomic…… end
B. Begin……. end
C. Both A and B
D. None of these
Answer:
Answer - Click Here:
C

7. In which database the temporary stored procedure are stored?
A. Model
B. Master
C. Both A and B
D. Tempdb
Answer:
Answer - Click Here:
D

8. Advantage of using SQL stored procedure is?
A. Security
B. Re-use of code
C. Maintability
D. All of above
Answer:
Answer - Click Here:
D

9. In which mode formal parameters acts liked initialized variable?
A. IN OUT
B. IN
C. OUT
D. None of these
Answer:
Answer - Click Here:
A

10. Which database object that groups logically related PL/SQL types, object and subprograms?
A. Module
B. Body
C. Package
D. Name
Answer:
Answer - Click Here:
C

11. A return statement does not return the value in which subprogram?
A. In function
B. In procedure
C. Both A and B
D. None of these
Answer:
Answer - Click Here:
A

12. Variables and expression passed from calling the subprograms are?
A. Actual parameters
B. Formal parameters
C. Both A and B
D. None of these
Answer:
Answer - Click Here:
A

13. Maximum number of triggers that can apply on a single table?
A. 10
B. 16
C. 16
D. 12
Answer:
Answer - Click Here:
D

14. Parameters that act like a constant inside the program are?
A. OUT
B. IN
C. Both A and B
D. None of these
Answer:
Answer - Click Here:
B

15. Data model which actually describes how the data is stored is?
A. Logic model
B. External model
C. Internal model
D. None of these
Answer:
Answer - Click Here:
C

16. Scheme of hierarchal database is?
A. A graph
B. A tree
C. Both A and B
D. None of these
Answer:
Answer - Click Here:
B

17. Database system compiles query when it is?
A. Prepared
B. Invoked
C. Executed
D. Initialized
Answer:
Answer - Click Here:
A

18. Trigger can be dropped by using command?
A. Defined drop trigger
B. Drop trigger
C. Both A and B
D. None of these
Answer:
Answer - Click Here:
B

19. Java application program does not include deceleration for?
A. Data executed
B. Data retrieved of database
C. Both A and B
D. Data stored in database
Answer:
Answer - Click Here:
D

Computer Science Repeated MCQs Book Download

Prof.Fazal Rehman Shamil (Available for Professional Discussions)
1. Message on Facebook page for discussions,
2. Video lectures on Youtube
3. Email is only for Advertisement/business enquiries.