TestMaker

TestMaker

​
Sign in

(Finals) Information Management Mocktest

(Finals) Information Management Mocktest
64 questions • 9 mo ago
  • Xai Alexandrei Delos Reyes
    • Report

    Question list

  • 1

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

    aggregate function

  • 2

    the minimum attribute value encountered in a given column

    MIN

  • 3

    the maximum attribute value encountered in a given column

    MAX

  • 4

    the number of rows containing non-null values

    COUNT

  • 5

    the sum of all values for a given column

    SUM

  • 6

    the arithmetic mean (average) for a specified column

    AVG

  • 7

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

    GROUP BY

  • 8

    What is the CORRECT syntax for MIN

    SELECT MIN(column_name) FROM table_name;

  • 9

    What is the CORRECT syntax for MAX

    SELECT MAX(column_name) FROM table_name;

  • 10

    What is the CORRECT syntax for COUNT

    SELECT COUNT(column_name) FROM table_name;

  • 11

    What is the CORRECT syntax for SUM

    SELECT SUM(column_name) FROM table_name;

  • 12

    What is the CORRECT syntax for AVG

    SELECT AVG(column_name) FROM table_name;

  • 13

    What is the CORRECT syntax for GROUP BY

    SELECT columns FROM table_name GROUP BY columns;

  • 14

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

    Alias

  • 15

    What is the CORRECT syntax of ALIAS

    SELECT column_name AS alias FROM table_name;

  • 16

    What is the CORRECT syntax of HAVING

    SELECT columns FROM table_name GROUP BY columns HAVING condition;

  • 17

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

    HAVING

  • 18

    returns a four-digit year

    YEAR

  • 19

    returns the number of the month

    MONTH

  • 20

    returns the number of the day

    DAY

  • 21

    returns the current date and time

    GETDATE

  • 22

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

    DATEADD

  • 23

    returns the difference between two (2) dates

    DATEDIFF

  • 24

    What is the CORRECT syntax for YEAR

    SELECT OrderID, YEAR(OrderDate) AS Year;

  • 25

    What is the CORRECT syntax for MONTH

    SELECT OrderID, MONTH(OrderDate) AS Month;

  • 26

    What is the CORRECT syntax for DAY

    SELECT OrderID, DAY(OrderDate) AS Day;

  • 27

    What is the CORRECT syntax for GETDATE

    SELECT GETDATE();

  • 28

    What is the CORRECT syntax for DATEADD

    DATEADD(datepart, number, date);

  • 29

    What is the CORRECT syntax for DATEDIFF

    DATEDIFF(datepart, date1, date2);

  • 30

    returns the absolute value of a number

    ABS

  • 31

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

    CEILING

  • 32

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

    FLOOR

  • 33

    What is the CORRECT syntax for ABS

    SELECT ABS(-234.5);

  • 34

    What is the CORRECT syntax for ROUND

    ROUND(number, decimal places);

  • 35

    What is the CORRECT syntax for CEILING

    SELECT CEILING(234.1);

  • 36

    What is the CORRECT syntax for FLOOR

    SELECT FLOOR(234.5);

  • 37

    joins two or more strings together

    CONCAT

  • 38

    returns a string in lowercase letters

    LOWER

  • 39

    returns a string in all capital letters

    UPPER

  • 40

    returns a part of a string

    SUBSTRING

  • 41

    returns the number of characters in a string

    LEN

  • 42

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

    TRIM

  • 43

    What is the CORRECT syntax for CONCAT

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

  • 44

    What is the CORRECT syntax for LOWER

    SELECT LOWER ('FUNCTIONS');

  • 45

    What is the CORRECT syntax for UPPER

    SELECT UPPER('sql');

  • 46

    What is the CORRECT syntax for SUBSTRING

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

  • 47

    What is the CORRECT syntax for LEN

    SELECT LEN('SQL Functions');

  • 48

    What is the CORRECT syntax for TRIM

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

  • 49

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

    JOIN

  • 50

    returns rows that have matching values in both tables

    INNER JOIN

  • 51

    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

  • 52

    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

  • 53

    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

  • 54

    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;

  • 55

    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;

  • 56

    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;

  • 57

    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;

  • 58

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

    2021-02-14 00:00:00.000

  • 59

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

    2020-08-14 00:00:00.000

  • 60

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

    2020-02-14 02:30:00.000

  • 61

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

    235

  • 62

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

    234

  • 63

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

    SQL

  • 64

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

    13

    • The Contemporary World Mock test (Prelims)

    The Contemporary World Mock test (Prelims)

    Xai Alexandrei Delos Reyes · 58 questions · 2 y ago

    The Contemporary World Mock test (Prelims)

    The Contemporary World Mock test (Prelims)

    58 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Computing Mock test (Prelims)

    Computing Mock test (Prelims)

    Xai Alexandrei Delos Reyes · 67 questions · 2 y ago

    Computing Mock test (Prelims)

    Computing Mock test (Prelims)

    67 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Programming Mock Test (Prelims)

    Programming Mock Test (Prelims)

    Xai Alexandrei Delos Reyes · 64 questions · 2 y ago

    Programming Mock Test (Prelims)

    Programming Mock Test (Prelims)

    64 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Entrepreneurship Mock Test (Prelims)

    Entrepreneurship Mock Test (Prelims)

    Xai Alexandrei Delos Reyes · 23 questions · 2 y ago

    Entrepreneurship Mock Test (Prelims)

    Entrepreneurship Mock Test (Prelims)

    23 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Computing Mock Test (Midterms) BSIT 107

    Computing Mock Test (Midterms) BSIT 107

    Xai Alexandrei Delos Reyes · 76 questions · 2 y ago

    Computing Mock Test (Midterms) BSIT 107

    Computing Mock Test (Midterms) BSIT 107

    76 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Math Mock Test (Prelims)

    Math Mock Test (Prelims)

    Xai Alexandrei Delos Reyes · 48 questions · 2 y ago

    Math Mock Test (Prelims)

    Math Mock Test (Prelims)

    48 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Programming Mock Test (Midterms) BSIT 107

    Programming Mock Test (Midterms) BSIT 107

    Xai Alexandrei Delos Reyes · 52 questions · 2 y ago

    Programming Mock Test (Midterms) BSIT 107

    Programming Mock Test (Midterms) BSIT 107

    52 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    UTS Mock Test (Midterms) BSIT107

    UTS Mock Test (Midterms) BSIT107

    Xai Alexandrei Delos Reyes · 40 questions · 2 y ago

    UTS Mock Test (Midterms) BSIT107

    UTS Mock Test (Midterms) BSIT107

    40 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Entrepreneurship Mock Test (Midterms) BSIT 107

    Entrepreneurship Mock Test (Midterms) BSIT 107

    Xai Alexandrei Delos Reyes · 38 questions · 2 y ago

    Entrepreneurship Mock Test (Midterms) BSIT 107

    Entrepreneurship Mock Test (Midterms) BSIT 107

    38 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Contemporary World Mock Test (Midterms) BSIT 107

    Contemporary World Mock Test (Midterms) BSIT 107

    Xai Alexandrei Delos Reyes · 28 questions · 2 y ago

    Contemporary World Mock Test (Midterms) BSIT 107

    Contemporary World Mock Test (Midterms) BSIT 107

    28 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Math Mocktest (Midterms) BSIT 107

    Math Mocktest (Midterms) BSIT 107

    Xai Alexandrei Delos Reyes · 24 questions · 2 y ago

    Math Mocktest (Midterms) BSIT 107

    Math Mocktest (Midterms) BSIT 107

    24 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Computer Programming Mocktest (Pre-finals)

    Computer Programming Mocktest (Pre-finals)

    Xai Alexandrei Delos Reyes · 26 questions · 2 y ago

    Computer Programming Mocktest (Pre-finals)

    Computer Programming Mocktest (Pre-finals)

    26 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Math Mocktest (Pre-Finals)

    Math Mocktest (Pre-Finals)

    Xai Alexandrei Delos Reyes · 19 questions · 2 y ago

    Math Mocktest (Pre-Finals)

    Math Mocktest (Pre-Finals)

    19 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Computing Mock Test (Pre-finals)

    Computing Mock Test (Pre-finals)

    Xai Alexandrei Delos Reyes · 36 questions · 2 y ago

    Computing Mock Test (Pre-finals)

    Computing Mock Test (Pre-finals)

    36 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Computing Mock Test Finals

    Computing Mock Test Finals

    Xai Alexandrei Delos Reyes · 26 questions · 2 y ago

    Computing Mock Test Finals

    Computing Mock Test Finals

    26 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Comprog 2nd sem (prelims) BSIT 205

    Comprog 2nd sem (prelims) BSIT 205

    Xai Alexandrei Delos Reyes · 63 questions · 2 y ago

    Comprog 2nd sem (prelims) BSIT 205

    Comprog 2nd sem (prelims) BSIT 205

    63 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Discrete Math 2nd sem (prelims) BSIT 205

    Discrete Math 2nd sem (prelims) BSIT 205

    Xai Alexandrei Delos Reyes · 36 questions · 2 y ago

    Discrete Math 2nd sem (prelims) BSIT 205

    Discrete Math 2nd sem (prelims) BSIT 205

    36 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Art Appreciation (Prelim) BSIT 205

    Art Appreciation (Prelim) BSIT 205

    Xai Alexandrei Delos Reyes · 56 questions · 2 y ago

    Art Appreciation (Prelim) BSIT 205

    Art Appreciation (Prelim) BSIT 205

    56 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Ethics 2nd sem (Prelims) BSIT 205

    Ethics 2nd sem (Prelims) BSIT 205

    Xai Alexandrei Delos Reyes · 45 questions · 2 y ago

    Ethics 2nd sem (Prelims) BSIT 205

    Ethics 2nd sem (Prelims) BSIT 205

    45 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    STS 2nd Sem (Prelim) BSIT 205

    STS 2nd Sem (Prelim) BSIT 205

    Xai Alexandrei Delos Reyes · 40 questions · 2 y ago

    STS 2nd Sem (Prelim) BSIT 205

    STS 2nd Sem (Prelim) BSIT 205

    40 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Systems Administration 2nd sem (Prelims) BSIT 205

    Systems Administration 2nd sem (Prelims) BSIT 205

    Xai Alexandrei Delos Reyes · 72 questions · 2 y ago

    Systems Administration 2nd sem (Prelims) BSIT 205

    Systems Administration 2nd sem (Prelims) BSIT 205

    72 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Discrete Mathematics (Midterms) BSIT 205

    Discrete Mathematics (Midterms) BSIT 205

    Xai Alexandrei Delos Reyes · 52 questions · 1 y ago

    Discrete Mathematics (Midterms) BSIT 205

    Discrete Mathematics (Midterms) BSIT 205

    52 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Art Appreciation (Midterm) BSIT 205

    Art Appreciation (Midterm) BSIT 205

    Xai Alexandrei Delos Reyes · 56 questions · 1 y ago

    Art Appreciation (Midterm) BSIT 205

    Art Appreciation (Midterm) BSIT 205

    56 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Ethics Mocktest (Midterms) BSIT205

    Ethics Mocktest (Midterms) BSIT205

    Xai Alexandrei Delos Reyes · 29 questions · 1 y ago

    Ethics Mocktest (Midterms) BSIT205

    Ethics Mocktest (Midterms) BSIT205

    29 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Comprog Mocktest (Midterm) BSIT 205

    Comprog Mocktest (Midterm) BSIT 205

    Xai Alexandrei Delos Reyes · 61 questions · 1 y ago

    Comprog Mocktest (Midterm) BSIT 205

    Comprog Mocktest (Midterm) BSIT 205

    61 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    System Administration Mocktest (Midterms) BSIT 205

    System Administration Mocktest (Midterms) BSIT 205

    Xai Alexandrei Delos Reyes · 65 questions · 1 y ago

    System Administration Mocktest (Midterms) BSIT 205

    System Administration Mocktest (Midterms) BSIT 205

    65 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Math Mocktest (Pre-finals) BSIT 205

    Math Mocktest (Pre-finals) BSIT 205

    Xai Alexandrei Delos Reyes · 49 questions · 1 y ago

    Math Mocktest (Pre-finals) BSIT 205

    Math Mocktest (Pre-finals) BSIT 205

    49 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Art Appreciation Mocktest (Pre-finals) BSIT 205

    Art Appreciation Mocktest (Pre-finals) BSIT 205

    Xai Alexandrei Delos Reyes · 66 questions · 1 y ago

    Art Appreciation Mocktest (Pre-finals) BSIT 205

    Art Appreciation Mocktest (Pre-finals) BSIT 205

    66 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Ethics Mocktest (Pre-finals) BSIT 205

    Ethics Mocktest (Pre-finals) BSIT 205

    Xai Alexandrei Delos Reyes · 50 questions · 1 y ago

    Ethics Mocktest (Pre-finals) BSIT 205

    Ethics Mocktest (Pre-finals) BSIT 205

    50 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Computer Programming Mocktest (Pre-finals) BSIT 205

    Computer Programming Mocktest (Pre-finals) BSIT 205

    Xai Alexandrei Delos Reyes · 33 questions · 1 y ago

    Computer Programming Mocktest (Pre-finals) BSIT 205

    Computer Programming Mocktest (Pre-finals) BSIT 205

    33 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    System Administration (Pre-finals) BSIT 205

    System Administration (Pre-finals) BSIT 205

    Xai Alexandrei Delos Reyes · 52 questions · 1 y ago

    System Administration (Pre-finals) BSIT 205

    System Administration (Pre-finals) BSIT 205

    52 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Art Appreciation Finals BSIT 205

    Art Appreciation Finals BSIT 205

    Xai Alexandrei Delos Reyes · 35 questions · 1 y ago

    Art Appreciation Finals BSIT 205

    Art Appreciation Finals BSIT 205

    35 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Data Structures and Algorithms (Mocktest) BSIT 307

    Data Structures and Algorithms (Mocktest) BSIT 307

    Xai Alexandrei Delos Reyes · 52 questions · 1 y ago

    Data Structures and Algorithms (Mocktest) BSIT 307

    Data Structures and Algorithms (Mocktest) BSIT 307

    52 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Object Oriented Programming Mock Test (Mocktest) BSIT 307

    Object Oriented Programming Mock Test (Mocktest) BSIT 307

    Xai Alexandrei Delos Reyes · 23 questions · 1 y ago

    Object Oriented Programming Mock Test (Mocktest) BSIT 307

    Object Oriented Programming Mock Test (Mocktest) BSIT 307

    23 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Human Computer Interactions Mocktest (Prelims) BSIT 307

    Human Computer Interactions Mocktest (Prelims) BSIT 307

    Xai Alexandrei Delos Reyes · 58 questions · 1 y ago

    Human Computer Interactions Mocktest (Prelims) BSIT 307

    Human Computer Interactions Mocktest (Prelims) BSIT 307

    58 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Principles of Communication Mocktest (Prelims) BSIT 307

    Principles of Communication Mocktest (Prelims) BSIT 307

    Xai Alexandrei Delos Reyes · 37 questions · 1 y ago

    Principles of Communication Mocktest (Prelims) BSIT 307

    Principles of Communication Mocktest (Prelims) BSIT 307

    37 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Principles of Communication Mocktest (Midterms) BSIT 307

    Principles of Communication Mocktest (Midterms) BSIT 307

    Xai Alexandrei Delos Reyes · 29 questions · 1 y ago

    Principles of Communication Mocktest (Midterms) BSIT 307

    Principles of Communication Mocktest (Midterms) BSIT 307

    29 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Data Structures and Algorithms Mocktest (Midterm) BSIT 307

    Data Structures and Algorithms Mocktest (Midterm) BSIT 307

    Xai Alexandrei Delos Reyes · 50 questions · 1 y ago

    Data Structures and Algorithms Mocktest (Midterm) BSIT 307

    Data Structures and Algorithms Mocktest (Midterm) BSIT 307

    50 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Object Oriented Programming Mock Test (Midterm) BSIT 307

    Object Oriented Programming Mock Test (Midterm) BSIT 307

    Xai Alexandrei Delos Reyes · 13 questions · 1 y ago

    Object Oriented Programming Mock Test (Midterm) BSIT 307

    Object Oriented Programming Mock Test (Midterm) BSIT 307

    13 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Human Computer Interactions Mocktest (Midterms) BSIT 307

    Human Computer Interactions Mocktest (Midterms) BSIT 307

    Xai Alexandrei Delos Reyes · 35 questions · 1 y ago

    Human Computer Interactions Mocktest (Midterms) BSIT 307

    Human Computer Interactions Mocktest (Midterms) BSIT 307

    35 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Readings In Philippine History (Midterms) Mocktest

    Readings In Philippine History (Midterms) Mocktest

    Xai Alexandrei Delos Reyes · 16 questions · 1 y ago

    Readings In Philippine History (Midterms) Mocktest

    Readings In Philippine History (Midterms) Mocktest

    16 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Discrete Structures and Algorithms (Midterms) Mocktest

    Discrete Structures and Algorithms (Midterms) Mocktest

    Xai Alexandrei Delos Reyes · 10 questions · 1 y ago

    Discrete Structures and Algorithms (Midterms) Mocktest

    Discrete Structures and Algorithms (Midterms) Mocktest

    10 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Principles of Communication (Midterm) Mocktest

    Principles of Communication (Midterm) Mocktest

    Xai Alexandrei Delos Reyes · 29 questions · 1 y ago

    Principles of Communication (Midterm) Mocktest

    Principles of Communication (Midterm) Mocktest

    29 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    TECHNOPRENEURSHIP PRELIMS BSIT 402

    TECHNOPRENEURSHIP PRELIMS BSIT 402

    Xai Alexandrei Delos Reyes · 74 questions · 1 y ago

    TECHNOPRENEURSHIP PRELIMS BSIT 402

    TECHNOPRENEURSHIP PRELIMS BSIT 402

    74 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    (Prelim) PH Popular Culture Mocktest BSIT 402

    (Prelim) PH Popular Culture Mocktest BSIT 402

    Xai Alexandrei Delos Reyes · 19 questions · 1 y ago

    (Prelim) PH Popular Culture Mocktest BSIT 402

    (Prelim) PH Popular Culture Mocktest BSIT 402

    19 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    (Prelim) Integrative Programming BSIT 402

    (Prelim) Integrative Programming BSIT 402

    Xai Alexandrei Delos Reyes · 46 questions · 1 y ago

    (Prelim) Integrative Programming BSIT 402

    (Prelim) Integrative Programming BSIT 402

    46 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    (Prelim) Quantitive Methods Mocktest BSIT 402

    (Prelim) Quantitive Methods Mocktest BSIT 402

    Xai Alexandrei Delos Reyes · 39 questions · 1 y ago

    (Prelim) Quantitive Methods Mocktest BSIT 402

    (Prelim) Quantitive Methods Mocktest BSIT 402

    39 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    (Prelim) System Integration and Architecture BSIT 402

    (Prelim) System Integration and Architecture BSIT 402

    Xai Alexandrei Delos Reyes · 29 questions · 1 y ago

    (Prelim) System Integration and Architecture BSIT 402

    (Prelim) System Integration and Architecture BSIT 402

    29 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    (Prelim) Network Technology Mocktest BSIT 402

    (Prelim) Network Technology Mocktest BSIT 402

    Xai Alexandrei Delos Reyes · 68 questions · 1 y ago

    (Prelim) Network Technology Mocktest BSIT 402

    (Prelim) Network Technology Mocktest BSIT 402

    68 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    (Prelim) Information Management Mocktest BSIT 402

    (Prelim) Information Management Mocktest BSIT 402

    Xai Alexandrei Delos Reyes · 45 questions · 1 y ago

    (Prelim) Information Management Mocktest BSIT 402

    (Prelim) Information Management Mocktest BSIT 402

    45 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    (Pre-Finals) Quantitative Research Mocktest BSIT 402

    (Pre-Finals) Quantitative Research Mocktest BSIT 402

    Xai Alexandrei Delos Reyes · 28 questions · 10 mo ago

    (Pre-Finals) Quantitative Research Mocktest BSIT 402

    (Pre-Finals) Quantitative Research Mocktest BSIT 402

    28 questions • 10 mo ago
    Xai Alexandrei Delos Reyes

    (Finals) Philippine Popular Culture Mocktest

    (Finals) Philippine Popular Culture Mocktest

    Xai Alexandrei Delos Reyes · 46 questions · 9 mo ago

    (Finals) Philippine Popular Culture Mocktest

    (Finals) Philippine Popular Culture Mocktest

    46 questions • 9 mo ago
    Xai Alexandrei Delos Reyes

    (Finals) Integrative Programming Mocktest BSIT 402

    (Finals) Integrative Programming Mocktest BSIT 402

    Xai Alexandrei Delos Reyes · 24 questions · 9 mo ago

    (Finals) Integrative Programming Mocktest BSIT 402

    (Finals) Integrative Programming Mocktest BSIT 402

    24 questions • 9 mo ago
    Xai Alexandrei Delos Reyes

    (Finals) Network Technology Mocktest BSIT 402

    (Finals) Network Technology Mocktest BSIT 402

    Xai Alexandrei Delos Reyes · 37 questions · 9 mo ago

    (Finals) Network Technology Mocktest BSIT 402

    (Finals) Network Technology Mocktest BSIT 402

    37 questions • 9 mo ago
    Xai Alexandrei Delos Reyes

    (Finals) Quantitative Methods Mocktest BSIT 402

    (Finals) Quantitative Methods Mocktest BSIT 402

    Xai Alexandrei Delos Reyes · 18 questions · 9 mo ago

    (Finals) Quantitative Methods Mocktest BSIT 402

    (Finals) Quantitative Methods Mocktest BSIT 402

    18 questions • 9 mo ago
    Xai Alexandrei Delos Reyes

    Application Development Mocktest (Prelim) BSIT 505

    Application Development Mocktest (Prelim) BSIT 505

    Xai Alexandrei Delos Reyes · 72 questions · 6 mo ago

    Application Development Mocktest (Prelim) BSIT 505

    Application Development Mocktest (Prelim) BSIT 505

    72 questions • 6 mo ago
    Xai Alexandrei Delos Reyes

    Data and Digital Communication Mocktest (Prelim) BSIT 505

    Data and Digital Communication Mocktest (Prelim) BSIT 505

    Xai Alexandrei Delos Reyes · 60 questions · 6 mo ago

    Data and Digital Communication Mocktest (Prelim) BSIT 505

    Data and Digital Communication Mocktest (Prelim) BSIT 505

    60 questions • 6 mo ago
    Xai Alexandrei Delos Reyes

    (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 questions · 6 mo ago

    (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 questions • 6 mo ago
    Xai Alexandrei Delos Reyes

    Enterprise Architecture Mocktest (Prelims) BSIT 505

    Enterprise Architecture Mocktest (Prelims) BSIT 505

    Xai Alexandrei Delos Reyes · 42 questions · 6 mo ago

    Enterprise Architecture Mocktest (Prelims) BSIT 505

    Enterprise Architecture Mocktest (Prelims) BSIT 505

    42 questions • 6 mo ago
    Xai Alexandrei Delos Reyes

    Professional Issues in Information Technology Mocktest (Prelims) BSIT 505

    Professional Issues in Information Technology Mocktest (Prelims) BSIT 505

    Xai Alexandrei Delos Reyes · 44 questions · 6 mo ago

    Professional Issues in Information Technology Mocktest (Prelims) BSIT 505

    Professional Issues in Information Technology Mocktest (Prelims) BSIT 505

    44 questions • 6 mo ago
    Xai Alexandrei Delos Reyes

    Application Development Mocktest (Midterm) BSIT 505

    Application Development Mocktest (Midterm) BSIT 505

    Xai Alexandrei Delos Reyes · 42 questions · 6 mo ago

    Application Development Mocktest (Midterm) BSIT 505

    Application Development Mocktest (Midterm) BSIT 505

    42 questions • 6 mo ago
    Xai Alexandrei Delos Reyes

    Event-Driven Programming Mocktest (Midterm) BSIT - 505

    Event-Driven Programming Mocktest (Midterm) BSIT - 505

    Xai Alexandrei Delos Reyes · 61 questions · 6 mo ago

    Event-Driven Programming Mocktest (Midterm) BSIT - 505

    Event-Driven Programming Mocktest (Midterm) BSIT - 505

    61 questions • 6 mo ago
    Xai Alexandrei Delos Reyes

    Data and Digital Communication Mocktest (Midterm) BSIT - 505

    Data and Digital Communication Mocktest (Midterm) BSIT - 505

    Xai Alexandrei Delos Reyes · 80 questions · 6 mo ago

    Data and Digital Communication Mocktest (Midterm) BSIT - 505

    Data and Digital Communication Mocktest (Midterm) BSIT - 505

    80 questions • 6 mo ago
    Xai Alexandrei Delos Reyes

    (Midterm) Advanced Systems and Integration Architecture BSIT - 505

    (Midterm) Advanced Systems and Integration Architecture BSIT - 505

    Xai Alexandrei Delos Reyes · 68 questions · 5 mo ago

    (Midterm) Advanced Systems and Integration Architecture BSIT - 505

    (Midterm) Advanced Systems and Integration Architecture BSIT - 505

    68 questions • 5 mo ago
    Xai Alexandrei Delos Reyes

    (Midterm) Advanced Database Systems Mocktest BSIT - 505

    (Midterm) Advanced Database Systems Mocktest BSIT - 505

    Xai Alexandrei Delos Reyes · 82 questions · 5 mo ago

    (Midterm) Advanced Database Systems Mocktest BSIT - 505

    (Midterm) Advanced Database Systems Mocktest BSIT - 505

    82 questions • 5 mo ago
    Xai Alexandrei Delos Reyes

    (Midterms) Enterprise Architecture Mocktest BSIT 505

    (Midterms) Enterprise Architecture Mocktest BSIT 505

    Xai Alexandrei Delos Reyes · 69 questions · 5 mo ago

    (Midterms) Enterprise Architecture Mocktest BSIT 505

    (Midterms) Enterprise Architecture Mocktest BSIT 505

    69 questions • 5 mo ago
    Xai Alexandrei Delos Reyes

    (Midterm) Professional Issues in Information Technology BSIT 505

    (Midterm) Professional Issues in Information Technology BSIT 505

    Xai Alexandrei Delos Reyes · 38 questions · 5 mo ago

    (Midterm) Professional Issues in Information Technology BSIT 505

    (Midterm) Professional Issues in Information Technology BSIT 505

    38 questions • 5 mo ago
    Xai Alexandrei Delos Reyes

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

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

    Xai Alexandrei Delos Reyes · 59 questions · 4 mo ago

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

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

    59 questions • 4 mo ago
    Xai Alexandrei Delos Reyes

    (Pre-finals) Application Development Mocktest BSIT 505

    (Pre-finals) Application Development Mocktest BSIT 505

    Xai Alexandrei Delos Reyes · 41 questions · 4 mo ago

    (Pre-finals) Application Development Mocktest BSIT 505

    (Pre-finals) Application Development Mocktest BSIT 505

    41 questions • 4 mo ago
    Xai Alexandrei Delos Reyes

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

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

    Xai Alexandrei Delos Reyes · 57 questions · 4 mo ago

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

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

    57 questions • 4 mo ago
    Xai Alexandrei Delos Reyes

    (Pre-Finals) ASIA Mocktest BSIT 505

    (Pre-Finals) ASIA Mocktest BSIT 505

    Xai Alexandrei Delos Reyes · 44 questions · 4 mo ago

    (Pre-Finals) ASIA Mocktest BSIT 505

    (Pre-Finals) ASIA Mocktest BSIT 505

    44 questions • 4 mo ago
    Xai Alexandrei Delos Reyes

    (Pre-Finals) Advanced Database Systems Mocktest BSIT 505

    (Pre-Finals) Advanced Database Systems Mocktest BSIT 505

    Xai Alexandrei Delos Reyes · 72 questions · 4 mo ago

    (Pre-Finals) Advanced Database Systems Mocktest BSIT 505

    (Pre-Finals) Advanced Database Systems Mocktest BSIT 505

    72 questions • 4 mo ago
    Xai Alexandrei Delos Reyes

    (Pre-Finals) Enterprise Architecture Mocktest BSIT 505

    (Pre-Finals) Enterprise Architecture Mocktest BSIT 505

    Xai Alexandrei Delos Reyes · 42 questions · 4 mo ago

    (Pre-Finals) Enterprise Architecture Mocktest BSIT 505

    (Pre-Finals) Enterprise Architecture Mocktest BSIT 505

    42 questions • 4 mo ago
    Xai Alexandrei Delos Reyes

    (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 questions · 4 mo ago

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

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

    62 questions • 4 mo ago
    Xai Alexandrei Delos Reyes

    (Finals) Application Development Mocktest BSIT 505

    (Finals) Application Development Mocktest BSIT 505

    Xai Alexandrei Delos Reyes · 62 questions · 3 mo ago

    (Finals) Application Development Mocktest BSIT 505

    (Finals) Application Development Mocktest BSIT 505

    62 questions • 3 mo ago
    Xai Alexandrei Delos Reyes

    (Finals) Data and Digital Communication Mocktest BSIT - 505

    (Finals) Data and Digital Communication Mocktest BSIT - 505

    Xai Alexandrei Delos Reyes · 61 questions · 3 mo ago

    (Finals) Data and Digital Communication Mocktest BSIT - 505

    (Finals) Data and Digital Communication Mocktest BSIT - 505

    61 questions • 3 mo ago
    Xai Alexandrei Delos Reyes

    (Finals) Advanced Database Systems Mocktest BSIT 505

    (Finals) Advanced Database Systems Mocktest BSIT 505

    Xai Alexandrei Delos Reyes · 62 questions · 3 mo ago

    (Finals) Advanced Database Systems Mocktest BSIT 505

    (Finals) Advanced Database Systems Mocktest BSIT 505

    62 questions • 3 mo ago
    Xai Alexandrei Delos Reyes

    (Finals) Enterprise Architecture Mocktest BSIT 505

    (Finals) Enterprise Architecture Mocktest BSIT 505

    Xai Alexandrei Delos Reyes · 60 questions · 3 mo ago

    (Finals) Enterprise Architecture Mocktest BSIT 505

    (Finals) Enterprise Architecture Mocktest BSIT 505

    60 questions • 3 mo ago
    Xai Alexandrei Delos Reyes

    (Finals) Professional issues in Information Technology Mocktest BSIT 505

    (Finals) Professional issues in Information Technology Mocktest BSIT 505

    Xai Alexandrei Delos Reyes · 27 questions · 3 mo ago

    (Finals) Professional issues in Information Technology Mocktest BSIT 505

    (Finals) Professional issues in Information Technology Mocktest BSIT 505

    27 questions • 3 mo ago
    Xai Alexandrei Delos Reyes

    (Finals) Event-Driven Programming Mocktest BSIT 505

    (Finals) Event-Driven Programming Mocktest BSIT 505

    Xai Alexandrei Delos Reyes · 65 questions · 4 mo ago

    (Finals) Event-Driven Programming Mocktest BSIT 505

    (Finals) Event-Driven Programming Mocktest BSIT 505

    65 questions • 4 mo ago
    Xai Alexandrei Delos Reyes

    (Prelims) Mobile Systems and Technologies Mocktest BSIT 604

    (Prelims) Mobile Systems and Technologies Mocktest BSIT 604

    Xai Alexandrei Delos Reyes · 41 views · 42 questions · 1 mo ago

    (Prelims) Mobile Systems and Technologies Mocktest BSIT 604

    (Prelims) Mobile Systems and Technologies Mocktest BSIT 604

    41 views • 42 questions • 1 mo ago
    Xai Alexandrei Delos Reyes

    (Prelims) Great Books Mocktest BSIT 604

    (Prelims) Great Books Mocktest BSIT 604

    Xai Alexandrei Delos Reyes · 46 views · 75 questions · 1 mo ago

    (Prelims) Great Books Mocktest BSIT 604

    (Prelims) Great Books Mocktest BSIT 604

    46 views • 75 questions • 1 mo ago
    Xai Alexandrei Delos Reyes

    (Prelims) Management Information Systems Mocktest BSIT - 604

    (Prelims) Management Information Systems Mocktest BSIT - 604

    Xai Alexandrei Delos Reyes · 70 views · 94 questions · 1 mo ago

    (Prelims) Management Information Systems Mocktest BSIT - 604

    (Prelims) Management Information Systems Mocktest BSIT - 604

    70 views • 94 questions • 1 mo ago
    Xai Alexandrei Delos Reyes

    (Prelims) Programming Languages Mocktest BSIT 604

    (Prelims) Programming Languages Mocktest BSIT 604

    Xai Alexandrei Delos Reyes · 26 views · 79 questions · 1 mo ago

    (Prelims) Programming Languages Mocktest BSIT 604

    (Prelims) Programming Languages Mocktest BSIT 604

    26 views • 79 questions • 1 mo ago
    Xai Alexandrei Delos Reyes

    (Prelims) Web Systems and Technologies Mocktest BSIT 604

    (Prelims) Web Systems and Technologies Mocktest BSIT 604

    Xai Alexandrei Delos Reyes · 33 views · 99 questions · 29 d ago

    (Prelims) Web Systems and Technologies Mocktest BSIT 604

    (Prelims) Web Systems and Technologies Mocktest BSIT 604

    33 views • 99 questions • 29 d ago
    Xai Alexandrei Delos Reyes

    (Prelims) Information Assurance and Security Mocktest BSIT 604

    (Prelims) Information Assurance and Security Mocktest BSIT 604

    Xai Alexandrei Delos Reyes · 33 views · 92 questions · 28 d ago

    (Prelims) Information Assurance and Security Mocktest BSIT 604

    (Prelims) Information Assurance and Security Mocktest BSIT 604

    33 views • 92 questions • 28 d ago
    Xai Alexandrei Delos Reyes

    (Midterms) Mobile Systems and Technologies Mocktest BSIT 604

    (Midterms) Mobile Systems and Technologies Mocktest BSIT 604

    Xai Alexandrei Delos Reyes · 54 questions · 17 d ago

    (Midterms) Mobile Systems and Technologies Mocktest BSIT 604

    (Midterms) Mobile Systems and Technologies Mocktest BSIT 604

    54 questions • 17 d ago
    Xai Alexandrei Delos Reyes

    (Midterm) Great Books Mocktest BSIT 604

    (Midterm) Great Books Mocktest BSIT 604

    Xai Alexandrei Delos Reyes · 74 questions · 11 d ago

    (Midterm) Great Books Mocktest BSIT 604

    (Midterm) Great Books Mocktest BSIT 604

    74 questions • 11 d ago
    Xai Alexandrei Delos Reyes

    (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 questions · 4 d ago

    (Midterms) 04 to 05_Handout Management Information Systems Mocktest BSIT 604

    (Midterms) 04 to 05_Handout Management Information Systems Mocktest BSIT 604

    69 questions • 4 d ago
    Xai Alexandrei Delos Reyes

    (Midterms) 06_Handout Management Information Systems Mocktest BSIT 604

    (Midterms) 06_Handout Management Information Systems Mocktest BSIT 604

    Xai Alexandrei Delos Reyes · 36 questions · 4 d ago

    (Midterms) 06_Handout Management Information Systems Mocktest BSIT 604

    (Midterms) 06_Handout Management Information Systems Mocktest BSIT 604

    36 questions • 4 d ago
    Xai Alexandrei Delos Reyes

    (Midterms) Programming Languages Mocktest BSIT 604

    (Midterms) Programming Languages Mocktest BSIT 604

    Xai Alexandrei Delos Reyes · 81 questions · 3 d ago

    (Midterms) Programming Languages Mocktest BSIT 604

    (Midterms) Programming Languages Mocktest BSIT 604

    81 questions • 3 d ago
    Xai Alexandrei Delos Reyes

    (Midterms) Information Assurance and Security Mocktest BSIT 604

    (Midterms) Information Assurance and Security Mocktest BSIT 604

    Xai Alexandrei Delos Reyes · 84 questions · 4 d ago

    (Midterms) Information Assurance and Security Mocktest BSIT 604

    (Midterms) Information Assurance and Security Mocktest BSIT 604

    84 questions • 4 d ago
    Xai Alexandrei Delos Reyes

    (Midterms) Web Systems an Technologies Mocktest BSIT 604

    (Midterms) Web Systems an Technologies Mocktest BSIT 604

    Xai Alexandrei Delos Reyes · 87 questions · 3 d ago

    (Midterms) Web Systems an Technologies Mocktest BSIT 604

    (Midterms) Web Systems an Technologies Mocktest BSIT 604

    87 questions • 3 d ago
    Xai Alexandrei Delos Reyes

    Question list

  • 1

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

    aggregate function

  • 2

    the minimum attribute value encountered in a given column

    MIN

  • 3

    the maximum attribute value encountered in a given column

    MAX

  • 4

    the number of rows containing non-null values

    COUNT

  • 5

    the sum of all values for a given column

    SUM

  • 6

    the arithmetic mean (average) for a specified column

    AVG

  • 7

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

    GROUP BY

  • 8

    What is the CORRECT syntax for MIN

    SELECT MIN(column_name) FROM table_name;

  • 9

    What is the CORRECT syntax for MAX

    SELECT MAX(column_name) FROM table_name;

  • 10

    What is the CORRECT syntax for COUNT

    SELECT COUNT(column_name) FROM table_name;

  • 11

    What is the CORRECT syntax for SUM

    SELECT SUM(column_name) FROM table_name;

  • 12

    What is the CORRECT syntax for AVG

    SELECT AVG(column_name) FROM table_name;

  • 13

    What is the CORRECT syntax for GROUP BY

    SELECT columns FROM table_name GROUP BY columns;

  • 14

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

    Alias

  • 15

    What is the CORRECT syntax of ALIAS

    SELECT column_name AS alias FROM table_name;

  • 16

    What is the CORRECT syntax of HAVING

    SELECT columns FROM table_name GROUP BY columns HAVING condition;

  • 17

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

    HAVING

  • 18

    returns a four-digit year

    YEAR

  • 19

    returns the number of the month

    MONTH

  • 20

    returns the number of the day

    DAY

  • 21

    returns the current date and time

    GETDATE

  • 22

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

    DATEADD

  • 23

    returns the difference between two (2) dates

    DATEDIFF

  • 24

    What is the CORRECT syntax for YEAR

    SELECT OrderID, YEAR(OrderDate) AS Year;

  • 25

    What is the CORRECT syntax for MONTH

    SELECT OrderID, MONTH(OrderDate) AS Month;

  • 26

    What is the CORRECT syntax for DAY

    SELECT OrderID, DAY(OrderDate) AS Day;

  • 27

    What is the CORRECT syntax for GETDATE

    SELECT GETDATE();

  • 28

    What is the CORRECT syntax for DATEADD

    DATEADD(datepart, number, date);

  • 29

    What is the CORRECT syntax for DATEDIFF

    DATEDIFF(datepart, date1, date2);

  • 30

    returns the absolute value of a number

    ABS

  • 31

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

    CEILING

  • 32

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

    FLOOR

  • 33

    What is the CORRECT syntax for ABS

    SELECT ABS(-234.5);

  • 34

    What is the CORRECT syntax for ROUND

    ROUND(number, decimal places);

  • 35

    What is the CORRECT syntax for CEILING

    SELECT CEILING(234.1);

  • 36

    What is the CORRECT syntax for FLOOR

    SELECT FLOOR(234.5);

  • 37

    joins two or more strings together

    CONCAT

  • 38

    returns a string in lowercase letters

    LOWER

  • 39

    returns a string in all capital letters

    UPPER

  • 40

    returns a part of a string

    SUBSTRING

  • 41

    returns the number of characters in a string

    LEN

  • 42

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

    TRIM

  • 43

    What is the CORRECT syntax for CONCAT

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

  • 44

    What is the CORRECT syntax for LOWER

    SELECT LOWER ('FUNCTIONS');

  • 45

    What is the CORRECT syntax for UPPER

    SELECT UPPER('sql');

  • 46

    What is the CORRECT syntax for SUBSTRING

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

  • 47

    What is the CORRECT syntax for LEN

    SELECT LEN('SQL Functions');

  • 48

    What is the CORRECT syntax for TRIM

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

  • 49

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

    JOIN

  • 50

    returns rows that have matching values in both tables

    INNER JOIN

  • 51

    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

  • 52

    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

  • 53

    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

  • 54

    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;

  • 55

    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;

  • 56

    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;

  • 57

    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;

  • 58

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

    2021-02-14 00:00:00.000

  • 59

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

    2020-08-14 00:00:00.000

  • 60

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

    2020-02-14 02:30:00.000

  • 61

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

    235

  • 62

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

    234

  • 63

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

    SQL

  • 64

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

    13