Information storage

RDBMS stands for:

• Relational Data Business Management System
• Relational Database Management System
• Regional Database Management System
• Relational Data Base Main System

Answer explanation

RDBMS stands for Relational Database Management System.

Which of the following is not a DBMS example?

• Oracle
• MySQL
• MS Word
• SQL Server

Answer explanation

MS Word is a word processor, not a database system.

Which language is used to query the database?

• HTML
• SQL
• XML
• PHP

Answer explanation

SQL (Structured Query Language) is used to query databases.

A table in a relational database is also called a:

• Record
• File
• Relation
• Attribute

Answer explanation

Tables are referred to as relations in RDBMS.

The rows in a table are called:

• Fields
• Attributes
• Tuples
• Entities

Answer explanation

Rows in a table are known as tuples.

The columns in a table represent:

• Tuples
• Fields
• Attributes
• Records

Answer explanation

Columns represent attributes or properties of entities.

Which key uniquely identifies a record in a table?

• Foreign key
• Primary key
• Super key
• Candidate key

Answer explanation

A primary key uniquely identifies a record in a table.

SQL stands for:

• Structured Query Language
• Simple Query Language
• Sequential Query Logic
• Structured Question Language

Answer explanation

SQL stands for Structured Query Language.

Which SQL command is used to retrieve data?

• SELECT
• INSERT
• UPDATE
• DELETE

Answer explanation

SELECT command is used to retrieve data from a table.

To remove all records but keep structure:

• DROP
• ERASE
• DELETE
• TRUNCATE

Answer explanation

TRUNCATE deletes all rows but preserves table structure.