Which of the following statement is TRUE for SQL Additional Operator?
SELECT operand1-operand2;
SELECT operand1*operand2;
SELECT operand1+operand2;
SELECT operand1>operand2;
Correct Answer :
C. SELECT operand1+operand2;
SELECT operand1+operand2; is the correct statement for SQL Additional Operator.
Related Questions
To get the table's previous permanent status, use the ____ command.
Commit
Transaction
Rollback
None of the above
SQL ___ can be used to delete or drop existing databases in a SQL schema.
CREATE DATABASE
RENAME DATABASE
DROP DATABASE
SELECT DATABASE
In case of ____Rule, the primary key value, table name, and column name are characteristics that allow us to access the precise data (atomic value) logically from a relational database.
Systematic Treatment of Null Values
Guaranteed Access
View Updating
Physical Data Independence
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
An SQL ____ is a virtual table, whose contents are based on the SQL statement's results.
Concatenate
Virtual
View
None 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.
The Web SQL API is supported by
Opera
Google Chrome
Android Browsers
All of the above
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 DBMS, table is known as _____ and row is known as _____.
Relation, Tuple
Tuple, Tuple
Tuple, Relation
Relation, Relation
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
____ and ____constraints form the core of the PRIMARY KEY constraint.
NOT NULL , CHECK
NOT NULL , DEFAULT
NOT NULL , FOREIGN KEY
NOT NULL , UNIQUE
Select the statement which is TRUE?
In case a transaction is rolled back, the data allied with table variable also get rolled back.
In case a transaction is rolled back, the data allied with table variable does not roll back.
In case a transaction is not rolled back, the data allied with table variable get rolled back.
None of the above.
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.
Which of the following statement is TRUE?
A DATABASE name can be renamed.
A TABLE name can be renamed.
Both A and B
None of the above
What will be the output of the below SQL statement?
2021-10-06 00:00:00.000
2021-10-06
2021 OCT 06
06-10-2021
Which one of the syntaxes given below is of Binary Operator?
Operator SQL _Operand
Operand2 SQL _Operator Operand1
Operand1 SQL _Operator Operand1
Operand1 SQL _Operator Operand2
ORDER BY clause comes ____ the EXCEPT clause in SQL statement?
Before
After
Flexible to before or after
None of the above
Select the Aggregate function(s) among the following.
AVG()
FIRST()
LAST()
All of the above
Command that comes under DCL is/are -
GRANT
REVOKE
Both A. and B.
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
Which of the following clause cannot be optional in SQL SELECT Statement?
WHERE
GROUP BY
ORDER BY
None of the above
Which of the following clause is optional in SQL SELECT Statement?
SELECT
FROM
HAVING
None of the above
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 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;
Which of the following is not MySQL String Data Type?
TEXT(Size)
TINYTEXT
MEDIUMTEXT
LARGETEXT
From the set of results, in order to remove the duplicate columns, ____ Clause is used.
DUPLICATE
DISTINCT
REMOVE
DROP
What does the INSERT INTO Statement do?
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.
A new database will be created through this SQL statement.
In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
By executing this SQL statement, all records in the SQL database will be deleted.
When the table is dropped:
Table structure is dropped
Integrity constraints are dropped
Relationship is dropped
All of the above
Select the correct statement about SQL Scripts?
At the run time, the SQL*Plus commands are ignored.
SQL Scripts and SQL Commands in the SQL Scripts have no interaction.
Through the SQL Script editor, SQL Commands are cut and pasted.
All of the above
BETWEEN Operator returns the TRUE value if the column value is
<=Value1 & >=Value2
<=Value1 & <=Value2
>=Value1 & >=Value2
>=Value1 & <=Value2