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
What is a view?

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.

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

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The HAVING clause does which of the following?

Acts like a WHERE clause but is used for columns rather than groups.

Acts like a WHERE clause but is used for groups rather than rows.

Acts like a WHERE clause but is used for rows rather than columns.

Acts EXACTLY like a WHERE clause.

Acts like a WHERE clause but is used for columns rather than groups.

Acts like a WHERE clause but is used for groups rather than rows.

Acts like a WHERE clause but is used for rows rather than columns.

Acts EXACTLY like a WHERE clause.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the SQL statements is correct?

SELECT Username AND Password FROM Users

SELECT Username, Password WHERE Username = 'user1'

SELECT Username, Password FROM Users

None of these

SELECT Username AND Password FROM Users

SELECT Username, Password WHERE Username = 'user1'

SELECT Username, Password FROM Users

None of these

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following join is also called as an 'inner-join'?

Equijoin

None of these

Non-Equijoin

Self-Join

Equijoin

None of these

Non-Equijoin

Self-Join

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 What is a view?

Introduction to SQL The HAVING clause does which of the following?

Introduction to SQL Which of the SQL statements is correct?

Introduction to SQL Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

Introduction to SQL Which of the following join is also called as an 'inner-join'?

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
What is a view?

Introduction to SQL
The HAVING clause does which of the following?

Introduction to SQL
Which of the SQL statements is correct?

Introduction to SQL
Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

Introduction to SQL
Which of the following join is also called as an 'inner-join'?