In SQL, which of the following syntax is correct for the count cid? A. SELECT COUNT(cid), gender FROM tblstudent WHERE gender = ‘male’ B. SELECT COUNT(cid), gender FROM tblstudent GROUP BY gender = ‘male’ C. SELECT COUNT(cid), gender FROM tblstudent…
In SQL, which of the following syntax is correct about group by cid? A. SELECT COUNT(cid), gender FROM tblstudent B. SELECT COUNT(cid), gender FROM tblstudent IN GROUP gender C. SELECT COUNT(cid), gender FROM tblstudent GROUP BY gender D. None correct…
In SQL, which of the following syntax is correct about order by name? A. SELECT * FROM tblstudent ORDER BY name WHERE name = ‘sok’ B. SELECT * FROM tblstudent WHERE name = ‘sok’ ORDER name C. SELECT * FROM…
In SQL, how to select multiple attributes from tblstudent? A. SELECT cid & name FROM tblstudent B. SELECT cid AND name FROM tblstudent C. SELECT cid, name FROM tblstudent D. None correct Answer: Option C
What syntax is correct to filter the student’s name is not ‘sok’? A. SELECT * FROM tblstudent WHERE name != ‘sok’ B. SELECT * FROM tblstudent WHERE name >< 'sok' C. SELECT * FROM tblstudent WHERE name ‘sok’ D. None…
In SQL, What syntax is correct for filtering student name’s sok or male? A. SELECT * FROM tblstudent WHERE name = ‘sok’ | gender = ‘male’ B. SELECT * FROM tblstudent WHERE name = ‘sok’ || gender = ‘male’ C.…
What syntax is correct for filtering student name’s sok and male? A. SELECT * FROM tblstudent WHERE name = ‘sok’ & gender = ‘male’ B. SELECT * FROM tblstudent WHERE name = ‘sok’ && gender = ‘male’ C. SELECT *…
What is the correct syntax for SQL for theta join of tblstudent and tblregister? A. SELECT * FROM tblstudent C & tblregistering B WHERE C.cid = B.cid B. SELECT * FROM tblstudent C, tblregistering B WHERE C.cid = B.cid C.…
What code is correct in SQL language joining tblstudent and tblregister? A. SELECT * FROM tblstudent OUTER JOIN tblregister B. SELECT * FROM tblstudent C LEFT OUTER JOIN tblregister B ON C.cid = B.cid C. SELECT * FROM tblstudent LEFT…
What code is correct in SQL for joining tblstudent and tblregister? A. SELECT * FROM tblstudent JOIN tblregister B. SELECT * FROM tblstudent INNER JOIN tblregister ON tblstudent.cid = tblregister.cid C. SELECT * BETWEEN tblstudent AND tblregister ON tblstudent.cid =…
KB Cambodia