Select the function which is not the Scalar Function(s)?
UCASE()
LEN()
SUM()
NOW()
Correct Answer :
C. SUM()
SUM() is aggregate function and not the Scalar function.
Related Questions
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.
Full form of DDL is
Data Describe Language
Definition Data Language
Data Definition Language
Data Distinct Language
What does the DELETE Statement do?
A new table in SQL is created using this SQL statement.
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.
By executing this SQL statement, you remove the table and all the information that it contains, including the structure, views, permissions, and triggers.
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
Select the statement which is TRUE?
In a table, there could be any number of rows and any number of columns.
In a table, there could be any number of rows and specified number of columns.
In a table, there could be any number of columns and specified number of rows.
In a table, there could be specified number of rows and specified number of columns.
Which of the following statement is TRUE for SQL Additional Operator?
SELECT operand1-operand2;
SELECT operand1*operand2;
SELECT operand1+operand2;
SELECT operand1>operand2;
Select the correct syntax of SELECT TOP clause?
SELECT TOP name
SELECT TOP column
SELECT TOP FROM
SELECT TOP Number
In order to convert the expression from one to another data type, which SQL Function is used?
CONVERT
CHANGE
CAST
TRANSIT
Numbers of operand used by Binary Operators are?
1
2
3
4
In order to execute a query in Web SQL, which function is used?
open()
translate()
transaction()
execute()
Which statement is TRUE about the ORDER BY Clause?
In order to return the rows in a specific order, ORDER BY Clause is used.
In order to group the rows, ORDER BY Clause is used.
In order to select the defined groups, ORDER BY Clause is used.
None of the above
What does the following statement do?
Finds any values that end with a
Finds any values whose second character is a
Find any values that contains only two characters ending with a
Mysql > Savepoint ini;
Which of the statement is true?
The precedence-low operators are evaluated last in SQL.
The precedence-high operators are evaluated first in SQL.
Both A and B
None of the above
Full form of DCL is -
Data Control Language
Data Commit Language
Data Common Language
Data Concatenate Language
What does this SQL database language design to?
Maintain the data in hierarchal database management systems.
Maintain the data in relational database management systems.
Maintain the data in network database management systems.
Maintain the data in object-oriented database management systems.
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.
Which one if these is used to put the same value in all the rows?
Group by unique column
Group by single column
Group by one column
Group by same value
Combining the results of ___ select statements will be done using UNION.
One
Two
Three
Four
SQL Indexes slows the execution time of which statement(s)?
UPDATE
INSERT
SELECT
Both A and B
The Web SQL API is supported by
Opera
Google Chrome
Android Browsers
All of the above
SQL Like is NOT used with which of the following statement(s)?
DELETE
SELECT
UPDATE
ALTER
Select the correct syntax for Savepoint.
Mysql > Transaction ini;
Mysql > &Savepoint;
Mysql > START Transaction;
Mysql > Savepoint ini;
What does the ROLLBACK Statement do?
Specify the columns of the table in this SQL statement to return distinct values.
Changes made in the SQL database transaction are permanently saved using this SQL statement.
By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
An index is created in a SQL database table with this SQL statement.
Which of the following is TRUE about SQL Concatenate?
It is also possible to combine more than two strings into one string.
Two columns of the table may be used to store the strings that are to be combined, or they may just be stored individually without being stored into the table.
When the concatenated strings are stored in separate columns of a table, they are stored in the column in which they were initially stored.
All of the above
What is TRUE about SQL EXCEPT clause?
The result is purged of duplicates
Duplicate records are not removed
Only one column can be compared by a clause
None of the above
In order to create the Index, we need to use which command?
ALTER
UPDATE
CREATE
ADD
SQL ___ can be used to delete or drop existing databases in a SQL schema.
CREATE DATABASE
RENAME DATABASE
DROP DATABASE
SELECT DATABASE
In case of ____ data, recursive CTE is used?
Round
Hierarchal
Linear
None of the above
Which of the following is SQL Server Date and Time Data Type?
timestamp
sql_variant
real
text
Which of the following keyword is used to delete the Join?
DELETE
ON
WHERE
All of the above