[Solved] Which one of the following is the right syntax for DECODE?

McqMate

Q.	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])
Answer» D. decode (expression, search, result [, search, result]… [, default])

542

0

Do you find this helpful?

2

View all MCQs in

DataBase Management System (DBMS)

Discussion

No comments yet

Related MCQs

Which of the following is the right syntax for the assertion?
Which of the syntax is correct for insert statement? i) insert into <table_name> values <list of values> ii) insert into <table_name> (column list) values <list of values>
To select all columns from the table the syntax is:
To select all column from the table the syntax is:
What is the syntax to load data into the database? (Consider D as the database and a, b, c as datA:)
Syntax for creating views is __________
What is the process that is done to SQL before execution, to check for proper syntax and to optimize the request called?
Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
Which one of the following is a set of one or more attributes taken collectively to Uniquely identify a record?