In order to delete duplicate rows from the table, which keyword is used?
DELETE
DISTINCT
FROM
WHERE
Correct Answer :
B. DISTINCT
DISTINCT keyword is used to delete duplicate rows from the table.
Related Questions
SQL Like is NOT used with which of the following statement(s)?
DELETE
SELECT
UPDATE
ALTER
Select the function which is not the Scalar Function(s)?
UCASE()
LEN()
SUM()
NOW()
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.
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
Which clause is needed in CTE SQL syntax?
FOR
AS
WITH
TO
Using the SQL first() function, one can return the ____ value of the selected column.
First
Second
Third
Last
SQL CREATE DATABASE is used to,
Create a table
Create a database
Create a column
Create a row
Host-based IDS can be used to monitor
Web server logs
When something weird occurs
Both A) and B)
None of the above
Which statement is true about the No-SQL?
No-SQL follows ACID Model.
No-SQL does require object-relational mapping.
Dynamic schemas for unstructured data are used in No-SQL databases.
No-SQL databases are not preferable for storage of hierarchal data.
Which of the following is/are TRUE about DDL command?
Our data is stored in a table that is described by the schema, thus DDL commands deal with the schema.
With the DDL commands, any structural changes can be made to the table, including creation, deletion, and alteration.
Both A. and B.
None of the above
Which of the following is SQL Server Numeric Data Type?
image
nchar
money
cursor
Which of the following is supported in Comprehensive Data SubLanguage Rule in the 12 Codd's Rules?
Data Definition
View Definition
Data Manipulation
All of the above
Following the completion of a transaction, it must be executed to save all the operations performed in the transaction. Here we are talking about which command?
REVOKE
COMMIT
ROLLBACK
SAVE
Which statement is correct to remove an Index from MySQL Database?
DROP INDEX Index_Name;
ALTER TABLE Table_Name DROP INDEX Index_Name;
DROP INDEX Index_Name ON Table_Name;
DROP INDEX Table_Name.Index_Name;
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
What does SQL stand for?
SQL stands for Sample Query Language
SQL stands for Structured Query List
SQL stands for Structured Query Language
SQL stands for Sample Query List
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;
The character(s) which are used independently or in conjunction with SQL Like Operator:
%
_
Both A. and B.
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.
What does COUNT() function returns?
Average value
Largest value
Smallest value
Number of rows
____ and ____constraints form the core of the PRIMARY KEY constraint.
NOT NULL , CHECK
NOT NULL , DEFAULT
NOT NULL , FOREIGN KEY
NOT NULL , UNIQUE
Command that comes under DCL is/are -
GRANT
REVOKE
Both A. and B.
None of the above
Which of the following statement is TRUE?
Web API is the part of HTML5
Web API is not the part of HTML5
Web API is the part of HTML
Web API is the part of XHTML
The ____ size of the result is shown by Script Quota.
Minimum
Maximum
Average
None of the above
What is the symbol of Concatenation Operator?
|
||
//
\
Comments whose starting and ending lines are different are known as
Inline Comments
Multi-line Comments
Single Line Comments
Varied line Comments
Select the correct syntax for Multi-line Comments.
//*Line1
Line2*//
/*Line1
Line2/*
The Web SQL API is supported by
Opera
Google Chrome
Android Browsers
All of the above
SQL Operator can be,
Unary
Binary
Both A and B
None of the above
Which syntax is correct for RENAME DATABASE in SQL?
RENAME old_database_name TO new_database_name;
RENAME DATABASE old_database_name TO new_database_name;
ALTER old_database_name MODIFY NAME = new_database_name;
ALTER DATABASE old_database_name MODIFY NAME = new_database_name;