SQL-FLASHCARD

Front

What command is used to create a new table in SQL?

Back

create table

Front

What command is used to delete a table in SQL? Options: delete table, destroy table, drop table, none of the above

Back

drop table

Front

What is the full form of RDBMS?

Back

Relational DataBase Management System

Front

Which SQL constraint do we use to set some value to field whose value has not been added explicitly?

Back

DEFAULT

Front

Which of the following is the full form of DDL? Options: Data Definition Language, Data Derivation Language, Dynamic Data Language, Detailed Data Language

Back

Data Definition Language

Front

Which of the following commands are used to put a restriction on the number of rows returned from a query? LIKE, LIMIT, WHERE, GROUP BY

Back

LIMIT

Front

What does the SQL command 'INSERT INTO' do?

Back

Adds new data into a database.

Front

What does the 'ALTER TABLE' command do in SQL?

Back

Modifies the structure of an existing table.