Protechsoft Technologies Database Programmer Interview Questions and Answers

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. Self about my fis experience
Add your answer
Q2. Tell about my contribution
Add your answer

Q1. About oracle database functionality
Add your answer

Q1. Salary discussion
Add your answer

Q1. Salary details location etc
Add your answer

Q1. Project details Data types varchar vs nvarchar Constrains Indexes optimization Temp vs CTE Variable Complete Rank Functions Compute Sum questions pivot and unpivot etc
Add your answer

Q1. Architecture of snowflake project details Azure related questions databricks
Add your answer

Q1. Salary discussion location joining date
Add your answer

Q1. Tell me about your roles and responsibilities
Add your answer
Q2. How to add diskgroup in disks
Ans. 
To add a diskgroup in disks, use the CREATE DISKGROUP command in Oracle ASM.
• Ensure that the disks are initialized and partitioned

• Use the ASMCA (ASM Configuration Assistant) or ASMCMD (ASM Command-Line Utility) to create the diskgroup

• Specify the diskgroup name, redundancy level, and the disks to be included in the diskgroup

• Example: CREATE DISKGROUP dg1 NORMAL REDUNDANCY DISK '/dev/sdb1', '/dev/sdc1'
Answered by AI
Add your answer
Q3. What will do in Real application cluater
Ans. 
Real Application Cluster (RAC) is a cluster database with shared disk architecture.
• RAC allows multiple instances to access a single database simultaneously.

• It provides high availability and scalability.

• RAC uses Oracle Clusterware to manage the cluster.

• Load balancing and failover are automatic in RAC.

• RAC requires additional hardware and software licenses.
Answered by AI
Add your answer

Multiple choice which is conducted in online and they asked me to take help from google as well to finish the aptitude but the questions which is asked is bit hard

Q1. Related to SQL and GTM
Add your answer
Q2. What is standalone database
Ans. 
A standalone database is a database that is independent and does not require connection to a network or other databases.
• Standalone databases are typically used for small-scale applications or for testing purposes.

• They do not rely on a network connection to function.

• Examples of standalone databases include SQLite and Microsoft Access.
Answered by AI
Add your answer
Q3. How to segregate alphabet and numbers in a table
Ans. 
Use SQL queries to segregate alphabet and numbers in a table
• Use the SQL function REGEXP to filter out alphabets and numbers

• For example, to select only alphabets: SELECT column_name FROM table_name WHERE column_name REGEXP '^[a-zA-Z]'

• For numbers: SELECT column_name FROM table_name WHERE column_name REGEXP '^[0-9]'
Answered by AI
Add your answer

Q1. Database related
Add your answer

Q1. Salary expectation
Add your answer