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().
Correct Answer :
D. If p comes between 0 to 24, data type becomes FLOAT(). If p comes between 25 to 53, data type becomes DOUBLE().
MySQL determines to use FLOAT or DOUBLE using the p parameter. If p comes between 0 to 24, the data type becomes FLOAT(). If p comes between 25 to 53, the data type becomes DOUBLE().
Related Questions
Which of the following statement is correct?
Comparison Operator has higher precedence than Conjuction Operator.
Identity Operator has higher precedence than Multiplication Operator.
Both A and B
None of the above
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
Select the correct statement which will return all the rows from the Table and then also deletes the Table_Add table?
SELECT * FROM Table; DROP TABLE Table_Add
SELECT * WHERE Table; DROP TABLE Table_Add
SELECT * FROM Table; DELETE TABLE Table_Add
SELECT * WHERE Table; DELETE TABLE Table_Add
The SQL Modulus Operator returns the,
Quotient
Percentage
Sum
Reminder
Select the correct syntax of SELECT TOP clause?
SELECT TOP name
SELECT TOP column
SELECT TOP FROM
SELECT TOP Number
Description allows the Script to load the
Owner of the script
Script name
Script Editor
All of the above
What is the difference between UNION & UNION ALL operators?
Combining the results of two select statements will be done using UNION whereas combined records from both queries are returned by UNION ALL operator.
Combining the results of two select statements will be done using UNION ALL whereas combined records from both queries are returned by UNION operator.
After performing the UNION operation, duplicate rows will not be removed whereas after performing the UNION ALL operation, duplicate rows will be removed.
None of the above
When the table is dropped:
Table structure is dropped
Integrity constraints are dropped
Relationship is dropped
All of the above
Which command will remove the records from the table, but not affect the structure of the table?
REMOVE
DELETE
DROP
TRUNCATE
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
Select the function which is not the Scalar Function(s)?
UCASE()
LEN()
SUM()
NOW()
Which statement is true about the SQL?
SQL databases are vertically scalable.
SQL follows BASE Model.
SQL database cannot handle complex queries.
SQL database does not require object-relational mapping.
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
What does the COMMIT Statement do?
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.
Specify the columns of the table in this SQL statement to return distinct values.
By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
SQL indexes speed up the execution time of which statement(s)?
SELECT
WHERE
Both A and B
None of the above
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.
Temporary variables use ____ resources than table variables.
More
Less
Equal
None of the above
Select the correct statement.
TRUNCATE TABLE is faster than DELETE TABLE statement.
TRUNCATE TABLE uses fewer resources than DELETE TABLE statement.
Both A) and B)
None of the above
The table records can be retrieved using which command?
RETRIEVE
SELECT
CREATE
ALTER
Select the correct rule of SQL EXCEPT.
There must be the same number of columns in each table and the same order in every select statement.
It is desirable that the columns have similar or compatible data types.
Both SELECT statements must have the same fields in their respective columns.
All of the above
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 NOT the SQL Arithmetic Operator?
Addition
Subtraction
Unary
Modulus
The character(s) which are used independently or in conjunction with SQL Like Operator:
%
_
Both A. and B.
None of the above
What is the difference between HAVING and WHERE clause?
HAVING clause is used in column operation whereas WHERE clause is used in row operation.
HAVING clause is post-filter whereas WHERE clause is pre-filter.
HAVING clause filters the groups whereas WHERE clauses filter the single record of the table.
All of the above
____ integrity is achieved by using a foreign key.
Referential Integrity
Domain Integrity
User-defined Integrity
Entity Integrity
____ and ____constraints form the core of the PRIMARY KEY constraint.
NOT NULL , CHECK
NOT NULL , DEFAULT
NOT NULL , FOREIGN KEY
NOT NULL , UNIQUE
To delete table definition and all data from the table, which statement is used?
DELETE
DROP
ALTER
None of the above
What will be the output of the below SQL statement?
25
26
25.65
25.00
Which of the following is not MySQL String Data Type?
TEXT(Size)
TINYTEXT
MEDIUMTEXT
LARGETEXT
With which of the following statement(s) can the SQL sub queries be used?
SELECT
UPDATE
INSERT
All of the above