What code is correct in SQL for joining tblclerk and tblpurchase? A. SELECT * FROM tblclerk JOIN tblpurchase B. SELECT * FROM tblclerk INNER JOIN tblpurchase ON tblclerk.sid = tblpurchase.sid C. SELECT * BETWEEN tblclerk AND tblpurchase ON tblclerk.sid =…
In SQL, which is correct for selecting all records from a table tblclerk? A. SELECT * FROM tblclerk B. SELECT * FROM TABLE tblclerk C. SELECT FROM TABLE tblclerk D. None correct Answer: Option A
In SQL, What is the correct syntax from selecting all data from a table tblclerk? A. SELECT ALL FROM tblclerk B. SELECT * FROM tblclerk C. SELECT ALL * FROM tblclerk D. None correct Answer: Option B
In SQL, which syntax is correct for updating data in tblseller? A. UPDATE tblseller WHERE sid = 101 B. UPDATE tblseller ON name = ‘meta’ WHERE sid = 101 C. UPDATE tblseller SET name = ‘meta’ WHERE sid = 101…
In SQL, which syntax is correct for inserting data into tblseller? A. INSERT INTO tblseller WHERE sid = 101 AND name = ‘meta’ B. INSERT INTO tblseller SET sid = 101 AND name = ‘meta’ C. INSERT INTO tblseller VALUES(101,…
In SQL, which syntax is correct for selecting unique row from tblseller? A. SELECT UNIQUE name FROM tblseller B. SELECT ATOMIC name FROM tblseller C. SELECT DISTINCT name FROM tblseller D. None correct Answer: Option C
In SQL, which of the following syntax is correct for the where like seller name meta? A. SELECT * FROM tblseller WHERE name = ‘%meta%’ B. SELECT * FROM tblseller WHERE name == ‘%meta%’ C. SELECT * FROM tblseller WHERE…
In SQL, which of the following syntax is correct for filtering the sum of sold? A. SELECT SUM(sold), gender FROM tblseller WHERE gender = ‘male’ B. SELECT SUM(sold), gender FROM tblseller GROUP BY gender = ‘male’ C. SELECT SUM(sold), gender…
In SQL, which of the following syntax is correct for the sum of sold of sellers? A. SELECT SUM(sold), gender FROM tblseller B. SELECT SUM(sold), gender FROM tblseller GROUP gender C. SELECT SUM(sold), gender FROM tblseller GROUP BY gender D.…
In SQL, which of the following syntax is correct for the average of age of seller? A. SELECT AVG(age), gender FROM tblseller B. SELECT AVG(age), gender FROM tblseller GROUP gender C. SELECT AVG(age), gender FROM tblseller GROUP BY gender D.…
KB Cambodia