(Finals) Information Management Mocktest
問題一覧
1
aggregate function
2
MIN
3
MAX
4
COUNT
5
SUM
6
AVG
7
GROUP BY
8
SELECT MIN(column_name) FROM table_name;
9
SELECT MAX(column_name) FROM table_name;
10
SELECT COUNT(column_name) FROM table_name;
11
SELECT SUM(column_name) FROM table_name;
12
SELECT AVG(column_name) FROM table_name;
13
SELECT columns FROM table_name GROUP BY columns;
14
Alias
15
SELECT column_name AS alias FROM table_name;
16
SELECT columns FROM table_name GROUP BY columns HAVING condition;
17
HAVING
18
YEAR
19
MONTH
20
DAY
21
GETDATE
22
DATEADD
23
DATEDIFF
24
SELECT OrderID, YEAR(OrderDate) AS Year;
25
SELECT OrderID, MONTH(OrderDate) AS Month;
26
SELECT OrderID, DAY(OrderDate) AS Day;
27
SELECT GETDATE();
28
DATEADD(datepart, number, date);
29
DATEDIFF(datepart, date1, date2);
30
ABS
31
CEILING
32
FLOOR
33
SELECT ABS(-234.5);
34
ROUND(number, decimal places);
35
SELECT CEILING(234.1);
36
SELECT FLOOR(234.5);
37
CONCAT
38
LOWER
39
UPPER
40
SUBSTRING
41
LEN
42
TRIM
43
SELECT CONCAT(FirstName + ' ' , LastName) FROM Customers WHERE CustomerID = 3446;
44
SELECT LOWER ('FUNCTIONS');
45
SELECT UPPER('sql');
46
SELECT SUBSTRING('SQL Functions', 1, 3);
47
SELECT LEN('SQL Functions');
48
SELECT TRIM('<!> ' FROM ' <Functions! >');
49
JOIN
50
INNER JOIN
51
LEFT JOIN
52
RIGHT JOIN
53
FULL JOIN
54
SELECT Customers.CustomerID, Customers.FirstName, Orders.OrderID FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID;
55
SELECT Customers.CustomerID, Customers.FirstName, Orders.OrderID FROM Customers LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID;
56
SELECT Customers.CustomerID, Customers.FirstName, Orders.OrderID FROM Customers RIGHT JOIN Orders ON Customers.CustomerID = Orders.CustomerID;
57
SELECT Customers.CustomerID, Customers.FirstName, Orders.OrderID FROM Customers FULL JOIN Orders ON Customers.CustomerID = Orders.CustomerID;
58
2021-02-14 00:00:00.000
59
2020-08-14 00:00:00.000
60
2020-02-14 02:30:00.000
61
235
62
234
63
SQL
64
13
The Contemporary World Mock test (Prelims)
The Contemporary World Mock test (Prelims)
Xai Alexandrei Delos Reyes · 58問 · 2年前The Contemporary World Mock test (Prelims)
The Contemporary World Mock test (Prelims)
58問 • 2年前Computing Mock test (Prelims)
Computing Mock test (Prelims)
Xai Alexandrei Delos Reyes · 67問 · 2年前Computing Mock test (Prelims)
Computing Mock test (Prelims)
67問 • 2年前Programming Mock Test (Prelims)
Programming Mock Test (Prelims)
Xai Alexandrei Delos Reyes · 64問 · 2年前Programming Mock Test (Prelims)
Programming Mock Test (Prelims)
64問 • 2年前Entrepreneurship Mock Test (Prelims)
Entrepreneurship Mock Test (Prelims)
Xai Alexandrei Delos Reyes · 23問 · 2年前Entrepreneurship Mock Test (Prelims)
Entrepreneurship Mock Test (Prelims)
23問 • 2年前Computing Mock Test (Midterms) BSIT 107
Computing Mock Test (Midterms) BSIT 107
Xai Alexandrei Delos Reyes · 76問 · 2年前Computing Mock Test (Midterms) BSIT 107
Computing Mock Test (Midterms) BSIT 107
76問 • 2年前Math Mock Test (Prelims)
Math Mock Test (Prelims)
Xai Alexandrei Delos Reyes · 48問 · 2年前Math Mock Test (Prelims)
Math Mock Test (Prelims)
48問 • 2年前Programming Mock Test (Midterms) BSIT 107
Programming Mock Test (Midterms) BSIT 107
Xai Alexandrei Delos Reyes · 52問 · 2年前Programming Mock Test (Midterms) BSIT 107
Programming Mock Test (Midterms) BSIT 107
52問 • 2年前UTS Mock Test (Midterms) BSIT107
UTS Mock Test (Midterms) BSIT107
Xai Alexandrei Delos Reyes · 40問 · 2年前UTS Mock Test (Midterms) BSIT107
UTS Mock Test (Midterms) BSIT107
40問 • 2年前Entrepreneurship Mock Test (Midterms) BSIT 107
Entrepreneurship Mock Test (Midterms) BSIT 107
Xai Alexandrei Delos Reyes · 38問 · 2年前Entrepreneurship Mock Test (Midterms) BSIT 107
Entrepreneurship Mock Test (Midterms) BSIT 107
38問 • 2年前Contemporary World Mock Test (Midterms) BSIT 107
Contemporary World Mock Test (Midterms) BSIT 107
Xai Alexandrei Delos Reyes · 28問 · 2年前Contemporary World Mock Test (Midterms) BSIT 107
Contemporary World Mock Test (Midterms) BSIT 107
28問 • 2年前Math Mocktest (Midterms) BSIT 107
Math Mocktest (Midterms) BSIT 107
Xai Alexandrei Delos Reyes · 24問 · 2年前Math Mocktest (Midterms) BSIT 107
Math Mocktest (Midterms) BSIT 107
24問 • 2年前Computer Programming Mocktest (Pre-finals)
Computer Programming Mocktest (Pre-finals)
Xai Alexandrei Delos Reyes · 26問 · 2年前Computer Programming Mocktest (Pre-finals)
Computer Programming Mocktest (Pre-finals)
26問 • 2年前Math Mocktest (Pre-Finals)
Math Mocktest (Pre-Finals)
Xai Alexandrei Delos Reyes · 19問 · 2年前Math Mocktest (Pre-Finals)
Math Mocktest (Pre-Finals)
19問 • 2年前Computing Mock Test (Pre-finals)
Computing Mock Test (Pre-finals)
Xai Alexandrei Delos Reyes · 36問 · 2年前Computing Mock Test (Pre-finals)
Computing Mock Test (Pre-finals)
36問 • 2年前Computing Mock Test Finals
Computing Mock Test Finals
Xai Alexandrei Delos Reyes · 26問 · 2年前Computing Mock Test Finals
Computing Mock Test Finals
26問 • 2年前Comprog 2nd sem (prelims) BSIT 205
Comprog 2nd sem (prelims) BSIT 205
Xai Alexandrei Delos Reyes · 63問 · 2年前Comprog 2nd sem (prelims) BSIT 205
Comprog 2nd sem (prelims) BSIT 205
63問 • 2年前Discrete Math 2nd sem (prelims) BSIT 205
Discrete Math 2nd sem (prelims) BSIT 205
Xai Alexandrei Delos Reyes · 36問 · 2年前Discrete Math 2nd sem (prelims) BSIT 205
Discrete Math 2nd sem (prelims) BSIT 205
36問 • 2年前Art Appreciation (Prelim) BSIT 205
Art Appreciation (Prelim) BSIT 205
Xai Alexandrei Delos Reyes · 56問 · 2年前Art Appreciation (Prelim) BSIT 205
Art Appreciation (Prelim) BSIT 205
56問 • 2年前Ethics 2nd sem (Prelims) BSIT 205
Ethics 2nd sem (Prelims) BSIT 205
Xai Alexandrei Delos Reyes · 45問 · 2年前Ethics 2nd sem (Prelims) BSIT 205
Ethics 2nd sem (Prelims) BSIT 205
45問 • 2年前STS 2nd Sem (Prelim) BSIT 205
STS 2nd Sem (Prelim) BSIT 205
Xai Alexandrei Delos Reyes · 40問 · 2年前STS 2nd Sem (Prelim) BSIT 205
STS 2nd Sem (Prelim) BSIT 205
40問 • 2年前Systems Administration 2nd sem (Prelims) BSIT 205
Systems Administration 2nd sem (Prelims) BSIT 205
Xai Alexandrei Delos Reyes · 72問 · 2年前Systems Administration 2nd sem (Prelims) BSIT 205
Systems Administration 2nd sem (Prelims) BSIT 205
72問 • 2年前Discrete Mathematics (Midterms) BSIT 205
Discrete Mathematics (Midterms) BSIT 205
Xai Alexandrei Delos Reyes · 52問 · 1年前Discrete Mathematics (Midterms) BSIT 205
Discrete Mathematics (Midterms) BSIT 205
52問 • 1年前Art Appreciation (Midterm) BSIT 205
Art Appreciation (Midterm) BSIT 205
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 · 29問 · 1年前Ethics Mocktest (Midterms) BSIT205
Ethics Mocktest (Midterms) BSIT205
29問 • 1年前Comprog Mocktest (Midterm) BSIT 205
Comprog Mocktest (Midterm) BSIT 205
Xai Alexandrei Delos Reyes · 61問 · 1年前Comprog Mocktest (Midterm) BSIT 205
Comprog Mocktest (Midterm) BSIT 205
61問 • 1年前System Administration Mocktest (Midterms) BSIT 205
System Administration Mocktest (Midterms) BSIT 205
Xai Alexandrei Delos Reyes · 65問 · 1年前System Administration Mocktest (Midterms) BSIT 205
System Administration Mocktest (Midterms) BSIT 205
65問 • 1年前Math Mocktest (Pre-finals) BSIT 205
Math Mocktest (Pre-finals) BSIT 205
Xai Alexandrei Delos Reyes · 49問 · 1年前Math Mocktest (Pre-finals) BSIT 205
Math Mocktest (Pre-finals) BSIT 205
49問 • 1年前Art Appreciation Mocktest (Pre-finals) BSIT 205
Art Appreciation Mocktest (Pre-finals) BSIT 205
Xai Alexandrei Delos Reyes · 66問 · 1年前Art Appreciation Mocktest (Pre-finals) BSIT 205
Art Appreciation Mocktest (Pre-finals) BSIT 205
66問 • 1年前Ethics Mocktest (Pre-finals) BSIT 205
Ethics Mocktest (Pre-finals) BSIT 205
Xai Alexandrei Delos Reyes · 50問 · 1年前Ethics Mocktest (Pre-finals) BSIT 205
Ethics Mocktest (Pre-finals) BSIT 205
50問 • 1年前Computer Programming Mocktest (Pre-finals) BSIT 205
Computer Programming Mocktest (Pre-finals) BSIT 205
Xai Alexandrei Delos Reyes · 33問 · 1年前Computer Programming Mocktest (Pre-finals) BSIT 205
Computer Programming Mocktest (Pre-finals) BSIT 205
33問 • 1年前System Administration (Pre-finals) BSIT 205
System Administration (Pre-finals) BSIT 205
Xai Alexandrei Delos Reyes · 52問 · 1年前System Administration (Pre-finals) BSIT 205
System Administration (Pre-finals) BSIT 205
52問 • 1年前Art Appreciation Finals BSIT 205
Art Appreciation Finals BSIT 205
Xai Alexandrei Delos Reyes · 35問 · 1年前Art Appreciation Finals BSIT 205
Art Appreciation Finals BSIT 205
35問 • 1年前Data Structures and Algorithms (Mocktest) BSIT 307
Data Structures and Algorithms (Mocktest) BSIT 307
Xai Alexandrei Delos Reyes · 52問 · 1年前Data Structures and Algorithms (Mocktest) BSIT 307
Data Structures and Algorithms (Mocktest) BSIT 307
52問 • 1年前Object Oriented Programming Mock Test (Mocktest) BSIT 307
Object Oriented Programming Mock Test (Mocktest) BSIT 307
Xai Alexandrei Delos Reyes · 23問 · 1年前Object Oriented Programming Mock Test (Mocktest) BSIT 307
Object Oriented Programming Mock Test (Mocktest) BSIT 307
23問 • 1年前Human Computer Interactions Mocktest (Prelims) BSIT 307
Human Computer Interactions Mocktest (Prelims) BSIT 307
Xai Alexandrei Delos Reyes · 58問 · 1年前Human Computer Interactions Mocktest (Prelims) BSIT 307
Human Computer Interactions Mocktest (Prelims) BSIT 307
58問 • 1年前Principles of Communication Mocktest (Prelims) BSIT 307
Principles of Communication Mocktest (Prelims) BSIT 307
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 · 29問 · 1年前Principles of Communication Mocktest (Midterms) BSIT 307
Principles of Communication Mocktest (Midterms) BSIT 307
29問 • 1年前Data Structures and Algorithms Mocktest (Midterm) BSIT 307
Data Structures and Algorithms Mocktest (Midterm) 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年前Object Oriented Programming Mock Test (Midterm) BSIT 307
Object Oriented Programming Mock Test (Midterm) BSIT 307
Xai Alexandrei Delos Reyes · 13問 · 1年前Object Oriented Programming Mock Test (Midterm) BSIT 307
Object Oriented Programming Mock Test (Midterm) BSIT 307
13問 • 1年前Human Computer Interactions Mocktest (Midterms) BSIT 307
Human Computer Interactions Mocktest (Midterms) BSIT 307
Xai Alexandrei Delos Reyes · 35問 · 1年前Human Computer Interactions Mocktest (Midterms) BSIT 307
Human Computer Interactions Mocktest (Midterms) BSIT 307
35問 • 1年前Readings In Philippine History (Midterms) Mocktest
Readings In Philippine History (Midterms) Mocktest
Xai Alexandrei Delos Reyes · 16問 · 1年前Readings In Philippine History (Midterms) Mocktest
Readings In Philippine History (Midterms) Mocktest
16問 • 1年前Discrete Structures and Algorithms (Midterms) Mocktest
Discrete Structures and Algorithms (Midterms) Mocktest
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 · 29問 · 1年前Principles of Communication (Midterm) Mocktest
Principles of Communication (Midterm) Mocktest
29問 • 1年前TECHNOPRENEURSHIP PRELIMS BSIT 402
TECHNOPRENEURSHIP PRELIMS BSIT 402
Xai Alexandrei Delos Reyes · 74問 · 1年前TECHNOPRENEURSHIP PRELIMS BSIT 402
TECHNOPRENEURSHIP PRELIMS BSIT 402
74問 • 1年前(Prelim) PH Popular Culture Mocktest BSIT 402
(Prelim) PH Popular Culture Mocktest BSIT 402
Xai Alexandrei Delos Reyes · 19問 · 1年前(Prelim) PH Popular Culture Mocktest BSIT 402
(Prelim) PH Popular Culture Mocktest BSIT 402
19問 • 1年前(Prelim) Integrative Programming BSIT 402
(Prelim) Integrative Programming BSIT 402
Xai Alexandrei Delos Reyes · 46問 · 1年前(Prelim) Integrative Programming BSIT 402
(Prelim) Integrative Programming BSIT 402
46問 • 1年前(Prelim) Quantitive Methods Mocktest BSIT 402
(Prelim) Quantitive Methods Mocktest BSIT 402
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 · 29問 · 1年前(Prelim) System Integration and Architecture BSIT 402
(Prelim) System Integration and Architecture BSIT 402
29問 • 1年前(Prelim) Network Technology Mocktest BSIT 402
(Prelim) Network Technology Mocktest BSIT 402
Xai Alexandrei Delos Reyes · 68問 · 1年前(Prelim) Network Technology Mocktest BSIT 402
(Prelim) Network Technology Mocktest BSIT 402
68問 • 1年前(Prelim) Information Management Mocktest BSIT 402
(Prelim) Information Management Mocktest BSIT 402
Xai Alexandrei Delos Reyes · 45問 · 1年前(Prelim) Information Management Mocktest BSIT 402
(Prelim) Information Management Mocktest BSIT 402
45問 • 1年前(Pre-Finals) Quantitative Research Mocktest BSIT 402
(Pre-Finals) Quantitative Research Mocktest BSIT 402
Xai Alexandrei Delos Reyes · 28問 · 10ヶ月前(Pre-Finals) Quantitative Research Mocktest BSIT 402
(Pre-Finals) Quantitative Research Mocktest BSIT 402
28問 • 10ヶ月前(Finals) Philippine Popular Culture Mocktest
(Finals) Philippine Popular Culture Mocktest
Xai Alexandrei Delos Reyes · 46問 · 9ヶ月前(Finals) Philippine Popular Culture Mocktest
(Finals) Philippine Popular Culture Mocktest
46問 • 9ヶ月前(Finals) Integrative Programming Mocktest BSIT 402
(Finals) Integrative Programming Mocktest BSIT 402
Xai Alexandrei Delos Reyes · 24問 · 9ヶ月前(Finals) Integrative Programming Mocktest BSIT 402
(Finals) Integrative Programming Mocktest BSIT 402
24問 • 9ヶ月前(Finals) Network Technology Mocktest BSIT 402
(Finals) Network Technology Mocktest BSIT 402
Xai Alexandrei Delos Reyes · 37問 · 9ヶ月前(Finals) Network Technology Mocktest BSIT 402
(Finals) Network Technology Mocktest BSIT 402
37問 • 9ヶ月前(Finals) Quantitative Methods Mocktest BSIT 402
(Finals) Quantitative Methods Mocktest BSIT 402
Xai Alexandrei Delos Reyes · 18問 · 9ヶ月前(Finals) Quantitative Methods Mocktest BSIT 402
(Finals) Quantitative Methods Mocktest BSIT 402
18問 • 9ヶ月前Application Development Mocktest (Prelim) BSIT 505
Application Development Mocktest (Prelim) BSIT 505
Xai Alexandrei Delos Reyes · 72問 · 6ヶ月前Application Development Mocktest (Prelim) BSIT 505
Application Development Mocktest (Prelim) BSIT 505
72問 • 6ヶ月前Data and Digital Communication Mocktest (Prelim) BSIT 505
Data and Digital Communication Mocktest (Prelim) BSIT 505
Xai Alexandrei Delos Reyes · 60問 · 6ヶ月前Data and Digital Communication Mocktest (Prelim) BSIT 505
Data and Digital Communication Mocktest (Prelim) BSIT 505
60問 • 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
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ヶ月前Enterprise Architecture Mocktest (Prelims) BSIT 505
Enterprise Architecture Mocktest (Prelims) BSIT 505
Xai Alexandrei Delos Reyes · 42問 · 6ヶ月前Enterprise Architecture Mocktest (Prelims) BSIT 505
Enterprise Architecture Mocktest (Prelims) BSIT 505
42問 • 6ヶ月前Professional Issues in Information Technology Mocktest (Prelims) BSIT 505
Professional Issues in Information Technology Mocktest (Prelims) BSIT 505
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ヶ月前Application Development Mocktest (Midterm) BSIT 505
Application Development Mocktest (Midterm) BSIT 505
Xai Alexandrei Delos Reyes · 42問 · 6ヶ月前Application Development Mocktest (Midterm) BSIT 505
Application Development Mocktest (Midterm) BSIT 505
42問 • 6ヶ月前Event-Driven Programming Mocktest (Midterm) BSIT - 505
Event-Driven Programming Mocktest (Midterm) BSIT - 505
Xai Alexandrei Delos Reyes · 61問 · 6ヶ月前Event-Driven Programming Mocktest (Midterm) BSIT - 505
Event-Driven Programming Mocktest (Midterm) BSIT - 505
61問 • 6ヶ月前Data and Digital Communication Mocktest (Midterm) BSIT - 505
Data and Digital Communication Mocktest (Midterm) BSIT - 505
Xai Alexandrei Delos Reyes · 80問 · 6ヶ月前Data and Digital Communication Mocktest (Midterm) BSIT - 505
Data and Digital Communication Mocktest (Midterm) BSIT - 505
80問 • 6ヶ月前(Midterm) Advanced Systems and Integration Architecture BSIT - 505
(Midterm) Advanced Systems and Integration Architecture BSIT - 505
Xai Alexandrei Delos Reyes · 68問 · 5ヶ月前(Midterm) Advanced Systems and Integration Architecture BSIT - 505
(Midterm) Advanced Systems and Integration Architecture BSIT - 505
68問 • 5ヶ月前(Midterm) Advanced Database Systems Mocktest BSIT - 505
(Midterm) Advanced Database Systems Mocktest BSIT - 505
Xai Alexandrei Delos Reyes · 82問 · 5ヶ月前(Midterm) Advanced Database Systems Mocktest BSIT - 505
(Midterm) Advanced Database Systems Mocktest BSIT - 505
82問 • 5ヶ月前(Midterms) Enterprise Architecture Mocktest BSIT 505
(Midterms) Enterprise Architecture Mocktest BSIT 505
Xai Alexandrei Delos Reyes · 69問 · 5ヶ月前(Midterms) Enterprise Architecture Mocktest BSIT 505
(Midterms) Enterprise Architecture Mocktest BSIT 505
69問 • 5ヶ月前(Midterm) Professional Issues in Information Technology BSIT 505
(Midterm) Professional Issues in Information Technology BSIT 505
Xai Alexandrei Delos Reyes · 38問 · 5ヶ月前(Midterm) Professional Issues in Information Technology BSIT 505
(Midterm) Professional Issues in Information Technology BSIT 505
38問 • 5ヶ月前(Pre-Finals)Event-Driven Programming Mocktest BSIT 505
(Pre-Finals)Event-Driven Programming Mocktest BSIT 505
Xai Alexandrei Delos Reyes · 59問 · 4ヶ月前(Pre-Finals)Event-Driven Programming Mocktest BSIT 505
(Pre-Finals)Event-Driven Programming Mocktest BSIT 505
59問 • 4ヶ月前(Pre-finals) Application Development Mocktest BSIT 505
(Pre-finals) Application Development Mocktest BSIT 505
Xai Alexandrei Delos Reyes · 41問 · 4ヶ月前(Pre-finals) Application Development Mocktest BSIT 505
(Pre-finals) Application Development Mocktest BSIT 505
41問 • 4ヶ月前(Pre-Finals) Data and Digital Communication Mocktest BSIT 505
(Pre-Finals) Data and Digital Communication Mocktest BSIT 505
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ヶ月前(Pre-Finals) ASIA Mocktest BSIT 505
(Pre-Finals) ASIA Mocktest BSIT 505
Xai Alexandrei Delos Reyes · 44問 · 4ヶ月前(Pre-Finals) ASIA Mocktest BSIT 505
(Pre-Finals) ASIA Mocktest BSIT 505
44問 • 4ヶ月前(Pre-Finals) Advanced Database Systems Mocktest BSIT 505
(Pre-Finals) Advanced Database Systems Mocktest BSIT 505
Xai Alexandrei Delos Reyes · 72問 · 4ヶ月前(Pre-Finals) Advanced Database Systems Mocktest BSIT 505
(Pre-Finals) Advanced Database Systems Mocktest BSIT 505
72問 • 4ヶ月前(Pre-Finals) Enterprise Architecture Mocktest BSIT 505
(Pre-Finals) Enterprise Architecture Mocktest BSIT 505
Xai Alexandrei Delos Reyes · 42問 · 4ヶ月前(Pre-Finals) Enterprise Architecture Mocktest BSIT 505
(Pre-Finals) Enterprise Architecture Mocktest BSIT 505
42問 • 4ヶ月前(Pre-Finals) Professional Issues In Information Technolog Mocktest BSIT 505
(Pre-Finals) Professional Issues In Information Technolog Mocktest BSIT 505
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ヶ月前(Finals) Application Development Mocktest BSIT 505
(Finals) Application Development Mocktest BSIT 505
Xai Alexandrei Delos Reyes · 62問 · 3ヶ月前(Finals) Application Development Mocktest BSIT 505
(Finals) Application Development Mocktest BSIT 505
62問 • 3ヶ月前(Finals) Data and Digital Communication Mocktest BSIT - 505
(Finals) Data and Digital Communication Mocktest BSIT - 505
Xai Alexandrei Delos Reyes · 61問 · 3ヶ月前(Finals) Data and Digital Communication Mocktest BSIT - 505
(Finals) Data and Digital Communication Mocktest BSIT - 505
61問 • 3ヶ月前(Finals) Advanced Database Systems Mocktest BSIT 505
(Finals) Advanced Database Systems Mocktest BSIT 505
Xai Alexandrei Delos Reyes · 62問 · 3ヶ月前(Finals) Advanced Database Systems Mocktest BSIT 505
(Finals) Advanced Database Systems Mocktest BSIT 505
62問 • 3ヶ月前(Finals) Enterprise Architecture Mocktest BSIT 505
(Finals) Enterprise Architecture Mocktest BSIT 505
Xai Alexandrei Delos Reyes · 60問 · 3ヶ月前(Finals) Enterprise Architecture Mocktest BSIT 505
(Finals) Enterprise Architecture Mocktest BSIT 505
60問 • 3ヶ月前(Finals) Professional issues in Information Technology Mocktest BSIT 505
(Finals) Professional issues in Information Technology Mocktest BSIT 505
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ヶ月前(Finals) Event-Driven Programming Mocktest BSIT 505
(Finals) Event-Driven Programming Mocktest BSIT 505
Xai Alexandrei Delos Reyes · 65問 · 4ヶ月前(Finals) Event-Driven Programming Mocktest BSIT 505
(Finals) Event-Driven Programming Mocktest BSIT 505
65問 • 4ヶ月前(Prelims) Mobile Systems and Technologies Mocktest BSIT 604
(Prelims) Mobile Systems and Technologies Mocktest BSIT 604
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ヶ月前(Prelims) Great Books Mocktest BSIT 604
(Prelims) Great Books Mocktest BSIT 604
Xai Alexandrei Delos Reyes · 46回閲覧 · 75問 · 1ヶ月前(Prelims) Great Books Mocktest BSIT 604
(Prelims) Great Books Mocktest BSIT 604
46回閲覧 • 75問 • 1ヶ月前(Prelims) Management Information Systems Mocktest BSIT - 604
(Prelims) Management Information Systems Mocktest BSIT - 604
Xai Alexandrei Delos Reyes · 70回閲覧 · 94問 · 1ヶ月前(Prelims) Management Information Systems Mocktest BSIT - 604
(Prelims) Management Information Systems Mocktest BSIT - 604
70回閲覧 • 94問 • 1ヶ月前(Prelims) Programming Languages Mocktest BSIT 604
(Prelims) Programming Languages Mocktest BSIT 604
Xai Alexandrei Delos Reyes · 26回閲覧 · 79問 · 1ヶ月前(Prelims) Programming Languages Mocktest BSIT 604
(Prelims) Programming Languages Mocktest BSIT 604
26回閲覧 • 79問 • 1ヶ月前(Prelims) Web Systems and Technologies Mocktest BSIT 604
(Prelims) Web Systems and Technologies Mocktest BSIT 604
Xai Alexandrei Delos Reyes · 33回閲覧 · 99問 · 29日前(Prelims) Web Systems and Technologies Mocktest BSIT 604
(Prelims) Web Systems and Technologies Mocktest BSIT 604
33回閲覧 • 99問 • 29日前(Prelims) Information Assurance and Security Mocktest BSIT 604
(Prelims) Information Assurance and Security Mocktest BSIT 604
Xai Alexandrei Delos Reyes · 33回閲覧 · 92問 · 28日前(Prelims) Information Assurance and Security Mocktest BSIT 604
(Prelims) Information Assurance and Security Mocktest BSIT 604
33回閲覧 • 92問 • 28日前(Midterms) Mobile Systems and Technologies Mocktest BSIT 604
(Midterms) Mobile Systems and Technologies Mocktest BSIT 604
Xai Alexandrei Delos Reyes · 54問 · 17日前(Midterms) Mobile Systems and Technologies Mocktest BSIT 604
(Midterms) Mobile Systems and Technologies Mocktest BSIT 604
54問 • 17日前(Midterm) Great Books Mocktest BSIT 604
(Midterm) Great Books Mocktest BSIT 604
Xai Alexandrei Delos Reyes · 72問 · 11日前(Midterm) Great Books Mocktest BSIT 604
(Midterm) Great Books Mocktest BSIT 604
72問 • 11日前(Midterms) 04 to 05_Handout Management Information Systems Mocktest BSIT 604
(Midterms) 04 to 05_Handout Management Information Systems Mocktest BSIT 604
Xai Alexandrei Delos Reyes · 69問 · 4日前(Midterms) 04 to 05_Handout Management Information Systems Mocktest BSIT 604
(Midterms) 04 to 05_Handout Management Information Systems Mocktest BSIT 604
69問 • 4日前(Midterms) 06_Handout Management Information Systems Mocktest BSIT 604
(Midterms) 06_Handout Management Information Systems Mocktest BSIT 604
Xai Alexandrei Delos Reyes · 36問 · 4日前(Midterms) 06_Handout Management Information Systems Mocktest BSIT 604
(Midterms) 06_Handout Management Information Systems Mocktest BSIT 604
36問 • 4日前(Midterms) Programming Languages Mocktest BSIT 604
(Midterms) Programming Languages Mocktest BSIT 604
Xai Alexandrei Delos Reyes · 81問 · 3日前(Midterms) Programming Languages Mocktest BSIT 604
(Midterms) Programming Languages Mocktest BSIT 604
81問 • 3日前(Midterms) Information Assurance and Security Mocktest BSIT 604
(Midterms) Information Assurance and Security Mocktest BSIT 604
Xai Alexandrei Delos Reyes · 84問 · 4日前(Midterms) Information Assurance and Security Mocktest BSIT 604
(Midterms) Information Assurance and Security Mocktest BSIT 604
84問 • 4日前(Midterms) Web Systems an Technologies Mocktest BSIT 604
(Midterms) Web Systems an Technologies Mocktest BSIT 604
Xai Alexandrei Delos Reyes · 87問 · 3日前(Midterms) Web Systems an Technologies Mocktest BSIT 604
(Midterms) Web Systems an Technologies Mocktest BSIT 604
87問 • 3日前問題一覧
1
aggregate function
2
MIN
3
MAX
4
COUNT
5
SUM
6
AVG
7
GROUP BY
8
SELECT MIN(column_name) FROM table_name;
9
SELECT MAX(column_name) FROM table_name;
10
SELECT COUNT(column_name) FROM table_name;
11
SELECT SUM(column_name) FROM table_name;
12
SELECT AVG(column_name) FROM table_name;
13
SELECT columns FROM table_name GROUP BY columns;
14
Alias
15
SELECT column_name AS alias FROM table_name;
16
SELECT columns FROM table_name GROUP BY columns HAVING condition;
17
HAVING
18
YEAR
19
MONTH
20
DAY
21
GETDATE
22
DATEADD
23
DATEDIFF
24
SELECT OrderID, YEAR(OrderDate) AS Year;
25
SELECT OrderID, MONTH(OrderDate) AS Month;
26
SELECT OrderID, DAY(OrderDate) AS Day;
27
SELECT GETDATE();
28
DATEADD(datepart, number, date);
29
DATEDIFF(datepart, date1, date2);
30
ABS
31
CEILING
32
FLOOR
33
SELECT ABS(-234.5);
34
ROUND(number, decimal places);
35
SELECT CEILING(234.1);
36
SELECT FLOOR(234.5);
37
CONCAT
38
LOWER
39
UPPER
40
SUBSTRING
41
LEN
42
TRIM
43
SELECT CONCAT(FirstName + ' ' , LastName) FROM Customers WHERE CustomerID = 3446;
44
SELECT LOWER ('FUNCTIONS');
45
SELECT UPPER('sql');
46
SELECT SUBSTRING('SQL Functions', 1, 3);
47
SELECT LEN('SQL Functions');
48
SELECT TRIM('<!> ' FROM ' <Functions! >');
49
JOIN
50
INNER JOIN
51
LEFT JOIN
52
RIGHT JOIN
53
FULL JOIN
54
SELECT Customers.CustomerID, Customers.FirstName, Orders.OrderID FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID;
55
SELECT Customers.CustomerID, Customers.FirstName, Orders.OrderID FROM Customers LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID;
56
SELECT Customers.CustomerID, Customers.FirstName, Orders.OrderID FROM Customers RIGHT JOIN Orders ON Customers.CustomerID = Orders.CustomerID;
57
SELECT Customers.CustomerID, Customers.FirstName, Orders.OrderID FROM Customers FULL JOIN Orders ON Customers.CustomerID = Orders.CustomerID;
58
2021-02-14 00:00:00.000
59
2020-08-14 00:00:00.000
60
2020-02-14 02:30:00.000
61
235
62
234
63
SQL
64
13