In SQL, which syntax is correct for selecting unique row from tblclerk? A. SELECT UNIQUE name FROM tblclerk B. SELECT ATOMIC name FROM tblclerk C. SELECT DISTINCT name FROM tblclerk D. None correct Answer: Option C
In SQL, which of the following syntax is correct for the where like seller name dara? A. SELECT * FROM tblclerk WHERE name = ‘%dara%’ B. SELECT * FROM tblclerk WHERE name == ‘%dara%’ C. SELECT * FROM tblclerk WHERE…
In SQL, which of the following syntax is correct about group by sid of tblclerk? A. SELECT COUNT(sid), gender FROM tblclerk B. SELECT COUNT(sid), gender FROM tblclerk IN GROUP gender C. SELECT COUNT(sid), gender FROM tblclerk GROUP BY gender D.…
In SQL, which is correct about order by name in table tblclerk? A. SELECT * FROM tblclerk ORDER BY name WHERE name = ‘dara’ B. SELECT * FROM tblclerk WHERE name = ‘dara’ ORDER name C. SELECT * FROM tblclerk…
In SQL, how to select multiple attributes from tblclerk? A. SELECT sid & name FROM tblclerk B. SELECT sid AND name FROM tblclerk C. SELECT sid, name FROM tblclerk D. None correct Answer: Option C
What syntax is correct to filter the seller’s name is not ‘dara’? A. SELECT * FROM tblclerk WHERE name != ‘dara’ B. SELECT * FROM tblclerk WHERE name >< 'dara' C. SELECT * FROM tblclerk WHERE name ‘dara’ D. None…
In SQL, What syntax is correct for filtering seller name’s dara or male? A. SELECT * FROM tblclerk WHERE name = ‘dara’ | gender = ‘male’ B. SELECT * FROM tblclerk WHERE name = ‘dara’ || gender = ‘male’ C.…
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…
KB Cambodia