In this page we have given CBSE Board Class 12 Computer Science with Python Book Chapter Structure Query Language MCQ Question and Answer. All the questions below are important for our CBSE Champs.
- Board – CBSE.
- Class – 12
- Subject- Computer Science with Python.
- Topic- MCQ.
- Number of MCQ- 30.
1.) It is a standard language for accessing and manipulating databases.
a.) MS Excel
b.) MS Access
c.) SQL (Structured Query Language)
d.) DBMS
Ans – c.) SQL (Structured Query Language)
2.) These commands are used to create, transform and retrieve information from Relational Database Management Systems and is also used to create interface between user and database.
a.) SQL
b.) DBMS
c.) RDBMS
d.) None of these
Ans: – a.) SQL
3) This command is used for creating the structure of the table.
a.) CREATE TABLE
b.) MAKE TABLE
c.) FORM TABLE
d) ADD TABLE
Ans – a.) CREATE TABLE
4.) It is the constraint is SQL which checks a column cannot store a NULL value.
a.) NOT NULL
b.) NONE
c.) ZERO
d.) EMPTY
Ans – a.) NOT NULL
5) The command which is used to add rows in the table, but can add only one row at a time.
a.) ADD INTO
b.) INSERT INTO
c.) ENTER INTO
d.) All of these
Ans – b.) INSERT INTO
6.) It is the command that is used to view table information from SQL database.
a.) SHOW
b.) DISPLAY
c.) VIEW
d.) SELECT
Ans – d.) SELECT
7.) The operator takes two operands and performs a mathematical calculation on them.
a.) Arithmetic
b.) Relational
c.) Logical
d.) None of these
Ans – a.) Arithmetic
8.) This operator is used to implement comparison between two operands.
a.) Arithmetic
b.) Like
c.) Relational
d.) Logical
Ans – c.) Relational
9.) This operators are also possible only in where clause and are used merge more than one condition
a.) Like
b.) Arithmetic
c.) Relational
d.) Logical
Ans – d.) Logical
10.) …………………. operator is used to search a value similar to specific pattern in a column using wild card operator.
a.) Arithmetic
b.) Like
c.) Relational
d.) Logical
Ans – b.) Like
12.) The two wild card operators are ……………………… and ……………………
a.) ( + ) plus sign and ( –) minus sign
b.) ( * ) multiply sign and ( / ) division sign
c.) percentage sign (%) and underscore (_)
d.) dollar sign ($) and hash sign (#)
Ans – c.) percentage sign (%) and underscore (_)
12.) The operator that allows us to specify multiple values in WHERE clause
a.) IN
b.) ADD
c.) INSERT
d.) Like
Ans- a.) IN
13.) This operator is used to test whether or not a value (stated before the keyword
BETWEEN) is “between “ the two values stated after the keyword BETWEEN
a.) MIDDLE
b.) CENTER
c.) BETWEEN
d.) All of these
Ans – c.) BETWEEN
14.) The command which is used for arranging in ascending and descending order.
a.) Arrange
b.) order by
c.) sort
d.) sequence
Ans – b.) order by
15.) It is the functions which are used to implement calculation that is based upon a particular column and always returns a single value.
a.) Aggregate
b.) Simultaneous
c.) order by
d.) Max
Ans- a.) Aggregate
16.) The function that is used for finding the total value of a particular column.
a.) Total ()
b.) Sum ()
c.) Max ()
d.) Avg ()
Ans – b.) Sum ()
17.) The function that is used for finding the maximum value of a particular column
a.) Sum ()
b.) Min ()
c.) Avg ()
d.) Max ()
Ans- d.) Max ()
18.) The function that is used for finding the minimum value of a particular column.
a.) Sum ()
b.) Min ()
c.) Avg ()
d.) Max ()
Ans – b) Min ()
19.) The function which helps in finding the average of a particular column.
a.) Avg ()
b.) Min ()
c.) Max ()
d.) Sum ()
Ans – a.) Avg ()
20.) The column that is used for finding the number of values (i.e number of rows) of a particular column.
a.) Avg ()
b.) Count ()
c.) Today ()
d.) Min ()
Ans – b.) Count ()
21.) It is a clause which is used in collaboration with the SELECT statement to arrange identical data into groups)
a.) Group By
b.) Collected by
c.) Gathered by
d.) Arranged by
Ans –
22.) The clause that is used for placing a condition on the selected columns.
a.) Group By
b.) Where
c.) Having
d.) Distinct
Ans – b.) Where
23.) The clause that is used for placing a condition on groups created by groups by clause.
a.) Group By
b.) Where
c.) Having
d.) Distinct
Ans – c.) Having
24.) The Keyword that is used for removing duplicate values in a particular column.
a.) Distinct
b.) Update
c.) Where
d.) None of these
Ans – c.) Having
25.) This command is used to implement modification of the data values.
a.) Update
b.) Renew
c.) Upgrade
d.) All of these
Ans – a.) Update
26.) The command that is used for removing the information from a particular rows or rows.
a.) Delete
b.) Remove
c.) Clear
d.) Erase
Ans – a.) Delete
27.) The command that is used to implement modification of the structure of the table.
a.) Change table
b.) Alter Table
c.) Modify Table
d.) All of these
Ans- b.) Alter Table
28) The command that used for removing the entire structure of the table and information
a.) Remove table
b.) Delete Table
c.) Drop Table
d.) Clear Table
Ans – c.) Drop Table
29.) The ……………….. joins are used to give information in different tables.
a.) Equi
b.) Same
c.) Similar
d.) Original
Ans – a.) Equi
30.) It is a join in which we use only relational operators except equal operator.
a.) Non Equi
b.) Not Equi
c.) None Equi
d.) None of these
Ans – a.) Non Equi
Hope above Chapter Structure Query Language MCQ will help You. For any doubts please contact us. Our Computer Science Teacher will help You.