What syntax is correct for filtering seller name’s dara and male? A. SELECT * FROM tblclerk WHERE name = ‘dara’ & gender = ‘male’ B. SELECT * FROM tblclerk WHERE name = ‘dara’ && gender = ‘male’ C. SELECT *…
What is the correct syntax for SQL for theta join of tblclerk and tblpurchase? A. SELECT * FROM tblclerk C & tblselling B WHERE C.sid = B.sid B. SELECT * FROM tblclerk C, tblselling B WHERE C.sid = B.sid C.…
What code is correct in SQL language joining tblclerk and tblpurchase? A. SELECT * FROM tblclerk OUTER JOIN tblpurchase B. SELECT * FROM tblclerk C LEFT OUTER JOIN tblpurchase B ON C.sid = B.sid C. SELECT * FROM tblclerk LEFT…
What code is correct in SQL for joining tblclerk and tblpurchase? A. SELECT * FROM tblclerk JOIN tblpurchase B. SELECT * FROM tblclerk INNER JOIN tblpurchase ON tblclerk.sid = tblpurchase.sid C. SELECT * BETWEEN tblclerk AND tblpurchase ON tblclerk.sid =…
In SQL, which is correct for selecting all records from a table tblclerk? A. SELECT * FROM tblclerk B. SELECT * FROM TABLE tblclerk C. SELECT FROM TABLE tblclerk D. None correct Answer: Option A
In SQL, What is the correct syntax from selecting all data from a table tblclerk? A. SELECT ALL FROM tblclerk B. SELECT * FROM tblclerk C. SELECT ALL * FROM tblclerk D. None correct Answer: Option B
In SQL, which syntax is correct for updating data in tblseller? A. UPDATE tblseller WHERE sid = 101 B. UPDATE tblseller ON name = ‘meta’ WHERE sid = 101 C. UPDATE tblseller SET name = ‘meta’ WHERE sid = 101…
In SQL, which syntax is correct for inserting data into tblseller? A. INSERT INTO tblseller WHERE sid = 101 AND name = ‘meta’ B. INSERT INTO tblseller SET sid = 101 AND name = ‘meta’ C. INSERT INTO tblseller VALUES(101,…
In SQL, which syntax is correct for selecting unique row from tblseller? A. SELECT UNIQUE name FROM tblseller B. SELECT ATOMIC name FROM tblseller C. SELECT DISTINCT name FROM tblseller D. None correct Answer: Option C
In SQL, which of the following syntax is correct for the where like seller name meta? A. SELECT * FROM tblseller WHERE name = ‘%meta%’ B. SELECT * FROM tblseller WHERE name == ‘%meta%’ C. SELECT * FROM tblseller WHERE…
KB Cambodia