Connect with us



Choose correct statements regarding database keys

Explanation: An alternate key is a candidate key that is not a primary key

What is alternate key in database ?

  • An alternate key in a database management system (DBMS) is a column or group of columns in a table that uniquely identify every row in that table.
  • Alternate keys are not used as primary keys because only one key can be set as the primary key.
  • Alternate keys are secondary candidate keys that are capable of identifying a row uniquely.

Other types of keys in a DBMS include: Candidate key, Super key, Primary key, Foreign key, Artificial key.

Artificial key in a DBMS

An artificial key in a DBMS is an extra attribute added to a table when the primary key is large and complex. The data values of the artificial keys are usually numbered in a serial order.

Recently updated  


Q.The average time required to reach a storage location in memory and obtain its contents is called the

Q.The Circuit used to store one bit of data is known as

Q.If ‘M’ denotes the number of memory locations and ‘N’ denotes the word size, then an expression that denotes the storage capacity is_______.

Q.What is the location of the internal registers of CPU ?

Q.Which of the following is independent of the address bus?

Q.Size of the ________ memory mainly depends on the size of the address bus.

Q.Which of the following is the fastest means of memory access for CPU?

Q.Any electronic holding where data can be stored and retrieved later whenever required is _____.

Q.What does SVGA stand for || Full form of SVGA ?

Q.A special request originated from some device to the CPU to acquire some of its time is called ______.