LIKE clause can be used with
% operator
_ operator
NOT operator
All of the above
Correct Answer :
D. All of the above
LIKE clause can be used with % , _ and NOT operators.
Related Questions
SQL ___ can be used to delete or drop existing databases in a SQL schema.
CREATE DATABASE
RENAME DATABASE
DROP DATABASE
SELECT DATABASE
In CRUD Operator, U is an acronym of
Upper
Unique
Update
Uppercase
If multiple columns are used as Primary Key, it is known as
Unique
Composite
Foreign
None of the above
Savepoint command is used with _____ command.
Commit
Transaction
Rollback
None of the above
Combining the results of ___ select statements will be done using UNION.
One
Two
Three
Four
The SQL Modulus Operator returns the,
Quotient
Percentage
Sum
Reminder
Scripts ____ from various workspaces can be imported through import.
Exported
Imported
Changed
Saved
Which syntax is correct for RENAME DATABASE in MySQL?
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;
What is the full form of GUID?
Guided Unique Identifier
Guided Unique Interpreter
Globally Unique Identifier
Globally Unique Interpreter
____ value is returned by the SQL Aggregate functions?
Single
Twice
NULL
Infinite
What is meant by 'SQL is an interactive language'?
Learning and understanding SQL is easy
It can also be used for communicating with the database.
In a few seconds, complex queries can also be answered using this language.
All of the above
SQL Operator can be,
Unary
Binary
Both A and B
None of the above
Which one is not the OPTIONAL Clause in SELECT statement?
WHERE
ORDER BY
HAVE
HAVING
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
All other columns other than the column which is termed as Primary Key, are known as
Unique Keys
Alternate Keys
Composite Keys
None of the above
Which statement is TRUE about the ORDER BY Clause?
In order to return the rows in a specific order, ORDER BY Clause is used.
In order to group the rows, ORDER BY Clause is used.
In order to select the defined groups, ORDER BY Clause is used.
None of the above
Using which clause, can SQL EXCEPT be used in single table?
TO
AS
WHERE
IN
A Key which uniquely identifies each row in the table is known as?
Primary Key
Unique Key
Composite Key
Foreign Key
What is the keyword of the Ascending and Descending?
ASCE, DESC
ASC, DES
ASCE, DES
ASC, DESC
SQL Division operator divides the operand on the ____ side by the operand on the ____ side.
Left, Left
Right, Left
Left, Right
Right, Right
Command that comes under DCL is/are -
GRANT
REVOKE
Both A. and B.
None of the above
In order to delete the database, which keyword is used?
DROP
DELETE
ALTER
None of the above
SQL BETWEEN operators include
Starting Value
In Between Value
Ending Value
All of the above
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 is the type of SQL Injection attack?
It inserts the data
It updates the data
It deletes the data
All 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
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
Name of the data type categories are,
String Data types
Numeric Data types
Date and time Data types
All of the above
____ are the columns for the retrieval purpose.
Tables
WHERE Conditions
Expressions
None of the above
Which statement is true about the SQL?
SQL databases are vertically scalable.
SQL follows BASE Model.
SQL database cannot handle complex queries.
SQL database does not require object-relational mapping.