Ch 28: Basic SQL SELECT Queries

Comprehensive querying tutorial, pattern matching with LIKE wildcards (% and _), sorting ascending/descending, and eliminating duplicates with DISTINCT.

16 Questions16 MCQs0 Short Questions0 Long Questions

🎯 Exam Practice Papers

CS403 - Database Management Systems Examination Practice

Timed practice exam simulation for CS403 - Database Management Systems.

Showing 11 – 16 of 16 Questions

Page 2 of 2

Q11

❓ MCQ📘 CS403📑 Lec 28🏷️ 28.3. Selecting All Columns (SELECT *)Easy🔁⭐💡📄🎓VU🏛️VU

Which of the following SQL SELECT queries correctly retrieves all columns and records from an employee table named 'EMP'?

💻 sql Snippet

SELECT * FROM EMP;

A.SELECT * FROM EMP;
B.SELECT emp* FROM EMP;
C.SELECT emp_id WHERE EMP;
D.SELECT * WHERE EMP;

Q12

❓ MCQ📘 CS403📑 Lec 28🏷️ 28.3. Selecting All Columns (SELECT *)Easy🔁⭐💡📄🎓VU🏛️VU

Which of the following SQL SELECT statements correctly retrieves all fields (columns) and rows from an employee table named 'EMP'?

💻 sql Snippet

SELECT * from EMP;

A.SELECT * from EMP;
B.SELECT emp* from EMP'
C.SELECT emp_id where EMP;
D.SELECT * where EMP;

Q13

❓ MCQ📘 CS403📑 Lec 28🏷️ 28.3. Selecting All Columns (SELECT *)Easy🔁⭐💡📄🎓VU🏛️VU

Which of the following SQL statements correctly retrieves all fields (columns) from an employee table named 'EMP'?

💻 sql Snippet

SELECT * from EMP;

A.SELECT * from EMP;
B.SELECT emp* from EMP'
C.SELECT emp_id where EMP;
D.SELECT * where EMP;

Q14

❓ MCQ📘 CS403📑 Lec 28🏷️ 28.3. Selecting All Columns (SELECT *)Easy🔁⭐💡📄🎓VU🏛️VU

Which of the following SQL statements correctly retrieves all columns and rows from an employee table named 'EMP'?

💻 sql Snippet

SELECT * FROM EMP;

A.SELECT * from EMP;
B.SELECT emp* from EMP;
C.SELECT emp_id where EMP;
D.SELECT * where EMP;

Q15

❓ MCQ📘 CS403📑 Lec 28🏷️ 28.3. Selecting All Columns (SELECT *)Easy🔁⭐💡📄🎓VU🏛️VU

Which of the following SQL statements represents the correct and standard query to retrieve all columns and rows from an employee table named 'EMP'?

💻 sql Snippet

SELECT * from EMP;

A.SELECT * from EMP;
B.SELECT emp* from EMP;
C.SELECT emp_id where EMP;
D.SELECT * where EMP;

Q16

📝 Short Q📘 CS403📑 Lec 28🏷️ 28.1. INSERT INTO CommandEasy🔁⭐💡📄🎓VU🏛️VU

Write the standard, basic SQL syntax of adding a new record to a database table, and explain both the explicit column specification method and the implicit positional value method.

💻 sql Snippet

INSERT INTO Student (stId, stName, cgpa) VALUES ('S1020', 'Sohail Dar', 3.2);