Question

Which of the following is true concerning a procedure?

a.

You do not create them with SQL.

b.

They do not need to have a unique name.

c.

They include procedural and SQL statements.

d.

They are the same thing as a function.

Posted under DBMS

Answer: (c).They include procedural and SQL statements.

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 is true concerning a procedure?

Add Comment

Similar Questions

Discover Related MCQs

Q. Which of the following is true concerning systems information in an RDBMS?

View solution

Q. A CASE SQL statement is which of the following?

View solution

Q. In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?

View solution

Q. In SQL, which command(s) is(are) used to enable/disable a database trigger?

View solution

Q. Which command is used to remove an index from the database in SQL?

View solution

Q. Which command is used to remove a table from the database in SQL?

View solution

Q. In SQL, GRANT command is used to

View solution

Q. In SQL, which command(s) is(are) used to enable/disable all triggers on a table?

View solution

Q. In SQL, which command is used to add new rows to a table?

View solution

Q. An operation that will increase the length of a list is

View solution

Q. In SQL, which command is used to add a column/integrity constraint to a table

View solution

Q. In SQL, which command is used to changes data in a table?

View solution

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

View solution

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

View solution

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

View solution

Q. In SQL, the ALTER TABLESPACE command is used

View solution

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

View solution

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

View solution

Q. In SQL, the CREATE VIEW command is used

View solution

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

View solution

View All MCQs on DBMS

Suggested Topics

Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Compiler Design

Unravel the process of translating source code into executable programs with our...

JavaScript

Strengthen your web development skills with our JavaScript MCQs. Understand core...

Web Technologies

Master the building blocks of the web with our Web Technologies MCQs. From HTML and...

Java Spring Framework

Enhance your Java development skills with our Spring Framework MCQs. Learn about...

Data Science

Discover the fascinating world of extracting insights from data with our Data Science...

Hadoop

Dive into the world of big data with our Hadoop MCQs. Cover key concepts including...

Java Programming

Level up your coding skills with our Java Programming MCQs. From object-oriented...

Visual Basic

Enhance your knowledge of Microsoft's event-driven programming language with our...

Wireless and Mobile Communications

Get to grips with modern communication technologies with our Wireless and Mobile...