Add office photos
Filter interviews by
Innovative Business Solutions Database Admin Interview Questions and Answers
Innovative Business Solutions Database Admin Interview Experiences
1 interview found
Anonymous
I applied via Naukri.com and was interviewed in Dec 2022. There were 2 interview rounds.
(3 Questions)
- Q1. Oracle database design
- Q2. What is normalize form
- Ans.
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down a table into smaller tables and defining relationships between them.
There are different levels of normalization, known as normal forms, with each level having specific rules to follow.
The most commonly used normal forms are first normal form (1NF), second normal form (2NF), ...
- Q3. What is view and materialized view
- Ans.
A view is a virtual table based on the result-set of an SQL statement. A materialized view is a physical copy of a view.
A view is a logical representation of data from one or more tables.
A materialized view is a table that contains the result of a query.
A view is updated dynamically when the underlying tables are updated.
A materialized view is updated periodically or manually.
Views are used to simplify complex queries ...
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Company Website and was interviewed in Apr 2024. There was 1 interview round.
(3 Questions)
- Q1. What is database
- Ans.
A database is a structured collection of data that is organized in a way that allows for easy access, management, and retrieval.
A database is used to store and organize large amounts of data.
It consists of tables, rows, and columns.
Examples of databases include MySQL, Oracle, and MongoDB.
- Q2. About previous project
- Q3. They asked very basic interview questions of ms sql
Selected
I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.
(1 Question)
- Q1. Scenario baes questions
(2 Questions)
- Q1. Statup parameters of sql server
- Ans.
Startup parameters are used to configure the behavior of SQL Server when it starts up.
Startup parameters are set in the SQL Server Configuration Manager or by using the SQL Server command prompt.
Common startup parameters include -d for specifying the location of the master database files, -m for starting SQL Server in single-user mode, and -T for enabling trace flags.
Startup parameters can also be configured in the Win...
- Q2. Differential backup query
Skills evaluated in this interview
I was interviewed in Jul 2023.
(1 Question)
- Q1. What is role of HAS in RAC systems?
- Ans.
HAS (High Availability Services) in RAC systems provides automatic failover and load balancing for improved system reliability.
HAS monitors the health of each node in the RAC cluster
It automatically relocates services to healthy nodes in case of node failure
It ensures high availability and scalability for the RAC system
Examples: Oracle Clusterware, Oracle Grid Infrastructure
(1 Question)
- Q1. How would you manage the upcoming challenging opportunities in the new role?
Interview Preparation Tips
I applied via Referral and was interviewed in Sep 2022. There were 2 interview rounds.
(3 Questions)
- Q1. What is database ? And type of sql
- Ans.
A database is a structured collection of data. SQL is a language used to manage and manipulate databases.
A database is a software system that stores and organizes data.
It allows users to create, read, update, and delete data.
SQL (Structured Query Language) is a programming language used to communicate with and manage databases.
There are different types of databases such as relational databases, object-oriented database...
- Q2. Write the sql command of the database
- Ans.
SQL command of which database?
Specify the name of the database you want the SQL command for
Provide the specific query you want to execute
Ensure that the syntax is correct and the query is optimized
Examples: SELECT * FROM table_name; INSERT INTO table_name (column1, column2) VALUES (value1, value2);
- Q3. For example ,select *from employee table
Interview Preparation Tips
- Database basic
Make communication a circle,not a line
Keep all information accessible
Ask for feedback
Skills evaluated in this interview
(2 Questions)
- Q1. Performance tuning and high availability
- Q2. Allways on and log shipping
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Nov 2022. There were 2 interview rounds.
(2 Questions)
- Q1. All technical knowledge
- Q2. Any challenges that you faced
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Nov 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Mainly go with high availability, performance tuning.
Interview Preparation Tips
(1 Question)
- Q1. Process of mysql replication
- Ans.
MySQL replication is the process of copying data from one database server to another in real-time.
MySQL replication involves a master server and one or more slave servers.
Changes made on the master server are logged and then applied to the slave servers.
Replication can be asynchronous or synchronous, with asynchronous being more common.
Replication can be used for load balancing, failover, and data backup purposes.
Innovative Business Solutions Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Oracle Database Administrator Interview Questions
- Database Developer Interview Questions
- SQL Database Administrator Interview Questions
- Database Analyst Interview Questions
- Database Administrator DBA Interview Questions
- Senior Database Administrator Interview Questions
- SQL Database Developer Interview Questions
- Database Engineer Interview Questions
- Show more
Database Admin Interview Questions from Similar Companies
Innovative Business Solutions Database Admin Reviews and Ratings
based on 1 review
Rating in categories
|
Softwaretest Engineer
16
salaries
|  ₹3.6 L/yr - ₹5.4 L/yr |
|
Data Analyst
15
salaries
| ₹3 L/yr - ₹7.7 L/yr |
|
Software Engineer
12
salaries
| ₹2.4 L/yr - ₹8 L/yr |
|
Software Developer
9
salaries
| ₹2.1 L/yr - ₹7.7 L/yr |
|
QA Engineer
8
salaries
| ₹4.2 L/yr - ₹6.5 L/yr |
TCS
Wipro
Infosys
HCLTech
- Home >
- Interviews >
- Innovative Business Solutions Interview Questions >
- Innovative Business Solutions Database Admin Interview Questions
