Crowdly

Додати до Chrome

Retake | Database Management Systems | Aldiyar Salkenov

Шукаєте відповіді та рішення тестів для Retake | Database Management Systems | Aldiyar Salkenov? Перегляньте нашу велику колекцію перевірених відповідей для Retake | Database Management Systems | Aldiyar Salkenov в moodle.astanait.edu.kz.

Отримайте миттєвий доступ до точних відповідей та детальних пояснень для питань вашого курсу. Наша платформа, створена спільнотою, допомагає студентам досягати успіху!

Which of the following is not true about simple views?

They derive data from one table.

They contain no functions or grouping.

All of the answers are true

You cannot perform DML operations through a simple view.

100%

Переглянути це питання

What does the ALTER TABLE clause do?

The SQL ALTER TABLE clause is used to delete a database table

The SQL ALTER TABLE clause is used to insert data into database table

THE SQL ALTER TABLE deletes data from database table

The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints

Переглянути це питання

What is the meaning of LIKE ‘%0%0%’?

Feature begins with two 0’s

Feature has two 0’s in it, at positions 2 and 4

Feature ends with two 0’s

Feature has two 0’s in it, at any position

Feature has more than two 0’s

Переглянути це питання

Which SQL statement lets you find the sales amount for each store?

Table SALES

SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES ORDER BY STORE_ID;

SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES;

SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES GROUP BY STORE_ID;

100%

SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES HAVING UNIQUE STORE_ID;

Переглянути це питання

How many records does the following SQL statement generate?

SELECT * FROM EXAM_RESULTS WHERE LAST_NAME LIKE '%N%' AND EXAM_SCORE > 88;

Table EXAM_RESULTS

STUDENT_ID	FIRST_NAME	LAST_NAME	EXAM_ID	EXAM_SCORE
10	LAURA	LYNCH	1	90
10	LAURA	LYNCH	2	85
11	GRACE	BROWN	1	78
11	GRACE	BROWN	2	72
12	JAY	JACKSON	1	95
12	JAY	JACKSON	2	92
13	WILLIAM	BISHOP	1	70
13	WILLIAM	BISHOP	2	100
14	CHARLES	PRADA	2	85

No result

Переглянути це питання

Statement 1:

SELECT promo_category, SUM(promo_cost)

FROM promotions

WHERE promo_end_date - promo_begin_date > 30

GROUP BY promo_category;

Statement 2 :

SELECT promo_category, SUM(promo_cost)

FROM promotions

GROUP BY promo_category

HAVING MIN(promo_end_date-promo_begin_date)>30;

Which statement is true regarding the above two SQL statements?

statement 1 and statement 2 execute successfully and

give the same output

statement1

gives an error, statement2 executes successfully

statement 1 and statement 2 execute successfully

and give a different output

100%

statement2

gives an error, statement1 executes successfully

Переглянути це питання

SELECT __________ FROM instructor WHERE dept_name= 'Comp. Sci.';

Which of the following should be used to find the mean of the salary?

SUM(salary)

MEAN(salary)

AVG(salary)

100%

COUNT(salary)

Переглянути це питання

How many records does the following SQL statement return?

SELECT * FROM EXAM_RESULTS WHERE STUDENT_ID <= 12 AND EXAM_SCORE > 85;

Table EXAM_RESULTS

STUDENT_ID	FIRST_NAME	LAST_NAME	EXAM_ID	EXAM_SCORE
10	LAURA	LYNCH	1	90
10	LAURA	LYNCH	2	85
11	GRACE	BROWN	1	78
11	GRACE	BROWN	2	72
12	JAY	JACKSON	1	95
12	JAY	JACKSON	2	92
13	WILLIAM	BISHOP	1	70
13	WILLIAM	BISHOP	2	100
14	CHARLES	PRADA	2	85

Переглянути це питання

Table B

ID
1
2
3

Table C

ID
4
5
6

The below query is run on both of the above tables:

SELECT * FROM C UNION SELECT * FROM B UNION ALL SELECT * FROM C UNION ALL SELECT * FROM B

What will be the result of the query:

ID
1
2
3
4
5
6

ID
1
2
3
4
5
6
4
5
6
4
5
6

ID
1
2
3
4
5
6
4
6
1
2
3

ID
1
2
3
4
5
6
4
5
6
1
2
3

Переглянути це питання

Which of the following is correct to count the total salary in "deptno" wise where more than two employees exist?

SELECT deptno, SUM(sal) AS totalsal FROM emp GROUP BY deptno where COUNT(empno) > 2

SELECT deptno, SUM(sal) AS totalsal FROM emp GROUP BY deptno HAVING COUNT(empno) > 2

SELECT deptno, SUM(sal) AS totalsal FROM emp GROUP BY deptno HAVING COUNT(empno) = 2

SELECT deptno, SUM(sal) AS totalsal FROM emp GROUP BY deptno where COUNT(empno) = 2

Переглянути це питання

Хочете миттєвий доступ до всіх перевірених відповідей на moodle.astanait.edu.kz?

Отримайте необмежений доступ до відповідей на екзаменаційні питання - встановіть розширення Crowdly зараз!

Додати до Chrome

Telegram Instagram TikTok Question Bank

Умови використання Зв'яжіться з нами