In SQL, which of the following syntax is correct for inserting data? A. INSERT INTO tblcustomer WHERE cid = 101 AND name = ‘sok’ B. INSERT INTO tblcustomer SET cid = 101 AND name = ‘sok’ C. INSERT INTO tblcustomer…
In SQL, which of the following syntax is correct for selecting unique row? A. SELECT UNIQUE name FROM tblcustomer B. SELECT ATOMIC name FROM tblcustomer C. SELECT DISTINCT name FROM tblcustomer D. None correct Answer: Option C
In SQL, which of the following syntax is correct for the where like? A. SELECT * FROM tblcustomer WHERE name = ‘%sok%’ B. SELECT * FROM tblcustomer WHERE name == ‘%sok%’ C. SELECT * FROM tblcustomer WHERE name LIKE ‘%sok%’…
In SQL, which of the following syntax is correct for filtering the sum? A. SELECT SUM(spend), gender FROM tblcustomer WHERE gender = ‘male’ B. SELECT SUM(spend), gender FROM tblcustomer GROUP BY gender = ‘male’ C. SELECT SUM(spend), gender FROM tblcustomer…
In SQL, which of the following syntax is correct for the sum? A. SELECT SUM(spend), gender FROM tblcustomer B. SELECT SUM(spend), gender FROM tblcustomer GROUP gender C. SELECT SUM(spend), gender FROM tblcustomer GROUP BY gender D. None correct Answer: Option…
In SQL, which of the following code is correct for filtering the average? A. SELECT AVG(age), gender FROM tblcustomer WHERE gender = ‘male’ B. SELECT AVG(age), gender FROM tblcustomer GROUP BY gender = ‘male’ C. SELECT AVG(age), gender FROM tblcustomer…
In SQL, which of the following syntax is correct for the average? A. SELECT AVG(age), gender FROM tblcustomer B. SELECT AVG(age), gender FROM tblcustomer GROUP gender C. SELECT AVG(age), gender FROM tblcustomer GROUP BY gender D. None correct Answer: Option…
In SQL, which of the following syntax is correct for the count? A. SELECT COUNT(cid), gender FROM tblcustomer WHERE gender = ‘male’ B. SELECT COUNT(cid), gender FROM tblcustomer GROUP BY gender = ‘male’ C. SELECT COUNT(cid), gender FROM tblcustomer GROUP…
In SQL, which of the following syntax is correct about group by? A. SELECT COUNT(cid), gender FROM tblcustomer B. SELECT COUNT(cid), gender FROM tblcustomer IN GROUP gender C. SELECT COUNT(cid), gender FROM tblcustomer GROUP BY gender D. None correct Answer:…
In SQL, which of the following syntax is correct about order by? A. SELECT * FROM tblcustomer ORDER BY name WHERE name = ‘sok’ B. SELECT * FROM tblcustomer WHERE name = ‘sok’ ORDER name C. SELECT * FROM tblcustomer…
KB Cambodia