(Finals) Information Management Mocktest

Xai Alexandrei Delos Reyes · 58問 · 2年前

通報

問題一覧

An ________ performs a calculation on a set of values and returns a single value.

aggregate function

the minimum attribute value encountered in a given column

MIN

the maximum attribute value encountered in a given column

MAX

the number of rows containing non-null values

COUNT

the sum of all values for a given column

SUM

the arithmetic mean (average) for a specified column

AVG

The _____ command option is often used with aggregate functions to group the result-set by one or more columns.

GROUP BY

What is the CORRECT syntax for MIN

SELECT MIN(column_name) FROM table_name;

What is the CORRECT syntax for MAX

SELECT MAX(column_name) FROM table_name;

What is the CORRECT syntax for COUNT

SELECT COUNT(column_name) FROM table_name;

What is the CORRECT syntax for SUM

SELECT SUM(column_name) FROM table_name;

What is the CORRECT syntax for AVG

SELECT AVG(column_name) FROM table_name;

What is the CORRECT syntax for GROUP BY

SELECT columns FROM table_name GROUP BY columns;

Use an _____ to assign a temporary name to the column. It can also be given to tables.

Alias

What is the CORRECT syntax of ALIAS

SELECT column_name AS alias FROM table_name;

What is the CORRECT syntax of HAVING

SELECT columns FROM table_name GROUP BY columns HAVING condition;

The ______ command option is used to restrict the output of a GROUP BY query by applying conditional criteria to the grouped rows.

HAVING

returns a four-digit year

YEAR

returns the number of the month

MONTH

returns the number of the day

DAY

returns the current date and time

GETDATE

adds a number of selected time/date periods to a date then returns the date

DATEADD

returns the difference between two (2) dates

DATEDIFF

What is the CORRECT syntax for YEAR

SELECT OrderID, YEAR(OrderDate) AS Year;

What is the CORRECT syntax for MONTH

SELECT OrderID, MONTH(OrderDate) AS Month;

What is the CORRECT syntax for DAY

SELECT OrderID, DAY(OrderDate) AS Day;

What is the CORRECT syntax for GETDATE

SELECT GETDATE();

What is the CORRECT syntax for DATEADD

DATEADD(datepart, number, date);

What is the CORRECT syntax for DATEDIFF

DATEDIFF(datepart, date1, date2);

returns the absolute value of a number

ABS

returns the smallest integer value that is greater than or equal to a number

CEILING

returns the largest integer value that is less than or equal to a number

FLOOR

What is the CORRECT syntax for ABS

SELECT ABS(-234.5);

What is the CORRECT syntax for ROUND

ROUND(number, decimal places);

What is the CORRECT syntax for CEILING

SELECT CEILING(234.1);

What is the CORRECT syntax for FLOOR

SELECT FLOOR(234.5);

joins two or more strings together

CONCAT

returns a string in lowercase letters

LOWER

returns a string in all capital letters

UPPER

returns a part of a string

SUBSTRING

returns the number of characters in a string

LEN

removes the spaces or specific characters from start or end of a string

TRIM

What is the CORRECT syntax for CONCAT

SELECT CONCAT(FirstName + ' ' , LastName) FROM Customers WHERE CustomerID = 3446;

What is the CORRECT syntax for LOWER

SELECT LOWER ('FUNCTIONS');

What is the CORRECT syntax for UPPER

SELECT UPPER('sql');

What is the CORRECT syntax for SUBSTRING

SELECT SUBSTRING('SQL Functions', 1, 3);

What is the CORRECT syntax for LEN

SELECT LEN('SQL Functions');

What is the CORRECT syntax for TRIM

SELECT TRIM('<!> ' FROM ' <Functions! >');

A _____ clause combines rows from two or more tables based on a common column.

JOIN

returns rows that have matching values in both tables

INNER JOIN

returns all rows from the left table and the matched records from the right table. If there is no match from the right side, the result is NULL.

LEFT JOIN

returns all rows from the right table and the matched records from the left table. If there is no match from the left side, the result is NULL.

RIGHT JOIN

returns all records when there is a match on either the left or right table. If there is no match, the missing side will contain NULL.

FULL JOIN

What is the CORRECT syntax for INNER JOIN

SELECT Customers.CustomerID, Customers.FirstName, Orders.OrderID FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID;

What is the CORRECT syntax for LEFT JOIN

SELECT Customers.CustomerID, Customers.FirstName, Orders.OrderID FROM Customers LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID;

What is the CORRECT syntax for RIGHT JOIN

SELECT Customers.CustomerID, Customers.FirstName, Orders.OrderID FROM Customers RIGHT JOIN Orders ON Customers.CustomerID = Orders.CustomerID;

What is the CORRECT syntax for FULL JOIN

SELECT Customers.CustomerID, Customers.FirstName, Orders.OrderID FROM Customers FULL JOIN Orders ON Customers.CustomerID = Orders.CustomerID;

What is the Output of this Query? SELECT DATEADD(month, 2, '2020/12/14');

2021-02-14 00:00:00.000

What is the Output of this Query? SELECT DATEADD(quarter, 2, '2020/02/14');

2020-08-14 00:00:00.000

SELECT DATEADD(hour, 2, DATEADD(minute, 30, '2020/02/14'));

2020-02-14 02:30:00.000

What is the output of this query? SELECT CEILING(234.1);

235

What is the output of this query? SELECT FLOOR(234.5);

234

What is the output of this query? SELECT SUBSTRING('SQL Functions', 1, 3);

SQL

What is the output of this query? SELECT LEN('SQL Functions');

The Contemporary World Mock test (Prelims)

The Contemporary World Mock test (Prelims)

58問 • 2年前

Xai Alexandrei Delos Reyes · 67問 · 2年前

Computing Mock test (Prelims)

Computing Mock test (Prelims)

67問 • 2年前

Xai Alexandrei Delos Reyes · 64問 · 2年前

Programming Mock Test (Prelims)

Programming Mock Test (Prelims)

64問 • 2年前

Xai Alexandrei Delos Reyes · 23問 · 2年前

Entrepreneurship Mock Test (Prelims)

Entrepreneurship Mock Test (Prelims)

23問 • 2年前

Xai Alexandrei Delos Reyes · 76問 · 2年前

Computing Mock Test (Midterms) BSIT 107

Computing Mock Test (Midterms) BSIT 107

76問 • 2年前

Xai Alexandrei Delos Reyes · 48問 · 2年前

Math Mock Test (Prelims)

Math Mock Test (Prelims)

48問 • 2年前

Xai Alexandrei Delos Reyes · 52問 · 2年前

Programming Mock Test (Midterms) BSIT 107

Programming Mock Test (Midterms) BSIT 107

52問 • 2年前

Xai Alexandrei Delos Reyes · 40問 · 2年前

UTS Mock Test (Midterms) BSIT107

UTS Mock Test (Midterms) BSIT107

40問 • 2年前

Xai Alexandrei Delos Reyes · 38問 · 2年前

Entrepreneurship Mock Test (Midterms) BSIT 107

Entrepreneurship Mock Test (Midterms) BSIT 107

38問 • 2年前

Xai Alexandrei Delos Reyes · 28問 · 2年前

Contemporary World Mock Test (Midterms) BSIT 107

Contemporary World Mock Test (Midterms) BSIT 107

28問 • 2年前

Xai Alexandrei Delos Reyes · 24問 · 2年前

Math Mocktest (Midterms) BSIT 107

Math Mocktest (Midterms) BSIT 107

24問 • 2年前

Xai Alexandrei Delos Reyes · 26問 · 2年前

Computer Programming Mocktest (Pre-finals)

Computer Programming Mocktest (Pre-finals)

26問 • 2年前

Xai Alexandrei Delos Reyes · 19問 · 2年前

Math Mocktest (Pre-Finals)

Math Mocktest (Pre-Finals)

19問 • 2年前

Xai Alexandrei Delos Reyes · 36問 · 2年前

Computing Mock Test (Pre-finals)

Computing Mock Test (Pre-finals)

36問 • 2年前

Xai Alexandrei Delos Reyes · 26問 · 2年前

Computing Mock Test Finals

Computing Mock Test Finals

26問 • 2年前

Xai Alexandrei Delos Reyes · 63問 · 1年前

Comprog 2nd sem (prelims) BSIT 205

Comprog 2nd sem (prelims) BSIT 205

63問 • 1年前

Xai Alexandrei Delos Reyes · 36問 · 1年前

Discrete Math 2nd sem (prelims) BSIT 205

Discrete Math 2nd sem (prelims) BSIT 205

36問 • 1年前

Xai Alexandrei Delos Reyes · 56問 · 1年前

Art Appreciation (Prelim) BSIT 205

Art Appreciation (Prelim) BSIT 205

56問 • 1年前

Xai Alexandrei Delos Reyes · 45問 · 1年前

Ethics 2nd sem (Prelims) BSIT 205

Ethics 2nd sem (Prelims) BSIT 205

45問 • 1年前

Xai Alexandrei Delos Reyes · 40問 · 1年前

STS 2nd Sem (Prelim) BSIT 205

STS 2nd Sem (Prelim) BSIT 205

40問 • 1年前

Xai Alexandrei Delos Reyes · 72問 · 1年前

Systems Administration 2nd sem (Prelims) BSIT 205

Systems Administration 2nd sem (Prelims) BSIT 205

72問 • 1年前

Xai Alexandrei Delos Reyes · 52問 · 1年前

Discrete Mathematics (Midterms) BSIT 205

Discrete Mathematics (Midterms) BSIT 205

52問 • 1年前

Xai Alexandrei Delos Reyes · 56問 · 1年前

Art Appreciation (Midterm) BSIT 205

Art Appreciation (Midterm) BSIT 205

56問 • 1年前

Ethics Mocktest (Midterms) BSIT205

Ethics Mocktest (Midterms) BSIT205

Xai Alexandrei Delos Reyes · 61問 · 1年前

Comprog Mocktest (Midterm) BSIT 205

Comprog Mocktest (Midterm) BSIT 205

61問 • 1年前

Xai Alexandrei Delos Reyes · 65問 · 1年前

System Administration Mocktest (Midterms) BSIT 205

System Administration Mocktest (Midterms) BSIT 205

65問 • 1年前

Xai Alexandrei Delos Reyes · 49問 · 1年前

Math Mocktest (Pre-finals) BSIT 205

Math Mocktest (Pre-finals) BSIT 205

49問 • 1年前

Xai Alexandrei Delos Reyes · 66問 · 1年前

Art Appreciation Mocktest (Pre-finals) BSIT 205

Art Appreciation Mocktest (Pre-finals) BSIT 205

66問 • 1年前

Xai Alexandrei Delos Reyes · 50問 · 1年前

Ethics Mocktest (Pre-finals) BSIT 205

Ethics Mocktest (Pre-finals) BSIT 205

50問 • 1年前

Xai Alexandrei Delos Reyes · 33問 · 1年前

Computer Programming Mocktest (Pre-finals) BSIT 205

Computer Programming Mocktest (Pre-finals) BSIT 205

33問 • 1年前

Xai Alexandrei Delos Reyes · 52問 · 1年前

System Administration (Pre-finals) BSIT 205

System Administration (Pre-finals) BSIT 205

52問 • 1年前

Xai Alexandrei Delos Reyes · 35問 · 1年前

Art Appreciation Finals BSIT 205

Art Appreciation Finals BSIT 205

35問 • 1年前

Xai Alexandrei Delos Reyes · 52問 · 1年前

Data Structures and Algorithms (Mocktest) BSIT 307

Data Structures and Algorithms (Mocktest) BSIT 307

52問 • 1年前

Xai Alexandrei Delos Reyes · 23問 · 1年前

Object Oriented Programming Mock Test (Mocktest) BSIT 307

Object Oriented Programming Mock Test (Mocktest) BSIT 307

23問 • 1年前

Xai Alexandrei Delos Reyes · 58問 · 1年前

Human Computer Interactions Mocktest (Prelims) BSIT 307

Human Computer Interactions Mocktest (Prelims) BSIT 307

58問 • 1年前

Xai Alexandrei Delos Reyes · 37問 · 1年前

