Question 1

Question 1Assertion (A): A database can have only one table in MySql.Reasoning (R): If a piece of data is stored in two places in the databases, then storage space is wasted.Both A and R are true and R is the correct explanation of A.Both A and R are true but R is not the correct explanation of A.A is true but R is false.A is false but R is true.

Accepted Answer

A is false but R is true.ExplanationA database can have multiple tables. Data redundancy, which occurs when the same data is repeated in multiple places within a database, leads to wastage of storage space. A DBMS eliminates data redundancy by integrating files, ensuring that multiple copies of the same data are not stored.

Question 2

Question 2Assertion (A): A database constraint can be added or removed any time in/from the database tables.Reasoning (R): Alter table command is used to change the structure of the table.Both A and R are true and R is the correct explanation of A.Both A and R are true but R is not the correct explanation of A.A is true but R is false.A is false but R is true.

Accepted Answer

Both A and R are true but R is not the correct explanation of A.ExplanationA database constraint can be added or removed from database tables using the ALTER TABLE command, even after the table has already been created. This command is used to modify the structure of a table by altering the definition of its columns.

Question 3

Question 3Assertion (A): SQL has efficient mechanisms to retrieve data stored in multiple tables in a MySQL database.Reasoning (R): The SQL statement CREATE is used to retrieve data from the tables in a database and is also called query statement.Both A and R are true and R is the correct explanation of A.Both A and R are true but R is not the correct explanation of A.A is true but R is false.A is false but R is true.

Accepted Answer

A is true but R is false.ExplanationSQL provides efficient mechanisms, such as JOIN operations, to retrieve data from multiple tables in a MySQL database. The SQL statement CREATE is used to create new database objects such as tables, indexes, or views. The SELECT statement is used to retrieve data from tables in a database and is known as a query statement.

Question 4

Question 4Assertion (A): The SQL keyword Like is used with wildcards only.Reasoning (R): '_' underscore and "%" per cent are the two wildcard characters used with LIKE clause.Both A and R are true and R is the correct explanation of A.Both A and R are true but R is not the correct explanation of A.A is true but R is false.A is false but R is true.

Accepted Answer

Both A and R are true and R is the correct explanation of A.ExplanationThe SQL LIKE keyword allows the use of wildcard characters to perform pattern matching. SQL provides two wildcard characters to use with the LIKE operator: the percent sign (%) which matches any string, and the underscore ("_") which matches any single character.

Question 5

Question 5Assertion (A): DISTINCT clause must be used in an SQL statement to eliminate duplicate rows.Reasoning (R): DISTINCT works with numeric data type only.Both A and R are true and R is the correct explanation of A.Both A and R are true but R is not the correct explanation of A.A is true but R is false.A is false but R is true.

Accepted Answer

A is true but R is false.ExplanationThe DISTINCT clause is used to remove duplicate rows from the results of a SELECT statement. It retrieves only unique values for a column in the table. The DISTINCT keyword in SQL can be used with any data type.

Question 6

Question 12Identify the correct statement(s):Statement 1 (S1): Char data-type in MySQL stores fixed length strings.Statement 2 (S2): Char data-type stores string smaller than the maximum field size.(S1) : Correct, (S2) : Correct(S1) : Incorrect, (S2) : Correct(S1) : Correct, (S2) : Incorrect(S1) : Incorrect, (S2) : Incorrect

Accepted Answer

(S1) : Correct, (S2) : IncorrectReason — The CHAR data type provides fixed-length memory storage. It specifies a fixed-length character string. If the input string is shorter, MySQL pads it with spaces to fill the fixed length. If the input string is longer, it is truncated to fit the fixed length.

Question 7

Question 14The SQL statements always end with ............... .,:;"

Accepted Answer

;Reason — The SQL statements always end with semicolon (;).

