KB Cambodia
A. B. C. D. Answer: Option
Category: Advanced System Analysis and Design
In SQL, which syntax is correct for updating data in tblclerk?
In SQL, which syntax is correct for updating data in tblclerk? A. UPDATE tblclerk WHERE sid = 101 B. UPDATE tblclerk ON name = ‘dara’ WHERE sid = 101 C. UPDATE tblclerk SET name = ‘dara’ WHERE sid = 101…
In SQL, which syntax is correct for inserting data into tblclerk?
In SQL, which syntax is correct for inserting data into tblclerk? A. INSERT INTO tblclerk WHERE sid = 101 AND name = ‘dara’ B. INSERT INTO tblclerk SET sid = 101 AND name = ‘dara’ C. INSERT INTO tblclerk VALUES(101,…
In SQL, which syntax is correct for selecting unique row from tblclerk?
In SQL, which syntax is correct for selecting unique row from tblclerk? A. SELECT UNIQUE name FROM tblclerk B. SELECT ATOMIC name FROM tblclerk C. SELECT DISTINCT name FROM tblclerk D. None correct Answer: Option C
In SQL, which of the following syntax is correct for the where like seller name dara?
In SQL, which of the following syntax is correct for the where like seller name dara? A. SELECT * FROM tblclerk WHERE name = ‘%dara%’ B. SELECT * FROM tblclerk WHERE name == ‘%dara%’ C. SELECT * FROM tblclerk WHERE…
In SQL, which of the following syntax is correct about group by sid of tblclerk?
In SQL, which of the following syntax is correct about group by sid of tblclerk? A. SELECT COUNT(sid), gender FROM tblclerk B. SELECT COUNT(sid), gender FROM tblclerk IN GROUP gender C. SELECT COUNT(sid), gender FROM tblclerk GROUP BY gender D.…
In SQL, which is correct about order by name in table tblclerk?
In SQL, which is correct about order by name in table tblclerk? A. SELECT * FROM tblclerk ORDER BY name WHERE name = ‘dara’ B. SELECT * FROM tblclerk WHERE name = ‘dara’ ORDER name C. SELECT * FROM tblclerk…
In SQL, how to select multiple attributes from tblclerk?
In SQL, how to select multiple attributes from tblclerk? A. SELECT sid & name FROM tblclerk B. SELECT sid AND name FROM tblclerk C. SELECT sid, name FROM tblclerk D. None correct Answer: Option C
What syntax is correct to filter the seller’s name is not ‘dara’?
What syntax is correct to filter the seller’s name is not ‘dara’? A. SELECT * FROM tblclerk WHERE name != ‘dara’ B. SELECT * FROM tblclerk WHERE name >< 'dara' C. SELECT * FROM tblclerk WHERE name ‘dara’ D. None…
In SQL, What syntax is correct for filtering seller name’s dara or male?
In SQL, What syntax is correct for filtering seller name’s dara or male? A. SELECT * FROM tblclerk WHERE name = ‘dara’ | gender = ‘male’ B. SELECT * FROM tblclerk WHERE name = ‘dara’ || gender = ‘male’ C.…