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:
2. How many values can be returned from a stored function?
A. 1
B. 2
C. 3
D. 0
Answer:
3. PSM stands for?
A. Prepared statement module
B. Prepare storage module
C. Permanent storage value
D. Persistent storage value
Answer:
4. To identify the procedure, the name is used along with it?
A. Attributes
B. Values
C. Arguments
D. Initialization
Answer:
5. CRL stands for?
A. Common language runtime
B. Communication language runtime
C. Conditional language runtime
D. Computing language runtime
Answer:
6. Compound statement format is?
A. Begin atomic…… end
B. Begin……. end
C. Both A and B
D. None of these
Answer:
7. In which database the temporary stored procedure are stored?
A. Model
B. Master
C. Both A and B
D. Tempdb
Answer:
8. Advantage of using SQL stored procedure is?
A. Security
B. Re-use of code
C. Maintability
D. All of above
Answer:
9. In which mode formal parameters acts liked initialized variable?
A. IN OUT
B. IN
C. OUT
D. None of these
Answer:
10. Which database object that groups logically related PL/SQL types, object and subprograms?
A. Module
B. Body
C. Package
D. Name
Answer:
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:
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:
13. Maximum number of triggers that can apply on a single table?
A. 10
B. 16
C. 16
D. 12
Answer:
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:
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:
16. Scheme of hierarchal database is?
A. A graph
B. A tree
C. Both A and B
D. None of these
Answer:
17. Database system compiles query when it is?
A. Prepared
B. Invoked
C. Executed
D. Initialized
Answer:
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:
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:
