In SQL, what code is correct for the insert a new student? A. INSERT INTO tblstudent VALUES(101, ‘sok’) WHERE cid = NULL B. INSERT tblstudent VALUES(101, ‘sok’) WHERE cid = NULL C. INSERT INTO tblstudent(cid, name) VALUES(101, ‘sok’) D. None…
In SQL, which of the following code is correct for selecting all records? A. SELECT * FROM tblstudent B. SELECT * FROM TABLE tblstudent C. SELECT FROM TABLE tblstudent D. None correct Answer: Option A
In SQL, What is the correct syntax from selecting all data from a table? A. SELECT ALL FROM tblstudent B. SELECT * FROM tblstudent C. SELECT ALL * FROM tblstudent D. None correct Answer: Option B
In SQL, which of the following syntax is correct for deleting the whole database? A. DELETE DATABASE dbPOS B. REMOVE DATABASE dbPOS C. DROP DATABASE dbPOS D. None correct Answer: Option C
In SQL, which of the following syntax is correct for deleting the whole table? A. DELETE TABLE tblcustomer B. REMOVE TABLE tblcustomer C. DROP TABLE tblcustomer D. None correct Answer: Option C
In SQL, which of the following syntax is correct for deleting records from a table? A. DELETE * FROM tblcustomer B. DELETE TABLE tblcustomer C. DELETE FROM tblcustomer D. None correct Answer: Option A
In SQL, which of the following syntax is correct for updating data? A. UPDATE tblcustomer WHERE cid = 101 B. UPDATE tblcustomer ON name = ‘sok’ WHERE cid = 101 C. UPDATE tblcustomer D. None correct Answer: Option C
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%’…
KB Cambodia