Database functions and procedure MCQs Answers

By: Prof. Dr. Fazal Rehman | Last updated: March 3, 2022

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

Leave a Comment

All Copyrights Reserved 2025 Reserved by T4Tutorials