Introduction to SQL

Introduction to SQL
SQL is a data sublanguage.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The command to eliminate a table from a database is:

DELETE TABLE CUSTOMER;

UPDATE TABLE CUSTOMER;

DROP TABLE CUSTOMER;

REMOVE TABLE CUSTOMER;

DELETE TABLE CUSTOMER;

UPDATE TABLE CUSTOMER;

DROP TABLE CUSTOMER;

REMOVE TABLE CUSTOMER;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

IN only.

LIKE only.

NOT IN only.

Both IN and NOT IN.

IN only.

LIKE only.

NOT IN only.

Both IN and NOT IN.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following is valid SQL for an Index?

CREATE INDEX ID;

ADD INDEX ID;

REMOVE INDEX ID;

CHANGE INDEX ID;

CREATE INDEX ID;

ADD INDEX ID;

REMOVE INDEX ID;

CHANGE INDEX ID;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which one of the following sorts rows in SQL?

ORDER BY

ALIGN BY

GROUP BY

SORT BY

ORDER BY

ALIGN BY

GROUP BY

SORT BY

ANSWER DOWNLOAD EXAMIANS APP

MORE MCQ ON Introduction to SQL

↑