Which of the following describes a precompiled collection of SQL statements stored on the database server that can be executed repeatedly by name? MCQ with Answer and Explanation

Question Report Error

Which of the following describes a precompiled collection of SQL statements stored on the database server that can be executed repeatedly by name?

A. View

B. Trigger

C. Stored Procedure

D. Cursor

Answer: Option C

Solution (By JKExamLibrary)

A Stored Procedure is a precompiled group of SQL statements and optional control-of-flow code stored in the database server, enhancing execution speed and security.

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

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1 Report Error

Which SQL function returns the current date and time?

A. GETDATE()

B. NOW()

C. All of the above depending on the DBMS

D. CURDATE()

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Different DBMSs have different functions: MySQL NOW(), SQL Server GETDATE(), etc. But all return current date/time.

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

Question #2 Report Error

Which database anomaly describes the necessity to update the exact same data value in multiple independent rows, creating a risk of data inconsistency?

A. Structural Anomaly

B. Insertion Anomaly

C. Selection Anomaly

D. Update Anomaly

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
An Update Anomaly occurs when data is redundantly duplicated across rows, requiring changes to be made to every copy, risking inconsistencies if any row is missed.

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