In November, I received a call from the HR team at C&R Software regarding my shortlisting and interview scheduling for the Database Administrator Intern role (off-campus). It was an internship + PPO offer.
Round 1: Technical Round (1 hour) :
The interview began with an introduction and a discussion of my projects. Then, the technical questions started:
- What is a foreign key? Provide an example.
- What are the different constraints in DBMS?
- What is the ALTER command?
Next, I was asked to open Oracle 11g on my laptop and create a simple table for students, inserting 2-3 rows as instructed. I was then required to perform various DDL, DML, and DCL operations on the table, such as:
- Add another column to the table.
- Update a row that satisfied the given condition.
- Add a CHECK constraint on a column.
- Extract the students who enrolled in more than one course.
The interview then moved on to cloud-related questions:
- What is S3?
- What is EC2?
- Explain the different types of cloud instances.
- Which cloud provider is better: AWS, Azure, or Google Cloud?
- How do you create a static website in AWS?
Round 2: HR Round (30 minutes) :
This round included general HR questions about relocation, my expectations from the company, and information about the company and its founder.
Outcome: Selected.
