Which of the following is TRUE about Savepoint command?
A transaction is marked in a table by this TCL command.
Imagine that you are making a long table, and you want to roll back only to a specific point in the table. You can do this with the savepoint.
In order to rollback part of a table rather than the entire table, a savepoint is useful.
All of the above
Correct Answer :
D. All of the above
Some of the points about Savepoint command are:
a) A transaction is marked in a table by this TCL command.
b) Imagine that you are making a long table, and you want to roll back only to a specific point in the table. You can do this with the savepoint.
c) In order to rollback part of a table rather than the entire table, a savepoint is useful.
Related Questions
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.
What is the default length of any data type in the CAST function?
10
20
30
40
Unique Index is similar to
Primary Key
Foreign Key
Composite Key
Alternate Key
What is TRUE about the Active/Dynamic Online Catalog based on the relational model in the 12 Codd's Rules?
The primary key value, table name, and column name are characteristics that allow us to access the precise data (atomic value) logically from a relational database.
Null values are treated in database records according to this rule.
Database dictionaries represent the complete logic of all descriptive data, which must be stored online.
None of the above
SQL contains which component in its process?
Optimization Engines
SQL Query Engines
Query Dispatchers
All of the above
Which of the following is TRUE about the type of SQL Injection attack?
Install malicious program
Export valuable data
Get user login detail
All of the above
What will be the output of the below SQL statement?
25
26
24
20
Select the correct statement about SQL Scripts?
At the run time, the SQL*Plus commands are ignored.
SQL Scripts and SQL Commands in the SQL Scripts have no interaction.
Through the SQL Script editor, SQL Commands are cut and pasted.
All of the above
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 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
____ and ____constraints form the core of the PRIMARY KEY constraint.
NOT NULL , CHECK
NOT NULL , DEFAULT
NOT NULL , FOREIGN KEY
NOT NULL , UNIQUE
SQL BETWEEN is a ______ operator.
Relational
Logical
Arithmetic
Assignment
Savepoint command is used with _____ command.
Commit
Transaction
Rollback
None of the above
Select the syntax of Single Line Comment.
.
!
--
#
Which of the following is SQL Server Date and Time Data Type?
timestamp
sql_variant
real
text
What is TRUE about NOT IN clause?
The result is purged of duplicates
Duplicate records are not removed
Performs column-by-column comparisons
None of the above
Which of the statement is true?
The precedence-low operators are evaluated last in SQL.
The precedence-high operators are evaluated first in SQL.
Both A and B
None of the above
Which of the following is TRUE about Pattern Matching in SQL?
In SQL, pattern matching is performed with LIKE clauses.
An SQL query usually begins with a LIKE clause before a WHERE clause
Using the LIKE clause in an SQL query, we compare the pattern in the query with the pattern present in a table.
All of the above
Host-based IDS can be used to monitor
Web server logs
When something weird occurs
Both A) and B)
None of the above
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 order to merge two or more strings, which string function is used?
CHAR
ALTER
CONCAT
MERGE
Numbers of operand used by Binary Operators are?
1
2
3
4
The ____ size of the result is shown by Script Quota.
Minimum
Maximum
Average
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
Which of the following is SQL Server String Data Type?
ntext
binary(n)
varbinary
All of the above
Which of the following is NOT the SQL Arithmetic Operator?
Addition
Subtraction
Unary
Modulus
Using TIME_FORMAT() function, time can be retrieved in
12-hour format
24-hour format
Both A. and B.
None of the above
When SELECT statements used to create Views contain ____ clauses, the views cannot be updated.
JOIN
HAVING
GROUP BY
All of the above
LIKE clause can be used with
% operator
_ operator
NOT operator
All of the above
Which function combines the two different columns?
ADD
MERGE
CONCAT
None of the above