ROUND function consists of ___ parameters?
One
Two
Three
Four
Correct Answer :
B. Two
The ROUND() function consists of Two Parameters and is used with the SELECT query in order to print the formatted value.
Related Questions
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
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.
SQL ___ can be used to delete or drop existing databases in a SQL schema.
CREATE DATABASE
RENAME DATABASE
DROP DATABASE
SELECT DATABASE
Read in CRUD Operator means
To retrieve data
To fetch data
Both A. and B.
None of the above
In SQL, which statement can help in changing the name of the table?
RENAME
ALTER
Both A) and B)
None of the above
____ integrity is achieved by using a foreign key.
Referential Integrity
Domain Integrity
User-defined Integrity
Entity Integrity
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.
Number of operands used by Unary Operator is?
1
2
3
4
Which syntax is used to show all the databases?
USE DATABASES;
SELECT DATABASES;
SHOW DATABASES;
None of the above
In order to build a link between two tables, which key is used?
Primary
Foreign
Composite
Unique
What is the similarity between CLOB and NCLOB Oracle Large Object Data Types?
Both CLOB and NCLOB are used for multibyte national character set data.
Both CLOB and NCLOB can range upto 2^32-1 bytes or 4 GB.
Both CLOB and NCLOB can range upto 2^32-1 bytes or 8GB.
Both CLOB and NCLOB are used for singlebyte and multibyte national character set data.
In CRUD Operator, U is an acronym of
Upper
Unique
Update
Uppercase
At which of the following stage does SQL Injection occurs?
When the user is asked to logout
When the user is asked to input password
When the user is asked to input captcha
When the user is asked to input username
Which of the following is supported in Comprehensive Data SubLanguage Rule in the 12 Codd's Rules?
Data Definition
View Definition
Data Manipulation
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
Which of the following is not an SQL Statement?
SELECT Statement
UPDATE Statement
TRUNCATE TABLE Statement
FROM Statement
Which of the following statement is TRUE about SQL Injection?
SQL Injection is an Object Penetration Technique
SQL Injection is a Function Penetration Technique
SQL Injection is a Code Penetration Technique
SQL Injection is a Database Penetration Technique
In SQL SELECT COUNT, one needs to specify the
Column Name
Row Name
Table Name
None of the above
ORDER BY clause comes ____ the EXCEPT clause in SQL statement?
Before
After
Flexible to before or after
None of the above
Bit is an integer that can be
0
1
Null
All of the above
What is the work of DELETE command?
A single or multiple rows can be accessed using this command from one or more tables of a database. Using the WHERE clause with this command is also possible.
Database data can be updated or changed using this command.
Database objects such as tables, table views, and other objects can be deleted using this command.
Using this command, you can remove or erase recorded information from a database table.
Which of the following is TRUE about Intrusion Detection System?
Intrusion Detection System is Network-based
Intrusion Detection System is Host-based
Both A) and B)
None of the above
GROUP BY clause is placed before which clause in SQL?
HAVING
WHERE
ORDER BY
FROM
Unique Index is similar to
Primary Key
Foreign Key
Composite Key
Alternate Key
____ are the columns for the retrieval purpose.
Tables
WHERE Conditions
Expressions
None of the above
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
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 function returns the largest value of the column?
MIN()
MAX()
LARGE()
AVG()
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
Which statement is TRUE about the HAVING Clause?
In order to group the rows, HAVING Clause is used.
In order to return the rows, HAVING Clause is used.
In order to select the defined groups by the GROUP BY Clause, HAVING Clause is used.
None of the above