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