SQL DELETE can be used to delete,
Rows
Database
View
All of the above
Correct Answer :
D. All of the above
SQL DELETE can be used to delete Rows, Database and View using specific SQL clauses.
Related Questions
Rules that are needed to be followed in SET Operators in SQL are
All columns must be identical in number and order.
There must be compatibility between data types.
Both A and B
None of the above
It is possible to retrieve time in a more readable format, using which function?
TIME
TIME_FORM
TIME_FORMAT
TIME & DATE
A single unit of work for all commands executed consecutively is known as-
Transaction
Commit
Rollback
Control
____ are the columns for the retrieval purpose.
Tables
WHERE Conditions
Expressions
None of the above
In order to create the Index, we need to use which command?
ALTER
UPDATE
CREATE
ADD
Determine the correct SQL command?
CREATE
UPDATE
DELETE
All of the above
SQL Operator can be,
Unary
Binary
Both A and B
None of the above
What is the full form of GUID?
Guided Unique Identifier
Guided Unique Interpreter
Globally Unique Identifier
Globally Unique Interpreter
Select the correct syntax for Multi-line Comments.
//*Line1
Line2*//
/*Line1
Line2/*
SQL has the disadvantage of?
SQL is cheap.
SQL interface is simple.
Both A and B.
None of the above.
What does the following statement do?
Finds any values that start with a and ends with o
Finds any values whose first character is a and third character is o
Both A. and B.
None of the above
Full form of TCL is -
Transaction Common Language
Transaction Commit Language
Transaction Concatenate Language
Transaction Control Language
What does the following statement do?
Finds any values that start with or
Finds any value that contains only four characters and second, third characters are 'o', 'r'
Finds any values that have or in any position
None of the above
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.
To get a record from one table, which is not present in another table, we can use the clause
CONCAT
COPY
EXCEPT
ALTER
____ Clause is used in Parent-child relationship in order to join two or more tables.
FROM
TO
WHERE
IN
In order to insert a row directly in the table, which command is used?
INSERT IN
INSERT INSIDE
INSERT UNDER
INSERT INTO
SQL Like is NOT used with which of the following statement(s)?
DELETE
SELECT
UPDATE
ALTER
Global Temp Variable is used with which sign?
###
####
#
##
What does task list consist of in SQL Script?
Import
Show Quotas
Manage Results
All of the above
Temporary variables use ____ resources than table variables.
More
Less
Equal
None of the above
In order to join N tables, minimum number of join statements required is
N
N-1
N-2
N+1
In order to delete duplicate rows from the table, which keyword is used?
DELETE
DISTINCT
FROM
WHERE
We can use literal in the CONCAT function. What does literal refer to?
Number
Character
Date
All of the above
Which statement is used to select the database in Oracle?
USE
SELECT
RENAME
None of the above
Unique Index is similar to
Primary Key
Foreign Key
Composite Key
Alternate Key
Which of the following statement is TRUE?
A DATABASE name can be renamed.
A TABLE name can be renamed.
Both A and B
None of the above
In how many categories data types has been classified?
2
3
4
5
To add a Primary Key constraint after table is created, which clause is used?
UPDATE
ADD
ALTER
JOIN
What does the CREATE INDEX Statement do?
An index is created in a SQL database table with this SQL statement.
Changes made in the SQL database transaction are permanently saved using this SQL statement.
By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
The SQL database table's index is deleted using this SQL statement.