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.
Signup and view all the answers
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.
Signup and view all the answers
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.
Signup and view all the answers
The ______ function returns the time between two dates in MySQL.
The ______ function returns the time between two dates in MySQL.
Signup and view all the answers
The ______ command is used to list the contents of a table.
The ______ command is used to list the contents of a table.
Signup and view all the answers
The ______ function returns the absolute value of any numeric value
The ______ function returns the absolute value of any numeric value
Signup and view all the answers
The ______ function returns the starting position of a specified pattern in MySQL
The ______ function returns the starting position of a specified pattern in MySQL
Signup and view all the answers
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
Signup and view all the answers
The ______ function rounds numbers to a specified number of decimal places
The ______ function rounds numbers to a specified number of decimal places
Signup and view all the answers
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
Signup and view all the answers
The ______ function returns the string in UPPERCASE in SQL Server
The ______ function returns the string in UPPERCASE in SQL Server
Signup and view all the answers
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
Signup and view all the answers
The ______ function returns the current system date and time in SQL Server
The ______ function returns the current system date and time in SQL Server
Signup and view all the answers
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.
Signup and view all the answers
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.
Signup and view all the answers
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.
Signup and view all the answers
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.
Signup and view all the answers
??? 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.
Signup and view all the answers
??? 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.
Signup and view all the answers
??? 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.
Signup and view all the answers
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.
Signup and view all the answers
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.
Signup and view all the answers
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.
Signup and view all the answers
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.
Signup and view all the answers
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.
Signup and view all the answers
______________ 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.
Signup and view all the answers
______________ 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.
Signup and view all the answers
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.
Signup and view all the answers
In ______________ databases, nodes and edges are the data model used.
In ______________ databases, nodes and edges are the data model used.
Signup and view all the answers
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
Signup and view all the answers
MongoDB stores documents on disk in the ______ serialization format
MongoDB stores documents on disk in the ______ serialization format
Signup and view all the answers
When comparing values of different BSON types, the lowest datatype is ______
When comparing values of different BSON types, the lowest datatype is ______
Signup and view all the answers
The default database of MongoDB is ______
The default database of MongoDB is ______
Signup and view all the answers
The command ______ provides you with a list of all the databases
The command ______ provides you with a list of all the databases
Signup and view all the answers
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
Signup and view all the answers
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
Signup and view all the answers
To create an index, you need to use the ______ method of MongoDB
To create an index, you need to use the ______ method of MongoDB
Signup and view all the answers