DatabaseBasic

What does RDBMS stand for?

• Relational Database Management System
• Reversible Database Management System
• Real-time Database Management System
• Random Database Management System

What is a primary key in a database?

• A unique identifier for a record in a table
• A secondary key in a database
• A table that stores metadata
• A column with numeric values

What is the purpose of an index in a database?

• To eradicate redundancy
• To store backup copies of data
• To establish relationships within tuple
• To enforce data constraints

What is SQL?

• Structured Query Language
• Structured Query Logic
• Simple Query Language
• Systematic Query Language

What is a table in a database?

• A collection of related data organized in rows and columns
• A function that performs a specific calculation on data
• A query that retrieves data from multiple tables
• A diagram that represents the structure of a database

Which data type is used to store a whole number in SQL?

• INTEGER
• VARCHAR
• BOOLEAN
• FLOAT

Which SQL data type is used to store textual data of variable length?

• VARCHAR
• INTEGER
• BOOLEAN
• DATE

Which SQL statement is used to insert data into a table?

• INSERT INTO
• CREATE TABLE
• SELECT
• UPDATE

Which SQL statement is used to create a new table?

• CREATE TABLE
• SELECT
• INSERT INTO
• UPDATE

Which SQL data type is best for storing large amounts of text?

• TEXT
• VARCHAR
• BOOLEAN
• INTEGER