adplus-dvertising
frame-decoration

Question

Which one of the following is the right syntax for DECODE ?

a.

DECODE (search, expression, result [, search, result]… [, default])

b.

DECODE (expression, result [, search, result]… [, default], search)

c.

DECODE (search, result [, search, result]… [, default], expression)

d.

DECODE (expression, search, result [, search, result]… [, default])

Posted under SQL Queries,Constraints and Triggers DBMS

Answer: (d).DECODE (expression, search, result [, search, result]… [, default])

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Which one of the following is the right syntax for DECODE ?
Add Comment

Similar Questions

Discover Related MCQs

Q. Which of these query will display the the table given below ?

View solution

Q. Select * from employee where employee_id>1009;

Which of the following employee_id will be displayed?

View solution

Q. Consider the two relations instructor and department. Which of the following is used to create view for these relations together?

View solution

Q. Which of the following is used to provide privilege to only a particular attribute ?

View solution

Q. Which of the following statement is used to remove the privilege from the user Amir ?

View solution

Q. Which of the following is used to provide delete authorization to instructor ?

View solution

Q. Which of the following is true regarding views ?

View solution

Q. If we wish to grant a privilege and to allow the recipient to pass the privilege on to other users, we append the __________ clause to the appropriate grant command.

View solution

Q. In authorization graph if DBA provides authorization to u1 which in turn gives to u2 which of the following is correct ?

View solution

Q. Which of the following is used to avoid cascading of authorizations from the user ?

View solution

Q. The granting and revoking of roles by the user may cause some confusions when that user role is revoked .To overcome the above situation

View solution
View All MCQs on SQL Queries,Constraints and Triggers

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!

Cryptography and Network Security

Secure your knowledge of information security with our Cryptography and Network...

Discrete Mathematics

Refine your mathematical skills essential for computer science with our Discrete...

Digital Communication

Master the basics of electronic communication with our Digital Communication MCQs....

Management Information Systems

Discover how businesses leverage technology with our Management Information Systems...

Hadoop

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

C# programming

Hone your skills in the C# language with our MCQs. Understand data types, operators,...

Software Architecture and Design

Get a strong hold on the blueprint of software systems with our Software Architecture...

Systems Programming

Decode low-level programming with our Systems Programming MCQs. These questions delve...

Computer Hardware

Explore the tangible components of computers with our Computer Hardware MCQs. Learn...