MCQ Questions Chapter 1 Querying and SQL Functions MCQs Class 12 Informatics Practices

Please refer to MCQ Questions Chapter 1 Querying and SQL Functions Class 12 Informatics Practices with answers provided below. These multiple-choice questions have been developed based on the latest NCERT book for class 12 Informatics Practices issued for the current academic year. We have provided MCQ Questions for Class 12 Informatics Practices for all chapters on our website. Students should learn the objective based questions for Chapter 1 Querying and SQL Functions in Class 12 Informatics Practices provided below to get more marks in exams.

Chapter 1 Querying and SQL Functions MCQ Questions

Please refer to the following Chapter 1 Querying and SQL Functions MCQ Questions Class 12 Informatics Practices with solutions for all important topics in the chapter.

Question. What is the full form of SQL?
a) Structured Query Language
b) Structured Query List
c) Simple Query Language
d) None of these

Question. Which of the following is not a valid SQL type?
a) FLOAT
b) NUMERIC
c) DECIMAL
d) CHARACTER

Question. SQL Views are also known as
a) Simple tables
b) Virtual tables
c) Complex tables
d) Actual Tables

Question. Which data manipulation command is used to combines the records from one or more tables?
a) SELECT
b) PROJECT
c) JOIN
d) PRODUCT

Question. If we have not specified ASC or DESC after a SQL ORDER BY clause, the following is used by default
a) DESC
b) ASC
c) There is no default value
d) None of the mentioned

Question. Which of the following is true about the HAVING clause?
a) Similar to the WHERE clause but is used for columns rather than groups.
b) Similar to WHERE clause but is used for rows rather than columns.
c) Similar to WHERE clause but is used for groups rather than rows.
d) Acts exactly like a WHERE clause.

Question. SQL applies conditions on the groups through _____ clause after groups have been formed,
a) Group by
b) With
c) Where
d) Having

Question. In SQL, which command is used to SELECT only one copy of each set of duplicable rows
a) SELECT DISTINCT
b) SELECT UNIQUE
c) SELECT DIFFERENT
d) All of the above

Question. By default, ORDER BY clause lists the results in _______ order.
a) Descending
b) Any
c) Same
d) Ascending

Question. Which SQL function is used to count the number of rows in a SQL query?
a) COUNT ()
b) NUMBER ()
c) SUM ()
d) COUNT (*)

Question. The default date format is
a) MM-DD-YYYY
b) YYYY-MM-DD
c) DD-MM-YYYY
d) None of these

Question. Which of the following function returns only date part from the given date/time argument?
a) DATE( )
b) CURDATE( )
c) DATECUR( )
d) None of these

Question. Which of the following performs a pre-defined task and returns some type of result?
a) Database
b) SQL function
c) Implementation
d) None of these

Question. Which command is used to change the definition of a table in SQL?
a) CREATE
b) UPDATE
c) ALTER
d) SELECT

Question. Which statement is true regarding procedures?
a) They include procedural and SQL statements.
b) They work similarly to the functions.
c) It does not need unique names.
d) It cannot be created with SQL statements.

Question. Name the host name used for signing in the database.
a) localhost
b) localpost
c) localcost
d) none of the above

Question. The term ____________ is used to refer to a field in a table.
a) Attribute
b) Tuple
c) Row
d) Instance

Question. Which of the SQL statements is correct?
a) SELECT Username AND Password FROM Users
b) SELECT Username, Password FROM Users
c) SELECT Username, Password WHERE Username = ‘user1’
d) None of these

Question. Which of the following SQL commands is used to retrieve data?
a) DELETE
b) INSERT
c) SELECT
d) JOIN

Question. The FROM SQL clause is used to…
a) Specify what table we are selecting or deleting data FROM
b) pecify range for search condition 
c) specify search condition 
d) None of these

Question. A relationship is formed via _______ that relates two tables where one table references other table’s key.
a) Candidate Key
b) Primary Key
c) Foreign Key
d) Check Constraint

Question. What is the meaning of Remark LIKE “%5%5%”;
a) Column Remark begin with two 5s
b) Column Remark ends with two 5s
c) Column Remark has more than two 5s
d) Column Remark has two 5s in it, at any position

Question. Which of the following types of table constraints will prevent the entry of duplicate rows?
a) Unique
b) Distinct
c) Primary Key
d) Null

Question. Which of the following must be enclosed in double-quotes?
a) Dates
b) Column Alias
c) Strings
d) All of the above

Question. Which of the following do you need to consider when you make a table in SQL?
a) Data types
b) Primary keys
c) Default values
d) All of the above.

Question. What is an SQL virtual table that is constructed from other tables
a) view
b) A relation
c) Just another table
d) Query results

Question. What SQL command can be used to delete columns from a table
a) MODIFY TABLE TableName DROP ColumnName
b) MODIFY TABLE TableName DROP COLUMN ColumnName
c) ALTER TABLE TableName DROP ColumnName
d) ALTER TABLE TableName DROP COLUMN ColumnName

Question. In SQL, which command(s) is are used to change a table’s storage characteristics
a) ALTER TABLE
b) MODIFY TABLE
c) CHANGE TABLE
d) All of the above