Crowdly

limits the column data that are returned.

can be used as a horizontal filter.

limits the row data are returned.

Which of the following clause allows us to extract data in a range?

BETWEEN

FIND IN

Which of the following query depicts the correct SELECT statement in MySQL ?

SELECT col1, col2;

SELECT * FROM DataFlair;

SELECT # FROM DataFlair;

SELECT FROM DataFlair;

How many Primary keys can be created on a table?

infinity

Which of the following query finds employees with an experience of more than 5?

Select * From DataFlair where experience<=5;

Select * From DataFlair;

Select * From DataFlair where experience>5;

Select * From DataFlair where experience>=5;

Which of the following is not true about SQL joins?

A full outer join returns results of an inner join as well as the results of a left and right join.

None of the above.

A left or right outer join returns the results of the inner join as well as the unmatched rows in the left or right table respectively.

An inner join is a join of two tables returning only matching rows.

What is the full form of SQL?

Structuring Query Language

Structured Query Language

Structural Query Language

Structured Question Language

еволюціонування характерів персонажів

Творчість Бертольта Брехта репрезентує літературу…

Характерною ознакою «епічного театру» Бертольта Брехта є…

вплив на інтелект глядача

створення ілюзії життєподібності

емоційний вплив на глядача