The numerical values of two ___ of the ___ table can be easily subtracted using SQL Subtraction Operator.
Rows, same
Columns, same
Rows, different
Columns, different
Correct Answer :
B. Columns, same
The numerical values of two columns of the same table can be easily subtracted using SQL Subtraction Operator.
Related Questions
Which statement is TRUE about the ORDER BY Clause?
In order to return the rows in a specific order, ORDER BY Clause is used.
In order to group the rows, ORDER BY Clause is used.
In order to select the defined groups, ORDER BY Clause is used.
None of the above
What is the default length of any data type in the CAST function?
10
20
30
40
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 following statement(s) is/are TRUE about DCL?
The DCL commands in SQL allow us to control which users have access to the data stored in SQL tables.
There will be certain privileges that each user has; consequently, the data can be accessed by them.
The DCL commands in SQL allow us to grant privileges to a user on the SQL database and its table(s), or revoke privileges that have already been granted.
All of the above
In order to create the Index, we need to use which command?
ALTER
UPDATE
CREATE
ADD
What does AVG() function returns?
First value of the column
Last value of the column
Sum of rows of the table
Average value of the column
Full form of DDL is
Data Describe Language
Definition Data Language
Data Definition Language
Data Distinct Language
Which statement is TRUE about the GROUP BY Clause?
In order to retrieve rows, GROUP BY Clause is used.
In order to group the rows that share the same property, GROUP BY Clause is used.
In order to select the defined groups, GROUP BY Clause is used.
In order to return the rows, GROUP BY Clause is used.
To connect strings, which function is used
CONNECT
ADD
COMBINE
CONCAT
In order to format, how the column should be displayed, which function is used?
FORM()
DISPLAY()
COL()
FORMAT()
Savepoint command is used with _____ command.
Commit
Transaction
Rollback
None of the above
What is TRUE about the Active/Dynamic Online Catalog based on the relational model in the 12 Codd's Rules?
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.
Null values are treated in database records according to this rule.
Database dictionaries represent the complete logic of all descriptive data, which must be stored online.
None of the above
SQL INSERT is used to insert a
Single or Multiple record
Single or Multiple database
Single or Multiple table
None of the above
What is the difference between MIN and MAX function?
MIN function is used to show the minimum data and MAX function is used to show the maximum data.
MIN function is used to show the maximum data and MAX function is used to show the minimum data.
Both of the above
None of the above
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
Select the correct type(s) of SQL Comments.
Inline Comments
Single Line Comments
Multi-line Comments
All of the above
Select the correct order of precedence among the following?
OR > NOT > + > **
NOT > OR > ** > +
** > + > OR > NOT
** > + > NOT > OR
Commands that comes under DDL is/are
CREATE
DROP
TRUNCATE
All of the above
SQL became the standard of?
ASCII
ANSI
ISO
Both B and C
In SQL, which statement can help in changing the name of the table?
RENAME
ALTER
Both A) and B)
None of the above
SQL Like is NOT used with which of the following statement(s)?
DELETE
SELECT
UPDATE
ALTER
Which of the following is TRUE about UNIQUE constraint?
In columns that are subject to the UNIQUE constraint, duplicate values are not allowed.
Unique values will always be present in the column containing the unique constraint.
A single table can have more than one unique constraint, since it can be applied to more than one column.
All of the above
In order to manage or store the data in the database, WEB SQL Database is used which is a
Web site
Web page
Web browser
None of the above
SQL Operator can be,
Unary
Binary
Both A and B
None of the above
You can also ____ the existing tables by using the UNIQUE constraint.
Change
Delete
Modify
Drop
BETWEEN operator is used with which SQL Statements
SELECT
DELETE
INSERT
All of the above
SET Operators are used to
Compile the results from two queries
Compile the results from three queries
Compile the results from four queries
Compile the results from five queries
To rename the Index, we need to use which command?
RENAME
ALTER
UPDATE
ADD
NULL means
ZERO
-1
1
Empty
What is the full form of CTE in SQL?
Character Table Expressions
Character Table Evaluator
Common Table Evaluator
Common Table Expressions