2/26/2021 AMA Answers: IT6202 - Database Management System 1

Higit Pa

AMA Answers
AMAOED Answers 95-100% correct with proof. Better than Brainly.ph and coursehero because this is free and tested

FIND BY COURSE NAME

Showing posts with label IT6202 - Database Management System 1. Show all posts
Calculus 1 (11)
SATURDAY, FEBRUARY 13, 2021 Computer Programming 1 (5)
Database Management System 1 (18)
Short Quiz 007 - IT6202 - Database Management System 1 ENGL6100 (21)
ENGL6100 - Purposive Communication 2
Scroll down for answers or choose a page (21)
Ethics (2)
- Assignment 001
GE6101 (1)
- Assignment 002 GE6101 - Readings in Philippine History (1)
GE6102 (4)
- Assignment 003
GE6102 - The Contemporary World (4)
- Assignment 004 GE6106 (1)
GE6106 - Purposive Communication (1)
- Assignment 005
GE6107 (2)
- Assignment 006 GE6107 Ethics (2)
General Mathematics (3)
- Assignment 007
GMAT111 (3)
- Assignment 008 GMAT111 - General Mathematics (3)
IT6202 (18)
- Assignment 009
IT6202 - Database Management System 1
- Short Quiz 001 (18)
ITE6102 (5)
- Short Quiz 002
ITE6102 - Computer Programming 1 (5)
- Short Quiz 003 MATH6100 (11)
MATH6100 - Calculus 1 (11)
- Short Quiz 004
Practical Research 1 (3)
- Short Quiz 005 Purposive Communication (1)
Purposive Communication 2 (21)
- Short Quiz 006
Readings in Philippine History (1)
- Short Quiz 007 RSCH -110 (3)
RSCH -110 - Practical Research 1 (3)
- Long Quiz 001
The Contemporary World (4)
- Long Quiz 002

It is use to accept numeric input and return numeric values.

Select one:
a. Multiple row function
b. Character function
c. Number function
d. Case manipulation function

https://amauoed.blogspot.com/search/label/IT6202 - Database Management System 1 1/9

2/26/2021 AMA Answers: IT6202 - Database Management System 1

This is use to return one result per group of row.

Customer
Select one:
a. Single row
b. Dual table Service
Reimagined
c. Multiple row
d. Number function

Be onboarded in
under 24 hours, save
time, improve NPS &
CSAT scores. Book
This is use to accept character input and can return both character and number values. your free demo!
Select one:
a. Multiple row function Dixa
b. Number function
c. Character function
d. Case manipulation function
Open

This is use to accept character input and can return both character and number values.
POPULAR AMA COURSES

Select one: GE6101 - Readings in Philippine History

a. Multiple row function The history or story of a society or group of
people is rooted from their ________,
b. Number function EXCEPT. Select one: a. Legends and Arts b.
Fol...
c. Character function
RSCH -110 - Practical Research 1 - Learning
d. Case manipulation function
Activities
Question 1 Correct Marked out of 1.00 Flag
question Question text True or False. If the
statement is true, write the word True. If
False,...

RSCH -110 - Practical Research 1 - Long

Quizzes
Trims leading or trailing characters (or both) from a character string.
Which of the following is not included in the
research experience? Select one: a. Identity
Select one: of the researcher b. Social class of the
research...
a. Trim
b. Length GE6102 - The Contemporary World
also have a look at - Contemporary
c. INSTR World Prelims answers - Contemporary World
Midterm answers - Contemporary World all
d. SUBSTR short quizes answe...

GMAT111 - General Mathematics

Solve for the value of x: 1. 7 x+4 = 49 2x-1
x = Answer 1. 4 x+2 = 8 2x x=
Answer Complete the ...

This is use to find the numeric position of a named character starting at character position n.

Select one:
a. INSTR
b. Length
c. SUBSTR
d. Trim

https://amauoed.blogspot.com/search/label/IT6202 - Database Management System 1 2/9

2/26/2021 AMA Answers: IT6202 - Database Management System 1

It is a table that is owned by the user SYS and can be accessed by all users.

Select one:
a. Authors

駐在3年目。
b. Parts
c. Dual
d. Employees
英語の会議が
苦手
ビジネス英語
スピーキング教材の
決定版！優秀な
This is use to return one result per row.