Principles of Communication Mocktest (Prelims) BSIT 307

Principles of Communication Mocktest (Prelims) BSIT 307

37問 • 1年前

Principles of Communication Mocktest (Midterms) BSIT 307

Principles of Communication Mocktest (Midterms) BSIT 307

Xai Alexandrei Delos Reyes · 50問 · 1年前

Data Structures and Algorithms Mocktest (Midterm) BSIT 307

Data Structures and Algorithms Mocktest (Midterm) BSIT 307

50問 • 1年前

Xai Alexandrei Delos Reyes · 13問 · 1年前

Object Oriented Programming Mock Test (Midterm) BSIT 307

Object Oriented Programming Mock Test (Midterm) BSIT 307

13問 • 1年前

Xai Alexandrei Delos Reyes · 35問 · 1年前

Human Computer Interactions Mocktest (Midterms) BSIT 307

Human Computer Interactions Mocktest (Midterms) BSIT 307

35問 • 1年前

Xai Alexandrei Delos Reyes · 16問 · 1年前

Readings In Philippine History (Midterms) Mocktest

Readings In Philippine History (Midterms) Mocktest

16問 • 1年前

Xai Alexandrei Delos Reyes · 10問 · 1年前

Discrete Structures and Algorithms (Midterms) Mocktest

Discrete Structures and Algorithms (Midterms) Mocktest

10問 • 1年前

Principles of Communication (Midterm) Mocktest

Principles of Communication (Midterm) Mocktest

Xai Alexandrei Delos Reyes · 74問 · 1年前

TECHNOPRENEURSHIP PRELIMS BSIT 402

TECHNOPRENEURSHIP PRELIMS BSIT 402

74問 • 1年前

Xai Alexandrei Delos Reyes · 19問 · 1年前

(Prelim) PH Popular Culture Mocktest BSIT 402

(Prelim) PH Popular Culture Mocktest BSIT 402

19問 • 1年前

Xai Alexandrei Delos Reyes · 46問 · 1年前

(Prelim) Integrative Programming BSIT 402

(Prelim) Integrative Programming BSIT 402

46問 • 1年前

Xai Alexandrei Delos Reyes · 39問 · 1年前

(Prelim) Quantitive Methods Mocktest BSIT 402

(Prelim) Quantitive Methods Mocktest BSIT 402

39問 • 1年前

(Prelim) System Integration and Architecture BSIT 402

(Prelim) System Integration and Architecture BSIT 402

Xai Alexandrei Delos Reyes · 68問 · 1年前

(Prelim) Network Technology Mocktest BSIT 402

(Prelim) Network Technology Mocktest BSIT 402

68問 • 1年前

Xai Alexandrei Delos Reyes · 45問 · 1年前

(Prelim) Information Management Mocktest BSIT 402

(Prelim) Information Management Mocktest BSIT 402

45問 • 1年前

Xai Alexandrei Delos Reyes · 28問 · 10ヶ月前

(Pre-Finals) Quantitative Research Mocktest BSIT 402

(Pre-Finals) Quantitative Research Mocktest BSIT 402

28問 • 10ヶ月前

Xai Alexandrei Delos Reyes · 46問 · 9ヶ月前

(Finals) Philippine Popular Culture Mocktest

(Finals) Philippine Popular Culture Mocktest

46問 • 9ヶ月前

Xai Alexandrei Delos Reyes · 24問 · 9ヶ月前

(Finals) Integrative Programming Mocktest BSIT 402

(Finals) Integrative Programming Mocktest BSIT 402

24問 • 9ヶ月前

Xai Alexandrei Delos Reyes · 37問 · 9ヶ月前

(Finals) Network Technology Mocktest BSIT 402

(Finals) Network Technology Mocktest BSIT 402

37問 • 9ヶ月前

Xai Alexandrei Delos Reyes · 18問 · 9ヶ月前

(Finals) Quantitative Methods Mocktest BSIT 402

(Finals) Quantitative Methods Mocktest BSIT 402

18問 • 9ヶ月前

Xai Alexandrei Delos Reyes · 72問 · 6ヶ月前

