What is the functionality of UCASE function?
To change the case of the string to lowercase characters.
To change the case of the string to uppercase characters.
To change the case of the string to numeric characters.
To change the case of the string to symbolic characters.
Correct Answer :
B. To change the case of the string to uppercase characters.
UCASE function is used to change the case of the string to uppercase characters.
Related Questions
What does the CREATE TABLE Statement do?
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.
Columns in the SQL database can be created, deleted, or modified with this SQL statement.
Which of the following is SQL Server Date and Time Data Type?
timestamp
sql_variant
real
text
Which statement is TRUE about the GROUP BY Clause?
In order to retrieve rows, GROUP BY Clause is used.
In order to group the rows that share the same property, GROUP BY Clause is used.
In order to select the defined groups, GROUP BY Clause is used.
In order to return the rows, GROUP BY Clause is used.
You can also ____ the existing tables by using the UNIQUE constraint.
Change
Delete
Modify
Drop
When an expression includes ___ SQL operator(s), the sequence in which they are evaluated is known as the SQL operator's precedence.
0
1
Multiple
NULL
In CRUD Operator, U is an acronym of
Upper
Unique
Update
Uppercase
An SQL ____ is a virtual table, whose contents are based on the SQL statement's results.
Concatenate
Virtual
View
None of the above
Which clause is used to retrieve a unique element from the table?
SELECT UNIQUE
SELECT DISTINCT
Both A) and B)
None of the above
What is the work of INSERT command?
Inserting records or data into the database tables is accomplished with this command. In addition to inserting records in single rows, we can insert records in multiple rows as well.
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.
Whenever a sub query appears in SQL, it is enclosed within ____ and placed to the ____ of the SQL operators.
Brackets, Left
Brackets, Right
Parenthesis, Left
Parenthesis, Right
Which of the following is not MySQL Numeric Data Type?
BIT(Size)
CHAR(Size)
INTEGER(Size)
INT(Size)
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
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
What will be the output of the below SQL statement?
2021-10-06 00:00:00.000
2021-10-06
2021 OCT 06
06-10-2021
In DBMS, table is known as _____ and row is known as _____.
Relation, Tuple
Tuple, Tuple
Tuple, Relation
Relation, Relation
In the script field, script is found by entering the
Script Name
Script Number
Script ID
Script Symbol
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.
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.
In the case of ____ Independence Rule, Physical independence of data to access the database is a requirement for a database or an application.
Physical Data
Logical Data
Integrity
Distribution
Which keyword is used in SQL Server to implement the auto increment?
UNIQUE
IDENTITY
INCREMENT
ADD
SQL BETWEEN operators include
Starting Value
In Between Value
Ending Value
All of the above
In order to execute a query in Web SQL, which function is used?
open()
translate()
transaction()
execute()
C in CRUD Operator means
To add or insert data
To retrieve or fetch data
To update the data
To delete the data
A Key which uniquely identifies each row in the table is known as?
Primary Key
Unique Key
Composite Key
Foreign Key
A Sub query is an SQL expression that is placed ____ another SQL statement.
Before
After
Inside
Outside
Global Temp Variable is used with which sign?
###
####
#
##
In order to manage or store the data in the database, WEB SQL Database is used which is a
Web site
Web page
Web browser
None of the above
____ and ____constraints form the core of the PRIMARY KEY constraint.
NOT NULL , CHECK
NOT NULL , DEFAULT
NOT NULL , FOREIGN KEY
NOT NULL , UNIQUE
Using the SQL last() function, one can return the ______ value of the selected column.
First
Second
Third
Last
What is Export Script by default?
Workspace_name_size/sql
Workspace_number_script/sql
Workspace_name_script/sql
Workspace_name_script/spl