Question
Differentiate between the terms primary key and alternate key.
✓
Answer
Primary Key: An attribute/ column used to identify each record in a table
Alternate Key: All such attributes/columns, which can act as a primary key but are not the primary key in a table.
Need a full question paper?
Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.
Explore more
Similar questions
Write one advantage of Star Topology of network? Also, illustrate how 5 computers can be connected with each other using Star topology of network.
Write a function to copy all the upper case words to another file.
Python program to check whether the list is empty or not.
Fill the statement 1 and Statement 2 according the requirement of output dataset:
What is default argument? Explain with help of an example.
What will be the time complexity of the following program code?
Observe the following table CANDIDATE carefully and write the name of the RDBMS operation out of
(i) SELECTION (ii) PROJECTION (iii) UNION (iv) CARTESIAN PRODUCT, which has been used to produce the output as shown in RESULT ? Also, find the Degree and Cardinality of the RESULT.
Which type of network (out of LAN, PAN, MAN) is formed when you connect two mobiles using Bluetooth to transfer a picture file?
To input two numbers and find the greater.
Write two advantages of using an optical fiber cable over an Ethernet cable to connect two service stations,
which are 190m away from each other.