Which statement is not true about SQL?
Using SQL in relational databases is all about inserting, updating, and deleting data.
Sample data can also be described with the aid of this tool.
It helps develop relational database functions, events, and views.
A SQL user can also set restrictions and permissions for a table column, a view, and a stored procedure.
Correct Answer :
B. Sample data can also be described with the aid of this tool.
Structured data can also be described with the aid of this tool.
Related Questions
NULL means
ZERO
-1
1
Empty
It is possible to retrieve time in a more readable format, using which function?
TIME
TIME_FORM
TIME_FORMAT
TIME & DATE
Which of the following clause is optional in SQL SELECT Statement?
SELECT
FROM
HAVING
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
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
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])
In order to delete duplicate rows from the table, which keyword is used?
DELETE
DISTINCT
FROM
WHERE
ROUND function consists of ___ parameters?
One
Two
Three
Four
TINYTEXT can hold the maximum length of ___ characters?
254
255
256
257
Select the correct syntax for Savepoint.
Mysql > Transaction ini;
Mysql > &Savepoint;
Mysql > START Transaction;
Mysql > Savepoint ini;
In order to insert a row directly in the table, which command is used?
INSERT IN
INSERT INSIDE
INSERT UNDER
INSERT INTO
What is the full form of BLOB?
Binary Long Objects
Binary Least Objects
Binary Large Objects
Binary Large Orientation
A Key which uniquely identifies each row in the table is known as?
Primary Key
Unique Key
Composite Key
Foreign Key
What is the functionality of SQL COUNT?
It returns the no of record of table
It returns the no of record of database
It returns the no of record of row
It returns the no of record of column
Command that comes under DML is/are
ROLLBACK
GRANT
UPDATE
All of the above
Which of the following statement is TRUE about Primary Key?
Table integrity is not enforced by the primary key.
The data in a primary key is always multiple.
900 bytes is the maximum length of a primary key.
Null values are allowed in primary keys.
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
Which of the following are the types of the temp tables?
Local Temp
Global Temp
Both A) and B)
None of the above
Which of the following statement is TRUE about DISTINCT Clause?
Returns only Distinct values.
Only on the single column, it operates.
It can be used with the aggregates such as COUNT, AVG, etc.
All of the above
With export, you can ____ SQL Scripts from the SQL repositories in your workspace.
Export
Import
Save
Exchange
MINUS Operator displays the rows which are
Detected in the second query, absent in the first query, and there are no duplications.
Detected in the first query, absent in the second query, and there are no duplications.
Detected in the first query, absent in the second query, and there are duplications.
Detected in the second query, absent in the first query, and there are duplications.
SQL Like is NOT used with which of the following statement(s)?
DELETE
SELECT
UPDATE
ALTER
It is possible to use LIKE clauses with
Strings
Numbers
Both A. and B.
None of the above
The description in SQL Script, displays script in
One Line
Two Line
Three Line
Many Lines
SQL EXCEPT statement behaves similar to _____operator in mathematics.
Sum
Multiply
Minus
Divide
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
What is TRUE about DEFAULT constraint?
The value will first be checked for certain conditions before inserting it into the column when a DEFAULT constraint applies to a column in the table.
In the event of a DEFAULT constraint being applied to a table's column without a user specifying the value to be inserted when that constraint was applied, the default value that was specified when the constraint was applied will be put into that column.
An index can be created on the table using the DEFAULT constraint.
None 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.
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().
Which keyword is used in SQL Server to implement the auto increment?
UNIQUE
IDENTITY
INCREMENT
ADD