Crowdly

Add to Chrome

Retake | Database Management Systems | Aldiyar Salkenov

Looking for Retake | Database Management Systems | Aldiyar Salkenov test answers and solutions? Browse our comprehensive collection of verified answers for Retake | Database Management Systems | Aldiyar Salkenov at moodle.astanait.edu.kz.

Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!

What kind of rows does the UNION operation eliminate during operation by default?

Duplicate columns

Duplicate structures

Duplicate values

Duplicate rows

100%

View this question

Aggregate functions…

perform a calculation across a set of table rows that are somehow related to the current row

divide the result set into groups of rows

perform a calculation on a set of rows and return a single row

100%

recovers or reuse disk space occupied by updated or deleted rows

collect statistics about a database

View this question

A view is actually a?

composition of a table

None of the above

decomposition of a table

associated to a table

View this question

The cats must be ordered first by breed and second by name. They are about to enter an elevator one by one. When all the cats of the same breed have entered they leave.

Which SQL statement helps to know what the running total weight of the cats is?

Cats:

name	varchar
breed	varchar
weight	float
color	varchar
age	int

SELECT name, breed, SUM(weight) OVER (PARTITION BY breed ORDER BY name) AS running_total_weight FROM cats

SELECT name, breed, SUM(weight) OVER (ORDER BY name) AS running_total_weight FROM cats

SELECT name, breed, SUM(weight) OVER (PARTITION BY breed GROUP BY name) AS running_total_weight FROM cats ORDER BY name

SELECT name, breed, SUM(weight) OVER (PARTITION BY breed) AS running_total_weight FROM cats GROUP BY name

View this question

Which one of the following queries will select the number of unique departments from the Department table below?

DepartmentNumber	EmployeeNumber
11	3244
11	4442
12	1253
11	5003
13	1123

SELECT DISTINCT DepartmentNumber FROM Department HAVING DepartmentNumber

SELECT COUNT(*) FROM Department

SELECT COUNT(DISTINCT DepartmentNumber) FROM Department HAVING DISTINCT DepartmentNumber

SELECT COUNT(DISTINCT DepartmentNumber) FROM Department

View this question

Which of the following can be characteristic(s) of a view?

A view can be permanently saved in the database with the table

All of the above

A view can include WHERE statements

A view can include joins between more than one table

View this question

Which one is the correct syntax for applying UNION operator?

SELECT FROM table_name1 AND table_name2

SELECT column_name(s) FROM table_name1 UNION SELECT column_name(s) FROM table_name2

100%

SELECT column_name(s) FROM table_name1 UNION table_name2

UNION SELECT column_name(s) FROM table_name1 SELECT column_name(s) FROM table_name2

View this question

What would be the output of the below query?

SELECT MAX(MIN(SLSVLM)) FROM sales

SLSVLM	SLSDate
1	20121010
12	20121110
5	20120111
2	20120111
-1	20120112
0	20120106

-1

ERROR

View this question

Which of the following is correct about the GROUP BY ROLLUP clause?

It creates grouping combinations in a hierarchical way based on the input columns

100%

It returns the same result set you would obtain by using the CUBE clause with and same input columns

It creates a SUM from the unique column combination used in the clause

It creates subtotals and grand totals from all possible column combinations

View this question

Table B

ID
1
2
3

Table C

ID
4
5
6

Which one do you think is the correct syntax of UNION ALL?

SELECT * FROM B UNION ALL SELECT * FROM C ORDER BY ID DESC

Both

SELECT * FROM B ORDER BY ID DESC UNION ALL SELECT * FROM C ORDER BY ID DESC

View this question

Want instant access to all verified answers on moodle.astanait.edu.kz?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Add to Chrome

Telegram Instagram TikTok Question Bank