KB Cambodia
In SQL, how to select multiple attributes?
In SQL, how to select multiple attributes? A. SELECT cid & name FROM tblcustomer B. SELECT cid AND name FROM tblcustomer C. SELECT cid, name FROM tblcustomer D. None correct Answer: Option C
Category: Advanced System Analysis and Design
What syntax is correct to filter the name attribute is not ‘sok’?
What syntax is correct to filter the name attribute is not ‘sok’? A. SELECT * FROM tblcustomer WHERE name != ‘sok’ B. SELECT * FROM tblcustomer WHERE name >< 'sok' C. SELECT * FROM tblcustomer WHERE name ‘sok’ D. None…
In SQL, What syntax is correct for WHERE clause?
In SQL, 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…
What syntax is correct for WHERE clause?
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?
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?
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?
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?
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?
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?
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