Source: This question is from Structured Query Language (SQL), Informatics Practices &mdash; Class 11, CBSE Board.
Key Concepts CoveredThis question tests your understanding of the following concepts from the chapter Structured Query Language (SQL): Question, Sql, Statements, End, Structured Query Language (SQL), Informatics Practices. These are fundamental topics in Informatics Practices that students are expected to master as part of the CBSE Class 11 curriculum.A thorough understanding of these concepts will help you answer similar questions confidently in your CBSE examinations. These topics are frequently tested in both objective and subjective sections of Informatics Practices papers. We recommend revising the relevant section of your textbook alongside practising these solved examples to build a strong foundation.
How to Approach MCQsMultiple choice questions test your ability to quickly recall facts and apply concepts. Read all options carefully before selecting your answer. Use the process of elimination to rule out clearly incorrect options first. If two options seem similar, look for the subtle difference that makes one more accurate. For numerical MCQs, verify your answer by substituting it back into the problem.
Key Points to RememberRead the question carefully and identify all parts before answering.
Use the terminology specific to this subject and chapter.
Review the textbook content for this chapter before attempting questions.
Practice writing concise, well-structured answers within time limits.
Related Questions from Structured Query Language (SQL)Q1: Question 1 Assertion (A): A database can have only one table in MySql. Reasoning (R): If a piece of...
Q11: Question 8 Differentiate between char and varchar data types.
Q12: Question 12 Identify the correct statement(s): Statement 1 (S1): Char data-type in MySQL stores...
Q13: Question 10 How would you calculate 13*15 in SQL?
Q15: Question 12 Write SQL queries to perform the following based on the table Product having fields as...
Practice more questions from Structured Query Language (SQL) &mdash; Informatics Practices, Class 11 CBSE

Question 8

Question 16Rajat wants to delete a primary key constraint from the table. Select an appropriate command to do so.CreateAlterDropDelete

Accepted Answer

AlterReason — The ALTER TABLE command is used to delete a primary key constraint from the table.

Source: This question is from Structured Query Language (SQL), Informatics Practices &mdash; Class 11, CBSE Board.
Key Concepts CoveredThis question tests your understanding of the following concepts from the chapter Structured Query Language (SQL): Question, Rajat, Wants, Delete, Primary, Key. These are fundamental topics in Informatics Practices that students are expected to master as part of the CBSE Class 11 curriculum.A thorough understanding of these concepts will help you answer similar questions confidently in your CBSE examinations. These topics are frequently tested in both objective and subjective sections of Informatics Practices papers. We recommend revising the relevant section of your textbook alongside practising these solved examples to build a strong foundation.
How to Approach MCQsMultiple choice questions test your ability to quickly recall facts and apply concepts. Read all options carefully before selecting your answer. Use the process of elimination to rule out clearly incorrect options first. If two options seem similar, look for the subtle difference that makes one more accurate. For numerical MCQs, verify your answer by substituting it back into the problem.
Key Points to RememberRead the question carefully and identify all parts before answering.
Use the terminology specific to this subject and chapter.
Review the textbook content for this chapter before attempting questions.
Practice writing concise, well-structured answers within time limits.
Related Questions from Structured Query Language (SQL)Q1: Question 1 Assertion (A): A database can have only one table in MySql. Reasoning (R): If a piece of...
Q11: Question 8 Differentiate between char and varchar data types.
Q12: Question 12 Identify the correct statement(s): Statement 1 (S1): Char data-type in MySQL stores...
Q13: Question 10 How would you calculate 13*15 in SQL?
Q14: Question 14 The SQL statements always end with ............... . , : ; "
Practice more questions from Structured Query Language (SQL) &mdash; Informatics Practices, Class 11 CBSE

Question 9

Question 17Rajveer wants to rename column in display result for his query. Select the appropriate query for the same:Select Ename, Salary*12 Annual Salary From Emp;Select Ename, Salary*12 Rename "Annual Salary" From Emp;Select Ename, Salary* 12 Change "Annual Salary" From Emp;Select Ename, Salary*12 as "Annual Salary" From Emp;

Accepted Answer

Select Ename, Salary*12 as "Annual Salary" From Emp;Reason — The AS keyword is used to give an alias to a column or expression in the SELECT statement. In this case, AS "Annual Salary" is used to rename the column Salary*12 to "Annual Salary" in the display result.

Question 10

Question 18The symbol Asterisk (*) in a select query retrieves ............... .All data from the tableData of primary key onlyNULL dataNone of these

Accepted Answer

All data from the tableReason — The asterisk symbol (*) is a wildcard character in SQL that retrieves all columns or fields from a table. When used in a SELECT statement, it returns all columns and rows from the specified table.

Question 11