Application Development Mocktest (Prelim) BSIT 505

Application Development Mocktest (Prelim) BSIT 505

72問 • 6ヶ月前

Xai Alexandrei Delos Reyes · 60問 · 6ヶ月前

Data and Digital Communication Mocktest (Prelim) BSIT 505

Data and Digital Communication Mocktest (Prelim) BSIT 505

60問 • 6ヶ月前

Xai Alexandrei Delos Reyes · 38問 · 6ヶ月前

(Handout 1 Only!) Advanced Systems Integration and Architecture Mocktest (Prelim) BSIT 505

(Handout 1 Only!) Advanced Systems Integration and Architecture Mocktest (Prelim) BSIT 505

38問 • 6ヶ月前

Xai Alexandrei Delos Reyes · 42問 · 6ヶ月前

Enterprise Architecture Mocktest (Prelims) BSIT 505

Enterprise Architecture Mocktest (Prelims) BSIT 505

42問 • 6ヶ月前

Xai Alexandrei Delos Reyes · 44問 · 6ヶ月前

Professional Issues in Information Technology Mocktest (Prelims) BSIT 505

Professional Issues in Information Technology Mocktest (Prelims) BSIT 505

44問 • 6ヶ月前

Xai Alexandrei Delos Reyes · 42問 · 5ヶ月前

Application Development Mocktest (Midterm) BSIT 505

Application Development Mocktest (Midterm) BSIT 505

42問 • 5ヶ月前

Xai Alexandrei Delos Reyes · 61問 · 5ヶ月前

Event-Driven Programming Mocktest (Midterm) BSIT - 505

Event-Driven Programming Mocktest (Midterm) BSIT - 505

61問 • 5ヶ月前

Xai Alexandrei Delos Reyes · 80問 · 5ヶ月前

Data and Digital Communication Mocktest (Midterm) BSIT - 505

Data and Digital Communication Mocktest (Midterm) BSIT - 505

80問 • 5ヶ月前

Xai Alexandrei Delos Reyes · 68問 · 5ヶ月前

(Midterm) Advanced Systems and Integration Architecture BSIT - 505

(Midterm) Advanced Systems and Integration Architecture BSIT - 505

68問 • 5ヶ月前

Xai Alexandrei Delos Reyes · 82問 · 5ヶ月前

(Midterm) Advanced Database Systems Mocktest BSIT - 505

(Midterm) Advanced Database Systems Mocktest BSIT - 505

82問 • 5ヶ月前

Xai Alexandrei Delos Reyes · 69問 · 5ヶ月前

(Midterms) Enterprise Architecture Mocktest BSIT 505

(Midterms) Enterprise Architecture Mocktest BSIT 505

69問 • 5ヶ月前

Xai Alexandrei Delos Reyes · 38問 · 5ヶ月前

(Midterm) Professional Issues in Information Technology BSIT 505

(Midterm) Professional Issues in Information Technology BSIT 505

38問 • 5ヶ月前

Xai Alexandrei Delos Reyes · 59問 · 4ヶ月前

(Pre-Finals)Event-Driven Programming Mocktest BSIT 505

(Pre-Finals)Event-Driven Programming Mocktest BSIT 505

59問 • 4ヶ月前

Xai Alexandrei Delos Reyes · 41問 · 4ヶ月前

(Pre-finals) Application Development Mocktest BSIT 505

(Pre-finals) Application Development Mocktest BSIT 505

41問 • 4ヶ月前

Xai Alexandrei Delos Reyes · 57問 · 4ヶ月前

(Pre-Finals) Data and Digital Communication Mocktest BSIT 505

(Pre-Finals) Data and Digital Communication Mocktest BSIT 505

57問 • 4ヶ月前

Xai Alexandrei Delos Reyes · 44問 · 4ヶ月前

(Pre-Finals) ASIA Mocktest BSIT 505

(Pre-Finals) ASIA Mocktest BSIT 505

44問 • 4ヶ月前

Xai Alexandrei Delos Reyes · 72問 · 4ヶ月前

(Pre-Finals) Advanced Database Systems Mocktest BSIT 505

(Pre-Finals) Advanced Database Systems Mocktest BSIT 505

