SQL Computech SQL Developer Interview Questions and Answers

Q1. Types of Indexes
Ans. 
Types of indexes include clustered, non-clustered, unique, composite, and filtered indexes.
• Clustered indexes physically reorder the data in the table based on the index key.

• Non-clustered indexes create a separate structure for the index, pointing back to the original table data.

• Unique indexes ensure that no two rows have the same values in the indexed columns.

• Composite indexes are created on multiple columns to improve...read more
Answered by AI
Add your answer
Q2. Sceanrio based question
Add your answer

Q1. Salary discussion
Add your answer
Q2. Joining date and last working date
Add your answer

Profit and loss,percentage

Q1. Why do you this job ?
Add your answer
Q2. How can i believe you are the best to our company?
Add your answer

Learn basics of aptitude

Q1. Learn oops conceps and knowledge of coding in any language
Add your answer

Q1. What are your strengths and weaknesses?
Add your answer
Q2. Tell me about yourself.
Add your answer

Q1. Basic SQL questions
Add your answer
Q2. Advanced PLSQL questions
Add your answer

Q1. Questions on C#, ref keyword, difference between abstract and interface, Pillars of OOPS, Inheritance, Filters in mvc, Tempdata, viewdata, viewbag
Add your answer

Q1. All the questions related to my resume
Add your answer
Q2. Questions on my project, my internships earlier
Add your answer
Q3. And my knowledge about Java and basic knowledge of web development
Add your answer

Q1. Difference between delete, drop and truncate
Ans. 
Delete removes rows from a table, drop removes the entire table, and truncate removes all rows from a table.
• Delete is a DML operation and can be rolled back, but it is slower than truncate.

• Drop is a DDL operation and cannot be rolled back. It removes the table and all associated objects.

• Truncate is a DDL operation and cannot be rolled back. It removes all rows from the table but keeps the table structure.

• Delete and tru...read more
Answered by AI
Add your answer
Q2. Difference between table and view
Ans. 
Table stores data in a structured format while view is a virtual table created from a query.
• Table is a physical object while view is a logical object.

• Table can be modified while view cannot be modified directly.

• Table can have indexes while view cannot have indexes.

• Table can have constraints while view cannot have constraints.

• View can be used to simplify complex queries by joining multiple tables.

• View can be used to res...read more
Answered by AI
Add your answer
Q3. What type of cursors did you use
Ans. 
I have used both implicit and explicit cursors in PL/SQL development.
• Implicit cursors are used for single-row queries while explicit cursors are used for multi-row queries.

• I have used explicit cursors with parameters to make the query more dynamic.

• I have also used cursor variables to pass cursors as parameters to procedures and functions.

• Examples of cursor types I have used include FOR LOOP, FETCH, and UPDATE cursors.
Answered by AI
Add your answer
Q4. What is primary key and unique key
Ans. 
Primary key uniquely identifies a record in a table, while unique key ensures uniqueness of a column or set of columns.
• Primary key is a column or set of columns that uniquely identifies each record in a table

• Unique key ensures that a column or set of columns have unique values

• Primary key cannot have null values, while unique key can have null values

• A table can have only one primary key, but multiple unique keys
Answered by AI
Add your answer

Coding test was easy, there were 2 questions.

Q1. Square root of a number in log n time
Ans. 
Using binary search, square root of a number can be found in log n time.
• Choose a range for the square root

• Use binary search to find the square root within the range

• Adjust the range based on whether the guess is too high or too low
Answered by AI
Add your answer

Q1. Basic questions on leadership and some problem based.
Add your answer
Q2. Basics questions
Add your answer