The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.

Introduction to SQL
The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
How to select all data from student table starting the name from letter 'r'?

SELECT * FROM student WHERE name LIKE '_r%';

SELECT * FROM student WHERE name LIKE 'r%';

SELECT * FROM student WHERE name LIKE '%r';

SELECT * FROM student WHERE name LIKE '%r%';

SELECT * FROM student WHERE name LIKE '_r%';

SELECT * FROM student WHERE name LIKE 'r%';

SELECT * FROM student WHERE name LIKE '%r';

SELECT * FROM student WHERE name LIKE '%r%';

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.

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.

None of these

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The wildcard in a WHERE clause is useful when?

An exact match is necessary in a CREATE statement.

An exact match is not possible in a CREATE statement.

An exact match is not possible in a SELECT statement.

An exact match is necessary in a SELECT statement.

An exact match is necessary in a CREATE statement.

An exact match is not possible in a CREATE statement.

An exact match is not possible in a SELECT statement.

An exact match is necessary in a SELECT statement.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy

SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy');

SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy');

SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy');

SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy');

SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy');

SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy');

SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy');

SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy');

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

Introduction to SQL The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.

Introduction to SQL How to select all data from student table starting the name from letter 'r'?

Introduction to SQL What is a view?

Introduction to SQL The wildcard in a WHERE clause is useful when?

Introduction to SQL A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.

Introduction to SQL Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy

Introduction to SQL
The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.

Introduction to SQL
How to select all data from student table starting the name from letter 'r'?

Introduction to SQL
What is a view?

Introduction to SQL
The wildcard in a WHERE clause is useful when?

Introduction to SQL
A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.

Introduction to SQL
Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy