Menu

Question Discussion & Solution

MCQ

Q.

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

E

None of the above

Community Discussion

No discussions yet. Be the first to start!

You must be logged in to participate in the discussion.

Login to Discuss

Similar Questions

MCQ

1.

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

A

Insert

B

Modify

C

Look-up

D

All of the above

E

None of the above

Discussion

MCQ

2.

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

A

ALTER TABLE

B

DEFINE TABLE

C

MODIFY TABLE

D

All of the above

E

None of the above

Discussion

MCQ

3.

The DBMS language component which can be embedded in a program is

A

The data definition language (DDL).

B

The data manipulation language (DML).

C

The database administrator (DBA).

D

A query language.

Discussion

MCQ

4.

In SQL, GRANT command is used to

A

allow user to access databases

B

allow user to create databases

C

grant system privileges, roles, and object privileges to uses and roles

D

choose auditing for specific SQL commands

E

None of the above

Discussion

MCQ

5.

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

A

CHOOSE

B

SELECT

C

LIST

D

BROWSE

E

None of the above

Discussion

More Computer Fundamentals Topics

Data Communication and Networking

522 MCQs

Miscellaneous or General

716 MCQs

Computer Basics

115 MCQs

Computer Softwares

58 MCQs

History and Generations

29 MCQs

CPU and its components

61 MCQs

Computer Languages

58 MCQs

Computer Hardware

336 MCQs

Input Devices

24 MCQs

Output Devices

23 MCQs

Computer Memory

132 MCQs

Digital Logic Gate

2 MCQs

Number System

37 MCQs

Computer Codes

28 MCQs

Operating System

536 MCQs

Disk Operating System (DOS)

211 MCQs

Database Systems

153 MCQs

Computer Security and Viruses

32 MCQs

Mixed

13 MCQs

Computer Awareness

115 MCQs

Files and its types

0 MCQs