Database Table Constraints and Duplicate Rows
Which of following types of table constraints will prevent the entry of duplicate rows:
مندرجہ ذیل میں سے کون سی قسم کی جدول کی رکاوٹیں ڈپلیکیٹ قطاروں کے اندراج کو روکیں گی:
Answer: Unique
Explanation
A unique constraint is a rule that forbids duplicate values in one or more columns within a table. Unique and primary keys are the supported unique constraints.
This question appeared in
Past Papers (3 times)
PPSC 5 Years Past Papers Subject Wise (Solved with Details) (2 times)
PPSC Past Papers (1 times)
This question appeared in
Subjects (1 times)
COMPUTER (1 times)
Related MCQs
- Which type of join returns all rows from both tables, matching rows from the left table, and NULL values for non-matching rows from the right table?
- Functional dependencies are the types of constraints that are based on _____?
- In Excel, The rows of a table correspond to _____?
- In a database, how you can determine location of rows in a table?
- In the periodic table, rows is considered to be a ____?
- To create table of columns and rows for statistical or mathematical calculation using spreadsheet, which software is used?
- We can prevent deaths and injuries on the road. (Here antonym of PREVENT is)
- Assuming a single journal entry is made to adjust Quinn Company's accounting records at January 31, the journal entry includes ______?
- Which of the following function rotate the contents of columns to rows and rows to columns in Microsoft Excel?
- During the school assembly, 105 students are standing in 7 rows. How many students are there in 2 rows?
