With SQL, how do you select a column named FirstName from a table named Persons?

PostgreSQL - Quiz(MCQ)

With SQL, how do you select a column named "FirstName" from a table named "Persons"?

SELECT Persons.FirstName

SELECT FirstName FROM Persons

EXTRACT FirstName FROM Persons

None of the above

Correct Answer : SELECT FirstName FROM Persons

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