Database Management Systems

The ______ command is used to remove an object such as an index, column or even a table from a database permanently.

A ______ is a group of database objects such as tables and indexes that are related to each other.

The ______ constraint ensures that no duplicate values are entered in specific columns that do not participate in a primary key.

The ______ function returns the current system date for MySQL.

The ______ operator is used to check whether an attribute value matches a given string.

The ______ function produces a date by adding a specified number to a specified part of date in SQL Server.

The ______ function returns the time between two dates in MySQL.

The ______ command is used to list the contents of a table.

The ______ function returns the absolute value of any numeric value

The ______ function returns the starting position of a specified pattern in MySQL

The ______ function is used to return a single part of a date/time, such as year, month, day, hour, minutes, etc. in MySQL

The ______ function rounds numbers to a specified number of decimal places

The ______ function returns the length (number of characters) of a desired string excluding trailing blanks in MySQL

The ______ function returns the string in UPPERCASE in SQL Server

The ______ function returns the next lower integer value when a number contains decimal places

The ______ function returns the current system date and time in SQL Server

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

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

In SQL Server, we can use execute, the actual name of the procedure or ______ to execute the stored procedure.

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

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

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

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

A ______ backup is 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 ______________ backup is a type of backup that must be done at least once before any of the other types of backup can be run.

A ______________ backup is 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.

The purpose of a transaction ______________ is to store a series of logs that provide the history of every modification of data, in a database.

A ______________ backup allows the database to be recovered to a specific point in time.

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

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

A ______________ database is a structured data that provides more functionality but gives less performance.

In ______________ databases, nodes and edges are the data model used.

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

MongoDB stores documents on disk in the ______ serialization format

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

The default database of MongoDB is ______

The command ______ provides you with a list of all the databases

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

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

To create an index, you need to use the ______ method of MongoDB