Question 19Consider the attributes ( RollINumber, SName, SDateofBirth, GUID ) of the table Student. According to you, which of the following options is the correct representation of the table after executing the following query?Insert Into Student (RollNumber, SName, SDateofBirth) 
Values (2, 'Sudha', '2002-02-28') ;  
(i)RollNumberSNameSDateofBirthGUID1Atharv2003-05-15123548992Sudha2002-02-28NULL(ii)RollNumberSNameSDateofBirthGUID1Atharv2003-05-15123548992Sudha2002-02-2800000000(iii)RollNumberSNameSDateofBirthGUID1Atharv2003-05-15123548992Sudha2002-02-2800000000(iv)RollNumberSNameSDateofBirthGUID1Atharv2003-05-15123548992Sudha2002-02-28

Accepted Answer

RollNumberSNameSDateofBirthGUID1Atharv2003-05-15123548992Sudha2002-02-28NULLReason — In the above code, a new row is inserted into the 'Student' table, values are provided for RollNumber, SName, and SDateofBirth, but not for GUID. Since GUID is not specified, it will take on its default value, which may be NULL if no default value is defined for the column.

Question 12

Question 20Consider a table Student having two fields—FName varchar(20) and LName char(20). If in a record, value stored in Fname is 'Anuj' and LName is 'Batra', then FName and LName will consume ...............and ............... Character space, respectively.4, 54, 2020, 420, 20

Accepted Answer

4, 20Reason — FName is a varchar(20) field, which means it can store a variable-length string up to a maximum of 20 characters. Since the value stored in FName is 'Anuj', it will consume 4 character spaces (A-n-u-j). LName is a char(20) field, which means it is a fixed-length string that always occupies 20 character spaces, regardless of the actual length of the string. Since the value stored in LName is 'Batra', it will still consume 20 character spaces, with the remaining 15 characters being padded with spaces.

Question 13

Question 3What do you understand by the terms candidate key and alternate key in relational database?

Accepted Answer

All attribute combinations inside a relation that can serve as primary key are candidate keys as they are candidates for the primary key position.A candidate key that is not the primary key is called an alternate key. In other words, any attribute that is a candidate for the primary key, i.e., which is capable of becoming a primary key but is not a primary key, is an alternate key.

Question 14

Question 4What is SQL? What are the different categories of commands available in SQL?

Accepted Answer

SQL (Structured Query Language) is a standard language for accessing and manipulating databases.The different categories of SQL commands are as follows:Data Definition Language (DDL) CommandsData Manipulation Language (DML) CommandsData Query Language (DQL) commandData Control Language (DCL) commandsTransaction Control Language (TCL) Commands

Question 15

Question 5What is a database system? What is its need?

Accepted Answer

A Database Management System is a general purpose software system that facilitates the process of defining, constructing and manipulating databases for various applications. The database system is used to eliminate the problems of data redundancy and data inconsistency.

Question 16

Question 6Differentiate between DDL and DML commands.

Accepted Answer

Data Definition Language (DDL)Data Manipulation Language (DML)DDL provides a set of definitions to specify the storage structure and access methods used by the database system.DML is a language that enables users to access or manipulate data as organized by the appropriate data model.DDL commands are used to perform tasks such as creating, altering, and dropping schema objects. They are also used to grant and revoke privileges and roles, as well as for maintenance commands related to tables.DML commands are used to retrieve, insert, delete, modify data stored in the database.Examples of DDL commands are CREATE, ALTER, DROP, GRANT, ANALYZE etc.Examples of DML commands are INSERT, UPDATE, DELETE, SELECT etc.

Question 17

Question 7What is a data type? Name some data types available in MySQL.

Accepted Answer

Data types are means to identify the type of data and associated operations for handling it. The data types available in MySQL are int, float, date, time, char, varchar etc.

