Which of the following is/are transaction control commands in SQL?
Commit
Rollback
Both A. and B.
None of the above
Correct Answer :
C. Both A. and B.
Commit and Rollback are transaction control commands in SQL.
Related Questions
What will be the output of the below SQL statement?
25
26
25.65
25.00
In order to sort the records according to the columns, which clause is used?
HAVING
GROUP BY
ORDER BY
None of the above
SQL BETWEEN operators include
Starting Value
In Between Value
Ending Value
All 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 start with a and are at least 2 characters in length
All of the above
Which of the following keyword is used to delete the Join?
DELETE
ON
WHERE
All of the above
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
Using the SQL last() function, one can return the ______ value of the selected column.
First
Second
Third
Last
In order to delete the database, which keyword is used?
DROP
DELETE
ALTER
None of the above
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
In order to delete duplicate rows from the table, which keyword is used?
DELETE
DISTINCT
FROM
WHERE
What does the ALTER TABLE Statement do?
By deleting the stored data, this SQL statement deletes the database.
Columns in the SQL database can be created, deleted, or modified with this SQL statement.
A new table in SQL is created using this SQL statement.
The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.
It is possible to use LIKE clauses with
Strings
Numbers
Both A. and B.
None of the above
What does the CREATE TABLE Statement do?
The stored data in the SQL database is changed or modified by this SQL statement.
By deleting the stored data, this SQL statement deletes the database.
A new table in SQL is created using this SQL statement.
Columns in the SQL database can be created, deleted, or modified with this SQL statement.
What does the DROP TABLE Statement do?
The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.
A new table in SQL is created using this SQL statement.
Columns in the SQL database can be created, deleted, or modified with this SQL statement.
A new database will be created through this SQL statement.
What is the clause to delete all rows from the table?
SQL DELETE ALL ROWS Table_Name;
SQL DELETE ROWS Table_Name;
DELETE FROM ALL ROWS Table_Name;
DELETE FROM Table_Name;
A single unit of work for all commands executed consecutively is known as-
Transaction
Commit
Rollback
Control
Which statement is used to select the database in SQL?
SELECT
USE
ALTER
CREATE
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
What is TRUE about DEFAULT constraint?
The value will first be checked for certain conditions before inserting it into the column when a DEFAULT constraint applies to a column in the table.
In the event of a DEFAULT constraint being applied to a table's column without a user specifying the value to be inserted when that constraint was applied, the default value that was specified when the constraint was applied will be put into that column.
An index can be created on the table using the DEFAULT constraint.
None of the above
What is the work of SELECT command?
Database objects such as tables, table views, and other objects can be deleted using this command.
Database objects such as tables, table views, and other objects can be deleted using this command.
One or more rows from one or more tables of the database can be accessed with this command. Using the WHERE clause with this command is also possible.
It enables you to create new databases, tables, table views, and other objects using this command.
SQL DELETE can be used to delete,
Rows
Database
View
All of the above
Name of the operators in SET Operators is
UNION
INTERSECT
MINUS
All of the above
Which of the following is a SQL Logical Operator?
SQL ALL Operator
SQL OR Operator
SQL LIKE Operator
All of the above
Which statement is TRUE about the GROUP BY Clause?
In order to retrieve rows, GROUP BY Clause is used.
In order to group the rows that share the same property, GROUP BY Clause is used.
In order to select the defined groups, GROUP BY Clause is used.
In order to return the rows, GROUP BY Clause is used.
In order to update one table using another table and join condition, which statement is used.
SQL UPDATE INTO
SQL UPDATE JOIN
SQL JOIN
SQL JOIN UPDATE
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
In the case of ____ Independence Rule, if using the SQL queries language to insert data into table's cells, the database must maintain integrity independence.
Interdependent
Intradependent
Integration
Integrity
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.
What is TRUE about UNION ALL Operator?
The results of both queries are combined with this operator.
After performing the UNION ALL operation, duplicate rows will not be removed.
Both A and B
None of the above
What does the DISTINCT Clause do?
Specify the columns of the table in this SQL clause to return distinct values.
By executing this SQL statement, all records in the SQL database will be deleted.
The data specified in this table or view is reported in this SQL statement.
Changes made in the SQL database transaction are permanently saved using this SQL statement.