Mastering SQL DDL and DML Commands

Mastering SQL DDL and DML Commands

Assessment

Flashcard

Information Technology (IT)

Professional Development

Practice Problem

Hard

Created by

Wayground Content

FREE Resource

Student preview

quiz-placeholder

15 questions

Show all answers

1.

FLASHCARD QUESTION

Front

What SQL command is used to create a new table?

Back

CREATE TABLE

2.

FLASHCARD QUESTION

Front

How do you add a new column to an existing table?

Back

ALTER TABLE table_name ADD COLUMN column_name data_type;

3.

FLASHCARD QUESTION

Front

What command would you use to remove a table from a database?

Back

DROP TABLE table_name;

4.

FLASHCARD QUESTION

Front

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

Back

INSERT INTO

5.

FLASHCARD QUESTION

Front

How can you update existing records in a table?

Back

Use the SQL UPDATE statement with SET and WHERE clauses.

6.

FLASHCARD QUESTION

Front

What is the SQL command to delete records from a table?

Back

DELETE FROM table_name WHERE condition;

7.

FLASHCARD QUESTION

Front

How can you rename an existing column? Options: ALTER TABLE table_name RENAME COLUMN column_name; , ALTER COLUMN table_name RENAME column_name; , sp_name 'column_name', 'new_name'; , sp_rename 'table_name.column_name', 'new_name', 'COLUMN';

Back

sp_rename 'table_name.column_name', 'new_name', 'COLUMN';

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?