Used for hiring
Database administrators (DBA) Developers
Data scientists Developers
Data analysts Developers
Understanding of the Oracle database, utilities, and tools
Knowledge of PL/SQL packages and triggers
Knowledge of data analysis and modeling, design, and implementation
How this test helps with hiring SQL candidates
Create a test
Add questions to assess SQL skills
Send invites to candidates
Evaluate the report
Programming questions to assess SQL skills
advanced SQL skills
Database management and .NET frameworks
Project file tests to assess SQL skills
“Based on the following table, what is the output of the SQL query:
STUDENT ID NAME ADDRESS 015 Bob 20 020 Alice 18 105 Mike 25 151 Tara NULL SQL > SELECT COUNT (ID) FROM STUDENT;”
- 10Correct Answer
- No Record selected
- All Records selected
- None of these
Which of the following statements about triggers in SQL are true?
1) It is automatically invoked by the DBMS in response to specific changes to the database.
2) A trigger has two parts.
3) A row-level trigger is activated for each modified record.
4)A statement-level trigger is activated once for every UPDATE command.
- 1 and 3Correct Answer
- 1, 2, and 3
- 1, 3, and 4
- All of these
Using the given set of table and data, what will be the result of the SQL following query:
Select COALESCE (Temp, Humidity) AS Result from City_weather where city = ‘Chicago’;
City Record_date Temp Humidity Weather
Athens 21-Mar-2018 97 89 Sunny Athens 22-Mar-2018 97 89 Sunny Chicago 21-Mar-2018 78 98 Rain Chicago 22-Mar-2018 88 Rain Chicago 23-Mar-2018 75 Rain Paris 22-Mar-2018 62 62 Cloudy Paris 22-Mar-2018 62 62 Cloudy Sydney 22-Mar-2018 12 12 Snow Sydney 23-Mar-2018 10 10 Snow San Francisco 22-Mar-2018 29 12 Snow Sydney 23-Mar-2018 25 10 Snow
- "RESULT 78 88 75"Correct Answer
- "RESULT 78 75"
- Query will return an Oracle error message
- None of these