72問 • 4ヶ月前

Xai Alexandrei Delos Reyes · 42問 · 4ヶ月前

(Pre-Finals) Enterprise Architecture Mocktest BSIT 505

(Pre-Finals) Enterprise Architecture Mocktest BSIT 505

42問 • 4ヶ月前

Xai Alexandrei Delos Reyes · 62問 · 4ヶ月前

(Pre-Finals) Professional Issues In Information Technolog Mocktest BSIT 505

(Pre-Finals) Professional Issues In Information Technolog Mocktest BSIT 505

62問 • 4ヶ月前

Xai Alexandrei Delos Reyes · 62問 · 3ヶ月前

(Finals) Application Development Mocktest BSIT 505

(Finals) Application Development Mocktest BSIT 505

62問 • 3ヶ月前

Xai Alexandrei Delos Reyes · 61問 · 3ヶ月前

(Finals) Data and Digital Communication Mocktest BSIT - 505

(Finals) Data and Digital Communication Mocktest BSIT - 505

61問 • 3ヶ月前

Xai Alexandrei Delos Reyes · 62問 · 3ヶ月前

(Finals) Advanced Database Systems Mocktest BSIT 505

(Finals) Advanced Database Systems Mocktest BSIT 505

62問 • 3ヶ月前

Xai Alexandrei Delos Reyes · 60問 · 3ヶ月前

(Finals) Enterprise Architecture Mocktest BSIT 505

(Finals) Enterprise Architecture Mocktest BSIT 505

60問 • 3ヶ月前

Xai Alexandrei Delos Reyes · 27問 · 3ヶ月前

(Finals) Professional issues in Information Technology Mocktest BSIT 505

(Finals) Professional issues in Information Technology Mocktest BSIT 505

27問 • 3ヶ月前

Xai Alexandrei Delos Reyes · 65問 · 3ヶ月前

(Finals) Event-Driven Programming Mocktest BSIT 505

(Finals) Event-Driven Programming Mocktest BSIT 505

65問 • 3ヶ月前

Xai Alexandrei Delos Reyes · 41回閲覧 · 42問 · 1ヶ月前

(Prelims) Mobile Systems and Technologies Mocktest BSIT 604

(Prelims) Mobile Systems and Technologies Mocktest BSIT 604

41回閲覧 • 42問 • 1ヶ月前

Xai Alexandrei Delos Reyes · 46回閲覧 · 75問 · 1ヶ月前

(Prelims) Great Books Mocktest BSIT 604

(Prelims) Great Books Mocktest BSIT 604

46回閲覧 • 75問 • 1ヶ月前

Xai Alexandrei Delos Reyes · 70回閲覧 · 94問 · 22日前

(Prelims) Management Information Systems Mocktest BSIT - 604

(Prelims) Management Information Systems Mocktest BSIT - 604

70回閲覧 • 94問 • 22日前

Xai Alexandrei Delos Reyes · 26回閲覧 · 79問 · 22日前

(Prelims) Programming Languages Mocktest BSIT 604

(Prelims) Programming Languages Mocktest BSIT 604

26回閲覧 • 79問 • 22日前

Xai Alexandrei Delos Reyes · 33回閲覧 · 99問 · 19日前

(Prelims) Web Systems and Technologies Mocktest BSIT 604

(Prelims) Web Systems and Technologies Mocktest BSIT 604

33回閲覧 • 99問 • 19日前

Xai Alexandrei Delos Reyes · 33回閲覧 · 92問 · 17日前

(Prelims) Information Assurance and Security Mocktest BSIT 604

(Prelims) Information Assurance and Security Mocktest BSIT 604

33回閲覧 • 92問 • 17日前

Xai Alexandrei Delos Reyes · 16問 · 6日前

(Midterms) Mobile Systems and Technologies Mocktest BSIT 604

(Midterms) Mobile Systems and Technologies Mocktest BSIT 604

16問 • 6日前

Xai Alexandrei Delos Reyes · 25問 · 9時間前

(Midterm) Great Books Mocktest BSIT 604

(Midterm) Great Books Mocktest BSIT 604

25問 • 9時間前