The command to eliminate a table from a database is:

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

UPDATE TABLE CUSTOMER;

DELETE TABLE CUSTOMER;

REMOVE TABLE CUSTOMER;

DROP TABLE CUSTOMER;

UPDATE TABLE CUSTOMER;

DELETE TABLE CUSTOMER;

REMOVE TABLE CUSTOMER;

DROP TABLE CUSTOMER;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The keyword LIKE can be used in a WHERE clause to refer to a range of values.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SQL -92 wildcards are and .

asterisk (*); percent sign (%)

underscore(_); question mark (?)

question mark (?); asterisk (*)

percent sign (%); underscore (_)

asterisk (*); percent sign (%)

underscore(_); question mark (?)

question mark (?); asterisk (*)

percent sign (%); underscore (_)

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
What is a view?

None of these

A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are.

A view is a database diagram.

A view is a special stored procedure executed when certain event occurs.

None of these

A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are.

A view is a database diagram.

A view is a special stored procedure executed when certain event occurs.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

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

Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.

Introduction to SQL The keyword LIKE can be used in a WHERE clause to refer to a range of values.

Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.

Introduction to SQL The SQL -92 wildcards are ____ and ____ .

Introduction to SQL What is a view?

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

Introduction to SQL
The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.

Introduction to SQL
The keyword LIKE can be used in a WHERE clause to refer to a range of values.

Introduction to SQL
SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.

Introduction to SQL
The SQL -92 wildcards are and .

Introduction to SQL
What is a view?