Shamgar Software Solutions Database Administrator DBA Interview Questions and Answers

Q1. Question about dba
Add your answer
Q2. Difference Between SQL And nosql
Ans. 
SQL is a structured query language used for relational databases, while NoSQL is a non-relational database management system.
• SQL is used for structured data with predefined schema, while NoSQL is used for unstructured or semi-structured data.

• SQL databases are vertically scalable, while NoSQL databases are horizontally scalable.

• SQL databases are ACID compliant, ensuring data integrity, while NoSQL databases sacrifice so...read more
Answered by AI
Add your answer
Q3. How to restore the database using rman
Ans. 
Restoring a database using RMAN involves connecting to the target database, restoring the control file, and recovering the database.
• Connect to the target database using RMAN

• Restore the control file from a backup

• Restore the datafiles and tablespaces

• Recover the database to bring it to a consistent state

• Perform necessary checks and validations after restoration
Answered by AI
Add your answer
Q4. How to change column in table
Ans. 
You can change a column in a table using the ALTER TABLE statement in SQL.
• Use the ALTER TABLE statement followed by the MODIFY keyword to change the data type or size of a column.

• Use the ALTER TABLE statement followed by the ADD or DROP keyword to add or remove a column.

• Make sure to specify the table name, column name, and the new data type or size when making changes.
Answered by AI
Add your answer
Q5. What are different types of objects in database
Ans. 
Different types of objects in a database include tables, views, indexes, sequences, and stored procedures.
• Tables: Used to store data in rows and columns.

• Views: Virtual tables created by a query.

• Indexes: Improve the performance of queries by allowing quick access to specific rows.

• Sequences: Generate unique numbers.

• Stored Procedures: Precompiled SQL code that can be executed with parameters.
Answered by AI
Add your answer

Q1. Fundamentals of Oracle DB and Architecture
Ans. 
Fundamentals of Oracle DB and Architecture
• Oracle Database is a relational database management system (RDBMS)

• It uses SQL (Structured Query Language) for querying and managing data

• Consists of physical and logical structures like data files, tablespaces, and schemas

• Architecture includes components like instance, memory structures, and background processes
Answered by AI
Add your answer
Q2. Prepare well for the Architecture and Basics
Add your answer

Q1. Fundamentals of Oracle DB, RAC, DG and Architecture.
Add your answer
Q2. Work experience, questions related to your experience
Add your answer

Q1. Default question, which hiring manager asks
Add your answer

Q1. Q.About SQL Server T-SQL
Add your answer
Q2. Q.Normal scenario based questions
Add your answer

Q1. Basics architecture, rman, datapump, upgrade, asm
Add your answer

Q1. Block corruption, upgrade, rman datapump, asm, patching
Add your answer

Q1. Basics..... Speaking skills.. Salary discussion
Add your answer

Q1. Why Standby Redo logfiles are required. How to troubleshoot node-eviction in RAC. RTO and RPO. Extended RAC. Managed Database.
Ans. 
Standby Redo logfiles are required for data protection and disaster recovery in Oracle databases.
• Standby Redo logfiles are essential for maintaining a standby database in Oracle Data Guard for disaster recovery purposes.

• They contain a record of changes made to the primary database, which can be applied to the standby database to keep it synchronized.

• In case of a primary database failure, the standby database can be act...read more
Answered by AI
Add your answer

Q1. What is view synonym mview Explain datapump Oracle goldengate in detail
Ans. 
A materialized view (mview) is a database object that contains the results of a query. Datapump is a tool for moving data between Oracle databases. Oracle GoldenGate is a real-time data integration and replication tool.
• Materialized views (mviews) store the results of a query for faster access.

• Datapump is a tool used for exporting and importing data between Oracle databases.

• Oracle GoldenGate is a real-time data integrat...read more
Answered by AI
Add your answer

Q1. What is your goal
Add your answer

Q1. Oracle DBA questions
Add your answer

Q1. Oracle DBA questions
Add your answer

Q1. Managerial round questions for this round.
Add your answer

Q1. HR discussion round, normal HR questions.
Add your answer

Basic coding question with u can find on the oracle website

Q1. Mostly the question are from the engineering subjects
Add your answer
Q2. Cs fundametals , oops concept and dbms
Add your answer