SQL indexes speed up the execution time of which statement(s)?
SELECT
WHERE
Both A and B
None of the above
Correct Answer :
C. Both A and B
SQL Indexes speed up the execution time of SELECT and WHERE statements.
Related Questions
Which of the following clause is optional in SQL SELECT Statement?
SELECT
FROM
HAVING
None of the above
In DBMS, table is known as _____ and row is known as _____.
Relation, Tuple
Tuple, Tuple
Tuple, Relation
Relation, Relation
When the table is truncated:
Table structure is dropped
Integrity constraints are dropped
Relationship is dropped
None of the above
How many temp tables are there?
1
2
3
4
A single unit of work for all commands executed consecutively is known as-
Transaction
Commit
Rollback
Control
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 syntax is used to show all the databases?
USE DATABASES;
SELECT DATABASES;
SHOW DATABASES;
None of the above
Name of the operators in SET Operators is
UNION
INTERSECT
MINUS
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
Which function is used to extract substrings from the column of the table
ROUND()
MID()
FORMAT()
NOW()
Full form of DCL is -
Data Control Language
Data Commit Language
Data Common Language
Data Concatenate Language
Which of the following statement is TRUE about Primary Key?
Table integrity is not enforced by the primary key.
The data in a primary key is always multiple.
900 bytes is the maximum length of a primary key.
Null values are allowed in primary keys.
Which of the following statement is correct for SQL Multiplication Operator?
SELECT Operand1+Operand2;
SELECT Operand1*Operand2;
SELECT Operand1**Operand2;
SELECT Operand1
Which of the following are the types of the temp tables?
Local Temp
Global Temp
Both A) and B)
None of the above
The character(s) which are used independently or in conjunction with SQL Like Operator:
%
_
Both A. and B.
None of the above
In which clause does the BETWEEN operator is used?
IF
AS
WHERE
EXCEPT
What can be the maximum size of char(n) in SQL Server String Data Type?
7000
8000
9000
10000
In order to format, how the column should be displayed, which function is used?
FORM()
DISPLAY()
COL()
FORMAT()
What is the work of DROP command?
Using this command, you can remove or erase recorded information from a database table.
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.
How MySQL determines which one to use, FLOAT or DOUBLE, using the p parameter?
If p comes between 0 to 25, data type becomes FLOAT(). If p comes between 26 to 54, data type becomes DOUBLE().
If p comes between 26 to 54, data type becomes FLOAT(). If p comes between 0 to 25, data type becomes DOUBLE().
If p comes between 25 to 53, data type becomes FLOAT(). If p comes between 0 to 24, data type becomes DOUBLE().
If p comes between 0 to 24, data type becomes FLOAT(). If p comes between 25 to 53, data type becomes DOUBLE().
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
Which function is used to obtain the month from the entire data stored in a table's column?
DATE
TIME
MONTH
DATE & TIME
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.
C in CRUD Operator means
To add or insert data
To retrieve or fetch data
To update the data
To delete the data
The table records can be retrieved using which command?
RETRIEVE
SELECT
CREATE
ALTER
Select the Aggregate function(s) among the following.
AVG()
FIRST()
LAST()
All of the above
Unique Index is similar to
Primary Key
Foreign Key
Composite Key
Alternate Key
In SQL, Like is a ____ operator.
Relational
Logical
Additional
Unique
Using the ___ statement, a database can be renamed.
SQL CREATE DATABASE
SQL RENAME DATABASE
SQL DROP DATABASE
SQL SELECT DATABASE
SET Operators are used to
Compile the results from two queries
Compile the results from three queries
Compile the results from four queries
Compile the results from five queries