Persistent Systems Database Developer Interview Questions and Answers

Database Management system SQL and PlSQL

Database Base Management system SQL and PlSQL

Database Management system

Database Management system

Database Management system

Database Management system

Database Base Management system

Q1. Database Management system
Add your answer
Q2. SQL and PlSQL Mango Data And Manu Database Management system
Add your answer
Q3. C Language and C++Language and Java
Add your answer
Q4. Data Analysis and Data entry
Add your answer
Q5. DBMS C,C++ Java Data Entry Ms Excel Ms Word Ms PP
Add your answer

Q1. How to sync primary and standby?
Ans. 
Primary and standby databases can be synced using Data Guard in Oracle.
• Configure Data Guard on primary and standby databases

• Enable redo transport services

• Monitor and resolve any synchronization issues

• Perform switchover or failover when necessary
Answered by AI
Add your answer
Q2. Performance tuning?
Add your answer

Q1. Why you want to change the job?
Ans. 
Seeking new challenges and growth opportunities in a dynamic environment.
• Looking for new challenges to enhance my skills and knowledge

• Seeking growth opportunities for career advancement

• Interested in working in a more dynamic and innovative environment
Answered by AI
Add your answer
Q2. Expected salary.
Add your answer

Q1. Architecture of sql
Ans. 
SQL architecture refers to the structure and components of a SQL database system.
• SQL architecture includes components like storage engine, query processor, and buffer manager.

• The storage engine manages data storage and retrieval, while the query processor processes SQL queries.

• The buffer manager handles caching and memory management to optimize performance.

• Examples of SQL architectures include MySQL, Oracle, and SQL Se
Answered by AI
Add your answer
Q2. Recovery models
Add your answer

Q1. Sql dmvs used in performance tuning
Ans. 
SQL DMVs are dynamic management views that provide information about the current state of a SQL Server instance for performance tuning.
• DMVs can be used to identify performance bottlenecks, monitor resource usage, and troubleshoot issues.

• Examples of commonly used DMVs include sys.dm_exec_query_stats, sys.dm_os_wait_stats, and sys.dm_io_virtual_file_stats.
Answered by AI
Add your answer

Q1. Tell about yourself
Ans. 
Experienced Oracle DBA with 5+ years of hands-on experience in managing databases, optimizing performance, and ensuring data security.
• 5+ years of experience as an Oracle DBA

• Proficient in database management, performance optimization, and data security

• Skilled in troubleshooting and resolving database issues

• Strong knowledge of Oracle database architecture and SQL

• Certified Oracle Database Administrator (OCA/OCP)
Answered by AI
Add your answer