Finals Reviewer pt2 Flashcards
In MySQL, the ??? table contains all the values we inserted using INSERT command.
inserted
or SELECT
A trigger that executes when INSERT, UPDATE, and DELETE commands modify data in a table or view.
DML trigger /
Data Manipulation Language trigger
A trigger that executes in response to a DDL statement that is often used to make database schema changes.
DDL trigger /
Data Definition Language trigger
A ??? is a set of transact-SQL (T-SQL) statements that is compiled and stored as a single database object for later repetitive use.
stored procedure
A ??? defines the name of the stored procedure, the input and output parameters, and some miscellaneous processing options.
procedure header / header
A ??? is part of a stored procedure that contains one or more transact sql statements to be executed at runtime
procedure body / body
A ??? parameter is part of a stored procedure that allows it to accept values and serve as variables.
input
A ??? parameter is part of a stored procedure that allows it to return a value and serve as variables.
output
How many characters can a stored procedure name contain?
128 Characters
True or False
Stored procedures may contain up to 2,200 input and output parameters.
False
can only contain 2,100
True or False
the maximum size of the body of the stored procedure is 128MB
True
in SQL server, we can use execute, the actual name of the procedure or ??? to execute the stored procedure.
EXEC / execute
A ??? temporary table is visible only to the session that it is created from and is dropped automatically when the connection is closed.
local
??? temporary tables are available to all users and are automatically dropped when the last user accessing the table disconnects from the database.
global
in SQL server, what symbol is used to denote a temporary table, please indicate the symbol only.
#
True or False
In scalar functions the return value is a standard data type but cannot be a text , Ntext, image or timestamp.
True
??? functions are often used as “parameterised views” as they can be included in place of tables in a query and can accept arguments.
table-valued
??? functions contain a single statement, which must be a SELECT. The results of the query become the return value of the functions
Scalar
True or False
in MySQL, we use DROP and CREATE when altering functions.
True
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.
Full Backup
A type of backup that allows for the simplest form of database restoration, since all of the contents are contained in one single backup.
Full backup
A type of backup that captures the state of the changed extents at the time that backup was created.
Differential backup
A type of backup that must be done at least once before any of the other types of backup can be run.
Full backup
is a file that stores a series of the logs that provide the history of every modification of data, in a database
Transaction Log
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
Differential backup
A type of backup that as its name implies, backs up the transaction logs.
Transaction Log backup
________ ____ backup allows the database to be recovered to a specific point in time
Transaction Log
When the recovery procedure uses a technique, the transaction operations do not immediately update the physical database
deferred-update
are operations in which the DBMS writes all of its updated buffers to disk
checkpoints / database checkpoints
are temporary storage areas in primary memory used to speed up disk operations
buffers / database buffers
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
Redundant transaction logs
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.
write-ahead logging
True or False
A full backup works on all database recovery models.
True
A MEDIA set option used to specify whether to overwrite the media header information.
FORMAT
A WITH option that is used to secure the backup files stored offsite.
ENCRYPTION
Structured or semi-structured data, less functionality and high performance.
NoSQL database
It is a structured data that provides more functionality but gives less performance.
RDBMS /
Relational Database Management System
Nodes and edges are the data model used in this type of NoSQL databases
Graph databases
Data is retrieved using the direct request method (provide the key and get the data) in this type of NoSQL databases data model
Key-value store
MongoDB stores documents on disk in the serialization format
BSON
When comparing values of different BSON types, the lowest datatype is
MinKey
Default database of MongoDB is
db
command provides you with a list of all the databases
show dbs
In MongoDB, ________ method is used to modify the existing documents of a collection,
update()
In MongoDB, collection. ________ method is used to check the newly inserted or updated documents
find()
In MongoDB, the db.collection________ method is used to delete documents from a collection.
remove()
MongoDB
You can delete a particular index using the method of MongoDB
dropIndex ()
MongoDB
to create an index, you need to use method of MongoDB
createIndex()
MongoDB
This method deletes multiple (specified) indexes on a collection.
dropIndexes
MongoDB
this method returns the description of all the indexes in the collection
getIndexes()
