Login / Signup

Question

What is the main function of a "foreign key" in a relational database table?

A It establishes and enforces a link to a primary key in another table

B It uniquely identifies each record within its own table and cannot have null values

C It automatically encrypts sensitive columns in the table

D It speeds up query execution by indexing every column

E It prevents any updates from being made to the table

Practice Next

More SQL Questions

What is the difference between DELETE, TRUNCATE, and DROP commands in SQL?
Table Employee(EmpID, ManagerID) has 6 rows: (1,NULL), (2,1), (3,1), (4,2), (5,2), (6,3). How many rows will the following self-join return? SELECT E.EmpI...
Which clause is used to sort query results in SQL?
Which SQL keyword prevents duplicate rows in result?
Materialized views differ from normal views because:
SQL Injection can be prevented by all EXCEPT:
Which query returns departments whose average salary is greater than 60000?
A table emp has salaries 50, 70, 70, 90, 90. What does the following query return? SELECT MAX(salary) FROM emp WHERE salary < (SELECT MAX(salary) FROM...
In SQL, what is the primary purpose of the GROUP BY clause?
A view is defined as: CREATE VIEW V AS SELECT dept_id, AVG(salary) AS avg_sal FROM Employees GROUP BY dept_id; Can this view be used directly in an UPDATE ...

Hey! Ask a query

ask-question

🎓

Think You're Ready for RBI Grade B?

RBI Grade B 2026 Phase 1 Memory Based Paper

200 Questions with Detailed Solutions
Section-wise Coverage (GA, English, Quant & Reasoning)

Download Now 100% Free PDF