The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.

Introduction to SQL
The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
________ was adopted as a national standard by ANSI in 1992.

Oracle

SQL

Microsoft Access

DBase

Oracle

SQL

Microsoft Access

DBase

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following query finds the names of the sailors who have reserved at least one boat?

SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid;

None of These

SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid;

None of These

SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
What is a view?

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.

None of these

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

A view is a database diagram.

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.

None of these

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

A view is a database diagram.

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

Introduction to SQL The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.

Introduction to SQL ________ was adopted as a national standard by ANSI in 1992.

Introduction to SQL Which of the following query finds the names of the sailors who have reserved at least one boat?

Introduction to SQL The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."

Introduction to SQL What is a view?

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
The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.

Introduction to SQL
________ was adopted as a national standard by ANSI in 1992.

Introduction to SQL
Which of the following query finds the names of the sailors who have reserved at least one boat?

Introduction to SQL
The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."

Introduction to SQL
What is a view?

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.