Commands that come under TCL is/are -
COMMIT
ROLLBACK
SAVEPOINT
All of the above
Correct Answer :
D. All of the above
Commands that comes under TCL are COMMIT, ROLLBACK & SAVEPOINT.
Related Questions
____ function extract characters from the text field.
LEN()
NOW()
MID()
FORMAT()
What can be the maximum size of char(n) in SQL Server String Data Type?
7000
8000
9000
10000
What is the meaning of Null Values in Systematic Treatment of Null Values in the 12 Codd's Rules?
No value in cell
Inappropriate Information
Unknown data
All of the above
Which of the following is the feature(s) of SQL Auto Increment?
In some cases you may not have any unique identifying characteristics in data; therefore, it makes sense to create a Primary Key.
Explicitly initializing and modifying the auto-increment value is possible at any time.
Record identifiers can easily be created that are unique to each record.
All of the above
____ are the columns for the retrieval purpose.
Tables
WHERE Conditions
Expressions
None of the above
Full form of TCL is -
Transaction Common Language
Transaction Commit Language
Transaction Concatenate Language
Transaction Control Language
What is Export Script by default?
Workspace_name_size/sql
Workspace_number_script/sql
Workspace_name_script/sql
Workspace_name_script/spl
Select the statement which is TRUE?
In a table, there could be any number of rows and any number of columns.
In a table, there could be any number of rows and specified number of columns.
In a table, there could be any number of columns and specified number of rows.
In a table, there could be specified number of rows and specified number of columns.
The records and structure of a table may be removed or deleted from the database using which command?
REMOVE
DELETE
DROP
TRUNCATE
Local Temp Variable is used with which sign?
?
@
#
&
Which of the following is SQL Server Numeric Data Type?
image
nchar
money
cursor
Which of the following statement is correct for SQL Multiplication Operator?
SELECT Operand1+Operand2;
SELECT Operand1*Operand2;
SELECT Operand1**Operand2;
SELECT Operand1
Full form of DDL is
Data Describe Language
Definition Data Language
Data Definition Language
Data Distinct Language
SQL Division operator divides the operand on the ____ side by the operand on the ____ side.
Left, Left
Right, Left
Left, Right
Right, Right
In order to manage or store the data in the database, WEB SQL Database is used which is a
Web site
Web page
Web browser
None of the above
Using the SQL last() function, one can return the ______ value of the selected column.
First
Second
Third
Last
____ integrity is achieved by using a foreign key.
Referential Integrity
Domain Integrity
User-defined Integrity
Entity Integrity
Select the correct type(s) of SQL Comments.
Inline Comments
Single Line Comments
Multi-line Comments
All of the above
How MySQL determines which one to use, FLOAT or DOUBLE, using the p parameter?
If p comes between 0 to 25, data type becomes FLOAT(). If p comes between 26 to 54, data type becomes DOUBLE().
If p comes between 26 to 54, data type becomes FLOAT(). If p comes between 0 to 25, data type becomes DOUBLE().
If p comes between 25 to 53, data type becomes FLOAT(). If p comes between 0 to 24, data type becomes DOUBLE().
If p comes between 0 to 24, data type becomes FLOAT(). If p comes between 25 to 53, data type becomes DOUBLE().
Which syntax is correct for RENAME DATABASE in SQL?
RENAME old_database_name TO new_database_name;
RENAME DATABASE old_database_name TO new_database_name;
ALTER old_database_name MODIFY NAME = new_database_name;
ALTER DATABASE old_database_name MODIFY NAME = new_database_name;
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 DBMS, table is known as _____ and row is known as _____.
Relation, Tuple
Tuple, Tuple
Tuple, Relation
Relation, Relation
Output returned by the Scalar functions is/are -
Single Value
Multiple Value
Two Values
None of the above
Difference between GRAND & REVOKE command is/are?
The GRANT command can be used to grant a user access to databases and tables whereas The REVOKE command can be used to revoke all access privileges already assigned to the user.
The REVOKE command can be used to grant a user access to databases and tables whereas The GRANT command can be used to revoke all access privileges already assigned to the user.
A transaction can be rolled back to its last saved state.
None of the above
Unique Index is similar to
Primary Key
Foreign Key
Composite Key
Alternate Key
What is SQL CREATE Table used for?
To Update table
To Create table
To Delete table
None of the above
Select the correct syntax for Multi-line Comments.
//*Line1
Line2*//
/*Line1
Line2/*
Which of these are the types of operators?
Arithmetic
Comparison
Set
All of the above
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
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