Finals Reviewer pt1

Question 1

Includes commands to create database objects such as tables, indexes, and views, as well as commands to define access rights to those database

Answer 1

Data Definition Language

Question 2

is a group of database objects such as tables and indexes that are related to each other

Answer 2

Schema

Question 3

is a collection of related data held in a table format within a database

Answer 3

Table

Question 4

Constraint wherein a column or columns are used to establish and enforce a link between the data in two tables

Answer 4

Foreign key

Question 5

Constraint that ensures that no duplicate values are entered in specific columns that do not participate in a primary key

Answer 5

Unique

Question 5

SQL command used to remove an object such as an index, column or even a table from a database permanently

Answer 5

DROP

Question 5

command is used to list the contents of a table

Answer 5

SELECT

Question 5

A special operator that we use if we want to check whether an attribute value is within a range

Answer 5

BETWEEN

Question 5

is a function that returns the current system date for MySQL

Answer 5

NOW()

Question 6

A special operator that we use to check whether a subquery returns any rows

Answer 6

EXISTS

Question 7

A special operator that we use to check whether an attribute value matches any value within a value list

Answer 7

IN

Question 8

A special operator that we use to check whether an attribute value matches a given string

Answer 8

LIKE

Question 9

A like special operator used in MySQL that means any single character NOT within a range or a set

Answer 9

[^]

Question 10

All changes in the table structure are made by using table command

Answer 10

ALTER TABLE

Question 11

MySQL uses the column command to change a column attribute

Answer 11

ALTER

Question 12

this type of subquery can be used anywhere a table is expected, such as when using the “FROM” clause

Answer 12

Computed Columns

Question 13

An SQL Server function that produces a date by adding a specified number to a specified part of date

Answer 13

DATEADD

Question 14

A MySQL function that returns the time between two dates

Answer 14

DATEDIFF

Question 15

An SQL Server function that returns the specified part of the date requested

Answer 15

DATEPART

Question 16

A MySQL function that is used to return a single part of a date/time, such as year, month, day, hour, minutes, etc.

Answer 16

EXTRACT()

Question 17

An SQL Server function that will extract the year from a value stored as a SMALLDATETIME data type

Answer 17

YEAR()

Question 18

An SQL Server function that returns the current system date and time

Answer 18

GETDATE()

Question 19

The function rounds numbers to a specified number of decimal places

Answer 19

ROUND

Question 20

The ??? function returns the next lower integer value when a number contains decimal places

Answer 20

FLOOR

Question 21

The function returns the absolute value of any numeric value

Answer 21

ABS

Question 22

An SQL Server function that returns a value if a table value is null

Answer 22

ISNULL

Question 23

A function that returns a NULL if expression1 = expression2. If the expressions are not equal, then expression is returned

Answer 23

NULLIF

Question 24

An SQL Server function that is used to display or return from a result set the rows that fall at the TOP of a range specified by an ORDER BY clause

Answer 24

TOP

Question 25

A MySQL specialized conversion function that formats the number X to a format like ‘#,###,#####’, rounded to D decimal places, and returns the result as a string

Answer 25

FORMAT()

Question 26

An SQL Server specialized conversion function that is also used to explicitly convert to a given data type

Answer 26

STR

Question 27

A string function that returns part of a string

Answer 27

SUBSTRING

Question 28

An MySQL string function that returns the length (number of characters) of a desired string excluding trailing blanks.

Answer 28

LEN

Question 29

An SQL Server string function that returns the string in UPPERCASE

Answer 29

UPPER

Question 30

A MySQL string function that returns the starting position of a specified pattern.

Answer 30

INSTR

Question 31

An SQL Server string function that returns the starting position of a specified pattern.

Answer 31

CHARINDEX ()

Question 32

A string function that removes blanks from the end (right) of a string

Answer 32

RTRIM

Question 33

A MySQL function that tests whether an expression is NULL

Answer 33

ISNULL

Question 34

An SQL Server function returns a certain percentage of rows that falls at the top of a specified range

Answer 34

PERCENT

Question 35

A MySQL clause that is used in the SELECT statement to constrain the number of rows in a result set

Answer 35

LIMIT

Question 36

A part of the MySQL LIMIT clause that specifies maximum number of rows to return

Answer 36

count

Question 37

An SQL Server specialized conversion function that always converts from a number (for example, float or numeric) to a character data type.

Answer 37

STR

Question 38

An SQL Server string function that returns the length (number of characters) of a desired string excluding trailing blanks

Answer 38

LEN

Question 39

An SQL Server string function that returns the string in LOWERCASE.

Answer 39

LOWER

Question 40

A MySQL string function that returns the substring from the given string before a specified number of occurrences of a delimiter

Answer 40

SUBSTRING_INDEX()

Question 41

A string function that starts from the right of the string expression or column and returns n characters

Answer 41

RIGHT

Question 42

A string function that returns part of a string.

Answer 42

SUBSTRING

Question 43

in SQL Server, the ??? table contains all the values we updated using the UPDATE command

Answer 43

UPDATE

IDK if SELECT or UPDATE yung tamang sagot

Question 44

in SQL Server, the table contains all the values we deleted using the DELETE command.

Answer 44

DELETE

Question 45

to delete or remove a trigger we use _trigger_name command

Answer 45

DROP TRIGGER

Question 46

in MySQL, the ??? table contains all the values we deleted using the DELETE command

Answer 46

OLD