Which statement is used to select the database in SQL?
SELECT
USE
ALTER
CREATE
Correct Answer :
B. USE
USE statement is used to select the database in SQL.
Related Questions
In order to remove a primary key constraint, which clause is used?
DELETE
DROP
ALTER
REMOVE
Numbers of operand used by Binary Operators are?
1
2
3
4
MINUS Operator displays the rows which are
Detected in the second query, absent in the first query, and there are no duplications.
Detected in the first query, absent in the second query, and there are no duplications.
Detected in the first query, absent in the second query, and there are duplications.
Detected in the second query, absent in the first query, and there are duplications.
Which of the following are the types of the temp tables?
Local Temp
Global Temp
Both A) and B)
None of the above
What does the DISTINCT Clause do?
Specify the columns of the table in this SQL clause to return distinct values.
By executing this SQL statement, all records in the SQL database will be deleted.
The data specified in this table or view is reported in this SQL statement.
Changes made in the SQL database transaction are permanently saved using this SQL statement.
With which of the following statement(s) can the SQL sub queries be used?
SELECT
UPDATE
INSERT
All of the above
Which one is not the OPTIONAL Clause in SELECT statement?
WHERE
ORDER BY
HAVE
HAVING
Which of the following statement is TRUE for SQL Additional Operator?
SELECT operand1-operand2;
SELECT operand1*operand2;
SELECT operand1+operand2;
SELECT operand1>operand2;
In case the CTE is wrong, it goes into
Infinite Loop
Null State
False State
True State
Commands that comes under DDL is/are
CREATE
DROP
TRUNCATE
All of the above
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 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
Which one of the syntaxes given below is of Binary Operator?
Operator SQL _Operand
Operand2 SQL _Operator Operand1
Operand1 SQL _Operator Operand1
Operand1 SQL _Operator Operand2
SQL Indexes slows the execution time of which statement(s)?
UPDATE
INSERT
SELECT
Both A and B
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
Select the function which is not the Scalar Function(s)?
UCASE()
LEN()
SUM()
NOW()
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 order to build a link between two tables, which key is used?
Primary
Foreign
Composite
Unique
What is meant by Partial Database Control?
Business rules are hidden.
Users or professionals can't have the full control over the database.
Both A and B
None of the above
Which of the following is not the SQL Comparison Operator?
SQL Equal Operator (=)
SQL Less Than Operator (<)
SQL Greater Than Operator (>)
All of the above
Name of the control in SQL Script
Script
Owner
Opinion
All of the above
A single unit of work for all commands executed consecutively is known as-
Transaction
Commit
Rollback
Control
The scalar functions operate on each record ____ in SQL.
Dependently
Independently
Interdependently
Intradependently
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
What does COUNT() function returns?
Average value
Largest value
Smallest value
Number of rows
SQL BETWEEN operators can be used to select the
Dates
Texts
Numbers
All of the above
By constraining a SQL statement, we limit the ____ according to certain conditions or restrictions.
Row
Column
Table
Database
The Web SQL API is supported by
Opera
Google Chrome
Android Browsers
All of the above
In order to sort the records according to the columns, which clause is used?
HAVING
GROUP BY
ORDER BY
None of the above
The numerical values of two ___ of the ___ table can be easily subtracted using SQL Subtraction Operator.
Rows, same
Columns, same
Rows, different
Columns, different