- Super Key: A set of one or more attributes that, taken collectively, uniquely identify a tuple in a relation. - Candidate Key: A minimal super key. This means that no proper subset of a candidate key is a super key. - Primary Key: One of the candidate keys chosen by the database designer to uniquely identify tuples.
Which of the following statement is true with regards to candidate keys and super keys? - Every super key is a candidate key. - Candidate keys must contain all attributes of the relation. - Candidate keys are minimal super key with no redundant attributes. - A candidate key must include a foreign key. - Question not attempted
Asked in Analyst Cum Programmer (Deputy Director) 2024 · Topic: Basics of Computers and Information Technology (Database Management Systems (DBMS) Basics: Concepts, Types of Databases)
More Information and Communication Technology questions
- Under which of the following conditions, a SQL view is said to be updatable? - The FROM clause has more than one database relation. - The SELECT clause contains only attribute names (no expressions, aggregates or DIS‐ TINCT). - Any attribute not listed in SELECT clause can be set to NULL and is not part of primary key. - The query does not use GROUP BY or HAVING. Select the correct combination using the code below - (1) (A), (B), (C) and (D) (2) (A), (B) and (D) only (3) (B), (C) and (D) only (4) (A) and (B) only (5) Question not attempted
- Consider a database table - Studentcourses(Student_Id, Student_Name, Course_Id, Course_Name, Instructor_Name) If a new course "XYZ123" is required to be introduced but none of the students have enrolled for it yet then which amongst the following problems will the database face? - Updation anomaly - View anomaly - Deletion anomaly - Insertion anomaly - Question not attempted
- What is the primary goal of query optimization in a DBMS? - To encrypt data during query execution - To validate query syntax - To normalize the database schema - To find the most efficient and cost-effective way to execute a query - Question not attempted
- In M.S. Excel, column in a table is called as
- Tag 260 in MARC-21 marks :
- By which entry you will get main information about a book ?
- What "BT" symbol denotes in SEARS list of Subject Headings ?
- How will you represent time period 1987 to 2019 in colon classification scheme?
All 1,360 Information and Communication Technology questions →