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 1 – 10 of 16 Questions

Page 1 of 2

❓ MCQ📘 CS403📑 Lec 28🏷️ 28.2. Select StatementEasy🔁⭐💡📄🎓VU🏛️VU

Which of the following clauses, keywords, or constraints is NOT related to or a part of the basic SQL SELECT statement structure?

💻 sql Snippet

SELECT stId, stName FROM Student WHERE cgpa >= 3.0;

A.SELECT
B.NOT NULL
C.WHERE
D.FROM

❓ MCQ📘 CS403📑 Lec 28🏷️ 28.2. Select StatementEasy🔁⭐💡📄🎓VU🏛️VU

Which of the following statements is true regarding the use of the DISTINCT keyword in a SQL SELECT statement?

💻 sql Snippet

SELECT DISTINCT prName FROM student;

A.It is used with DDL commands to enforce unique constraints during table creation
B.It removes duplicate values from the query result set output
C.It permanently deletes duplicate columns from the physical table schema
D.It forces columns to reject NULL values during database insertion

❓ MCQ📘 CS403📑 Lec 28🏷️ 28.1. Insert Statement SyntaxEasy🔁⭐💡📄🎓VU🏛️VU

The INSERT INTO statement in SQL is used to enter values into which of the following column scopes by default when the column list is omitted?

💻 sql Snippet

INSERT INTO course 
VALUES ('CS-211', 'Operating Systems', 4, 'MCS');

A.Not null columns only
B.Only a particular column
C.All columns
D.Key value columns only

❓ MCQ📘 CS403📑 Lec 28🏷️ 28.1. Insert Statement SyntaxEasy🔁⭐💡📄🎓VU🏛️VU

Which of the following SQL Data Manipulation Language statements represents the correct syntactical structure for inserting values into explicit columns of an 'employee' table?

💻 sql Snippet

INSERT into employee (col1, col2, col3) VALUES (val1, val2, val3)

A.INSERT into employee COLUMN (col1, col2, col3) VALUES (val1, val2, val3)
B.INSERT into (col1, col2, col3) VALUES (val1, val2, val3)
C.INSERT into employee (col1, col2, col3), (val1, val2, val3)
D.INSERT into employee (col1, col2, col3) VALUES (val1, val2, val3)

❓ MCQ📘 CS403📑 Lec 28🏷️ 28.2. Select StatementEasy🔁⭐💡📄🎓VU🏛️VU

Which of the following clauses, keywords, or constraints is NOT a part of the basic SQL SELECT statement structure?

💻 sql Snippet

SELECT stId, stName 
FROM student 
WHERE cgpa >= 3.0;

A.WHERE
B.SELECT
C.NOT NULL
D.FROM

❓ MCQ📘 CS403📑 Lec 28🏷️ 28.1. Insert Statement SyntaxEasy🔁⭐💡📄🎓VU🏛️VU

Which of the following SQL Data Manipulation Language (DML) statements is standardly used to insert and enter values into table columns?

💻 sql Snippet

INSERT INTO course 
VALUES ('CS-211', 'Operating Systems', 4, 'MCS');

A.ENTER INTO
B.INSERT TOP
C.PUT INTO
D.INSERT INTO

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

What will be the precise output of executing the SQL statement 'SELECT * FROM student;' on a relational database table?

💻 sql Snippet

SELECT * FROM student;

A.Display only the row values of the student table without their column headers
B.Display only the column names and metadata of the student table
C.Display all the column headers without retrieving any individual row instances
D.Display all rows and all columns of the student table

❓ MCQ📘 CS403📑 Lec 28🏷️ 28.1. Insert Statement SyntaxEasy🔁⭐💡📄🎓VU🏛️VU

The INSERT INTO statement in SQL is used to enter values into which of the following column scopes by default when the target column list is omitted?

💻 sql Snippet

INSERT INTO course VALUES ('CS-211', 'Operating Systems', 4, 'MCS');

A.Only particular column
B.All columns
C.Not null columns only
D.Key value columns only

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

Which of the following SQL queries 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;

Q10

❓ MCQ📘 CS403📑 Lec 28🏷️ 28.2. Select StatementMedium🔁⭐💡📄🎓VU🏛️VU

You are working with a 'STUDENT' table defined with the attributes: 'stId', 'stName', 'stPhone', 'cgpa', and 'stAdr' (address). Write the most efficient and recommended SQL query to retrieve and display all column values of the student table EXCEPT the address ('stAdr') column.

💻 sql Snippet

SELECT stId, stName, stPhone, cgpa FROM STUDENT;

A.SELECT stId, stName, stPhone, cgpa FROM STUDENT;
B.SELECT * EXCEPT stAdr FROM STUDENT;
C.SELECT ALL - stAdr FROM STUDENT;
D.SELECT stId, stName, stPhone, cgpa,!stAdr FROM STUDENT;

Ch 28: Basic SQL SELECT Queries

CS403 - Database Management Systems Examination Practice

Mid Term Examination

Final Term Examination

CS403 - Database Management Systems Examination Practice

Mid Term Examination

Final Term Examination

📖 Related CS403 - Database Management Systems Curriculum Units