FIS Manager Interview Questions and Answers

A case study is related to supply and demand.

Q1. As questions related to SQL, types of joins, keys, and windows function.
Add your answer
Q2. Types of Joins?
Ans. 
Types of joins include inner join, outer join, left join, right join, and full join.
• Inner join: Returns rows when there is a match in both tables.

• Outer join: Returns all rows when there is a match in one of the tables.

• Left join: Returns all rows from the left table and the matched rows from the right table.

• Right join: Returns all rows from the right table and the matched rows from the left table.

• Full join: Returns rows
Answered by AI
Add your answer
Q3. Explain different types of Keys.
Ans. 
Keys in database management are used to uniquely identify records in a table.
• Primary Key: uniquely identifies each record in a table, must be unique and not null

• Foreign Key: links two tables together, ensures referential integrity

• Composite Key: combination of two or more columns to uniquely identify a record

• Super Key: set of attributes that uniquely identifies a record
Answered by AI
Add your answer
Q4. Difference between DBMS and R-DBMS
Ans. 
DBMS is a software system that manages databases, while R-DBMS is a relational database management system that stores data in tables with relationships.
• DBMS stores data in files, while R-DBMS stores data in tables with relationships

• DBMS does not support relationships between tables, while R-DBMS supports relationships through keys

• R-DBMS ensures data integrity through normalization, while DBMS does not have this feature
Answered by AI
Add your answer

Q1. Writing BRD's , what will come in our mind when v write Brds
Add your answer

Q1. Overview of the current job profile
Add your answer

Q1. What is the difference between singleton class and static class
Ans. 
Singleton class allows only one instance to be created, while static class cannot be instantiated and all members are static.
• Singleton class can have instance methods and properties, while static class can only have static members.

• Singleton class can be lazy loaded, while static class is eagerly loaded.

• Singleton class can be implemented using a static property or method to return the single instance, while static class...read more
Answered by AI
Add your answer