We are providing MCQs with answers for Class 12 Informatics Practices based on the NCERT Book for Standard 12 Commerce Informatics Practices. These questions are organized by chapter to assist students in self-assessment. Here you will find MCQ Questions for Class 12 Informatics Practices Chapter 1 Querying and SQL Functions.
Table of Contents
[PDF] Download MCQ Questions for Class 12 Informatics Practices Chapter 1 Querying and SQL Functions
As Multiple Choice Questions (MCQs) become increasingly crucial in the Class 12th Informatics Practices exam, it’s essential for students to review the provided MCQs and answers below. We offer a comprehensive collection of chapter-wise MCQs for Class 12 Informatics Practices, aligned with the latest NCERT textbooks. Explore the links below for chapter-specific practice questions.
Querying and SQL Functions MCQ
Question 1: All aggregate functions ignore NULLs except for the __ function.
(a) Distinct
(b) Count(*)
(c) Average()
(d) None of these
Show Answer
Ans. (a)Question 2: An aggregate function:
a) Takes a column name as its arguments
b) May take an expression as its argument
c) Both (a) and (b)
d) None of (a) and (b)
Show Answer
Ans. (c)Question 3: Which of the following are correct aggregate functions in SQL
(a) AVERAGE()
(b) MAX()
(c) COUNT()
(d) TOTAL()
Show Answer
Ans. (b) and (c)Question 4: Aggregate functions can be used in the select list or the _ clause of the select statement. They cannot be used in a __ clause.
(a) Where, having
(b) Having, where
(c) Group by, having
(d) Group by where
Show Answer
Ans. (c)Question 5: Identify the correct INSERT queries from the following :
(a) INSERT INTO Persons(‘xxx1’, ‘yyy1’);
(b) INSERT INTO Persons(LastName, FirstName) Values (‘xxx’, ‘yyy’);
(c) INSERT INTO Persons Values(‘xxx1’ , ‘yyy1’);
(d) INSERT INTO Persons Value(‘xxx1’ , ‘yyy1’);
Show Answer
Ans. (b) and (c)Question 6: What is the meaning of “HAVING” clause in SELECT query.
(a) To filter out the summary groups.
(b) To filter out the column groups.
(c) To filter out the row and column values.
(d) None of the mentioned.
Show Answer
Ans. (a)Question 7: What will be returned by the given query ?
SELECT INSTR(‘INDIA’, ‘DI’);
(a) 2
(b) 3
(c) -2
(d) -3
Show Answer
Ans. (b)Question 8: Which of the following is not a text function?
(a) TRIM ()
(b) TRUNCATE()
(c) LEFT()
(d) MID ()
Show Answer
Ans. (b)Question 9. Which of the following is the correct syntax of LCASE( ) function?
a) LCASE(row_name)
b) LCE(column_name)
c) LCASE(str/column_name)
d) None of the above
Show Answer
Ans. (c)Question 10: What will be returned by the given query?
SELECT month(‘2020-05-11’);
(a) 5
(b) 11
(c) May
(d) November
Show Answer
Ans. (a)Question 11: Which of the following will give the same answer irrespective of the NULL values
in the specified column:
a) MIN()
b) MAX()
c) SUM()
d) None of the above
Show Answer
Ans. (c)Question 12. The correct output of mysql>SELECT TRIM(LEADING ‘&’ FROM ‘&&& India &&& ‘);
a) India &&
b) India &&&
c) && India
d) &&& India
Show Answer
Ans. (b)Question 13: What will be returned by the given query?
SELECT ROUND(153.669,2);
(a) 153.6
(b) 153.66
(c) 153.67
(d) 153.7
Show Answer
Ans. (c)Question 14: HAVING is used in conjunction with
a) WHERE
b) GROUP BY clause
c) Aggregate functions
d) None of the above
Show Answer
Ans. (b)Question 15. What will be returned by the given query ? SELECT INSTR(‘INDIA’, ‘DI’);
a) 2
b) 3
c) −2
d) −3
Show Answer
Ans. (b)Question 16. What is the significance of the statement “HAVING COUNT (emp_id)>2” in the
following MySQL statement? SELECT name, COUNT (emp_id),emp_no FROM
department GROUP BY name HAVING COUNT (emp_id)>2;
a) Filter out all rows whose total emp_id below 2
b) Selecting those rows whose total emp_id>2
c) Both a) and b)
d) None of the mentioned
Show Answer
Ans. (c)Question 17. What will be the order of sorting in the following MySQL statement? SELECT
emp_id, emp_name FROM person ORDER BY emp_id, emp_name;
a) Sorting {emp_id, emp_name}
b) Sorting {emp_name, emp_id}
c) Sorting {emp_id} but not emp_name
d) None of the mentioned
Show Answer
Ans. (a)Question 18: JOIN in RDBMS refers to
a) Combination of multiple columns
b) Combination of multiple rows
c) Combination of multiple tables
d) Combination of multiple databases
Show Answer
Ans. (c)Question 19: Referential integrity
a) Must be maintained
b) Cannot be maintained
c) Is automatically maintained by databases
d) Should not be maintained
Show Answer
Ans. (a)Question 20. Find odd one out?
a) GROUP BY
b) DESC
c) ASC
d) ORDER BY
Show Answer
Ans. (a)Question 21. Which of the following function returns an integer that indicates the position of
the first occurrence of the sub-string within the string?
a) INSTR( )
b) RTRIM( )
c) LENGTH( )
d) TRIM( )
Show Answer
Ans. (a)Question 22: Equi-join is formed by equating
a) Foreign key with Primary key
b) Each row with all other rows
c) Primary key with Primary key
d) Two tables
Show Answer
Ans. (a)Question 23. In which function, NULL values are excluded from the result returned?
a) SUM()
b) MAX()
c) MIN()
d) All of these
Show Answer
Ans. (d)Question 24: In the FROM clause of a SELECT statement
a) Multiple Column Names are specified.
b) Multiple table names are specified
c) Multiple Column Names may be specified.
d) Multiple table names may be specified.
Show Answer
Ans. (a)Question 25. Which aggregate function returns the count of all rows in a specified table?
a) SUM()
b) DISTINCT()
c) COUNT()
d) None of these
Show Answer
Ans. (c)Question 26. Which of the following is not an aggregate function?
a) AVG()
b) ADD()
c) MAX()
d) COUNT()
Show Answer
Ans. (b)Question 27. Which of the following function converts the characters of an argument string to
the uppercase characters ?
a) UCASE( )
b) UPPER( )
c) Both (a) and (b)
d) None of the above
Show Answer
Ans. (c)Question 28. Which clause is used with an “aggregate functions”?
a) GROUP BY
b) SELECT
c) WHERE
d) Both (a) and (c)
Show Answer
Ans. (a)Question 29: Primary Key of a table can be
a) Defined at the time of table creation only.
b) Defined after table creation only.
c) Can be changed after table creation
d) Cannot be changed after table creation
Show Answer
Ans. (a)Question 30. What is the significance of “ORDER BY” in the following MySQL
statement? SELECT emp_id, fname, lname FROM person ORDER BY emp_id;
a) Data of emp_id will be sorted
b) Data of emp_id will be sorted in descending order
c) Data of emp_id will be sorted in ascending order
d) All of the mentioned
Show Answer
Ans. (c)Question 31: A Primary key column
a) Can have NULL values
b) Can have duplicate values
c) Both (a) and (b)
d) Neither (a) nor (b)
Show Answer
Ans. (d)Question 32: Two SELECT commands in a UNION
a) Should select same number of columns.
b) Should have different number of columns
c) Both (a) and (b)
d) Neither (a) nor (b)
Show Answer
Ans. (c)Question 33. What is the significance of the statement “GROUP BY d.name” in the following
MySQL statement? SELECT name, COUNT (emp_id), emp_no FROM department GROUP BY
name;
a) Counting of the field “name” on the table “department”
b) Aggregation of the field “name” of table “department”
c) Sorting of the field “name”
d) None of the mentioned
Show Answer
Ans. (b)Question 34. Which clause is similar to “HAVING” clause in MySQL?
a) SELECT
b) WHERE
c) FROM
d) None of the mentioned
Show Answer
Ans. (b)Chapter List
Chapter 1 Querying and SQL Functions MCQ Questions
Chapter 2 Data Handling using_Pandas – 1 MCQ Questions
Chapter 3 Data Handling using Pandas – II MCQ Questions
Chapter 4 Plotting Data using Matplotlib MCQ Questions
Chapter 5 Internet and Web MCQ Questions
Chapter 6 Societal Impacts MCQ Questions
Chapter 7 Project Based Learning MCQ Questions
Chapter 8 Extensible Markup Language MCQ Questions
Chapter 9 IT Applications MCQ Questions
Chapter 10 Web Application Development MCQ Questions
CBSE Class 12 Informatics Practices (IP) Syllabus
The Class 12 (2023-24) CBSE Informatics Practices Syllabus emphasizes the cultivation of computer science abilities and hands-on expertise among students. This syllabus encompasses diverse subjects such as Python-based data handling, SQL for database queries, an introduction to computer networks, and understanding the societal implications of technology. It is crafted to empower students with the skills and insights necessary for proficient information technology utilization in both personal and professional realms.
Class 12 IP Syllabus: Practical and Theory Components
CBSE Class 12 IP consists of both practical and theoretical components.
The practical component focuses on the learning of the students to apply their knowledge to solve real-world problems using programming languages, databases, and web development tools.
The theory component includes conceptual understanding, principles, and applications of Informatics Practices. Students are evaluated based on their performance in practical examinations and theory assessments.
Preparation Tips to Excel in CBSE Class 12 Informatics Practices (IP)
To excel in CBSE Class 12 Informatics Practices, students can employ these strategies:
- Conceptual Understanding: Instead of rote learning, prioritize grasping the core concepts. This will enable you to apply your knowledge effectively in practical situations.
- Regular Practice: Consistent programming practice is essential for honing your programming skills. Solve coding problems, undertake projects, and delve into real-world applications to gain hands-on proficiency.
- Review Previous Year Papers: Familiarize yourself with the question patterns and question types from past exams. Practicing with these papers will enhance your time management and problem-solving abilities.
- Collaboration and Discussion: Engage in group discussions or join study groups with peers. Teaching others and discussing various approaches can deepen your understanding and broaden your perspective.
- Stay Informed: Stay abreast of the latest developments in the realm of Informatics Practices. Follow tech blogs, subscribe to relevant newsletters, and explore emerging trends to stay at the forefront of this dynamic field.”
Hope this helps.
Happy Learning!
