Which of the following type of Join returns all rows from the left table even if no matches are found in the right table? - HSQLDB Quiz

HSQLDB - Quiz(MCQ)

Which of the following type of Join returns all rows from the left table even if no matches are found in the right table?

A)

RIGHT JOIN

B)

LEFT JOIN

C)

INNER JOIN

D)

All of the above

Correct Answer : LEFT JOIN

Explanation : LEFT JOIN returns all rows from the left table even if no matches are found in the right table.

Recently Updated in HSQLDB Questions

____ triggers are only permitted if the trigger is defined on a VIEW?

A)

AFTER

B)

BEFORE

C)

INSTEAD OF

D)

None of the above

Correct Answer : INSTEAD OF

Explanation : INSTEAD OF triggers are only permitted if the trigger is defined on a VIEW.

Access to schema objects is easily controlled by the ____ objects

A)

Role

B)

User

C)

Both (A) and (B)

D)

None of the above

Correct Answer : Both (A) and (B)

Explanation : Access to schema objects is easily controlled by the ROLE and USER objects.

Does HyperSQL supports log4J and JDK logging?

A)

Yes

B)

No

C)

Can Not Say

D)

None of the above

Correct Answer : Yes

Explanation : HyperSQL supports log4J and JDK logging.

New Technologies MCQ's

Machine Learning

Artificial Intelligence

Ethical Hacking

Microsoft Azure

Cloud Computing

Quantum Computing

Neural Networks

Virtual Reality

Augmented Reality

Advertisement