Which of the following is TRUE about SQL Concatenate?
It is also possible to combine more than two strings into one string.
Two columns of the table may be used to store the strings that are to be combined, or they may just be stored individually without being stored into the table.
When the concatenated strings are stored in separate columns of a table, they are stored in the column in which they were initially stored.
All of the above
Correct Answer :
D. All of the above
In case of SQL Concatenate:
a) It is also possible to combine more than two strings into one string.
b) Two columns of the table may be used to store the strings that are to be combined, or they may just be stored individually without being stored into the table.
c) When the concatenated strings are stored in separate columns of a table, they are stored in the column in which they were initially stored.
Related Questions
Using which clause, can SQL EXCEPT be used in single table?
TO
AS
WHERE
IN
Which statement is true about the No-SQL?
No-SQL follows ACID Model.
No-SQL does require object-relational mapping.
Dynamic schemas for unstructured data are used in No-SQL databases.
No-SQL databases are not preferable for storage of hierarchal data.
What does the DISTINCT Clause do?
Specify the columns of the table in this SQL clause to return distinct values.
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.
Changes made in the SQL database transaction are permanently saved using this SQL statement.
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
Rules that are needed to be followed in SET Operators in SQL are
All columns must be identical in number and order.
There must be compatibility between data types.
Both A and B
None 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
Which of the following is SQL Server String Data Type?
ntext
binary(n)
varbinary
All of the above
Using which SQL Comparison Operator can we find the data that matches our query?
SQL Not Equal Operator (!=)
SQL Equal Operator (=)
SQL Greater Than Operator (>)
SQL Less Than Operator (<)
Which function returns the largest value of the column?
MIN()
MAX()
LARGE()
AVG()
Command that comes under DCL is/are -
GRANT
REVOKE
Both A. and B.
None of the above
What is TRUE about UNION ALL Operator?
The results of both queries are combined with this operator.
After performing the UNION ALL operation, duplicate rows will not be removed.
Both A and B
None of the above
At which of the following stage does SQL Injection occurs?
When the user is asked to logout
When the user is asked to input password
When the user is asked to input captcha
When the user is asked to input username
Which of the following constraints are TRUE to be put in Password system?
One uppercase character must be included in the password.
An eight-character minimum password is required.
At least one symbol must appear in the password.
All of the above
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
The ____ size of the result is shown by Script Quota.
Minimum
Maximum
Average
None of the above
____ value is returned by the SQL Aggregate functions?
Single
Twice
NULL
Infinite
What does the ROLLBACK Statement do?
Specify the columns of the table in this SQL statement to return distinct values.
Changes made in the SQL database transaction are permanently saved using this SQL statement.
By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
An index is created in a SQL database table with this SQL statement.
In order to merge two or more strings, which string function is used?
CHAR
ALTER
CONCAT
MERGE
What is the full form of CTE in SQL?
Character Table Expressions
Character Table Evaluator
Common Table Evaluator
Common Table Expressions
When SELECT statements used to create Views contain ____ clauses, the views cannot be updated.
JOIN
HAVING
GROUP BY
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.
In order to join N tables, minimum number of join statements required is
N
N-1
N-2
N+1
What is Export Script by default?
Workspace_name_size/sql
Workspace_number_script/sql
Workspace_name_script/sql
Workspace_name_script/spl
In the script field, script is found by entering the
Script Name
Script Number
Script ID
Script Symbol
In the case of the ____ Independence Rule, It shouldn't make a difference what the user sees (application) if the logical structure changes.
Physical Data
Logical Data
Integrity
Distribution
You can also ____ the existing tables by using the UNIQUE constraint.
Change
Delete
Modify
Drop
In order to build a link between two tables, which key is used?
Primary
Foreign
Composite
Unique
The scalar functions operate on each record ____ in SQL.
Dependently
Independently
Interdependently
Intradependently
Which statement is used to select the database in Oracle?
USE
SELECT
RENAME
None of the above
What does the DESCRIBE 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.
By executing this SQL statement, all records in the SQL database will be deleted.
Specify the columns of the table in this SQL statement to return distinct values.
The data specified in this table or view is reported in this SQL statement.