In order to convert the expression from one to another data type, which SQL Function is used?
CONVERT
CHANGE
CAST
TRANSIT
Correct Answer :
C. CAST
In order to convert the expression from one to another data type, SQL CAST Function is used.
Related Questions
What is TRUE about NOT IN clause?
The result is purged of duplicates
Duplicate records are not removed
Performs column-by-column comparisons
None of the above
Select the correct order of precedence among the following?
OR > NOT > + > **
NOT > OR > ** > +
** > + > OR > NOT
** > + > NOT > OR
What does the DROP DATABASE Statement do?
The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.
In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
A new database will be created through this SQL statement.
In this SQL statement, the data or records are inserted into an existing database table. One query statement can insert multiple records simultaneously using this statement.
TRUNCATE TABLE requires:
WHERE clause
HAVING clause
Both a and b
None of the above
In order to join N tables, minimum number of join statements required is
N
N-1
N-2
N+1
In order to merge two or more strings, which string function is used?
CHAR
ALTER
CONCAT
MERGE
From the set of results, in order to remove the duplicate columns, ____ Clause is used.
DUPLICATE
DISTINCT
REMOVE
DROP
What does task list consist of in SQL Script?
Import
Show Quotas
Manage Results
All of the above
Which of the following clause cannot be optional in SQL SELECT Statement?
WHERE
GROUP BY
ORDER BY
None of the above
Which of the following statement is correct for SQL Multiplication Operator?
SELECT Operand1+Operand2;
SELECT Operand1*Operand2;
SELECT Operand1**Operand2;
SELECT Operand1
In case of ____ data, recursive CTE is used?
Round
Hierarchal
Linear
None of the above
In order to build a link between two tables, which key is used?
Primary
Foreign
Composite
Unique
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.
SQL EXCEPT clause is supported in
MySQL
PostgreSQL
Both A and B
None of the above
Numbers of operand used by Binary Operators are?
1
2
3
4
SELECT INTO statement -
Select the content from a table.
Rename the content in a table.
Copy the content from one table into another existing table.
None of the above
SQL Division operator divides the operand on the ____ side by the operand on the ____ side.
Left, Left
Right, Left
Left, Right
Right, Right
You can also ____ the existing tables by using the UNIQUE constraint.
Change
Delete
Modify
Drop
Which of the following is SQL Server Date and Time Data Type?
timestamp
sql_variant
real
text
We can create View in SQL using
CREATE statement
CREATE VIEW statement
VIEW CREATE statement
SQL VIEW statement
What does AVG() function returns?
First value of the column
Last value of the column
Sum of rows of the table
Average value of the column
Name of the data type categories are,
String Data types
Numeric Data types
Date and time Data types
All of the above
Which of the following statement is FALSE?
A Primary Key cannot be NULL
A Foreign Key cannot be NULL
A Primary Key cannot be Duplicate
A Foreign Key can be Duplicate
Select the correct type(s) of SQL Comments.
Inline Comments
Single Line Comments
Multi-line Comments
All of the above
Which keyword is used in SQL Server to implement the auto increment?
UNIQUE
IDENTITY
INCREMENT
ADD
Select the correct statement.
DDL consist of 4 commands
DCL consist of 2 commands
TCL consist of 5 commands
DML consist of 3 commands
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 does the following statement do?
Finds any values that start with a and ends with o
Finds any values whose first character is a and third character is o
Both A. and B.
None of the above
Using TIME_FORMAT() function, time can be retrieved in
12-hour format
24-hour format
Both A. and B.
None of the above
Name of the operators in SET Operators is
UNION
INTERSECT
MINUS
All of the above