Similar Collections


    No collections found

questions

Title
A Key which uniquely identifies each row in the table is known as?

A Key which uniquely identifies each row in the table is known as?


  1. Primary Key
  2. Unique Key
  3. Composite Key
  4. Foreign Key
discuss
A Primary Key is basically a –

A Primary Key is basically a –


  1. Row
  2. Column
  3. Table
  4. Database
discuss
If multiple columns are used as Primary Key, it is known as –

If multiple columns are used as Primary Key, it is known as –


  1. Unique
  2. Composite
  3. Foreign
  4. None of the above
discuss
Which of the following statement is TRUE about Primary Key?

Which of the following statement is TRUE about Primary Key?


  1. Table integrity is not enforced by the primary key.
  2. The data in a primary key is always multiple.
  3. 900 bytes is the maximum length of a primary key.
  4. Null values are allowed in primary keys.
discuss
Primary keys can be contained in a table only ____?

Primary keys can be contained in a table only ____?


  1. Once
  2. Twice
  3. Thrice
  4. None of the above
discuss
To add a Primary Key constraint after table is created, which clause is used?

To add a Primary Key constraint after table is created, which clause is used?


  1. UPDATE
  2. ADD
  3. ALTER
  4. JOIN
discuss
In order to remove a primary key constraint, which clause is used?

In order to remove a primary key constraint, which clause is used?


  1. DELETE
  2. DROP
  3. ALTER
  4. REMOVE
discuss
In order to build a link between two tables, which key is used?

In order to build a link between two tables, which key is used?


  1. Primary
  2. Foreign
  3. Composite
  4. Unique
discuss
Which of the following statement is FALSE?

Which of the following statement is FALSE?


  1. A Primary Key cannot be NULL
  2. A Foreign Key cannot be NULL
  3. A Primary Key cannot be Duplicate
  4. A Foreign Key can be Duplicate
discuss
Foreign key is a field in a table that is _______ key in another table?

Foreign key is a field in a table that is _______ key in another table?


  1. Primary
  2. Unique
  3. Composite
  4. None of the above
discuss
When two or more columns are combined to be used to uniquely identify each row in the table, it is known as -

When two or more columns are combined to be used to uniquely identify each row in the table, it is known as -


  1. Primary Key
  2. Unique Key
  3. Composite Key
  4. Foreign Key
discuss
For one table, there can be ____unique key constraint(s)

For one table, there can be ____unique key constraint(s).


  1. 1
  2. NULL
  3. Many
  4. None of the above
discuss
All other columns other than the column which is termed as Primary Key, are known as –

All other columns other than the column which is termed as Primary Key, are known as –


  1. Unique Keys
  2. Alternate Keys
  3. Composite Keys
  4. None of the above
discuss
total MCQs: 13

MCQs

13

Views

79

Best Answers

299

Points

5