Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

DBMS > Finals Reviewer pt2 > Flashcards

Finals Reviewer pt2 Flashcards

1
Q

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

A

inserted

or SELECT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

DML trigger /
Data Manipulation Language trigger

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

DDL trigger /
Data Definition Language trigger

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

stored procedure

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

procedure header / header

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

procedure body / body

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

input

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

output

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

How many characters can a stored procedure name contain?

A

128 Characters

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

True or False

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

A

False

can only contain 2,100

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

True or False

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

EXEC / execute

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

local

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

global

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

#

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

True or False

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

table-valued

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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

A

Scalar

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

True or False

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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.

A

Full Backup

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

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

A

Full backup

21
Q

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

A

Differential backup

21
Q

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

A

Full backup

21
Q

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

A

Transaction Log

22
Q

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

A

Differential backup

23
Q

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

A

Transaction Log backup

24
Q

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

A

Transaction Log

25
Q

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

A

deferred-update

26
Q

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

A

checkpoints / database checkpoints

27
Q

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

A

buffers / database buffers

28
Q

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

A

Redundant transaction logs

29
Q

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.

A

write-ahead logging

29
Q

True or False

A full backup works on all database recovery models.

A

True

30
Q

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

A

FORMAT

31
Q

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

A

ENCRYPTION

32
Q

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

A

NoSQL database

33
Q

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

A

RDBMS /
Relational Database Management System

34
Q

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

A

Graph databases

35
Q

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

A

Key-value store

36
Q

MongoDB stores documents on disk in the serialization format

A

BSON

37
Q

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

A

MinKey

38
Q

Default database of MongoDB is

A

db

39
Q

command provides you with a list of all the databases

A

show dbs

40
Q

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

A

update()

41
Q

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

A

find()

41
Q

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

A

remove()

42
Q

MongoDB

You can delete a particular index using the method of MongoDB

A

dropIndex ()

43
Q

MongoDB

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

A

createIndex()

44
Q

MongoDB

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

A

dropIndexes

45
Q

MongoDB

this method returns the description of all the indexes in the collection

A

getIndexes()

DBMS (6 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions