Which of the following query is correct for using comparison operators?

PostgreSQL - Quiz(MCQ)

SELECT name, course_name FROM student WHERE age>50 and <80;

SELECT name, course_name FROM student WHERE age>50 and WHERE age<80;

SELECT name, course_name FROM student WHERE age>50 and age<80;

None of the above

Correct Answer : SELECT name, course_name FROM student WHERE age>50 and age<80;

Recently Updated in PostgreSQL Questions

What is one mistake network administrators often make from a security perspective?

Using domain admin privileged accounts for day-to-day non-admin use.

Enforcing password security on users who do not require it.

Forgetting passwords on systems since they have too many passwords.

Not writing passwords down in a safe place, such as a sticky note on your workstation.

Correct Answer : Using domain admin privileged accounts for day-to-day non-admin use.

Special type of stored procedure is?

Table

Trigger

View

Function

Correct Answer : Trigger

Injecting a malicious script into a website which will later be executed in a victimâ€™s web browser is called what?

Java scripting

Malware injection

Cross site scripting

Command Injection

Correct Answer : Cross site scripting

New Technologies MCQ's

Machine Learning

Artificial Intelligence