What is an alternate key? MCQ with Answer and Explanation

Question
What is an alternate key?
A. A super key with extra attributes
B. A foreign key
C. A candidate key that is not chosen as the primary key
D. The primary key
Answer: Option C
Solution (By JKSSB Mock Tests)
An alternate key is any candidate key that is not the primary key.
This question belongs to: Computer Database Management System (DBMS)
Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1
What is the purpose of the SQL 'UNION' operator?
A. To join tables horizontally
B. To filter duplicates
C. To aggregate data
D. To combine the results of two or more SELECT statements, removing duplicates
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
UNION concatenates the result sets of two or more queries, eliminating duplicate rows. UNION ALL keeps duplicates.
This question belongs to: Computer Database Management System (DBMS)
Question #2
Which operator allows you to specify a range of values to filter query results, including the specified start and end endpoints?
A. WITHIN
B. BETWEEN
C. LIKE
D. IN
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The BETWEEN operator selects values within a specific inclusive range. It is shorthand for a combination of greater-than-or-equal-to and less-than-or-equal-to conditions.
This question belongs to: Computer Database Management System (DBMS)
Question #3
Which SQL keyword is used to remove a table from the database?
A. DROP
B. DELETE
C. TRUNCATE
D. REMOVE
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
DROP TABLE is a DDL command that deletes the table and its structure from the database.
This question belongs to: Computer Database Management System (DBMS)
Explore All Database Management System (DBMS) MCQs
Today's Top Topics
Microsoft Office 1199 Memory and Storage Devices 438 Internet and Web Technologies 461 Database Management System (DBMS) 278 Computer Networking 325
Explore Subjects
Current Affairs 575 Maths 5575 Static General Knowledge 6362 Economy GK 2220 Geography GK 6121
Practice Mix
She ___ a great singer.
Which national park in Madhya Pradesh has the 'Mandla Plant Fossils'?
Who was the first woman to command a space mission?
In a school, 60% are boys and 40% are girls. 20% of boys and 25% of girls get scholarship. What percent of students do not get scholarship?
Which of the following is a characteristic of 'Reference-Dependent Preferences'?