SQL - Basic concepts

Full form of SQL

• Structured query language

• Simple query language

• Structure of query language

Which statement is used to extract the table from a database?

• Extract

• Get

• Open

• Select

The number of rows in a relation

• degree

• tuple

• cardinality

• domain

Data about data is ______________

• Data Description

• Metadata

• Data redundancy

• Data inconsistency

A ............ is an organized collection of structured data.

• information

• file

• database

• DBMS

Data redundancy may lead to data inconsistency.

• True

• False

In relational data model, the total number of rows can be identified as ______________________ .

• Cardinality

• Degree

• Attribute

• Entity

A row in a database.

• Record
• Field
• Entity
• Table

Which constraint uniquely identify the record in the SQL table?

• UNIQUE key

• PRIMARY key

• FOREIGN key

Which data type is used to store decimal values?

• string

• numerical

• float

• char