Following the completion of a transaction, it must be executed to save all the operations performed in the transaction. Here we are talking about which command?
REVOKE
COMMIT
ROLLBACK
SAVE
Correct Answer :
B. COMMIT
Following the completion of a transaction, the COMMIT command must be executed to save all the operations performed in the transaction.
Related Questions
Which of the following statement is TRUE?
Web API is the part of HTML5
Web API is not the part of HTML5
Web API is the part of HTML
Web API is the part of XHTML
What will be the output of the below SQL statement?
25
26
24
20
Which of the following is TRUE about SQL Concatenate?
It is also possible to combine more than two strings into one string.
Two columns of the table may be used to store the strings that are to be combined, or they may just be stored individually without being stored into the table.
When the concatenated strings are stored in separate columns of a table, they are stored in the column in which they were initially stored.
All of the above
Which of the following is TRUE about TCL?
Transactions can be saved to the database and rolled back with the help of TCL commands in SQL.
There will be certain privileges that each user has; consequently, the data can be accessed by them using TCL.
Our data is stored in a table that is described by the schema, thus TCL commands deal with the schema.
SQL TCL commands can be used to perform any kind of retrieval or manipulation of the data present in SQL tables.
What is the functionality of SQL COUNT?
It returns the no of record of table
It returns the no of record of database
It returns the no of record of row
It returns the no of record of column
Which of the following statement is correct?
Comparison Operator has higher precedence than Conjuction Operator.
Identity Operator has higher precedence than Multiplication Operator.
Both A and B
None of the above
In order to build a link between two tables, which key is used?
Primary
Foreign
Composite
Unique
In the case of ____ Independence Rule, Physical independence of data to access the database is a requirement for a database or an application.
Physical Data
Logical Data
Integrity
Distribution
For one table, there can be ____unique key constraint(s).
1
NULL
Many
None of the above
What does the following statement do?
Finds any values that start with a
Finds any values that start with a%
Finds any values that contains only two characters starting with a
All of the above
What does the CREATE INDEX Statement do?
An index is created in a SQL database table with this SQL statement.
Changes made in the SQL database transaction are permanently saved using this SQL statement.
By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
The SQL database table's index is deleted using this SQL statement.
Using the ___ statement, a database can be renamed.
SQL CREATE DATABASE
SQL RENAME DATABASE
SQL DROP DATABASE
SQL SELECT DATABASE
Which of these are the types of operators?
Arithmetic
Comparison
Set
All of the above
What does the INSERT INTO Statement do?
In this SQL statement, the data or records are inserted into an existing database table. One query statement can insert multiple records simultaneously using this statement.
A new database will be created through this SQL statement.
In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
By executing this SQL statement, all records in the SQL database will be deleted.
SQL contains which component in its process?
Optimization Engines
SQL Query Engines
Query Dispatchers
All of the above
What does the UPDATE Statement do?
By deleting the stored data, this SQL statement deletes the database.
A new table in SQL is created using this SQL statement.
The stored data in the SQL database is changed or modified by this SQL statement.
Columns in the SQL database can be created, deleted, or modified with this SQL statement.
Command that comes under DML is/are
ROLLBACK
GRANT
UPDATE
All of the above
What is the functionality of UCASE function?
To change the case of the string to lowercase characters.
To change the case of the string to uppercase characters.
To change the case of the string to numeric characters.
To change the case of the string to symbolic characters.
What is the keyword of the Ascending and Descending?
ASCE, DESC
ASC, DES
ASCE, DES
ASC, DESC
How many temp tables are there?
1
2
3
4
In CRUD Operator, U is an acronym of
Upper
Unique
Update
Uppercase
What is the default length of any data type in the CAST function?
10
20
30
40
Which statement is TRUE about the ORDER BY Clause?
In order to return the rows in a specific order, ORDER BY Clause is used.
In order to group the rows, ORDER BY Clause is used.
In order to select the defined groups, ORDER BY Clause is used.
None of the above
Which of the following statement is TRUE about Primary Key?
Table integrity is not enforced by the primary key.
The data in a primary key is always multiple.
900 bytes is the maximum length of a primary key.
Null values are allowed in primary keys.
SET Operators are used to
Compile the results from two queries
Compile the results from three queries
Compile the results from four queries
Compile the results from five queries
____ are the columns for the retrieval purpose.
Tables
WHERE Conditions
Expressions
None of the above
Using which SQL Comparison Operator can we find the data that matches our query?
SQL Not Equal Operator (!=)
SQL Equal Operator (=)
SQL Greater Than Operator (>)
SQL Less Than Operator (<)
What is the difference between UNION & UNION ALL operators?
Combining the results of two select statements will be done using UNION whereas combined records from both queries are returned by UNION ALL operator.
Combining the results of two select statements will be done using UNION ALL whereas combined records from both queries are returned by UNION operator.
After performing the UNION operation, duplicate rows will not be removed whereas after performing the UNION ALL operation, duplicate rows will be removed.
None of the above
Output returned by the Scalar functions is/are -
Single Value
Multiple Value
Two Values
None of the above
What does the CREATE DATABASE Statement do?
Columns in the SQL database can be created, deleted, or modified with this SQL statement.
The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.
In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
A new database will be created through this SQL statement.