To connect strings, which function is used
CONNECT
ADD
COMBINE
CONCAT
Correct Answer :
D. CONCAT
To connect strings, CONCAT function is used.
Related Questions
Which of the following is not MySQL String Data Type?
TEXT(Size)
TINYTEXT
MEDIUMTEXT
LARGETEXT
What does task list consist of in SQL Script?
Import
Show Quotas
Manage Results
All of the above
The SELECT TOP statement shows the limited number of:
Rows
Columns
Tables
None of the above
What is the symbol of Concatenation Operator?
|
||
//
\
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
Which of the following is TRUE about SQL Auto Increment?
It increments the unique number automatically.
It decrements the unique number automatically.
It keeps the unique number constant
None of the above
Which of the following is TRUE about the type of SQL Injection attack?
Install malicious program
Export valuable data
Get user login detail
All of the above
What is the difference between UNION & UNION ALL operators?
Combining the results of two select statements will be done using UNION whereas combined records from both queries are returned by UNION ALL operator.
Combining the results of two select statements will be done using UNION ALL whereas combined records from both queries are returned by UNION operator.
After performing the UNION operation, duplicate rows will not be removed whereas after performing the UNION ALL operation, duplicate rows will be removed.
None of the above
Which syntax is correct for RENAME DATABASE in SQL?
RENAME old_database_name TO new_database_name;
RENAME DATABASE old_database_name TO new_database_name;
ALTER old_database_name MODIFY NAME = new_database_name;
ALTER DATABASE old_database_name MODIFY NAME = new_database_name;
SQL indexes speed up the execution time of which statement(s)?
SELECT
WHERE
Both A and B
None of the above
Number of operands used by Unary Operator is?
1
2
3
4
Which of these are the types of operators?
Arithmetic
Comparison
Set
All of the above
In SQL, Like is a ____ operator.
Relational
Logical
Additional
Unique
Which of the following statement is false?
There is no difference between a lower case and upper case keyword in SQL.
It is easier to read SQL queries when the keywords are in lowercase.
An SQL statement's syntax is determined by its text line.
One or more SQL statements can be placed on a single line of text.
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
Which of the following statement is true?
SQL statements are used for most operations in a database.
Relational algebra and tuple relationship calculus are needed for SQL syntax.
All of the above
None of the above
Which of the following is/are TRUE about DDL command?
Our data is stored in a table that is described by the schema, thus DDL commands deal with the schema.
With the DDL commands, any structural changes can be made to the table, including creation, deletion, and alteration.
Both A. and B.
None of the above
The records and structure of a table may be removed or deleted from the database using which command?
REMOVE
DELETE
DROP
TRUNCATE
LIKE clause can be used with
% operator
_ operator
NOT operator
All of the above
In how many parts are the SQL functions are divided into?
1
2
3
4
Name of the data type categories are,
String Data types
Numeric Data types
Date and time Data types
All of the above
To get a record from one table, which is not present in another table, we can use the clause
CONCAT
COPY
EXCEPT
ALTER
Output returned by the Scalar functions is/are -
Single Value
Multiple Value
Two Values
None of the above
Select the function which is not the Scalar Function(s)?
UCASE()
LEN()
SUM()
NOW()
MINUS Operator displays the rows which are
Detected in the second query, absent in the first query, and there are no duplications.
Detected in the first query, absent in the second query, and there are no duplications.
Detected in the first query, absent in the second query, and there are duplications.
Detected in the second query, absent in the first query, and there are duplications.
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
SQL EXCEPT clause is supported in
MySQL
PostgreSQL
Both A and B
None 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 syntax is used to show all the databases?
USE DATABASES;
SELECT DATABASES;
SHOW DATABASES;
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