Which of the following are not MySQL Date and Time Data Type?
DATE
TIME(fsp)
YEAR
None of the above
Correct Answer :
D. None of the above
MySQL Date and Time Data Types are DATE, TIME(fsp), and YEAR.
Related Questions
Which keyword is used in SQL Server to implement the auto increment?
UNIQUE
IDENTITY
INCREMENT
ADD
Select the correct order of precedence among the following?
OR > NOT > + > **
NOT > OR > ** > +
** > + > OR > NOT
** > + > NOT > OR
SQL has the disadvantage of?
SQL is cheap.
SQL interface is simple.
Both A and B.
None of the above.
In order to convert the expression from one to another data type, which SQL Function is used?
CONVERT
CHANGE
CAST
TRANSIT
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 difference between nchar and nvarchar?
nchar is fixed and nvarchar is variable.
nchar is variable and nvarchar is fixed.
nchar has the maximum size of 4000 characters and nvarchar has the maximum size of 8000 characters.
nchar has the maximum size of 800 characters and nvarchar has the maximum size of 4000 characters.
____ and ____constraints form the core of the PRIMARY KEY constraint.
NOT NULL , CHECK
NOT NULL , DEFAULT
NOT NULL , FOREIGN KEY
NOT NULL , UNIQUE
ROUND function consists of ___ parameters?
One
Two
Three
Four
To connect strings, which function is used
CONNECT
ADD
COMBINE
CONCAT
Description allows the Script to load the
Owner of the script
Script name
Script Editor
All of the above
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
In the script field, script is found by entering the
Script Name
Script Number
Script ID
Script Symbol
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 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.
Using which SQL Comparison Operator can we find the data that matches our query?
SQL Not Equal Operator (!=)
SQL Equal Operator (=)
SQL Greater Than Operator (>)
SQL Less Than Operator (<)
What is the difference between DELETE and TRUNCATE statements?
DELETE statement free up the space kept in check by the table whereas TRUNCATE statement does not free up the space kept in check by the table.
DELETE statement does not free up the space kept in check by the table whereas TRUNCATE statement free up the space kept in check by the table.
DELETE statement only deletes rows from the table whereas TRUNCATE statement can only delete columns from the table.
DELETE statement only deletes columns from the table whereas TRUNCATE statement can only delete rows from the table.
Select the correct syntax for Savepoint.
Mysql > Transaction ini;
Mysql > &Savepoint;
Mysql > START Transaction;
Mysql > Savepoint ini;
To get a record from one table, which is not present in another table, we can use the clause
CONCAT
COPY
EXCEPT
ALTER
Select the correct statement.
With the DDL commands, any structural changes can be made to the table, including creation, deletion, and alteration.
With the DML commands, any structural changes can be made to the table, including creation, deletion, and alteration.
With the DCL commands, any structural changes can be made to the table, including creation, deletion, and alteration.
With the TCL commands, any structural changes can be made to the table, including creation, deletion, and alteration.
In case to prevent the endless loop in CTE, ____ is added.
MAXLINEAR
MAXROUND
MAXRECURSION
None of the above
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
Using the DELETE Query from the CRUD Operator, we can delete
Only one row
All the rows
Only two rows
None of the above
Which of the following is not an SQL Statement?
SELECT Statement
UPDATE Statement
TRUNCATE TABLE Statement
FROM Statement
With which of the following statement(s) can the SQL sub queries be used?
SELECT
UPDATE
INSERT
All of the above
Which of the following is TRUE about Pattern Matching in SQL?
In SQL, pattern matching is performed with LIKE clauses.
An SQL query usually begins with a LIKE clause before a WHERE clause
Using the LIKE clause in an SQL query, we compare the pattern in the query with the pattern present in a table.
All of the above
Which function returns the correct date and time?
DATE()
NOW()
TIME()
DATETIME()
When the table is truncated:
Table structure is dropped
Integrity constraints are dropped
Relationship is dropped
None of the above
A single unit of work for all commands executed consecutively is known as-
Transaction
Commit
Rollback
Control
In order to remove an index, we need to use which command?
REMOVE
DELETE
DROP
DEL
What is the default length of any data type in the CAST function?
10
20
30
40