CBSE Class 12 - Informatics Practices - Database Query Using SQL (MCQs) #cbseclass12 #sql #database #eduvictors

CBSE Class 12 - Informatics Practices  - Database Query Using SQL (MCQs)

Q1. SQL part-language that facilitates defining creation/ modification etc. of database objects such as tables, indexes, sequences etc. is called?

A. DML

B. DCL

C. DDL

D. None of these

Q2. A ____ is a property of the entire relation, which ensures through its value that each tuple is unique in a relation.

A. Rows 

B. Key 

C. Attributes 

D. Fields

Q3. Which function accepts a character string as an input and provides character string or numeric values as an output?

A. Text 

B. Date

C. Time 

D. Math

Q4. Which of the following is a DDL command?

A. SELECT 

B. ALTER 

C. INSERT 

D. UPDATE

Q5. Which of the following types of table constraints will prevent the entry of duplicate rows?

A. Unique 

B. Distinct 

C. Primary Key 

D. Null

Q6. Write the output of the following SQL command. 

SELECT ROUND (47.89);

A. 47.88 

B. 47.8

C. 50

D. 48.0

Q7. Which operator can take wild card characters for query condition?

A. BETWEN 

B. LIKE 

C. IN 

D. NOT

Q8.  The default date format is

A. MM-DD-YYYY 

B. YYYY-MM-DD

C. DD-MM-YYYY 

D. None of these

Q9. Which of the following IS NOT an aggregate function in SQL 

A. AVERAGE() 

B. SUM() 

C. COUNT() 

D. CHAR()

Q10. Which of the following is not a text function?

A. TRIM () 

B. TRUNCATE() 

C. LEFT() 

D. MID 

Answers:

1. C. DDL

2. B. Key 

3. A. Text 

4. B. ALTER 

5. A. Unique 

6. D. 48.0

7. B. LIKE 

8. B. YYYY-MM-DD

9. D. CHAR()

10. B. TRUNCATE() 

 

👉See Also:

Informatics Practices Sample Question Paper with Marking Scheme (2016)
 Informatics Practices - Solved Sample Question Paper with Marking Scheme(2017-18)
 Informatics Practices - Sample Question Paper + Marking Scheme (2018-19)
 Informatics Practices Sample Question Paper with Marking Scheme (2020-21)
 Informatics Practices Sample Question Paper (Set-2) 2020-21

 Querying and SQL Functions (Worksheet)

 Database Concepts (Important Terms)

 SQL Commands (Summary)

Worksheet on Database Management Systems