Finals Reviewer pt2

Question 1

In MySQL, the ??? table contains all the values we inserted using INSERT command.

Answer 1

inserted

or SELECT

Question 2

A trigger that executes when INSERT, UPDATE, and DELETE commands modify data in a table or view.

Answer 2

DML trigger /
Data Manipulation Language trigger

Question 3

A trigger that executes in response to a DDL statement that is often used to make database schema changes.

Answer 3

DDL trigger /
Data Definition Language trigger

Question 4

A ??? is a set of transact-SQL (T-SQL) statements that is compiled and stored as a single database object for later repetitive use.

Answer 4

stored procedure

Question 5

A ??? defines the name of the stored procedure, the input and output parameters, and some miscellaneous processing options.

Answer 5

procedure header / header

Question 6

A ??? is part of a stored procedure that contains one or more transact sql statements to be executed at runtime

Answer 6

procedure body / body

Question 7

A ??? parameter is part of a stored procedure that allows it to accept values and serve as variables.

Answer 7

input

Question 8

A ??? parameter is part of a stored procedure that allows it to return a value and serve as variables.

Answer 8

output

Question 9

How many characters can a stored procedure name contain?

Answer 9

128 Characters

Question 10

True or False

Stored procedures may contain up to 2,200 input and output parameters.

Answer 10

False

can only contain 2,100

Question 11

True or False

the maximum size of the body of the stored procedure is 128MB

Answer 11

True

Question 11

in SQL server, we can use execute, the actual name of the procedure or ??? to execute the stored procedure.

Answer 11

EXEC / execute

Question 12

A ??? temporary table is visible only to the session that it is created from and is dropped automatically when the connection is closed.

Answer 12

local

Question 13

??? temporary tables are available to all users and are automatically dropped when the last user accessing the table disconnects from the database.

Answer 13

global

Question 14

in SQL server, what symbol is used to denote a temporary table, please indicate the symbol only.

Answer 14

#

Question 15

True or False

In scalar functions the return value is a standard data type but cannot be a text , Ntext, image or timestamp.

Answer 15

True

Question 16

??? functions are often used as “parameterised views” as they can be included in place of tables in a query and can accept arguments.

Answer 16

table-valued

Question 17

??? functions contain a single statement, which must be a SELECT. The results of the query become the return value of the functions

Answer 17

Scalar

Question 18

True or False

in MySQL, we use DROP and CREATE when altering functions.

Answer 18

True

Question 19

A type of backup that creates a complete backup of the database as well as part of the transaction log, so the database can be recovered.

Answer 19

Full Backup

Question 20

A type of backup that allows for the simplest form of database restoration, since all of the contents are contained in one single backup.

Answer 20

Full backup

Question 21

A type of backup that captures the state of the changed extents at the time that backup was created.

Answer 21

Differential backup

Question 21

A type of backup that must be done at least once before any of the other types of backup can be run.

Answer 21

Full backup

Question 21

is a file that stores a series of the logs that provide the history of every modification of data, in a database

Answer 21

Transaction Log

Question 22

A type of backup that is the **superset of the last full backup** and contains all changes that have been made **since the last full backup**

Answer 22

Differential backup

Question 23

A type of backup that as its name implies, **backs up the transaction logs.**

Answer 23

Transaction Log backup

Question 24

________ ____ backup allows the database to be recovered to a **specific point in time**

Answer 24

Transaction Log

Question 25

When the **recovery procedure uses a technique**, the transaction operations do not immediately update the physical database

Answer 25

deferred-update

Question 26

are operations in which the DBMS **writes all of its updated buffers to disk**

Answer 26

checkpoints / database checkpoints

Question 27

are temporary storage areas in primary memory used to **speed up disk operations**

Answer 27

buffers / database buffers

Question 28

are logs (several copies of the transaction log) that ensure that a **physical disk failure** will not impair the DBMS's **ability to recover data**

Answer 28

Redundant transaction logs

Question 29

This Protocol **ensures in case of a failure**, the **database can later be recovered** to a consistent state, using the data in the transaction log.

Answer 29

write-ahead logging

Question 29

# True or False A full backup works on all database recovery models.

Answer 29

True

Question 30

A **MEDIA** set option used to specify **whether to overwrite the media header information**.

Answer 30

FORMAT

Question 31

A WITH option that is used to **secure the backup files stored offsite.**

Answer 31

ENCRYPTION

Question 32

Structured or **semi-structured data**, **less functionality and high performance.**

Answer 32

NoSQL database

Question 33

It is a **structured data** that **provides more functionality but gives less performance**.

Answer 33

RDBMS / Relational Database Management System

Question 34

**Nodes and edges are the data model** used in this type of NoSQL databases

Answer 34

Graph databases

Question 35

Data is **retrieved using the direct request** method (provide the key and get the data) in this type of NoSQL databases data model

Answer 35

Key-value store

Question 36

**MongoDB** stores documents on disk in the **serialization format**

Answer 36

BSON

Question 37

When comparing values of different **BSON** types, the **lowest datatype** is

Answer 37

MinKey

Question 38

Default database of Mongo**DB** is

Answer 38

db

Question 39

command provides you with a **list of all the databases**

Answer 39

show dbs

Question 40

In **MongoDB**, ________ method is used to **modify the existing** documents of a collection,

Answer 40

update()

Question 41

In **MongoDB**, collection. ________ method is used to **check the newly inserted** or updated documents

Answer 41

find()

Question 41

In **MongoDB**, the db.collection________ method is used to **delete documents from a collection**.

Answer 41

remove()

Question 42

# MongoDB You can **delete a particular index** using the method of MongoDB

Answer 42

dropIndex ()

Question 43

# MongoDB to **create an index**, you need to use method of **MongoDB**

Answer 43

createIndex()

Question 44

# MongoDB This method **deletes multiple (specified)** indexes on a collection.

Answer 44

dropIndexes

Question 45

# MongoDB this method **returns the description of all the indexes** in the collection

Answer 45

getIndexes()