Select the Aggregate function(s) among the following.
AVG()
FIRST()
LAST()
All of the above
Correct Answer :
D. All of the above
AVG(), FIRST() and LAST() are all the aggregate functions.
Related Questions
What is the work of SELECT command?
Database objects such as tables, table views, and other objects can be deleted using this command.
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.
What is the clause to delete all rows from the table?
SQL DELETE ALL ROWS Table_Name;
SQL DELETE ROWS Table_Name;
DELETE FROM ALL ROWS Table_Name;
DELETE FROM Table_Name;
____ integrity is achieved by using a foreign key.
Referential Integrity
Domain Integrity
User-defined Integrity
Entity Integrity
In order to format, how the column should be displayed, which function is used?
FORM()
DISPLAY()
COL()
FORMAT()
Description allows the Script to load the
Owner of the script
Script name
Script Editor
All of the above
Primary keys can be contained in a table only ____?
Once
Twice
Thrice
None of the above
SQL indexes speed up the execution time of which statement(s)?
SELECT
WHERE
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
What is the work of DROP command?
Using this command, you can remove or erase recorded information from a database table.
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.
How MySQL determines which one to use, FLOAT or DOUBLE, using the p parameter?
If p comes between 0 to 25, data type becomes FLOAT(). If p comes between 26 to 54, data type becomes DOUBLE().
If p comes between 26 to 54, data type becomes FLOAT(). If p comes between 0 to 25, data type becomes DOUBLE().
If p comes between 25 to 53, data type becomes FLOAT(). If p comes between 0 to 24, data type becomes DOUBLE().
If p comes between 0 to 24, data type becomes FLOAT(). If p comes between 25 to 53, data type becomes DOUBLE().
Commands that comes under DDL is/are
CREATE
DROP
TRUNCATE
All of the above
What does the INSERT INTO Statement do?
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.
A new database will be created through this SQL statement.
In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
By executing this SQL statement, all records in the SQL database will be deleted.
What does COUNT() function returns?
Average value
Largest value
Smallest value
Number of rows
What does the following statement do?
Finds any values that start with a
Finds any values that start with a%
Finds any values that contains only two characters starting with a
All of the above
Which of the following is TRUE about Information Rule in the 12 Codd's Rules?
The primary key value, table name, and column name are characteristics that allow us to access the precise data (atomic value) logically from a relational database.
Null values are treated in database records according to this rule.
Database systems must update all views tables on a regular basis.
Databases contain a wide variety of information, and each row and column of each table must hold this information.
SET Operators are used to
Compile the results from two queries
Compile the results from three queries
Compile the results from four queries
Compile the results from five queries
Full form of DML is
Data Multiplication Language
Data Manipulation Language
Data Modify Language
Data Mapping Language
What does the UPDATE Statement do?
By deleting the stored data, this SQL statement deletes the database.
A new table in SQL is created using this SQL statement.
The stored data in the SQL database is changed or modified by this SQL statement.
Columns in the SQL database can be created, deleted, or modified with this SQL statement.
With export, you can ____ SQL Scripts from the SQL repositories in your workspace.
Export
Import
Save
Exchange
Choose the correct syntax of NOW function?
SELECT ()NOW;
NOW() SELECT;
SELECT NOW();
SELECT OWN();
Which of the following clause cannot be optional in SQL SELECT Statement?
WHERE
GROUP BY
ORDER BY
None of the above
Select the correct order of precedence among the following?
OR > NOT > + > **
NOT > OR > ** > +
** > + > OR > NOT
** > + > NOT > OR
Which of the following is TRUE about UNIQUE constraint?
In columns that are subject to the UNIQUE constraint, duplicate values are not allowed.
Unique values will always be present in the column containing the unique constraint.
A single table can have more than one unique constraint, since it can be applied to more than one column.
All of the above
What is the symbol of Concatenation Operator?
|
||
//
\
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
Unique Index is similar to
Primary Key
Foreign Key
Composite Key
Alternate Key
Which function returns the largest value of the column?
MIN()
MAX()
LARGE()
AVG()
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
In LIKE clause, to represent a single character, _____ is used.
-
_
!
&
To get the table's previous permanent status, use the ____ command.
Commit
Transaction
Rollback
None of the above