adplus-dvertising
frame-decoration

Question

The concatenation operator in SQL which can concatenate two strings is denoted as

a.

double quotation marks

b.

double vertical bar

c.

single vertical bar

d.

triple vertical bar

Posted under SQL DBMS

Answer: (b).double vertical bar

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. The concatenation operator in SQL which can concatenate two strings is denoted as

Similar Questions

Discover Related MCQs

Q. In the statement DECIMAL () to specify numeric data type, the number of decimal digits is called

Q. Considering the change in schema statement in SQL, the command which is used to delete records of table and leave the definition of table for later use is classified as

Q. In standard query language, the rows and columns are called respectively

Q. If the length of bit string is multiple of 4 then it can be specified with the notation called

Q. The referential triggered action clause in Standard Query Language is attached to constraint called

Q. The types of bit-string data type are

Q. If the concatenation operator is applied to two strings such as [ 'ABCD' || 'wxyz' ] then the resultant string will be

Q. In SQL, the constraints, constructs, views, domains and tables are classified as its

Q. The clause used in CREATE TABLE statement in SQL to specify secondary keys is called

Q. The possible actions of altering the tables in Standard Query Language includes

Q. The type of bit strings which is preceded by 'B' and is placed between single quotes is classified as

Q. In CREATE TABLE SQL command, each table must have atleast column/s

Q. Which of the following information does an SQL DDL not specify?

Q. Which of the following data types does the SQL standard not support?

Q. Which command is used to create a new relation in SQL

Q. If a1, a2, a3 are attributes in a relation and S is another relation, which of the following is an incorrect specification of an integrity constraint?

Q. What is the syntax to load data into the database? (Consider D as the database and a, b, c as data)

Q. Which of the following commands do we use to delete a relation (R) from a database?

Q. Which of the following commands do we use to delete all the tuples from a relation (R)?

Q. Choose the correct command to delete an attribute A from a relation R