In order to start the transaction, the command used is
Mysql > START COMMIT;
Mysql > START TRANSACTION;
Mysql > START ROLLBACK;
None of the above
Correct Answer :
B. Mysql > START TRANSACTION;
To start the transaction, Mysql > START ROLLBACK; command is used.
Related Questions
Which of the following is a SQL Logical Operator?
SQL ALL Operator
SQL OR Operator
SQL LIKE Operator
All of the above
Which clause is used to retrieve a unique element from the table?
SELECT UNIQUE
SELECT DISTINCT
Both A) and B)
None of the above
What is the work of CREATE command?
Using this command, you can remove or erase recorded information from a database table.
It enables you to create new databases, tables, table views, and other objects using this command.
Inserting records or data into the database tables is accomplished with this command. In addition to inserting records in single rows, we can insert records in multiple rows as well.
A single or multiple rows can be accessed using this command from one or more tables of a database. Using the WHERE clause with this command is also possible.
What is the difference between Column Level and Table Level Constraints?
Constraints are applied to a single row using Column Level Constraints whereas Multiple rows can be constrained using a Table Level Constraint.
Constraints are applied to multiple rows using Column Level Constraints whereas a single row can be constrained using a Table Level Constraint.
Constraints are applied to a single column using Column Level Constraints whereas Multiple columns can be constrained using a Table Level Constraint.
Constraints are applied to multiple columns using Column Level Constraints whereas only a single column can be constrained using a Table Level Constraint.
What can be the maximum size of char(n) in SQL Server String Data Type?
7000
8000
9000
10000
Which of the following statement is TRUE about SQL Injection?
SQL Injection is an Object Penetration Technique
SQL Injection is a Function Penetration Technique
SQL Injection is a Code Penetration Technique
SQL Injection is a Database Penetration Technique
Select the syntax of Single Line Comment.
.
!
--
#
ORDER BY clause comes ____ the EXCEPT clause in SQL statement?
Before
After
Flexible to before or after
None of the above
What does AVG() function returns?
First value of the column
Last value of the column
Sum of rows of the table
Average value of the column
A Key which uniquely identifies each row in the table is known as?
Primary Key
Unique Key
Composite Key
Foreign Key
Full form of LCASE is -
Low case
Letter case
Light case
Lower case
Select the correct syntax for Savepoint.
Mysql > Transaction ini;
Mysql > &Savepoint;
Mysql > START Transaction;
Mysql > Savepoint ini;
Unique Index is similar to
Primary Key
Foreign Key
Composite Key
Alternate Key
Select the correct syntax of SELECT TOP clause?
SELECT TOP name
SELECT TOP column
SELECT TOP FROM
SELECT TOP Number
Which one is not the OPTIONAL Clause in SELECT statement?
WHERE
ORDER BY
HAVE
HAVING
SQL BETWEEN operators include
Starting Value
In Between Value
Ending Value
All of the above
Which function returns the largest value of the column?
MIN()
MAX()
LARGE()
AVG()
Which of the following statement is FALSE?
A Primary Key cannot be NULL
A Foreign Key cannot be NULL
A Primary Key cannot be Duplicate
A Foreign Key can be Duplicate
When two or more columns are combined to be used to uniquely identify each row in the table, it is known as -
Primary Key
Unique Key
Composite Key
Foreign Key
Which of the following statement is false?
There is no difference between a lower case and upper case keyword in SQL.
It is easier to read SQL queries when the keywords are in lowercase.
An SQL statement's syntax is determined by its text line.
One or more SQL statements can be placed on a single line of text.
Temporary variables use ____ resources than table variables.
More
Less
Equal
None of the above
Determine the correct SQL command?
CREATE
UPDATE
DELETE
All of the above
Full form of DML is
Data Multiplication Language
Data Manipulation Language
Data Modify Language
Data Mapping Language
The SQL Modulus Operator returns the,
Quotient
Percentage
Sum
Reminder
In which clause does the BETWEEN operator is used?
IF
AS
WHERE
EXCEPT
LIKE clause can be used with
% operator
_ operator
NOT operator
All of the above
Which syntax is correct for RENAME DATABASE in MySQL?
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;
A Primary Key is basically a
Row
Column
Table
Database
The description in SQL Script, displays script in
One Line
Two Line
Three Line
Many Lines
Command that comes under DCL is/are -
GRANT
REVOKE
Both A. and B.
None of the above