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