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.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following query finds colors of boats reserved by "Dustin"?

SELECT DISTINCT b.color FROM boats b, sailors s WHERE s.sname = 'Dustin' AND s.sid = b.sid

SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid AND r.bid = b.bid;

SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND r.bid = b.bid

SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid

SELECT DISTINCT b.color FROM boats b, sailors s WHERE s.sname = 'Dustin' AND s.sid = b.sid

SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid AND r.bid = b.bid;

SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND r.bid = b.bid

SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
SQL data definition commands make up a(n) ________ .

DML

HTML

DDL

XML

DML

HTML

DDL

XML

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return

less than 10 rows

None of these

more than 10 rows

exactly 10 rows

less than 10 rows

None of these

more than 10 rows

exactly 10 rows

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
What is a view?

None of these

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.

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

None of these

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.

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

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 DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.

Introduction to SQL Which of the following query finds colors of boats reserved by "Dustin"?

Introduction to SQL SQL data definition commands make up a(n) ________ .

Introduction to SQL Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return

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
DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.

Introduction to SQL
Which of the following query finds colors of boats reserved by "Dustin"?

Introduction to SQL
SQL data definition commands make up a(n) ________ .

Introduction to SQL
Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return

Introduction to SQL
What is a view?