Supporto Software Interview Questions

1,390 supporto software interview questions shared by candidates

Triggers, type of trigger, Package... only specification enough , body required? Which is mandatory? If specification has 2 procedure and 2 functions and body doesn't have one function among them will it error ? Difference between procedure and package? What's a sequence ? Select seq.curval, seq.nextval from dual; - what will be the output of this query if it is a fresh sequence? Types of indexes? Views... can DML be performed in complex views? Example of implicit cursor ? What are cursors? Keys- primary , unique, composite ? Cursor attributes.. can we use cursor attributes in implicit cursor ? Reference cursor? Where can you find the list of views? What are Trigger event ? Materialized view? How materialized view is refreshed ? What is clustered index? Btree index?
avatar

Oracle Developer and Support

Interviewed at HCLTech

3.5
Dec 25, 2016

Triggers, type of trigger, Package... only specification enough , body required? Which is mandatory? If specification has 2 procedure and 2 functions and body doesn't have one function among them will it error ? Difference between procedure and package? What's a sequence ? Select seq.curval, seq.nextval from dual; - what will be the output of this query if it is a fresh sequence? Types of indexes? Views... can DML be performed in complex views? Example of implicit cursor ? What are cursors? Keys- primary , unique, composite ? Cursor attributes.. can we use cursor attributes in implicit cursor ? Reference cursor? Where can you find the list of views? What are Trigger event ? Materialized view? How materialized view is refreshed ? What is clustered index? Btree index?

Online Test - Easy q's on networking and DBMS questions. Technical HR - Questions on IP address, how to find IP address and MAC address on PC, DBMS Queries - Update and Alter difference, Constraints, etc., Java Questions - Difference between JDBC and ODBC, Major and Minor Project, DB connectivity, etc. PI - Intro, why Tech Support instead of pure tech.
avatar

Technical Support Or Software Specialist

Interviewed at eClinicalWorks

3.6
Jun 24, 2017

Online Test - Easy q's on networking and DBMS questions. Technical HR - Questions on IP address, how to find IP address and MAC address on PC, DBMS Queries - Update and Alter difference, Constraints, etc., Java Questions - Difference between JDBC and ODBC, Major and Minor Project, DB connectivity, etc. PI - Intro, why Tech Support instead of pure tech.

Viewing 781 - 790 interview questions

Glassdoor has 1,390 interview questions and reports from Supporto software interviews. Prepare for your interview. Get hired. Love your job.