SQL Concepts

What does DML stand for in SQL?

• Data Modification Language

• Data Manipulation Language

• Data Modeling Language

• Database Management Language

Which SQL statement is used to create a new table?

• UPDATE TABLE

• ADD TABLE

• INSERT TABLE

• CREATE TABLE

What does SQL Engine do?

• SQL Engine designs databases

• SQL Engine processes SQL queries, optimizes them, and executes them on the database to retrieve data.

• SQL Engine manages server hardware

• SQL Engine generates reports

What is the purpose of SQL Joins?

• To delete rows from a table

• To update rows in a table

• To create new tables

• To combine rows from two or more tables based on a related column

Define Normalization in the context of databases.

• Organizing data in a database efficiently by creating tables and establishing relationships between those tables.

• Storing data in a database without any organization

• Establishing relationships between data in separate databases

• Creating multiple copies of the same data in a database

Which SQL statement is used to modify an existing table?

• ALTER TABLE

• CHANGE TABLE

• UPDATE TABLE

• MODIFY TABLE

What is the purpose of DDL statements in SQL?

• DDL statements in SQL are used to manage user permissions

• DDL statements in SQL are used to perform calculations on data

• DDL statements in SQL are used to define the structure of database objects.

• DDL statements in SQL are used to retrieve data from the database

What is the SQL statement used to add new records to a table?

• CREATE RECORD

• UPDATE TABLE

• INSERT INTO

• ADD RECORD

Explain the difference between Create and Alter statements in SQL.

• CREATE is used to delete objects, while ALTER is used to modify existing objects.

• CREATE is used to update objects, while ALTER is used to create new objects.

• CREATE is used to modify existing objects, while ALTER is used to delete objects.

• The main difference between CREATE and ALTER statements in SQL is that CREATE is used to create new objects, while ALTER is used to modify existing objects.

What is the role of Insert statement in SQL?

• To update existing records in a database table

• To retrieve data from a database table

• To delete records from a database table

• To add new records or rows into a database table.