AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Goolean Technologies Database Administrator DBA Interview Questions and Answers for Experienced
Goolean Technologies Database Administrator DBA Interview Experiences for Experienced
1 interview found
Anonymous
I applied via Naukri.com and was interviewed in Jan 2021. There was 1 interview round.
Interview Questionnaire
5 Questions
- Q1. Types of table joins
- Ans.
Table joins are used to combine data from two or more tables based on a related column.
Inner join: returns only the matching rows from both tables
Left join: returns all rows from the left table and matching rows from the right table
Right join: returns all rows from the right table and matching rows from the left table
Full outer join: returns all rows from both tables, with NULL values in the columns where there is no m...
- Q2. MySQL backup command from command prompt
- Ans.
MySQL backup command from command prompt
Use mysqldump command to backup MySQL database from command prompt
Syntax: mysqldump -u [username] -p [password] [database_name] > [backup_file_name.sql]
Example: mysqldump -u root -p mypassword mydatabase > mybackup.sql
- Q3. How to load csv file into a database from command prompt
- Ans.
To load a CSV file into a database from the command prompt, you can use the database's command-line interface or a scripting language.
Ensure the database is installed and accessible from the command prompt
Use the appropriate command or script to connect to the database
Create a table in the database with the same structure as the CSV file
Use the appropriate command or script to import the CSV file into the table
Verify t...
- Q4. How to source a SQL file into database from command prompt
- Ans.
To source a SQL file into database from command prompt, use the 'mysql' command followed by the database name and file path.
Open command prompt
Navigate to the directory where the SQL file is located
Use the 'mysql' command followed by the database name and file path
Example: mysql -u username -p database_name < file_path.sql
- Q5. How to create table
- Ans.
To create a table, use the CREATE TABLE statement followed by the table name and column definitions.
Use CREATE TABLE statement
Specify table name
Define columns with data types and constraints
Example: CREATE TABLE customers (id INT PRIMARY KEY, name VARCHAR(50), email VARCHAR(100));
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Referral and was interviewed in Mar 2021. There was 1 interview round.
Interview Questionnaire
3 Questions
- Q1. Interviewer copied questions from internet and asked the same to me
- Q2. What are different type of explain plans
- Ans.
Different types of explain plans include basic, serial, parallel, and statement-level.
Basic explain plan shows the execution plan of a SQL statement
Serial explain plan shows the execution plan for a serial query
Parallel explain plan shows the execution plan for a parallel query
Statement-level explain plan shows the execution plan for each SQL statement in a PL/SQL block
- Q3. Explain about MVCC
- Ans.
MVCC stands for Multi-Version Concurrency Control, a technique used in database management systems to allow multiple transactions to access the same data simultaneously.
MVCC is used to maintain data consistency and prevent conflicts between transactions.
It works by creating multiple versions of a data item, each with a timestamp indicating when it was created.
When a transaction reads a data item, it sees the version wi...
Interview Preparation Tips
I applied via Walk-in and was interviewed before Apr 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. General technical questions
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. I was asked about Oracle architecture, wait events and other questions was asked from my profile and relates to my day to day activities in project
Interview Questionnaire
2 Questions
- Q1. What is database.
- Ans.
A structured collection of data that is organized and managed to provide access and efficient retrieval of information.
A database is a collection of related data that is organized in a specific way.
It is designed to store, retrieve, and manage data efficiently.
It can be used to store any type of data, such as text, images, videos, and more.
Examples of databases include MySQL, Oracle, SQL Server, and MongoDB.
- Q2. What is rdbms
- Ans.
RDBMS stands for Relational Database Management System.
It is a type of database management system that stores data in tables with relationships between them.
It uses SQL (Structured Query Language) to manage and manipulate data.
Examples include Oracle, MySQL, Microsoft SQL Server, and PostgreSQL.
Skills evaluated in this interview
Interview Questionnaire
4 Questions
- Q1. Explain ora 60 error
- Ans.
ORA-00600 is an internal error code that indicates a software bug or corrupted data.
ORA-00600 is a generic error message that indicates an internal error has occurred.
It is caused by a software bug or corrupted data.
It is a critical error that requires immediate attention from the DBA.
The error message includes a code that identifies the specific error.
The error can be resolved by applying a patch or contacting Oracle ...
- Q2. Explain ora600 error
- Ans.
ORA-600 is an internal error code in Oracle database.
It is a generic error that indicates that something unexpected has occurred within the database.
It is usually accompanied by a detailed error message that provides more information about the cause of the error.
It can be caused by a variety of factors, including software bugs, hardware failures, and data corruption.
It is important to diagnose and resolve ORA-600 error...
- Q3. Clone high level steps
- Ans.
Cloning high level steps involve creating a copy of an existing database or server.
Identify the source database or server to be cloned
Create a backup of the source database or server
Restore the backup to a new location or server
Modify the cloned database or server as needed
Test the cloned database or server to ensure it functions properly
- Q4. How to add datafile
- Ans.
To add a datafile in a database, use the ALTER TABLESPACE statement.
Connect to the database as a user with the necessary privileges.
Identify the tablespace where you want to add the datafile.
Use the ALTER TABLESPACE statement with the ADD DATAFILE clause to add the datafile.
Specify the file name, size, and other attributes of the datafile.
Example: ALTER TABLESPACE users ADD DATAFILE '/path/to/datafile.dbf' SIZE 100M;
Interview Preparation Tips
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Mar 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Day to day activities, Datapump activities, Rman jobs, Dataguard configuration
Interview Preparation Tips
I don't recommend HCL to anyone .
HR names : Ravi Teja , Sadana Priya
If you get the call or mail from this 2 people please don't waste your time to attending intery in HCL.
I applied via Naukri.com and was interviewed in May 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Questions were related to database architecture and RAC and dataguard
Interview Preparation Tips
I applied via Referral and was interviewed in Oct 2020. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. How to install sql server on laptop?
- Q2. Joints and types examples
- Ans.
Joints are used to combine data from multiple tables in a database. There are different types of joints such as inner, outer, left, and right.
Inner join returns only the matching rows from both tables
Outer join returns all the rows from both tables and null values for non-matching rows
Left join returns all the rows from the left table and matching rows from the right table
Right join returns all the rows from the right ...
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Jan 2021. There were 3 interview rounds.
Interview Questionnaire
10 Questions
- Q1. Questions were asked based on your resume, your experience level and things you are supposed to know, specially in real time scenarios and activities.
- Q2. Oracle Architecture
- Q3. Oracle Dataguard
- Q4. Oracle RAC
- Q5. Oracle ASM
- Q6. Database Upgrade
- Q7. Database Migration
- Q8. Database Patching
- Q9. Performance Tuning
- Q10. Cloud
Interview Preparation Tips
1. Technical
2. Less Technical + More Managerial
3. HR (Basic information about you, your goals, why are you leaving your current company and Salary Expectations)
Bonus Round - The Actual Salary discussion and negotiation or bargaining with your assigned Recruiter, not with the HR who took your HR round,
Goolean Technologies Interview FAQs
Some of the top questions asked at the Goolean Technologies Database Administrator DBA interview for experienced candidates -
Tell us how to improve this page.
Database Administrator DBA Interview Questions from Similar Companies
|
Senior PHP Developer
8
salaries
|  ₹4 L/yr - ₹7.7 L/yr |
|
Software Engineer
7
salaries
| ₹3.6 L/yr - ₹6.8 L/yr |
|
Software Developer
6
salaries
| ₹2.5 L/yr - ₹7.8 L/yr |
|
PHP Developer
6
salaries
| ₹3.6 L/yr - ₹5 L/yr |
|
Android Developer
5
salaries
| ₹3 L/yr - ₹5 L/yr |
TCS
Accenture
Wipro
Cognizant
- Home >
- Interviews >
- Goolean Technologies Interview Questions >
- Goolean Technologies Interview Questions for Experienced