Select one:
ビジネスパーソンが
a. Dual table
b. Single row
選ぶ【60日返金保証】
c. Multiple row パタプライングリッシュ
d. Number function

開く
Extracts a string of determined length. BLOG ARCHIVE
▼ 2021 (31)
Select one: ▼ February (8)
a. Trim Part 2 GE6107 - Ethics (BS IT and BS
CS Only)
b. Length
Part 1 GE6107 - Ethics (BS IT and BS
c. SUBSTR CS Only)

d. INSTR Short Quiz 007 - IT6202 - Database

Management Syst...
Assignment 009 - IT6202 - Database
Management Syst...
Assignment 008 - IT6202 - Database
Management Syst...
Assignment 007 - IT6202 - Database
What is the return value if the user try to do the following: Management Syst...
SELECT TRUNC (65.73,-2) FROM DUAL;
Assignment 006 - IT6202 - Database
Management Syst...
Select one:
Long Quiz 002 - IT6202 - Database
a. 600 Management System 1

b. 0 ► January (23)
c. 00
► 2020 (38)
d. 60

- February 13, 2021 No comments:

Labels: Database Management System 1, IT6202, IT6202 - Database Management System 1

Assignment 009 - IT6202 - Database Management System 1

Scroll down for answers or choose a page

- Assignment 001

https://amauoed.blogspot.com/search/label/IT6202 - Database Management System 1 3/9

2/26/2021 AMA Answers: IT6202 - Database Management System 1
- Assignment 002

- Assignment 003

- Assignment 004

- Assignment 005

- Assignment 006

Customer
- Assignment 007

- Assignment 008
Service
- Assignment 009

- Short Quiz 001

Reimagined
- Short Quiz 002 Be onboarded in
- Short Quiz 003
under 24 hours, save
time, improve NPS &
- Short Quiz 004 CSAT scores. Book
- Short Quiz 005 your free demo!
- Short Quiz 006
Dixa
- Short Quiz 007

- Long Quiz 001

- Long Quiz 002

Open

Choose the letter of the correct answer based on the table EMPLOYEES as shown
below.
Table 1.0 EMPLOYEES

Question 1
Which of the following query is correct which will display the same output as shown
Correct
below?
Mark 1.00 out of
1.00
Select one:
Flag question
a. SELECT COUNT(DISTINCT MANAGER_ID) AS "NO. OF MANAGER_ID"
FROM EMPLOYEES;
b. SELECT COUNT *(DISTINCT MANAGER_ID) AS "NO. OF MANAGER_ID"
FROM EMPLOYEES;
c. SELECT COUNT(DISTINCT MANAGER_ID) AS NO. OF MANAGER_ID
FROM EMPLOYEES;

d. SELECT COUNT(MANAGER_ID) AS "NO. OF MANAGER_ID" FROM

EMPLOYEES;

Question 2
Which of the following query is correct which will display the same output as shown
Correct
below?
Mark 1.00 out of
1.00

Flag question
Select one:
a. SELECT COUNT(*) FROM EMPLOYEES;
b. SELECT COUNT ALL FROM EMPLOYEES;
c. SELECT * FROM EMPLOYEES;

https://amauoed.blogspot.com/search/label/IT6202 - Database Management System 1 4/9

2/26/2021 AMA Answers: IT6202 - Database Management System 1

Question 3
Which of the following query is correct which will display the same output as shown
Correct
below?
Mark 1.00 out of
1.00

Flag question
Select one:
a. SELECT MIN(LASTNAME), JOB_ID, MAX(SALARY)
FROM EMPLOYEES
WHERE JOB_ID LIKE '%REP%';

b. SELECT MIN(LASTNAME), JOB_ID, MAX(SALARY)

FROM EMPLOYEES
WHERE JOB_ID LIKE 'REP%'
GROUP BY JOB_ID;

c. SELECT MIN(LASTNAME), MIN(JOB_ID), MAX(SALARY)

FROM EMPLOYEES
WHERE JOB_ID LIKE '%REP%'
GROUP BY JOB_ID;

d. SELECT MIN(LASTNAME), JOB_ID, MAX(SALARY)

FROM EMPLOYEES
WHERE JOB_ID LIKE '%REP%'
GROUP BY JOB_ID;

