# 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

A

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

C

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

B

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

C

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

B

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.

C

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

D

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

A

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

D

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

D

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

B

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

A

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

B

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

C

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.

A

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

A

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

A

Question. Which of the SQL statements is correct?
d) None of these

B

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

C

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

A

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

C

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

D

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

A

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

B

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.

D

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

A

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