Question
Which single SQL constraint, when applied to a column, automatically enforces both uniqueness of values and a NOT NULL restriction, and is also used to uniquely identify each row of the table?
More SQL Questions
- Which SQL constraint ensures a column cannot have NULL values?
- Employees(emp_id, name, salary, mgr_id): (1,'Alice',9000,NULL), (2,'Bob',7000,1), (3,'Carol',9500,1), (4,'Dave',6000,2). What does the following self-join ...
- What will be the output of the following SQL query? SELECT COUNT(*) FROM Transactions WHERE Amount > 10000 AND Status = 'Completed';
- What is the result of SELECT COUNT(NULL) on any table?
- In database management, which SQL command is used to retrieve only unique (non-duplicate) values from a column?
- Which SQL keyword removes duplicate rows automatically from results?
- In SQL, what is the difference between 'WHERE' and 'HAVING' clauses?
- Which type of SQL JOIN returns only the rows that have matching values in both of the joined tables?
- What does the following query return? SELECT name FROM emp WHERE salary > ALL (SELECT salary FROM emp WHERE dept = 'HR');
- A table has a B-tree index on the 'Name' column. Which of the following queries is LEAST likely to benefit from this index?
Hey! Ask a query
Please enter email id
The email must be a valid email address.
Please enter Mobile Number
Please enter valid Mobile Number
Please enter your Doubt
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)