Relational model

What is a row in a table also known as?

• Attribute

• Tuple

• name

• none

A column in a table is called as

• row

• tuple

• attribute

• degree

A set of possible atomic values that apply to an attribute is called

• tuple

• degree

• schema

• domain

What is a foreign key?

• A foreign key is a primary key of a relation which is an attribute in another relation

• A foreign key is a superkey of a relation which is an attribute in more than one other relations

• A foreign key is an attribute of a relation that is a primary key of another relation

• A foreign key is the primary key of a relation that does not occur anywhere else in the schema

Choose the correct statement regarding superkeys

• A superkey is an attribute or a group of multiple attributes that can uniquely identify a tuple

• A superkey is a tuple or a set of multiple tuples that can uniquely identify an attribute

• Every superkey is a candidate key

• A superkey is an attribute or a set of attributes that distinguish the relation from other relations

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

• Primary Key

• Unique Key

• Composite Key

• Foreign Key

A Primary Key is basically a –

• row

• column

• table

• database

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

• Primary

• Foreign

• Composite

• Unique

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

• Primary Key

• Unique Key

• Composite Key

• Foreign Key

What is the full form of SQL?

• Structured Query List

• Structured Query Language

• Sample Query Language

• None of these