SQL EXCEPT statement behaves similar to _____operator in mathematics.
Sum
Multiply
Minus
Divide
Correct Answer :
C. Minus
SQL EXCEPT statement behaves similar to Minus operator in mathematics.
Related Questions
What can be the maximum size of char(n) in SQL Server String Data Type?
7000
8000
9000
10000
In order to update one table using another table and join condition, which statement is used.
SQL UPDATE INTO
SQL UPDATE JOIN
SQL JOIN
SQL JOIN UPDATE
What is meant by Partial Database Control?
Business rules are hidden.
Users or professionals can't have the full control over the database.
Both A and B
None of the above
We can use literal in the CONCAT function. What does literal refer to?
Number
Character
Date
All 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;
Which of the following statement is TRUE?
At run time, temporary tables can be created.
Temporary table can do similar operations to normal table.
Both A) and B)
None of the above
In more readable form, you can retrieve the date values, using ______ function?
DATE
DATE_FORM
DATE_FORMAT
DATE_VALUE
____ are the columns for the retrieval purpose.
Tables
WHERE Conditions
Expressions
None of the above
Which function is used to extract substrings from the column of the table
ROUND()
MID()
FORMAT()
NOW()
Which of the following statement is TRUE about DISTINCT Clause?
It cannot ignore the NULL values
It can ignore the NULL values
Its query can return multiple values
None of the above
Which of the following is TRUE about Intrusion Detection System?
Intrusion Detection System is Network-based
Intrusion Detection System is Host-based
Both A) and B)
None of the above
What does the ALTER TABLE Statement do?
By deleting the stored data, this SQL statement deletes the database.
Columns in the SQL database can be created, deleted, or modified with this SQL statement.
A new table in SQL is created using this SQL statement.
The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.
Which of the following statement is TRUE?
Web API is the part of HTML5
Web API is not the part of HTML5
Web API is the part of HTML
Web API is the part of XHTML
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
Which of the statement is true?
The precedence-low operators are evaluated last in SQL.
The precedence-high operators are evaluated first in SQL.
Both A and B
None of the above
Using TIME_FORMAT() function, time can be retrieved in
12-hour format
24-hour format
Both A. and B.
None of the above
In order to join N tables, minimum number of join statements required is
N
N-1
N-2
N+1
In order to start the transaction, the command used is
Mysql > START COMMIT;
Mysql > START TRANSACTION;
Mysql > START ROLLBACK;
None of the above
SQL BETWEEN is a ______ operator.
Relational
Logical
Arithmetic
Assignment
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
In how many parts are the SQL functions are divided into?
1
2
3
4
What does SQL is used to perform operations on?
Update Records
Insert Records
Both A and B
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.
Number of operands used by Unary Operator is?
1
2
3
4
In CRUD Operator, U is an acronym of
Upper
Unique
Update
Uppercase
The Web SQL API is supported by
Opera
Google Chrome
Android Browsers
All of the above
Difference between GRAND & REVOKE command is/are?
The GRANT command can be used to grant a user access to databases and tables whereas The REVOKE command can be used to revoke all access privileges already assigned to the user.
The REVOKE command can be used to grant a user access to databases and tables whereas The GRANT command can be used to revoke all access privileges already assigned to the user.
A transaction can be rolled back to its last saved state.
None of the above
To get the table's previous permanent status, use the ____ command.
Commit
Transaction
Rollback
None of the above
When the table is dropped:
Table structure is dropped
Integrity constraints are dropped
Relationship is dropped
All of the above
Select the function which is not the Scalar Function(s)?
UCASE()
LEN()
SUM()
NOW()