Which SQL command is used to give permission to a user?
Anonymous Poll
91%
GRANT
4%
UPDATE
4%
INSERT
0%
REVOKE
Which SQL wildcard is used to match any number of characters (including zero characters)?
Anonymous Quiz
33%
*
11%
&
8%
$
48%
%
❤1
Which SQL function is used to convert text into uppercase?
Anonymous Quiz
13%
CAPITAL()
0%
LOWER()
87%
UPPER()
0%
TEXT()
WHICH OF THE FOLLOWING COMMAND IS A DDL COMMAND ?
Anonymous Quiz
34%
SELECT
25%
INSERT
33%
TRUNCATE
9%
DELETE
All concepts are explained in detail in the PDF.
To get the PDF:
📌 Comment “PDF”
or
📌 Join our Telegram channel. #SQL #SQLTutorial #LearnSQL #DatabaseManagement
https://www.instagram.com/p/DTDKw4SkiJp/?igsh=ajIyczYyZzY2Y3c5
To get the PDF:
📌 Comment “PDF”
or
📌 Join our Telegram channel. #SQL #SQLTutorial #LearnSQL #DatabaseManagement
https://www.instagram.com/p/DTDKw4SkiJp/?igsh=ajIyczYyZzY2Y3c5
❤1
DCL commands are mainly used for:
Anonymous Poll
15%
Data definition
31%
Data manipulation
31%
Transaction control
22%
Data security
DQL is mainly used for
Anonymous Poll
65%
Retrieving data
8%
Creating tables
9%
Deleting data
18%
Modifying data
Which clause is executed after GROUP BY in SQL logical query processing?
Anonymous Quiz
15%
WHERE
72%
HAVING
9%
FROM
4%
SELECT
❤2