Which clause is used to combine rows from two or more tables based on a related column between them.

Structured Query Language

Aliases

Similar Questions

1.

This is used to give alias name to table or column while writing sql query

A.

AS

B.

ASIS

C.

AS IS

D.

ALIAS AS

2.

In a table, a column contains duplicate value, if you want to list all different value only, then which SQL clause is used?

A.

SQL DISTINCT

B.

SQL UNIQUE

C.

SQL BETWEEN

D.

SQL Exists

3.

To give a temporary name to a table, or a column in a table for more readability, what is used ?

A.

SQL Wildcards

B.

SQL aliases

C.

SQL LIKES

D.

SQL Comments

4.

What does below SQL statement describe?

SELECT CustomerName, Address + ‘, ‘ + City + ‘, ‘ + Country AS Address

FROM Customers;

A.

Alias named Address column will be created and under this Address, City and Country will be printed as combined statement.

B.

Alias named Address will be created for Country columns

C.

Alias named Address column will be created and under this all CustomerName, address, city and country will be printed as combined statement

D.

All above options are wrong

5.

Logical operators used in SQL are

A.

AND, OR , NOT

B.

&&, ||, !

C.

$,|,!

D.

None of the above

6.

To specify the number of records to return, which keyword is used

A.

FIRST

B.

TOP

C.

START

D.

ROW

7.

To search for a specified pattern in a column

A.

SQL MATCH

B.

SQL LIKE

C.

SQL PATTERN

D.

SQL SEARCH

8.

Which clause is used to combine rows from two or more tables based on a related column between them.

A.

SQL MATCH

B.

SQL JOIN

C.

SQL PATTERN

D.

NONE

9.

Which is called as a virtual table in SQL?

A.

INNER JOIN

B.

JOIN

C.

VIEW

D.

NONE