Infinite Technology solutions Interview Questions and Answers

Q1. Do you know stored procedure
Ans. 
Yes, stored procedures are pre-written SQL codes that can be saved and reused.
• Stored procedures are used to improve performance and security

• They can be called from within an application or directly from a database management system

• They can accept input parameters and return output parameters

• Examples include sp_help, sp_who, and sp_adduser
Answered by AI
Add your answer
Q2. Do you know trigger and indexes
Ans. 
Yes, I know triggers and indexes.
• Triggers are database objects that are automatically executed in response to certain events, such as insert, update, or delete operations.

• Indexes are database objects that improve the performance of queries by allowing them to quickly locate the data they need.

• Triggers can be used to enforce business rules, audit changes to data, or replicate data to other tables or databases.

• Indexes ca...read more
Answered by AI
Add your answer

Q1. Write a query to display about emp table
Ans. 
Query to display information about emp table
• SELECT * FROM emp;

• Use WHERE clause to filter results based on specific criteria

• Use ORDER BY clause to sort results in ascending or descending order
Answered by AI
Add your answer

Technology boon or bane