Question 4
Which of the following query is correct which will display the same output as shown
Correct
below?
Mark 1.00 out of
1.00
Select one:
Flag question
a. SELECT MAX(LASTNAME||','||FIRSTNAME) AS NAME, MAX(SALARY)
FROM EMPLOYEES;

b. SELECT MAX(LASTNAME||','||FIRSTNAME) AS NAME, MIN(SALARY)

FROM EMPLOYEES;

c. SELECT MAX(LASTNAME||FIRSTNAME) AS NAME, MAX(SALARY)

FROM EMPLOYEES;

d. SELECT MAX(LASTNAME||''||FIRSTNAME) AS NAME, MAX(SALARY)

FROM EMPLOYEES;

Question 5
Which of the following query is correct which will display the same output as shown
Correct
below?
Mark 1.00 out of
1.00
Select one:
Flag question
a. SELECT MIN(LASTNAME||FIRSTNAME) AS NAME, DEPARTMENT_ID
FROM EMPLOYEES
GROUP BY DEPARTMENT_ID
WHERE DEPARTMENT_ID IN(90,50)
HAVING MIN(DEPARTMENT_ID)<=90;

https://amauoed.blogspot.com/search/label/IT6202 - Database Management System 1 5/9

2/26/2021 AMA Answers: IT6202 - Database Management System 1

b. SELECT MIN(LASTNAME||FIRSTNAME) AS NAME, DEPARTMENT_ID

FROM EMPLOYEES
WHERE DEPARTMENT_ID IN(90,50)
GROUP BY DEPARTMENT_ID
HAVING MIN(DEPARTMENT_ID)<=90;

c. SELECT MIN(LASTNAME||FIRSTNAME) AS NAME, DEPARTMENT_ID

FROM EMPLOYEES
WHERE DEPARTMENT_ID IN(90,50)
HAVING MIN(DEPARTMENT_ID)<=90;

d. SELECT MIN(LASTNAME||FIRSTNAME) AS NAME, DEPARTMENT_ID

FROM EMPLOYEES
WHERE DEPARTMENT_ID NOT IN(90,50)
GROUP BY DEPARTMENT_ID
HAVING(DEPARTMENT_ID)<=90;

Question 6
Which of the following query is correct which will display the same output as shown
Correct
below?
Mark 1.00 out of
1.00
Select one:
Flag question
a. SELECT COUNTDISTINCT(MANAGER_ID) AS "NO. OF MANAGER_ID"
FROM EMPLOYEES;
b. SELECT COUNT *(MANAGER_ID) AS "NO. OF MANAGER_ID" FROM
EMPLOYEES;
c. SELECT COUNT(MANAGER_ID) AS "NO. OF MANAGER_ID" FROM
EMPLOYEES;

d. SELECT COUNT(MANAGER_ID) NO. OF MANAGER_ID FROM

EMPLOYEES;

Question 7
Which of the following query is correct which will display the same output as shown
Correct
below?
Mark 0.67 out of
1.00
Select one:
Flag question
a. SELECT MAX(FIRSTNAME), MANAGER_ID, COUNT(SALARY),
AVG(SALARY)
FROM EMPLOYEES
GROUP BY MANAGER_ID
WHERE SALARY BETWEEN 6000 AND 10000
HAVING MIN(SALARY) >= 5000;

b. SELECT MAX(FIRSTNAME), MANAGER_ID, COUNT(SALARY),

AVG(SALARY)
FROM EMPLOYEES
WHERE SALARY BETWEEN 6000 AND 10000
GROUP BY MANAGER_ID
HAVING (SALARY) >= 5000;

c. SELECT MAX(FIRSTNAME), MANAGER_ID, COUNT(SALARY),

AVG(SALARY)
FROM EMPLOYEES
WHERE SALARY BETWEEN 10000 AND 6000

https://amauoed.blogspot.com/search/label/IT6202 - Database Management System 1 6/9

2/26/2021 AMA Answers: IT6202 - Database Management System 1
GROUP BY MANAGER_ID
HAVING MIN(SALARY) >= 5000;

d. SELECT MAX(FIRSTNAME), MANAGER_ID, COUNT(SALARY),

AVG(SALARY)
FROM EMPLOYEES
WHERE SALARY BETWEEN 6000 AND 10000
HAVING MIN(SALARY) >= 5000
GROUP BY MANAGER_ID;

Question 8
Which of the following query is correct which will display the same output as shown
Correct
below?
Mark 1.00 out of
1.00
Select one:
Flag question

