What is a stored procedure? MCQ with Answer and Explanation

Question

Share Report Error

What is a stored procedure?

A. A trigger

B. An index

C. A set of precompiled SQL statements that can be executed as a single unit

D. A view

Answer: Option C

Solution (By JKSSB Mock Tests)

A stored procedure is a named collection of SQL statements and logic stored in the database, which can be invoked by applications.

This question belongs to: Computer Database Management System (DBMS)

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1

Share Report

Which SQL component is used to specify a fallback default value for a column when no value is provided during an insert operation?

A. DEFAULT

B. CHECK

C. UNIQUE

D. NOT NULL

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The DEFAULT constraint assigns a predefined default value to a column when an INSERT statement does not explicitly provide a value for that column.

This question belongs to: Computer Database Management System (DBMS)

Question #2

Share Report

Which of the following is a valid SQL data type for storing large binary data?

A. VARCHAR

B. TEXT

C. CHAR

D. BLOB

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
BLOB (Binary Large Object) is used for storing large binary data, such as images or files.

This question belongs to: Computer Database Management System (DBMS)

Question #3

Share Report

Which of the following is a valid SQL numeric function?

A. CEILING

B. All of the above

C. FLOOR

D. ROUND

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
ROUND, CEILING, and FLOOR are common mathematical functions in SQL.

This question belongs to: Computer Database Management System (DBMS)

Explore All Database Management System (DBMS) MCQs