SQL Fundamentals Quiz - https://www.tutorialspoint.com/sql/index

Who developed SQL?

• Microsoft in the 1980s

• Google in the 1990s

• None of the Above

• IBM in the 1970s

Answer explanation

SQL was developed by IBM in the 1970s, making the correct answer choice 'IBM in the 1970s'.

What does SQL stand for?

• Simple Query Language

• Sequential Query Language

• Standard Query Language

• Structured Query Language

Answer explanation

SQL stands for Structured Query Language, making it the correct choice among the options provided.

Which of the following is NOT a SQL command type?

• Data Manipulation Language

• Data Definition Language

• Data Control Language

• Data Connection Language

Answer explanation

Data Connection Language is NOT a SQL command type, the other three are valid SQL command types.

Which command is used to retrieve data from a database in SQL?

• GET

• READ

• FETCH

• SELECT

Answer explanation

The correct command used to retrieve data from a database in SQL is SELECT. It is used to fetch specific data based on specified criteria.

Which SQL statement is used to insert new data into a database?

• ADD RECORD

• INSERT INTO

• UPDATE

• CREATE NEW

Answer explanation

The correct SQL statement to insert new data into a database is INSERT INTO.

What are the basic operations performed by SQL?

• SELECT, INSERT, UPDATE, DELETE

• CREATE, ADD, MODIFY, REMOVE

• FETCH, POST, PUT, DELETE

• READ, WRITE, UPDATE, DELETE

Answer explanation

The basic operations performed by SQL are SELECT, INSERT, UPDATE, and DELETE. These operations are fundamental for querying and manipulating data in a database.

Which of the following is a purpose of SQL?

• Creating mobile applications

• Programming microcontrollers

• Managing relational databases

• Styling web pages

Answer explanation

The purpose of SQL is managing relational databases, not creating mobile applications, programming microcontrollers, or styling web pages.

What does DDL stand for in SQL?

• Data Deletion Language

• Database Development Language

• Data Duplication Language

• Data Definition Language

Answer explanation

DDL stands for Data Definition Language in SQL, used to define the structure of database objects like tables, indexes, and views.

Which SQL keyword is used to remove a table or database?

• ERASE

• DELETE

• REMOVE

• DROP

Answer explanation

The correct SQL keyword used to remove a table or database is DROP.

Which of the following is true about SQL?

• It is used for creating desktop applications.

• It is a hardware description language.

• It is mainly used for styling web pages.

• It is a programming language used to manage data in relational databases.

Answer explanation

SQL is a programming language used to manage data in relational databases, making it the correct choice among the options provided.