Which function returns the largest value of the column?
MIN()
MAX()
LARGE()
AVG()
Correct Answer :
B. MAX()
MAX() function returns the largest value of the column.
Related Questions
In DBMS, table is known as _____ and row is known as _____.
Relation, Tuple
Tuple, Tuple
Tuple, Relation
Relation, Relation
In order to build a link between two tables, which key is used?
Primary
Foreign
Composite
Unique
What is meant by 'SQL is an interactive language'?
Learning and understanding SQL is easy
It can also be used for communicating with the database.
In a few seconds, complex queries can also be answered using this language.
All of the above
Select the Aggregate function(s) among the following.
AVG()
FIRST()
LAST()
All of the above
Which of the following statement is FALSE?
A Primary Key cannot be NULL
A Foreign Key cannot be NULL
A Primary Key cannot be Duplicate
A Foreign Key can be Duplicate
To rename the Index, we need to use which command?
RENAME
ALTER
UPDATE
ADD
Using a WHERE clause in a SQL query is used to specify SQL reserved words and characters, known as ____?
Operators
Data Types
Numbers
Syntax
What is the difference between nvarchar and ntext?
nvarchar is fixed and ntext is variable.
nvarchar is variable and ntext is fixed.
nvarchar can be of the maximum size upto 4000 characters and ntext can be of the maximum size upto 2GB of the text data.
nvarchar can be of the maximum size upto 4000 characters and ntext can be of the maximum size upto 1GB of the text data.
Foreign key is a field in a table that is _______ key in another table?
Primary
Unique
Composite
None of the above
SQL EXCEPT returns the record from -
First SELECT Query
Second SELECT Query
Third SELECT Query
None of the above
It is possible to retrieve time in a more readable format, using which function?
TIME
TIME_FORM
TIME_FORMAT
TIME & DATE
SQL CREATE DATABASE is used to,
Create a table
Create a database
Create a column
Create a row
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
LIKE clause can be used with
% operator
_ operator
NOT operator
All of the above
Which function combines the two different columns?
ADD
MERGE
CONCAT
None of the above
Which one is not the OPTIONAL Clause in SELECT statement?
WHERE
ORDER BY
HAVE
HAVING
What does the TRUNCATE TABLE Statement do?
In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
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.
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.
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
What does BOOL mean in MySQL Numeric Data Types?
A Boolean value is specified by this variable. When a value is nonzero, it is considered false, and zero is considered true.
A Boolean value is specified by this variable. When a value is nonzero, it is considered true, and zero is considered false.
A Boolean value is specified by this variable. When a value is nonzero, it is considered true, and zero is also considered true.
A Boolean value is specified by this variable. When a value is nonzero, it is considered false, and zero is also considered false.
C in CRUD Operator means
To add or insert data
To retrieve or fetch data
To update the data
To delete the data
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
In LIKE clause, to represent a zero, a character, or a number of characters ___ is used.
/
_
*
%
What is the syntax of SQL CAST Function?
CAST (expression AS [data type])
CAST (expression IN [data type])
CAST (expression TO [data type])
CAST (expression FOR [data type])
What is the keyword of the Ascending and Descending?
ASCE, DESC
ASC, DES
ASCE, DES
ASC, DESC
What is TRUE about UPDATE in SQL VIEW?
Views that depend on a single table can be updated.
An update of a view created from more than one table will not be allowed by SQL.
There should be no NULL values in the fields of view.
All of the above
What is the meaning of Null Values in Systematic Treatment of Null Values in the 12 Codd's Rules?
No value in cell
Inappropriate Information
Unknown data
All of the above
Full form of TCL is -
Transaction Common Language
Transaction Commit Language
Transaction Concatenate Language
Transaction Control Language
In SQL SELECT COUNT, one needs to specify the
Column Name
Row Name
Table Name
None of the above
Which syntax is correct for RENAME DATABASE in SQL?
RENAME old_database_name TO new_database_name;
RENAME DATABASE old_database_name TO new_database_name;
ALTER old_database_name MODIFY NAME = new_database_name;
ALTER DATABASE old_database_name MODIFY NAME = new_database_name;
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.