Full form of TCL is -
Transaction Common Language
Transaction Commit Language
Transaction Concatenate Language
Transaction Control Language
Correct Answer :
D. Transaction Control Language
Full form of TCL is Transaction Control Language.
Related Questions
Which of the following clause cannot be used in SQL sub queries?
GROUP BY
ORDER BY
DELETE
FROM
All other columns other than the column which is termed as Primary Key, are known as
Unique Keys
Alternate Keys
Composite Keys
None of the above
SQL indexes speed up the execution time of which statement(s)?
SELECT
WHERE
Both A and B
None of the above
SQL Division operator divides the operand on the ____ side by the operand on the ____ side.
Left, Left
Right, Left
Left, Right
Right, Right
What is TRUE about SAVEPOINT?
Following the completion of a transaction, it must be executed to save all the operations performed in the transaction.
A transaction can be rolled back to its last saved state.
A specific part of a transaction can be given a name
None of the above
Which one is not the OPTIONAL Clause in SELECT statement?
WHERE
ORDER BY
HAVE
HAVING
What is meant by Partial Database Control?
Business rules are hidden.
Users or professionals can't have the full control over the database.
Both A and B
None of the above
SQL BETWEEN operators can be used to select the
Dates
Texts
Numbers
All of the above
In SQL, Like is a ____ operator.
Relational
Logical
Additional
Unique
In order to delete duplicate rows from the table, which keyword is used?
DELETE
DISTINCT
FROM
WHERE
What will be the output of the below SQL statement?
2021-10-06 00:00:00.000
2021-10-06
2021 OCT 06
06-10-2021
What is Export Script by default?
Workspace_name_size/sql
Workspace_number_script/sql
Workspace_name_script/sql
Workspace_name_script/spl
Number of operands used by Unary Operator is?
1
2
3
4
What is TRUE about SQL EXCEPT clause?
The result is purged of duplicates
Duplicate records are not removed
Only one column can be compared by a clause
None of the above
In order to execute a query in Web SQL, which function is used?
open()
translate()
transaction()
execute()
Which statement is used to select the database in SQL?
SELECT
USE
ALTER
CREATE
When SELECT statements used to create Views contain ____ clauses, the views cannot be updated.
JOIN
HAVING
GROUP BY
All of the above
What will be the output of the below SQL statement?
25
26
25.65
25.00
Using which clause, can SQL EXCEPT be used in single table?
TO
AS
WHERE
IN
What does COUNT() function returns?
Average value
Largest value
Smallest value
Number of rows
In order to start the transaction, the command used is
Mysql > START COMMIT;
Mysql > START TRANSACTION;
Mysql > START ROLLBACK;
None of the above
Which of the following statement(s) is/are TRUE about DCL?
The DCL commands in SQL allow us to control which users have access to the data stored in SQL tables.
There will be certain privileges that each user has; consequently, the data can be accessed by them.
The DCL commands in SQL allow us to grant privileges to a user on the SQL database and its table(s), or revoke privileges that have already been granted.
All of the above
Select the syntax of Single Line Comment.
.
!
--
#
Which statement is true about the No-SQL?
No-SQL follows ACID Model.
No-SQL does require object-relational mapping.
Dynamic schemas for unstructured data are used in No-SQL databases.
No-SQL databases are not preferable for storage of hierarchal data.
____ are the columns for the retrieval purpose.
Tables
WHERE Conditions
Expressions
None of the above
In LIKE clause, to represent a zero, a character, or a number of characters ___ is used.
/
_
*
%
Commands that come under TCL is/are -
COMMIT
ROLLBACK
SAVEPOINT
All of the above
Using the SQL last() function, one can return the ______ value of the selected column.
First
Second
Third
Last
What is the difference between DELETE and TRUNCATE statements?
DELETE statement free up the space kept in check by the table whereas TRUNCATE statement does not free up the space kept in check by the table.
DELETE statement does not free up the space kept in check by the table whereas TRUNCATE statement free up the space kept in check by the table.
DELETE statement only deletes rows from the table whereas TRUNCATE statement can only delete columns from the table.
DELETE statement only deletes columns from the table whereas TRUNCATE statement can only delete rows from the table.
In the relational database, in order to modify index, we need to use which command?
ALTER
MODIFY
UPDATE
ADD