What syntax is correct for WHERE clause? A. SELECT * FROM tblcustomer WHERE name = ‘sok’ & gender = ‘male’ B. SELECT * FROM tblcustomer WHERE name = ‘sok’ && gender = ‘male’ C. SELECT * FROM tblcustomer WHERE name…
What is the correct syntax for SQL? A. SELECT * FROM tblcustomer C & tblbuying B WHERE C.cid = B.cid B. SELECT * FROM tblcustomer C, tblbuying B WHERE C.cid = B.cid C. SELECT * FROM tblcustomer C AND tblbuying…
What code is correct in SQL language the join? A. SELECT * FROM tblcustomer OUTER JOIN tblbuy B. SELECT * FROM tblcustomer C LEFT OUTER JOIN tblbuy B ON C.cid = B.cid C. SELECT * FROM tblcustomer LEFT tblbuy D.…
What code is correct in SQL for joining two tables? A. SELECT * FROM tblcustomer JOIN tblbuy B. SELECT * FROM tblcustomer INNER JOIN tblbuy ON tblcustomer.cid = tblbuy.cid C. SELECT * BETWEEN tblcustomer AND tblbuy ON tblcustomer.cid = tblbuy.cid…
In SQL, what code is correct for the insert? A. INSERT INTO tblcustomer VALUES(101, ‘sok’) WHERE cid = NULL B. INSERT tblcustomer VALUES(101, ‘sok’) WHERE cid = NULL C. INSERT INTO tblcustomer(cid, name) VALUES(101, ‘sok’) D. None correct Answer: Option…
In SQL, which of the following code is correct for the select? A. SELECT * FROM tblcustomer B. SELECT * FROM TABLE tblcustomer C. SELECT FROM TABLE tblcustomer D. None correct Answer: Option A
In SQL, What is the correct syntax from select all? A. SELECT ALL FROM tblcustomer B. SELECT * FROM tblcustomer C. SELECT ALL * FROM tblcustomer D. None correct Answer: Option B
What is the correct syntax in SQL for the update? A. UPDATE tblcustomer SET name = ‘sok’ B. UPDATE TABLE tblcustomer SET name = ‘sok’ C. UPDATE TABLE tblcustomer SET name = ‘sok’ WHERE cid = 101 D. None correct…
What is the correct syntax for creating a table? A. CREATE tblcustomer (cid INTEGER, name VARCHAR(255)) B. CREATE TABLE tblcustomer (cid INTEGER, name VARCHAR(255)) C. CREATE tblcustomer {cid INTEGER, name VARCHAR(255)} D. None correct Answer: Option B
Which of the following syntax is correct for the insert? A. INSERT tblcustomer VALUES(101, ‘sok’) B. INSERT INTO tblcustomer VALUES(101, ‘sok’) C. INSERT INTO TABLE tblcustomer VALUES(101, ‘sok’) D. None correct Answer: Option B
KB Cambodia