Add office photos
Filter interviews by
Goolean Technologies Database Administrator DBA Interview Questions, Process, and Tips for Experienced
Goolean Technologies Database Administrator DBA Interview Experiences for Experienced
1 interview found
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 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.
Interview Questionnaire
4 Questions
- Q1. RAC architecture,startup and shutdown process steps in RAC, migration of spfile,asm migration
- Ans.
Answering questions on RAC architecture, startup and shutdown process, spfile and ASM migration
RAC architecture involves multiple nodes sharing a common storage and network infrastructure
Startup process involves starting the Oracle Clusterware stack, starting the database instances, and mounting the database
Shutdown process involves dismounting the database, stopping the database instances, and stopping the Oracle Clus...
- Q2. Goldengate architecture and zero downtime migration
- Q3. Data guard steps in RAC
- Ans.
Data Guard steps in RAC
Configure primary and standby databases
Enable archive log mode on primary database
Create standby control file on standby database
Start the Data Guard broker
Start the redo apply process on standby database
- Q4. Performance tuning
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?
- Ans.
To install SQL Server on a laptop, download the installation file from Microsoft's website and follow the installation wizard.
Download the SQL Server installation file from Microsoft's website
Run the installation file and follow the installation wizard
Choose the appropriate installation options, such as the edition and features
Set up the necessary authentication and security settings
Complete the installation process an
- 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
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
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
I applied via LinkedIn and was interviewed in Aug 2024. There were 2 interview rounds.
Technical questions were asked in the aptitude
(2 Questions)
- Q1. Technical questions
- Q2. Oracle architechture
Oracle Database Administrator Interview Questions & Answers
Accenture
Anonymous
posted on 12 Apr 2024
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
(1 Question)
- Q1. How would you monitor a db performance with OEM AWR report?
- Ans.
Monitoring db performance using OEM AWR report
Access OEM console and navigate to Performance tab
Select AWR report option to generate a report
Analyze the report for key performance metrics like CPU usage, memory utilization, I/O stats
Identify any performance bottlenecks and take necessary actions to optimize db performance
Interview Preparation Tips
- Dataguard
- BACKUP & recovery
- ASM
- Oracle RAC
Oracle Database Administrator Interview Questions & Answers
Cognizant
Anonymous
posted on 19 Apr 2024
(2 Questions)
- Q1. Oracle architecture
- Q2. RAC architecture
Interview Preparation Tips
Oracle Database Administrator Interview Questions & Answers
Tech Mahindra
amit aman
posted on 24 Jan 2024
Selected
I applied via Referral and was interviewed before Jan 2023. There were 2 interview rounds.
(1 Question)
- Q1. Basic questions
(2 Questions)
- Q1. Asking over past experience
- Q2. RAC and GG related questions. Data guard gap resolve. RMAN scenario based question. Oracle architecture.
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.
Interview Questions for Popular Designations
- Oracle Database Administrator Interview Questions
- Database Admin Interview Questions
- Database Developer Interview Questions
- SQL Database Administrator Interview Questions
- DB2 Database Administrator Interview Questions
- Senior Database Administrator Interview Questions
- MS SQL DBA Interview Questions
- Database Engineer Interview Questions
- Show more
Database Administrator DBA Interview Questions from Similar Companies
|
Software Engineer
8
salaries
|  ₹3.6 L/yr - ₹6.5 L/yr |
|
Senior PHP Developer
8
salaries
| ₹4 L/yr - ₹7.7 L/yr |
|
PHP Developer
7
salaries
| ₹2 L/yr - ₹5 L/yr |
|
Software Developer
5
salaries
| ₹3.4 L/yr - ₹7.8 L/yr |
|
Android Developer
5
salaries
| ₹3 L/yr - ₹5 L/yr |
TCS
Infosys
Wipro
- Home >
- Interviews >
- Goolean Technologies Interview Questions >
- Goolean Technologies Database Administrator DBA Interview Questions for Experienced
