The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.

Introduction to SQL
The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The benefits of a standard relational language include which of the following?

All of these

Reduced training costs

Increased dependence on a single vendor

Applications are not needed

All of these

Reduced training costs

Increased dependence on a single vendor

Applications are not needed

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
What is a view?

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.

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.

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
Which of the following query finds the total rating of the sailors who have reserved boat "103"?

SELECT SUM(s.rating) FROM sailors s, reserves r AND r.bid = 103;

SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103

SELECT s.rating FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103

c) SELECT COUNT(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103

SELECT SUM(s.rating) FROM sailors s, reserves r AND r.bid = 103;

SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103

SELECT s.rating FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103

c) SELECT COUNT(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103

ANSWER DOWNLOAD EXAMIANS APP

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

Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.

Introduction to SQL The benefits of a standard relational language include which of the following?

Introduction to SQL What is a view?

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

Introduction to SQL Which of the following query finds the total rating of the sailors who have reserved boat "103"?

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
The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.

Introduction to SQL
The benefits of a standard relational language include which of the following?

Introduction to SQL
What is a view?

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

Introduction to SQL
Which of the following query finds the total rating of the sailors who have reserved boat "103"?

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