Normal Market research questions
Associate Analyst Interview Questions
5,826 associate analyst interview questions shared by candidates
What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ? Procedures and Functions,Packages and Database Triggers. What are the advantages of having a Package ? Increased functionality (for example,global package variables can be declared and used by any proecdure in the package) and performance (for example all objects of the package are parsed compiled, and loaded into memory once) What are the uses of Database Trigger ? Database triggers can be used to automatic data generation, audit data modifications, enforce complex Integrity constraints, and customize complex security authorizations. What is a Procedure ? A Procedure consist of a set of SQL and PL/SQL statements that are grouped together as a unit to solve a specific problem or perform a set of related tasks. What is a Package ? A Package is a collection of related procedures, functions, variables and other package constructs together as a unit in the database. What is difference between Procedures and Functions ? A Function returns a value to the caller where as a Procedure does not. What is Database Trigger ? A Database Trigger is procedure (set of SQL and PL/SQL statements) that is automatically executed as a result of an insert in, update to, or delete from a table.
what do you think your work here if u get hired? Task
From the three questions that stuck into my mind was the one about the book I am reading no / have read most recently
Analytical ability questions via mail interview
In Data Structure, what's the difference between Tree and Array in term of FIFO and LIFO ?
How many barbers are there in Delhi?
1. Guestimate questions are must 2. Tell me about yourself
How does the pen is being sold from the manufacturing point to the customer. Also how the payment goes through the channel. Also question from my Under graduation was also asked They asked me how do i fit in this role
How many types of bullets are there?
Viewing 421 - 430 interview questions