What is the correct syntax for SQL for theta join of tblstudent and tblregister? A. SELECT * FROM tblstudent C & tblregistering B WHERE C.cid = B.cid B. SELECT * FROM tblstudent C, tblregistering B WHERE C.cid = B.cid C.…
What code is correct in SQL language joining tblstudent and tblregister? A. SELECT * FROM tblstudent OUTER JOIN tblregister B. SELECT * FROM tblstudent C LEFT OUTER JOIN tblregister B ON C.cid = B.cid C. SELECT * FROM tblstudent LEFT…
What code is correct in SQL for joining tblstudent and tblregister? A. SELECT * FROM tblstudent JOIN tblregister B. SELECT * FROM tblstudent INNER JOIN tblregister ON tblstudent.cid = tblregister.cid C. SELECT * BETWEEN tblstudent AND tblregister ON tblstudent.cid =…
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
KB Cambodia