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.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following query is correct for using comparison operators in SQL?

SELECT name, course_name FROM student WHERE age>50 and age <80;

None of these

SELECT name, course_name FROM student WHERE age>50 and WHERE age<80;

SELECT name, course_name FROM student WHERE age>50 and <80;

SELECT name, course_name FROM student WHERE age>50 and age <80;

None of these

SELECT name, course_name FROM student WHERE age>50 and WHERE age<80;

SELECT name, course_name FROM student WHERE age>50 and <80;

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.

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.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The command to eliminate a table from a database is:

REMOVE TABLE CUSTOMER;

DROP TABLE CUSTOMER;

UPDATE TABLE CUSTOMER;

DELETE TABLE CUSTOMER;

REMOVE TABLE CUSTOMER;

DROP TABLE CUSTOMER;

UPDATE TABLE CUSTOMER;

DELETE TABLE CUSTOMER;

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 Which of the following query is correct for using comparison operators in SQL?

Introduction to SQL What is a view?

Introduction to SQL COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.

Introduction to SQL Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.

Introduction to SQL The command to eliminate a table from a database is:

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
Which of the following query is correct for using comparison operators in SQL?

Introduction to SQL
What is a view?

Introduction to SQL
COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.

Introduction to SQL
Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.

Introduction to SQL
The command to eliminate a table from a database is: