SQL MCQs Kotak Mahindra - Motilal Nehru NIT (MNNIT) Allahabad

Problem Preview

"**Mode:** On-Campus **OA Date:** 2026-10-06 ## SQL MCQs – Business Intelligence ### Q1. Which command removes a table permanently? Options: - DELETE - REMOVE - TRUNCATE TABLE - DROP TABLE ### Q2. What is the difference between NVL and COALESCE? Options: - No difference - NVL accepts 2 arguments; COALESCE accepts multiple arguments - COALESCE accepts only 2 arguments - NVL is ANSI Standard ### Q3. Which index type is most commonly used? Options: - Bitmap - Clustered - Hash Cluster - B-Tree ### Q4. Which operator checks for a range of values? Options: - LIKE - BETWEEN - EXISTS - IN ### Q5. What is the output? ``` SELECT NVL('SQL', 'Oracle') FROM DUAL; ``` Options: - Oracle - SQL - NULL - Error ### Q6. What is the output? ``` SELECT LPAD('100', 5, '0') FROM DUAL; ``` Options: - `00100` - `00001` - `10000` - `01000` ### Q7. What is the output? ``` SELECT TO_CHAR( DATE '2024-02-01', 'DD-MM-YYYY' ) FROM DUAL; ``` Options visible in the screenshot: - `01-02-2024` - `01-FEB-24` - `01-FEB-24` (format may be duplicated or unclear) - `NULL` Note: The screenshot for Q7 is blurry, so the exact date format and options may need verification. ### Q8. What is the output? ``` SELECT TO_DATE( '31-02-2024', 'DD-MM-YYYY' ) FROM DUAL; ``` Options: - Error - `29-FEB-24` - `31-FEB-24` - NULL ## SQL Question: TRUNC Function and INNER JOIN ### Question 9: What does this return? ``` SELECT TRUNC( DATE '2024-10-25', 'Q' ) FROM DUAL; ``` Options shown in the screenshot: - 01-OCT-2024 - Error - 31-DEC-2024 - 25-OCT-2024 ### Question 2: What is the output of the following SQL query? Table A | ID1 | | --- | | 1 | | 1 | | 1 | Table B | ID1 | | --- | | 1 | | 1 | | 1 | ``` SELECT * FROM TableA A INNER JOIN TableB B ON A.ID = B.ID; ``` Options: 4, 8, 12, 16"