a. SELECT MIN(LASTNAME),MAX(FIRSTNAME),SUM(SALARY),AVG(SALAR
Y)
FROM EMPLOYEES
WHERE JOB_ID LIKE 'ST%';

b. SELECT MIN(LASTNAME),MAX(FIRSTNAME),SUM(SALARY),AVG(SALAR
Y)
FROM EMPLOYEES
WHERE JOB_ID LIKE '%ST%';

c. SELECT MIN(LASTNAME),MAX(FIRSTNAME),SUM(SALARY),AVG(SALAR
Y)
FROM EMPLOYEES
WHERE JOB_ID LIKE '%ST';

d. SELECT MIN(LASTNAME),MAX(FIRSTNAME),SUM(SALARY),AVG(SALAR
Y)
FROM EMPLOYEES
WHERE JOB_ID LIKE = ‘ST’;

Question 9
Which of the following query is correct which will display the same output as shown
Correct
below?
Mark 1.00 out of
1.00
Select one:
Flag question
a. SELECT MIN(initcap(FIRSTNAME||' surnname is '||LASTNAME)) AS
COMPLETE NAME, MIN(MANAGER_ID) AS "LOWEST MANAGER_ID" FROM
EMPLOYEES;
b. SELECT MIN(LOWER(FIRSTNAME||surnname is ||LASTNAME)) AS
"COMPLETE NAME", MIN(MANAGER_ID) AS "LOWEST MANAGER_ID" FROM
EMPLOYEES;

c. SELECT MIN(LOWER(FIRSTNAME||' surnname is '||LASTNAME)) AS

"COMPLETE NAME", MIN(MANAGER_ID) AS "LOWEST MANAGER_ID" FROM
EMPLOYEES;
d. SELECT MIN(initcap(FIRSTNAME||' surnname is '||LASTNAME)) AS
"COMPLETE NAME", MIN(MANAGER_ID) AS "LOWEST MANAGER_ID" FROM

https://amauoed.blogspot.com/search/label/IT6202 - Database Management System 1 7/9

2/26/2021 AMA Answers: IT6202 - Database Management System 1
EMPLOYEES;

Question 10
Which of the following query is correct which will display the same output as shown
Correct
below?
Mark 1.00 out of
1.00
Select one:
Flag question
a. SELECT JOB_ID, COUNT(JOB_ID)"NO. OF JOB_ID", SUM(SALARY),
AVG(SALARY)
FROM EMPLOYEES;

b. SELECT JOB_ID, COUNT*(JOB_ID)"NO. OF JOB_ID", SUM(SALARY),

AVG(SALARY)
FROM EMPLOYEES
GROUP BY JOB_ID;

c. SELECT JOB_ID, COUNT(JOB_ID)"NO. OF JOB_ID", SUM(SALARY),

AVG(SALARY)
FROM EMPLOYEES
GROUP BY JOB_ID;

d. SELECT JOB_ID, COUNTDISTINCT(JOB_ID)"NO. OF JOB_ID",

SUM(SALARY), AVG(SALARY)
FROM EMPLOYEES
GROUP BY JOB_ID;

- February 13, 2021 No comments:

Labels: Database Management System 1, IT6202, IT6202 - Database Management System 1

Home Older Posts

Subscribe to: Posts (Atom)

COURSES

ENGL6100 ENGL6100 - Purposive Communication 2 Purposive Communication 2 Database

Management System 1 IT6202 IT6202 - Database Management System 1 Calculus 1 MATH6100 MATH6100 -
Calculus 1 Computer Programming 1 ITE6102 ITE6102 - Computer Programming 1 GE6102 GE6102 - The Contemporary World The Contemporary World GMAT111
GMAT111 - General Mathematics General Mathematics Practical Research 1 RSCH -110 RSCH -110 - Practical Research 1 Ethics GE6107 GE6107 Ethics GE6101 GE6101 - Readings in
Philippine History GE6106 GE6106 - Purposive Communication Purposive Communication Readings in Philippine History

https://amauoed.blogspot.com/search/label/IT6202 - Database Management System 1 8/9

2/26/2021 AMA Answers: IT6202 - Database Management System 1
Powered by Blogger.

https://amauoed.blogspot.com/search/label/IT6202 - Database Management System 1 9/9