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.
Correct Answer :
B. 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 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.
Related Questions
SQL EXCEPT returns the record from -
First SELECT Query
Second SELECT Query
Third SELECT Query
None of the above
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
When the table is dropped:
Table structure is dropped
Integrity constraints are dropped
Relationship is dropped
All of the above
The table records can be retrieved using which command?
RETRIEVE
SELECT
CREATE
ALTER
In more readable form, you can retrieve the date values, using ______ function?
DATE
DATE_FORM
DATE_FORMAT
DATE_VALUE
In order to delete the database, which keyword is used?
DROP
DELETE
ALTER
None of the above
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
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.
Which of the following is among the 12 Codd's Rules?
View Updating Rule
Relational Level Operation Rule
Distribution Independence Rule
None of the above
TINYTEXT can hold the maximum length of ___ characters?
254
255
256
257
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
The ____ size of the result is shown by Script Quota.
Minimum
Maximum
Average
None of the above
SQL Operator can be,
Unary
Binary
Both A and B
None of the above
GROUP BY clause is placed before which clause in SQL?
HAVING
WHERE
ORDER BY
FROM
Using which SQL Comparison Operator can we find the data that matches our query?
SQL Not Equal Operator (!=)
SQL Equal Operator (=)
SQL Greater Than Operator (>)
SQL Less Than Operator (<)
Which of the following is TRUE about Intrusion Detection System?
Intrusion Detection System is Network-based
Intrusion Detection System is Host-based
Both A) and B)
None of the above
Foreign key is a field in a table that is _______ key in another table?
Primary
Unique
Composite
None of the above
Which statement is not true about SQL?
Using SQL in relational databases is all about inserting, updating, and deleting data.
Sample data can also be described with the aid of this tool.
It helps develop relational database functions, events, and views.
A SQL user can also set restrictions and permissions for a table column, a view, and a stored procedure.
Which of the following is not an SQL Statement?
SELECT Statement
UPDATE Statement
TRUNCATE TABLE Statement
FROM Statement
Which of the following is NOT the SQL Arithmetic Operator?
Addition
Subtraction
Unary
Modulus
Full form of LCASE is -
Low case
Letter case
Light case
Lower case
Which of the following statement is TRUE about DISTINCT Clause?
It cannot ignore the NULL values
It can ignore the NULL values
Its query can return multiple values
None of the above
What is the difference between HAVING and WHERE clause?
HAVING clause is used in column operation whereas WHERE clause is used in row operation.
HAVING clause is post-filter whereas WHERE clause is pre-filter.
HAVING clause filters the groups whereas WHERE clauses filter the single record of the table.
All of the above
What will be the output of the below SQL statement?
25
26
25.65
25.00
BETWEEN operator is used with which SQL Statements
SELECT
DELETE
INSERT
All of the above
Select the correct statement.
TRUNCATE TABLE is faster than DELETE TABLE statement.
TRUNCATE TABLE uses fewer resources than DELETE TABLE statement.
Both A) and B)
None of the above
In SQL, Like is a ____ operator.
Relational
Logical
Additional
Unique
Command that comes under DCL is/are -
GRANT
REVOKE
Both A. and B.
None of the above
What is the work of INSERT 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.
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.
In case the CTE is wrong, it goes into
Infinite Loop
Null State
False State
True State