Command that comes under DML is/are
ROLLBACK
GRANT
UPDATE
All of the above
Correct Answer :
C. UPDATE
Commands that comes under DML are INSERT, SELECT, UPDATE & DELETE.
Related Questions
Network-based IDS can be used to monitor
Web server logs
When something weird occurs
All connections to the database server
None of the above
We can create View in SQL using
CREATE statement
CREATE VIEW statement
VIEW CREATE statement
SQL VIEW statement
Which of the following is TRUE about SQL Auto Increment?
It increments the unique number automatically.
It decrements the unique number automatically.
It keeps the unique number constant
None of the above
By default, TIME data type stores time in which format?
MM:HH:SS;
SS:HH:MM;
HH:SS:MM;
HH:MM:SS;
Select the correct type(s) of SQL Comments.
Inline Comments
Single Line Comments
Multi-line Comments
All of the above
Using the DELETE Query from the CRUD Operator, we can delete
Only one row
All the rows
Only two rows
None of the above
SQL EXCEPT statement behaves similar to _____operator in mathematics.
Sum
Multiply
Minus
Divide
With export, you can ____ SQL Scripts from the SQL repositories in your workspace.
Export
Import
Save
Exchange
In case to prevent the endless loop in CTE, ____ is added.
MAXLINEAR
MAXROUND
MAXRECURSION
None of the above
Which function returns the correct date and time?
DATE()
NOW()
TIME()
DATETIME()
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
What is the full form of CTE in SQL?
Character Table Expressions
Character Table Evaluator
Common Table Evaluator
Common Table Expressions
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 DELETE Statement do?
A new table in SQL is created using this SQL statement.
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.
By executing this SQL statement, you remove the table and all the information that it contains, including the structure, views, permissions, and triggers.
Difference between GRAND & REVOKE command is/are?
The GRANT command can be used to grant a user access to databases and tables whereas The REVOKE command can be used to revoke all access privileges already assigned to the user.
The REVOKE command can be used to grant a user access to databases and tables whereas The GRANT command can be used to revoke all access privileges already assigned to the user.
A transaction can be rolled back to its last saved state.
None of the above
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 (<)
What is the syntax of SQL CAST Function?
CAST (expression AS [data type])
CAST (expression IN [data type])
CAST (expression TO [data type])
CAST (expression FOR [data type])
TINYTEXT can hold the maximum length of ___ characters?
254
255
256
257
Number of operands used by Unary Operator is?
1
2
3
4
In the relational database, in order to modify index, we need to use which command?
ALTER
MODIFY
UPDATE
ADD
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.
Using a WHERE clause in a SQL query is used to specify SQL reserved words and characters, known as ____?
Operators
Data Types
Numbers
Syntax
The ____ operator cannot be used with the sub query, but within it.
IN
INTO
BETWEEN
JOIN
Which command will remove the records from the table, but not affect the structure of the table?
REMOVE
DELETE
DROP
TRUNCATE
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
Local Temp Variable is used with which sign?
?
@
#
&
Which keyword is used in SQL Server to implement the auto increment?
UNIQUE
IDENTITY
INCREMENT
ADD
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
Select the correct statement which will return all the rows from the Table and then also deletes the Table_Add table?
SELECT * FROM Table; DROP TABLE Table_Add
SELECT * WHERE Table; DROP TABLE Table_Add
SELECT * FROM Table; DELETE TABLE Table_Add
SELECT * WHERE Table; DELETE TABLE Table_Add
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