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