Which of the following is a SQL Logical Operator?
SQL ALL Operator
SQL OR Operator
SQL LIKE Operator
All of the above
Correct Answer :
D. All of the above
SQL ALL, SQL OR and SQL LIKE are all SQL Logical Operators.
Related Questions
In order to remove a primary key constraint, which clause is used?
DELETE
DROP
ALTER
REMOVE
In LIKE clause, to represent a single character, _____ is used.
-
_
!
&
In DBMS, table is known as _____ and row is known as _____.
Relation, Tuple
Tuple, Tuple
Tuple, Relation
Relation, Relation
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.
Which statement is TRUE about the HAVING Clause?
In order to group the rows, HAVING Clause is used.
In order to return the rows, HAVING Clause is used.
In order to select the defined groups by the GROUP BY Clause, HAVING Clause is used.
None of the above
In order to delete duplicate rows from the table, which keyword is used?
DELETE
DISTINCT
FROM
WHERE
A Sub query is an SQL expression that is placed ____ another SQL statement.
Before
After
Inside
Outside
Which function returns the correct date and time?
DATE()
NOW()
TIME()
DATETIME()
Which of the following statement(s) is/are TRUE about DCL?
The DCL commands in SQL allow us to control which users have access to the data stored in SQL tables.
There will be certain privileges that each user has; consequently, the data can be accessed by them.
The DCL commands in SQL allow us to grant privileges to a user on the SQL database and its table(s), or revoke privileges that have already been granted.
All of the above
In order to start the transaction, the command used is
Mysql > START COMMIT;
Mysql > START TRANSACTION;
Mysql > START ROLLBACK;
None of the above
Which of the following is not MySQL String Data Type?
TEXT(Size)
TINYTEXT
MEDIUMTEXT
LARGETEXT
What does the following statement do?
Finds any values that start with a
Finds any values that start with a%
Finds any values that contains only two characters starting with a
All of the above
SQL CREATE DATABASE is used to,
Create a table
Create a database
Create a column
Create a row
Which statement is not true?
SQL is rational whereas No-SQL is non-rational.
SQL follows BASE Model whereas No-SQL follows ACID Model.
SQL database are vertically scalable whereas No-SQL database are horizontally scalable.
No-SQL databases are preferable to store hierarchical data in comparison SQL databases.
Which statement is not true about SQL?
Using SQL in relational databases is all about inserting, updating, and deleting data.
Sample data can also be described with the aid of this tool.
It helps develop relational database functions, events, and views.
A SQL user can also set restrictions and permissions for a table column, a view, and a stored procedure.
In more readable form, you can retrieve the date values, using ______ function?
DATE
DATE_FORM
DATE_FORMAT
DATE_VALUE
What is the default length of any data type in the CAST function?
10
20
30
40
Which of the following is NOT the SQL Arithmetic Operator?
Addition
Subtraction
Unary
Modulus
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 of the following is SQL Server Date and Time Data Type?
timestamp
sql_variant
real
text
Which of the following is TRUE about UNIQUE constraint?
In columns that are subject to the UNIQUE constraint, duplicate values are not allowed.
Unique values will always be present in the column containing the unique constraint.
A single table can have more than one unique constraint, since it can be applied to more than one column.
All of the above
In the script field, script is found by entering the
Script Name
Script Number
Script ID
Script Symbol
The description in SQL Script, displays script in
One Line
Two Line
Three Line
Many Lines
In SQL SELECT COUNT, one needs to specify the
Column Name
Row Name
Table Name
None of the above
When the table is truncated:
Table structure is dropped
Integrity constraints are dropped
Relationship is dropped
None of the above
For one table, there can be ____unique key constraint(s).
1
NULL
Many
None of the above
What is TRUE about UNION ALL Operator?
The results of both queries are combined with this operator.
After performing the UNION ALL operation, duplicate rows will not be removed.
Both A and B
None of the above
Name of the control in SQL Script
Script
Owner
Opinion
All of the above
Command that comes under DCL is/are -
GRANT
REVOKE
Both A. and B.
None of the above
Which statement is used to select the database in SQL?
SELECT
USE
ALTER
CREATE