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 **abs**olute **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