The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.

Introduction to SQL
The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
SQL is a data sublanguage.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SQL keyword(s) ________ is used with wildcards.

IN only

NOT IN only

IN and NOT IN

LIKE only

IN only

NOT IN only

IN and NOT IN

LIKE only

ANSWER DOWNLOAD EXAMIANS APP

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

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
What is a view?

None of these

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

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.

None of these

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

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.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

Introduction to SQL The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.

Introduction to SQL SQL is a data sublanguage.

Introduction to SQL The SQL keyword(s) ________ is used with wildcards.

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

Introduction to SQL SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.

Introduction to SQL What is a view?

Introduction to SQL
The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.

Introduction to SQL
SQL is a data sublanguage.

Introduction to SQL
The SQL keyword(s) ________ is used with wildcards.

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

Introduction to SQL
SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.

Introduction to SQL
What is a view?