TRUNCATE TABLE requires:
WHERE clause
HAVING clause
Both a and b
None of the above
Correct Answer :
D. None of the above
TRUNCATE TABLE does not require any clause.
Related Questions
What does BOOL mean in MySQL Numeric Data Types?
A Boolean value is specified by this variable. When a value is nonzero, it is considered false, and zero is considered true.
A Boolean value is specified by this variable. When a value is nonzero, it is considered true, and zero is considered false.
A Boolean value is specified by this variable. When a value is nonzero, it is considered true, and zero is also considered true.
A Boolean value is specified by this variable. When a value is nonzero, it is considered false, and zero is also considered false.
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.
Using which clause, can SQL EXCEPT be used in single table?
TO
AS
WHERE
IN
In order to delete the database, which keyword is used?
DROP
DELETE
ALTER
None 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.
____ and ____constraints form the core of the PRIMARY KEY constraint.
NOT NULL , CHECK
NOT NULL , DEFAULT
NOT NULL , FOREIGN KEY
NOT NULL , UNIQUE
Which statement is used to select the database in SQL?
SELECT
USE
ALTER
CREATE
In the case of ____ Independence Rule, Physical independence of data to access the database is a requirement for a database or an application.
Physical Data
Logical Data
Integrity
Distribution
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 does the following statement do?
Finds any values that end with a
Finds any values whose second character is a
Find any values that contains only two characters ending with a
Mysql > Savepoint ini;
Full form of DDL is
Data Describe Language
Definition Data Language
Data Definition Language
Data Distinct Language
Which of the following statement is TRUE about DISTINCT Clause?
Returns only Distinct values.
Only on the single column, it operates.
It can be used with the aggregates such as COUNT, AVG, etc.
All of the above
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;
We can create View in SQL using
CREATE statement
CREATE VIEW statement
VIEW CREATE statement
SQL VIEW statement
Using the SQL last() function, one can return the ______ value of the selected column.
First
Second
Third
Last
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
Name of the data type categories are,
String Data types
Numeric Data types
Date and time Data types
All of the above
What is the difference between UNION & UNION ALL operators?
Combining the results of two select statements will be done using UNION whereas combined records from both queries are returned by UNION ALL operator.
Combining the results of two select statements will be done using UNION ALL whereas combined records from both queries are returned by UNION operator.
After performing the UNION operation, duplicate rows will not be removed whereas after performing the UNION ALL operation, duplicate rows will be removed.
None of the above
A single unit of work for all commands executed consecutively is known as-
Transaction
Commit
Rollback
Control
To add a Primary Key constraint after table is created, which clause is used?
UPDATE
ADD
ALTER
JOIN
SQL Indexes slows the execution time of which statement(s)?
UPDATE
INSERT
SELECT
Both A and B
The SELECT TOP statement shows the limited number of:
Rows
Columns
Tables
None of the above
_____ variables are not supported by SQL Script.
Bind
Dynamic
Both A) and B)
None of the above
Which of the following is not a SQL Logical Operator?
SQL Equal Operator
SQL ANY Operator
SQL BETWEEN Operator
SQL IN Operator
Determine the correct SQL command?
CREATE
UPDATE
DELETE
All of the above
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 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.
A database does not need to be created in ____. A direct table creation option is provided in ____.
MySQL
Oracle
Both A and B
None of the above
In the relational database, in order to modify index, we need to use which command?
ALTER
MODIFY
UPDATE
ADD
Name of the control in SQL Script
Script
Owner
Opinion
All of the above