SQL - Basics

RDBMS stands for?

• Relational Database Management System

• Rational Database Management System

• Relational Data Management System

• Relational Database Management Society

Semicolon (;) is the standard way to separate each SQL statement in database systems.

• True

• False

SELECT statement is used to ..

• Write data to table

• Update data to table

• Read data from table

• Delete from table

Which of the following is used to delete a table?

• SELECT

• DELETE

• DROP

• ALTER

Select the statement to display all data from a table that contains the columns index_number, customer_name, customer_address and phone_number

• SELECT index_number FROM table;

• SELECT index_number, customer_name, customer_address, phone_number FROM table;

• SELECT * FROM table;

• None of the above

SELECT DISTINCT Country FROM Customers;

The above statement provides the list of countries in the table 'Customers'.

• True

• False