Which of the following is not MySQL Numeric Data Type?
BIT(Size)
CHAR(Size)
INTEGER(Size)
INT(Size)
Correct Answer :
B. CHAR(Size)
MySQL Numeric Data Types are BIT(Size), INT(Size), and INTEGER(Size).
Related Questions
A SELECT statement is intersected to use it as a join, but it only returns the records that are ________ between both statements.
Distinct
Common
Shared
Both B and C
____ are the columns for the retrieval purpose.
Tables
WHERE Conditions
Expressions
None of the above
LIKE clause can be used with
% operator
_ operator
NOT operator
All of the above
What is TRUE about SQL EXCEPT clause?
The result is purged of duplicates
Duplicate records are not removed
Only one column can be compared by a clause
None of the above
What does the CREATE INDEX Statement do?
An index is created in a SQL database table with this SQL statement.
Changes made in the SQL database transaction are permanently saved using this SQL statement.
By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
The SQL database table's index is deleted using this SQL statement.
If multiple columns are used as Primary Key, it is known as
Unique
Composite
Foreign
None of the above
What is the default length of any data type in the CAST function?
10
20
30
40
In SQL, which statement can help in changing the name of the table?
RENAME
ALTER
Both A) and B)
None of the above
When SELECT statements used to create Views contain ____ clauses, the views cannot be updated.
JOIN
HAVING
GROUP BY
All of the above
In SQL SELECT COUNT, one needs to specify the
Column Name
Row Name
Table Name
None of the above
Which statement is correct to remove an Index from MySQL Database?
DROP INDEX Index_Name;
ALTER TABLE Table_Name DROP INDEX Index_Name;
DROP INDEX Index_Name ON Table_Name;
DROP INDEX Table_Name.Index_Name;
SQL Like is NOT used with which of the following statement(s)?
DELETE
SELECT
UPDATE
ALTER
Which of the following is SQL Server Numeric Data Type?
image
nchar
money
cursor
In order to assign a random name to a column or table, which SQL SELECT Clause is used?
FROM
WHERE
HAVING
AS
Which function is used to extract substrings from the column of the table
ROUND()
MID()
FORMAT()
NOW()
Which of the following is among the 12 Codd's Rules?
View Updating Rule
Relational Level Operation Rule
Distribution Independence Rule
None of the above
Which of the following is not MySQL Numeric Data Type?
BIT(Size)
CHAR(Size)
INTEGER(Size)
INT(Size)
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
Commands that come under TCL is/are -
COMMIT
ROLLBACK
SAVEPOINT
All of the above
The records and structure of a table may be removed or deleted from the database using which command?
REMOVE
DELETE
DROP
TRUNCATE
Which of the following statement is TRUE for SQL Additional Operator?
SELECT operand1-operand2;
SELECT operand1*operand2;
SELECT operand1+operand2;
SELECT operand1>operand2;
In the script field, script is found by entering the
Script Name
Script Number
Script ID
Script Symbol
Which of the following statement is true?
SQL statements are used for most operations in a database.
Relational algebra and tuple relationship calculus are needed for SQL syntax.
All of the above
None of the above
In LIKE clause, to represent a zero, a character, or a number of characters ___ is used.
/
_
*
%
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 of the following is TRUE about TCL?
Transactions can be saved to the database and rolled back with the help of TCL commands in SQL.
There will be certain privileges that each user has; consequently, the data can be accessed by them using TCL.
Our data is stored in a table that is described by the schema, thus TCL commands deal with the schema.
SQL TCL commands can be used to perform any kind of retrieval or manipulation of the data present in SQL tables.
Select the correct type(s) of SQL Comments.
Inline Comments
Single Line Comments
Multi-line Comments
All of the above
In order to remove a primary key constraint, which clause is used?
DELETE
DROP
ALTER
REMOVE
Select the correct syntax for Multi-line Comments.
//*Line1
Line2*//
/*Line1
Line2/*
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;