Podcast
Questions and Answers
The ______ command is used to remove an object such as an index, column or even a table from a database permanently.
The ______ command is used to remove an object such as an index, column or even a table from a database permanently.
DROP
A ______ is a group of database objects such as tables and indexes that are related to each other.
A ______ is a group of database objects such as tables and indexes that are related to each other.
Schema
The ______ constraint ensures that no duplicate values are entered in specific columns that do not participate in a primary key.
The ______ constraint ensures that no duplicate values are entered in specific columns that do not participate in a primary key.
Unique
The ______ function returns the current system date for MySQL.
The ______ function returns the current system date for MySQL.
The ______ operator is used to check whether an attribute value matches a given string.
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 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 ______ function returns the time between two dates in MySQL.
The ______ command is used to list the contents of a table.
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 absolute value of any numeric value
The ______ function returns the starting position of a specified pattern in MySQL
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 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 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 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 string in UPPERCASE in SQL Server
The ______ function returns the next lower integer value when a number contains decimal places
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
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 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.
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.
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.
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.
??? 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 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.
??? 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 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 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.
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.
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.
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.
______________ 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.
______________ 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.
A ______________ database is a structured data that provides more functionality but gives less performance.
In ______________ databases, nodes and edges are the data model used.
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
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
MongoDB stores documents on disk in the ______ serialization format
When comparing values of different BSON types, the lowest datatype is ______
When comparing values of different BSON types, the lowest datatype is ______
The default database of MongoDB is ______
The default database of MongoDB is ______
The command ______ provides you with a list of all the databases
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, 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
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
To create an index, you need to use the ______ method of MongoDB
Flashcards are hidden until you start studying