Source: This question is from Structured Query Language (SQL), Informatics Practices &mdash; Class 11, CBSE Board.
Key Concepts CoveredThis question tests your understanding of the following concepts from the chapter Structured Query Language (SQL): Question, Data, Available, Mysql, Structured Query Language (SQL), Informatics Practices. These are fundamental topics in Informatics Practices that students are expected to master as part of the CBSE Class 11 curriculum.A thorough understanding of these concepts will help you answer similar questions confidently in your CBSE examinations. These topics are frequently tested in both objective and subjective sections of Informatics Practices papers. We recommend revising the relevant section of your textbook alongside practising these solved examples to build a strong foundation.
How to Approach This QuestionRead the question carefully and identify what is being asked. Break down complex questions into smaller parts. Use the terminology and concepts discussed in this chapter. Structure your answer logically — begin with a definition or key statement, then provide supporting details. Review your answer to ensure it addresses all parts of the question completely.
Key Points to RememberRead the question carefully and identify all parts before answering.
Use the terminology specific to this subject and chapter.
Review the textbook content for this chapter before attempting questions.
Practice writing concise, well-structured answers within time limits.
Related Questions from Structured Query Language (SQL)Q1: Question 1 Assertion (A): A database can have only one table in MySql. Reasoning (R): If a piece of...
Q11: Question 8 Differentiate between char and varchar data types.
Q12: Question 12 Identify the correct statement(s): Statement 1 (S1): Char data-type in MySQL stores...
Q13: Question 10 How would you calculate 13*15 in SQL?
Q14: Question 14 The SQL statements always end with ............... . , : ; "
Practice more questions from Structured Query Language (SQL) &mdash; Informatics Practices, Class 11 CBSE

Question 18

Question 8Differentiate between char and varchar data types.

Accepted Answer

Char datatypeVarchar datatypeChar datatype specifies a fixed length string.Varchar datatype specifies a variable length string.Defining a length is not required, but the default is 1.Defining a length is required.CHAR(n) ensures that all values stored in that column are of length n bytes, padding shorter values with blanks while maintaining a fixed size of n bytes.VARCHAR(n) columns have a maximum size of n bytes, storing values exactly as specified without adding blanks for shorter lengths. Exceeding n bytes results in an error message.

Question 19

Question 10How would you calculate 13*15 in SQL?

Accepted Answer

To calculate 13 * 15 in SQL, we can use SELECT statement to retrieve rows computed without reference to any table. For example,mysql> SELECT 13 * 15;

Source: This question is from Structured Query Language (SQL), Informatics Practices &mdash; Class 11, CBSE Board.
Key Concepts CoveredThis question tests your understanding of the following concepts from the chapter Structured Query Language (SQL): Question, Sql, Structured Query Language (SQL), Informatics Practices. These are fundamental topics in Informatics Practices that students are expected to master as part of the CBSE Class 11 curriculum.A thorough understanding of these concepts will help you answer similar questions confidently in your CBSE examinations. These topics are frequently tested in both objective and subjective sections of Informatics Practices papers. We recommend revising the relevant section of your textbook alongside practising these solved examples to build a strong foundation.
How to Approach This QuestionRead the question carefully and identify what is being asked. Break down complex questions into smaller parts. Use the terminology and concepts discussed in this chapter. Structure your answer logically — begin with a definition or key statement, then provide supporting details. Review your answer to ensure it addresses all parts of the question completely.
Key Points to RememberRead the question carefully and identify all parts before answering.
Use the terminology specific to this subject and chapter.
Review the textbook content for this chapter before attempting questions.
Practice writing concise, well-structured answers within time limits.
Related Questions from Structured Query Language (SQL)Q1: Question 1 Assertion (A): A database can have only one table in MySql. Reasoning (R): If a piece of...
Q11: Question 8 Differentiate between char and varchar data types.
Q12: Question 12 Identify the correct statement(s): Statement 1 (S1): Char data-type in MySQL stores...
Q14: Question 14 The SQL statements always end with ............... . , : ; "
Q15: Question 12 Write SQL queries to perform the following based on the table Product having fields as...
Practice more questions from Structured Query Language (SQL) &mdash; Informatics Practices, Class 11 CBSE

Question 20

Question 12Write SQL queries to perform the following based on the table Product having fields as (prod_id, prod_name, quantity, unit_rate, price, city)(a) Display those records from table Product where prod_id is more than 100.(b) List records from table Product where prod_name is 'Almirah'.(c) List all those records whose price is between 200 and 500.(d) Display the product names whose quantity is not given.(e) Show the detailed records in the table Product.

Accepted Answer

(a)SELECT * FROM PRODUCT
WHERE prod_id > 100;(b)SELECT * FROM PRODUCT
WHERE prod_name = 'Almirah';(c)SELECT * FROM PRODUCT
WHERE price BETWEEN 200 AND 500; (d)SELECT prod_name
FROM PRODUCT
WHERE quantity IS NULL;(e)SELECT * FROM PRODUCT;

Structured Query Language (SQL)

Assertions And Reasons

Multiple Choice Questions

Solutions To Unsolved Questions