What does UCASE() function do?
Converts database field to uppercase
Converts database field to lowercase
Returns the length of the text field
Returns the current date and time
Correct Answer :
A. Converts database field to uppercase
UCASE() function converts database field to uppercase.
Related Questions
In which clause does the BETWEEN operator is used?
IF
AS
WHERE
EXCEPT
What does the SELECT Statement do?
Data is read from the SQL database by this statement and displayed to the database user.
The stored data in the SQL database is changed or modified by this SQL statement.
By deleting the stored data, this SQL statement deletes the database.
A new table in SQL is created using this SQL statement.
In case of ____ data, recursive CTE is used?
Round
Hierarchal
Linear
None of the above
Which function is used to extract substrings from the column of the table
ROUND()
MID()
FORMAT()
NOW()
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.
Which of the following states the correct situation in which Indexes should not be used in SQL?
When the table is small, it is possible to avoid using SQL indexes.
Updates need to be made frequently to the table.
When there are a lot of NULL values in a column, indexed should not be used.
All of the above
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
What will be the output of the below SQL statement?
25
26
24
20
Using a WHERE clause in a SQL query is used to specify SQL reserved words and characters, known as ____?
Operators
Data Types
Numbers
Syntax
Which statement is used to select the database in SQL?
SELECT
USE
ALTER
CREATE
Name of the data type categories are,
String Data types
Numeric Data types
Date and time Data types
All of the above
Combining the results of ___ select statements will be done using UNION.
One
Two
Three
Four
What is the difference between DELETE and TRUNCATE statements?
DELETE statement free up the space kept in check by the table whereas TRUNCATE statement does not free up the space kept in check by the table.
DELETE statement does not free up the space kept in check by the table whereas TRUNCATE statement free up the space kept in check by the table.
DELETE statement only deletes rows from the table whereas TRUNCATE statement can only delete columns from the table.
DELETE statement only deletes columns from the table whereas TRUNCATE statement can only delete rows from the table.
What does the following statement do?
Finds any values that start with or
Finds any value that contains only four characters and second, third characters are 'o', 'r'
Finds any values that have or in any position
None of the above
Local Temp Variable is used with which sign?
?
@
#
&
When SELECT statements used to create Views contain ____ clauses, the views cannot be updated.
JOIN
HAVING
GROUP BY
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
What is the symbol of Concatenation Operator?
|
||
//
\
SQL BETWEEN is a ______ operator.
Relational
Logical
Arithmetic
Assignment
SQL INSERT is used to insert a
Single or Multiple record
Single or Multiple database
Single or Multiple table
None of the above
By constraining a SQL statement, we limit the ____ according to certain conditions or restrictions.
Row
Column
Table
Database
To get a record from one table, which is not present in another table, we can use the clause
CONCAT
COPY
EXCEPT
ALTER
The ____ size of the result is shown by Script Quota.
Minimum
Maximum
Average
None of the above
Command that comes under DML is/are
ROLLBACK
GRANT
UPDATE
All of the above
In order to prevent multiple records from being returned by the sub query, ____ must be used before the sub query.
Many Value Operators
Multiple Value Operators
Single Value Operator
Unique Value Operator
A single unit of work for all commands executed consecutively is known as-
Transaction
Commit
Rollback
Control
In the database table, data types describe the kind of ___ that it can contain.
Table
Data
Number
None of the above
GROUP BY clause is placed before which clause in SQL?
HAVING
WHERE
ORDER BY
FROM
To get the table's previous permanent status, use the ____ command.
Commit
Transaction
Rollback
None of the above
In the case of the ____ Independence Rule, It shouldn't make a difference what the user sees (application) if the logical structure changes.
Physical Data
Logical Data
Integrity
Distribution