Exam

Question 1

includes commands to create database

Answer 1

Data Definition Language

Question 2

is a group of database objects

Answer 2

Schema

Question 3

is a collection of related data

Answer 3

Table

Question 4

type of constraint. . to extablish and enforce a link

Answer 4

Foreign Key

Question 5

type of constraints that ensures. . no duplicate values

Answer 5

Unique Constraint / Unique

Question 6

what sql command is used to remove an object

Answer 6

DROP

Question 7

command is used to list the contents of a table

Answer 7

SELECT

Question 8

is a function that returns the current system date for MySQL

Answer 8

CURDATE()

Question 9

wheter an attribute value is within a range

Answer 9

BETWEEN

Question 10

subquery returns any rows

Answer 10

EXISTS

Question 11

the highest maximmum value in the table

Answer 11

MAX()

Question 12

the toal sum for any specified attribute

Answer 12

SUM()

Question 13

when you have attribute columns combined with aggregate functions

Answer 13

GROUP BY

Question 14

condition is generally composed of an equality comparison between

Answer 14

Referential Integrity Constraint (RIC)

Question 15

type of join wherein a table is connected to itself

Answer 15

Self join

Question 16

type of outer join wherein it will show all rows

Answer 16

Right outer join

Question 17

statement combines rows from two or more queries

Answer 17

UNION

Question 18

join performs a relational product

Answer 18

Cartesian Join

Question 19

this select subquery is used anywhere a single value is expected

Answer 19

Scalar subquery

Question 20

operator allows you to check if a single value exists

Answer 20

IN operator

Question 21

one way of reading every row in a table and comparing values in each row against related data

Answer 21

Correlated subquery

Question 22

type of subquery runs once for each row in the outer query, using values

Answer 22

DATE_ADD()

Question 23

MySQL funcion adds a specified interval

Answer 23

DATEDIFF()

Question 24

SQL server function calculates the difference between two dates

Answer 24

DATE_SUB()

Question 25

SQL server function extracts the **month part**

Answer 25

MONTH()

Question 26

SQL function returns the **current UTC date**

Answer 26

GETUTCDATE()

Question 27

SQL supports **carious arithmetic** functions for calculations

Answer 27

Arithmetic functions

Question 28

function rounds a number up to the nearest integer

Answer 28

CEILING()

Question 29

SQL server function proivdes a alternative value

Answer 29

ISNULL()

Question 30

SQL Server: Up to _ _ _ characters (depending on the version) MySQL: Up to _ _ characters

Answer 30

SQL Server: Up to 128 characters (depending on the version) MySQL: Up to 64 characters

Question 31

false - 2,200 input and output

Question 32

true - 128MB

Question 33

we can use execute

Answer 33

EXEC

Question 34

the _____ clause is generally used when you have attribute columns combined with aggregate function SELECT statement

Answer 34

having

Question 35

A _____ is a virtual table based on a SELECT query

Answer 35

view | or cursor??

Question 36

____ condition is generally composed of an equality comparison between the foreign key and the primary key of relate tables

Answer 36

join

Question 37

The ____ statement combines rows from two or more queries

Answer 37

union

Question 38

A _____ join performs a relational product

Answer 38

cross

Question 39

a type of outer join wherein it will show all rows from the right table regardless if there's a match on the left table

Answer 39

right join

Question 40

this select subquery is used anywhere **a single value is expected**

Answer 40

scalar subquery

Question 41

When you want to compare a single attribute to a list of values, you use ____ operator

Answer 41

IN

Question 42

____ subquery is a subquery that **executes once for each row in the outer query**

Answer 42

correlated

Question 43

MySQL function that substracts a specified time interval from a date

Answer 43

DATE_SUB()

Question 44

SQL server function that returns the current system date and time in UTC format

Answer 44

GETUTCDATE()

Question 45

clause is used to restrict the groups that will be included in a query result?

Answer 45

Having

Question 46

a ____ "function" can be used to perform an arithmetic operation on a column

Answer 46

+ / Add

Question 47

Which operator finds rows that do not contain a null value in the specified column?

Answer 47

IS NOT NULL

Question 48

Which operator finds rows that do not contain a null value in the specified column?

Answer 48

LIKE

Question 49

Which function determines the number of rows in a table?

Answer 49

COUNT

Question 50

the _____ function returns the next larger integer value when a number contains decimal places

Answer 50

round

Question 51

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

Answer 51

IS NULL

Question 52

A _____ parameter is part of a stored procedure that allows it to return a value or multiple values

Answer 52

output

Question 53

How many characers can a stored procedure name contain?

Answer 53

128