adplus-dvertising
frame-decoration

Question

Which of the following command(s) is(are) used to recompile a stored procedure in SQL?

a.

COMPILE PROCEDURE

b.

ALTER PROCEDURE

c.

MODIFY PROCEDURE id) All of the above

d.

None of the above

Posted under DBMS

Answer: (b).ALTER PROCEDURE

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Which of the following command(s) is(are) used to recompile a stored procedure in SQL?

Similar Questions

Discover Related MCQs

Q. Which command(s) is(are) used to redefine a column of the table in SQL ?

Q. Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?

Q. In SQL, the ALTER TABLESPACE command is used

Q. In SQL, which command(s) is(are) used to create a synonym for a schema object?

Q. In SQL, which of the following is not a data Manipulation Language Commands?

Q. In SQL, the CREATE VIEW command is used

Q. In SQL, which command is used to create a database user?

Q. In SQL, which command(s) is(are) used to redefine an index's future storage allocation

Q. In SQL, which command is used to select data in rows and column from one or more tables?

Q. The _____ command is used to allocates an extent for the table in SQL

Q. In SQL, the _____ command is used to recompile a view

Q. Which language has recently become the de-facto standard for interfacing application programs with relational database system?

Q. In SQL, the CREATE TABLE is used

Q. In SQL, which command is used to select only one copy of each set of duplicable rows

Q. Which command is used to select distinct subject (SUB) from the table (BOOK)?

Q. In SQL, the CREATE TABLESPACE is used

Q. In SQL, which command is used to remove a stored function from the database?

Q. A command that lets you change one or more fields in a record is

Q. In SQL, the command(s) is(are) used to create an index for a table or cluster

Q. In SQL, which command(s) is(are) used to recompile a stored function?