Question

SELECT emp_name
FROM department
WHERE dept name LIKE
Computer Science'
In the above-given Query, which of the following can be placed in the Query's blank
portion to select the "dept_name" that also contains Computer Science as its ending
string?
A. &
ho
B.
C. %
D. $​

Answer 1

ɧɛƖƖơ ɱąɬɛ

Answer:

C. %

_________________________

Explanation:

ɪɴ ᴍʏsQʟ :

• (% )ᴡɪʟʟ ʙᴇ ᴜsᴇᴅ ɪF ᴍᴀɴʏ ʟᴇᴛᴛᴇʀs ᴀʀᴇ ᴛʜᴇʀᴇ ᴀɴᴅ ᴡᴇ ᴀʀᴇ ɴᴏᴛ ᴀʙʟᴇ ᴛᴏ sᴘᴇᴄɪFʏ ᴛʜᴇ ᴄᴏʀʀᴇᴄᴛ ɴᴜᴍʙᴇʀs..ʜᴇɴᴄᴇ( %) ᴄᴀɴ ʙᴇ ᴜsᴇᴅ Fᴏʀ ᴠᴀʀɪᴀʙʟᴇ ʟᴇɴɢᴛʜ  

• (_) ᴡɪʟʟ ʙᴇ ᴜsᴇᴅ ɪF ᴡᴇ ᴋɴᴏᴡ ᴛʜᴇ ɴᴜᴍʙᴇʀ ᴏF ʟᴇᴛᴛᴇʀs ..ʜᴇɴᴄᴇ( _ ) ɪs ᴜsᴇᴅ Fᴏʀ Fɪxᴇᴅ ʟᴇɴɢᴛʜ.

_________________________

ᴇxᴀᴍᴘʟᴇ:

ɪF ᴡᴇ ᴡᴀɴᴛ ᴛᴏ sᴇᴀʀᴄʜ Fᴏʀ :

• ᴘᴇɴ  ᴀɴᴅ ᴡᴇ ᴋɴᴏᴡ ᴛʜᴀᴛ ɪᴛ ᴇɴᴅs ᴡɪᴛʜ ɴ ᴀɴᴅ ɪɴ ᴛᴏᴛᴀʟ ɪᴛ ʜᴀs 3 ʟᴇᴛᴛᴇʀs ᴛʜᴇɴ  ɪɴ sQʟ ᴡᴇ ᴄᴀɴ ᴅᴇɴᴏᴛᴇ ɪᴛ ᴀs:                                                                     "_ _ ɴ "

• ᴘᴇɴ  ᴀɴᴅ ᴡᴇ  ᴋɴᴏᴡ ᴛʜᴀᴛ ɪᴛ ᴇɴᴅs ᴡɪᴛʜ ɴ ᴀɴᴅ ʙᴜᴛ ᴅᴏɴᴛ ᴋɴᴏᴡ ᴛʜᴀᴛ  ɪᴛ ʜᴀs 3 ʟᴇᴛᴛᴇʀs ᴛʜᴇɴ   ɪɴ sQʟ ᴡᴇ ᴄᴀɴ ᴅᴇɴᴏᴛᴇ ɪᴛ ᴀs:                                                  " %ɴ  "                                            

_________________________

ɧơ℘ɛ ıɬ ɧɛƖ℘ʂ ყơų  ☺