ASENTECH Oracle Developer Interview Questions and Answers

Q1. What are constraints
Ans. 
Constraints are rules that are applied to the data in a database to ensure its integrity and consistency.
• Constraints define the limits or conditions that must be met for data to be valid.

• They can be applied to individual columns or entire tables.

• Common types of constraints include primary key, foreign key, unique, and check constraints.

• Primary key constraints ensure that each row in a table is uniquely identified.

• Forei...read more
Answered by AI
Add your answer

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. Oracle receivables core setup
Add your answer
Q2. Oracle bill in advance accounting entries
Ans. 
Oracle bill in advance accounting entries
• When billing in advance, recognize revenue over the service period

• Debit Accounts Receivable and credit Unearned Revenue upon billing

• Recognize revenue by debiting Unearned Revenue and crediting Revenue over time

• Adjust entries as revenue is earned
Answered by AI
Add your answer

Q1. Interview is scheduled
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. How you will find that some user SQL running slow without discussing with user?
Add your answer
Q2. How you will patch specific db components to reduce downtime?
Ans. 
To patch specific db components to reduce downtime, follow these steps:
• Identify the specific components that need to be patched

• Plan the patching process during a scheduled maintenance window

• Backup the database before applying patches

• Apply patches to the specific components one by one

• Test the patched components to ensure they are functioning correctly

• Monitor the database for any issues post-patching
Answered by AI
Add your answer

Q1. Why you have so many hopping in your resume?
Add your answer
Q2. How you will rate yourself as an dba?
Add your answer

Q1. Mainly they focus on PLSQL query .
Add your answer

Q1. What are constraints
Ans. 
Constraints are rules that are applied to the data in a database to ensure its integrity and consistency.
• Constraints define the limits or conditions that must be met for data to be valid.

• They can be applied to individual columns or entire tables.

• Common types of constraints include primary key, foreign key, unique, and check constraints.

• Primary key constraints ensure that each row in a table is uniquely identified.

• Forei...read more
Answered by AI
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