Aknamed Software Engineer Interview Questions and Answers

Hackerrank
Duration: 1 hr
Topics: Hashes, Arrays, Queues, Sorting

Q1. What is RDBMS? Write some sample queries for the employees table
Ans. 
RDBMS stands for Relational Database Management System. It is a software system used to manage relational databases.
• RDBMS stores data in tables with rows and columns

• It enforces relationships between tables using foreign keys

• SQL is used to query and manipulate data in RDBMS

• Sample queries for employees table: SELECT * FROM employees WHERE department='IT';

• UPDATE employees SET salary=60000 WHERE id=1234;
Answered by AI
Add your answer
Q2. Basics of SQL, demonstrate the use of foreign keys,
Add your answer
Q3. Display how through table works.
Ans. 
A through table is a table that connects two other tables in a many-to-many relationship.
• Through tables contain foreign keys from both tables they connect.

• They allow for efficient querying of data across multiple tables.

• Example: A through table connecting a 'users' table and a 'groups' table to show which users belong to which groups.
Answered by AI
Add your answer

Describe yourself. How to deal with conflict? How to manage critical situations.