Assertion (A): We can retrieve records from more than one table in MYSQL.
Reason (R): Foreign key is used to establish a relationship between two tables.
Reason (R): Foreign key is used to establish a relationship between two tables.
Show Hint
and use JOIN to retrieve combined data.
- Both Assertion (A) and Reason (R) are true and Reason (R) is the correct explanation for Assertion (A).
- Both Assertion (A) and Reason (R) are true and Reason (R) is not the correct explanation for Assertion (A).
- Assertion (A) is true but, Reason (R) is false.
- Assertion (A) is false but, Reason (R) is true.
The Correct Option is B
Solution and Explanation
using operations like JOIN, which combines rows based on related columns.
So, Assertion (A) is true.
A foreign key is a field in one table that refers to the primary key of another table,
which helps to establish a relationship between them — so Reason (R) is true too.
However, the foreign key does not itself perform the retrieval;
it only defines how tables relate.
The actual retrieval is done using queries like JOIN statements.
Therefore, Reason (R) is true but not the correct explanation for Assertion (A).
So, option (B) is correct.
Top Questions on SQL
- Write a function
Delete_Theatre()to input the value of Th_ID from the user and permanently delete the corresponding record from the THEATRE table in the CINEMA database.
Given:
Host: localhost, User: root, Password: Ex2025
Assume that you are working in the IT Department of a Creative Art Gallery (CAG), which sells different forms of art creations like Paintings, Sculptures etc. The data of Art Creations and Artists are kept in tables Articles and Artists respectively. Following are few records from these two tables:
(i) To display all the records from the Articles table in descending order of Price.
(ii) To display the details of Articles which were created in the year 2020.
(iii) To display the structure of the Artists table.
(iv-a) To display the name of all artists whose Article is Painting using Equi Join.
(iv-b) To display the name of all artists whose Article is 'Painting' using Natural JoinSuman has created a table named WORKER with a set of records to maintain the data of the construction sites, which consists of WID, WNAME, WAGE, HOURS, TYPE, and SITEID. After creating the table, she entered data in it, which is as follows :
- Nisha is assigned the task of maintaining the staff data of an organization. She has to store the details of the staff in the SQL table named EMPLOYEES with attributes as EMPNO, NAME, DEPARTMENT, BASICSAL to store Employee’s Identification Number, Name, Department, and Basic Salary respectively. There can be two or more Employees with the same name in the organization.
(i)
(a) Help Nisha to identify the attribute which should be designated as the PRIMARY KEY. Justify your answer.
OR
(b) Help Nisha to identify the constraint which should be applied to the attribute NAME such that the Employees’ Names cannot be left empty or NULL while entering the records but can have duplicate values.
(ii)
(a) Write the SQL command to change the size of the attribute BASICSAL in the table EMPLOYEES to allow the maximum value of 99999.99 to be stored in it.
OR
(b) Write the SQL command to delete the table EMPLOYEES. - Which aggregate function in SQL displays the number of values in the specified column ignoring the NULL values?
Questions Asked in CBSE CLASS XII exam
- A coil of 60 turns and area \( 1.5 \times 10^{-3} \, \text{m}^2 \) carrying a current of 2 A lies in a vertical plane. It experiences a torque of 0.12 Nm when placed in a uniform horizontal magnetic field. The torque acting on the coil changes to 0.05 Nm after the coil is rotated about its diameter by 90°. Find the magnitude of the magnetic field.
- CBSE CLASS XII - 2025
- Magnetism and matter
- Determine the values of $x$ for which the function $f(x) = \frac{x-4}{x+1}$ is an increasing or a decreasing function.
- CBSE CLASS XII - 2025
- Application of derivatives
Complete and balance the following chemical equations: (a) \[ 2MnO_4^-(aq) + 10I^-(aq) + 16H^+(aq) \rightarrow \] (b) \[ Cr_2O_7^{2-}(aq) + 6Fe^{2+}(aq) + 14H^+(aq) \rightarrow \]
- CBSE CLASS XII - 2025
- Redox Reactions
- Two wires of the same material and the same radius have their lengths in the ratio 2:3. They are connected in parallel to a battery which supplies a current of 15 A. Find the current through the wires.
- CBSE CLASS XII - 2025
- Current electricity
- Arun, Bashir and Joseph were partners in a firm sharing profits and losses in the ratio of 5 : 3 : 2. They admitted Daksh as a new partner who acquired his share entirely from Arun. If Arun sacrificed \( \frac{1}{5} \)th from his share to Daksh, Daksh's share in the profits of the firm will be :
- CBSE CLASS XII - 2025
- Partnership Accounts