Combining the results of ___ select statements will be done using UNION.
One
Two
Three
Four
Correct Answer :
B. Two
Combining the results of two select statements will be done using UNION.
Related Questions
SQL EXCEPT returns the record from -
First SELECT Query
Second SELECT Query
Third SELECT Query
None of the above
Which statement is not true?
SQL is rational whereas No-SQL is non-rational.
SQL follows BASE Model whereas No-SQL follows ACID Model.
SQL database are vertically scalable whereas No-SQL database are horizontally scalable.
No-SQL databases are preferable to store hierarchical data in comparison SQL databases.
Command that comes under DML is/are
ROLLBACK
GRANT
UPDATE
All of the above
What is the difference between VARCHAR and VARCHAR2?
VARCHAR can store upto 4000 bytes and VARCHAR2 can store upto 8000 bytes.
VARCHAR can store upto 2000 bytes and VARCHAR2 can store upto 4000 bytes.
Both VARCHAR and VARCHAR2 are similar but use of VARCHAR2 is mostly recommended.
There is no similarity between VARCHAR and VARCHAR2.
Which of the following is TRUE about Savepoint command?
A transaction is marked in a table by this TCL command.
Imagine that you are making a long table, and you want to roll back only to a specific point in the table. You can do this with the savepoint.
In order to rollback part of a table rather than the entire table, a savepoint is useful.
All of the above
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 TRUE about UPDATE in SQL VIEW?
Views that depend on a single table can be updated.
An update of a view created from more than one table will not be allowed by SQL.
There should be no NULL values in the fields of view.
All of the above
What is SQL CREATE Table used for?
To Update table
To Create table
To Delete table
None of the above
Types of SQL Commands are
DDL
DML
DCL
All of the above
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
To delete table definition and all data from the table, which statement is used?
DELETE
DROP
ALTER
None of the above
Which of the following clause cannot be optional in SQL SELECT Statement?
WHERE
GROUP BY
ORDER BY
None of the above
Primary keys can be contained in a table only ____?
Once
Twice
Thrice
None of the above
In order to sort the records according to the columns, which clause is used?
HAVING
GROUP BY
ORDER BY
None of the above
In order to join N tables, minimum number of join statements required is
N
N-1
N-2
N+1
What is the functionality of UCASE function?
To change the case of the string to lowercase characters.
To change the case of the string to uppercase characters.
To change the case of the string to numeric characters.
To change the case of the string to symbolic characters.
Which clause is needed in CTE SQL syntax?
FOR
AS
WITH
TO
What is the symbol of Concatenation Operator?
|
||
//
\
BETWEEN Operator returns the TRUE value if the column value is
<=Value1 & >=Value2
<=Value1 & <=Value2
>=Value1 & >=Value2
>=Value1 & <=Value2
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.
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
The description in SQL Script, displays script in
One Line
Two Line
Three Line
Many Lines
Which of the following is TRUE about Pattern Matching in SQL?
In SQL, pattern matching is performed with LIKE clauses.
An SQL query usually begins with a LIKE clause before a WHERE clause
Using the LIKE clause in an SQL query, we compare the pattern in the query with the pattern present in a table.
All of the above
An SQL ____ is a virtual table, whose contents are based on the SQL statement's results.
Concatenate
Virtual
View
None of the above
Select the statement which is TRUE?
In a table, there could be any number of rows and any number of columns.
In a table, there could be any number of rows and specified number of columns.
In a table, there could be any number of columns and specified number of rows.
In a table, there could be specified number of rows and specified number of columns.
It is possible to use LIKE clauses with
Strings
Numbers
Both A. and B.
None of the above
Which of the following is the feature(s) of SQL Auto Increment?
In some cases you may not have any unique identifying characteristics in data; therefore, it makes sense to create a Primary Key.
Explicitly initializing and modifying the auto-increment value is possible at any time.
Record identifiers can easily be created that are unique to each record.
All of the above
What does the following statement do?
Finds any values that start with a
Finds any values that start with a%
Finds any values that start with a and are at least 2 characters in length
All of the above
What is TRUE about SAVEPOINT?
Following the completion of a transaction, it must be executed to save all the operations performed in the transaction.
A transaction can be rolled back to its last saved state.
A specific part of a transaction can be given a name
None of the above
Following the completion of a transaction, it must be executed to save all the operations performed in the transaction. Here we are talking about which command?
REVOKE
COMMIT
ROLLBACK
SAVE