Enlink Senior SQL Database Developer Interview Questions and Answers

Q1. Explain sql commands
Add your answer
Q2. Explain normalization in sql
Add your answer

Sql
ddl
dml
tcl
dql
joins
view
date commit

Date commit
joins
view
sum
max
avg
count
min

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. What is sql , index , stored proc , triggers
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. Static and dynamic polymorphism
Add your answer
Q2. Code snipts related to prefix and postfix
Add your answer

Q1. Joins in sql server
Add your answer
Q2. Set operator in sql
Add your answer

Q1. What is CAP theorem What is column families What function are used in cassandra what is key value pair
Ans. 
CAP theorem states that in a distributed system, it is impossible to simultaneously guarantee consistency, availability, and partition tolerance.
• CAP theorem: Consistency, Availability, Partition tolerance - pick two

• Column families: A way to organize data in NoSQL databases like Apache Cassandra

• Functions in Cassandra: read, write, delete, update

• Key value pair: Basic data structure where each key is associated with a val
Answered by AI
Add your answer
Q2. What is Cloumn families
Ans. 
Column families are a way to organize related data in a NoSQL database, grouping columns together for efficient retrieval.
• Column families are a way to group related columns together in a NoSQL database.

• They are used in databases like Apache Cassandra to organize data efficiently.

• Column families can contain a large number of columns, each with a unique name and value.

• They are stored together on disk for faster retrieval...read more
Answered by AI
Add your answer
Q3. What are the functions in cassandra
Ans. 
Cassandra functions are used for data manipulation and retrieval in Cassandra database.
• Aggregate functions like COUNT, SUM, AVG, MIN, MAX

• Date and time functions like NOW, DATEOF, UNIXTIMESTAMP

• Mathematical functions like ABS, CEIL, FLOOR, SIN, COS

• String functions like LENGTH, SUBSTRING, CONCAT, LOWER, UPPER
Answered by AI
Add your answer
Q4. Fundamentels of cassandra
Ans. 
Cassandra is a distributed NoSQL database management system designed for handling large amounts of data across multiple servers.
• Cassandra is a highly scalable and fault-tolerant database system.

• It is based on a distributed architecture, with data spread across multiple nodes.

• Cassandra uses a masterless design, where all nodes are equal and can handle read and write requests.

• It uses a partitioning strategy called consis...read more
Answered by AI
Add your answer
Q5. What is key value pair
Ans. 
Key value pair is a data structure where each key is associated with a corresponding value.
• Key value pairs are commonly used in dictionaries, hash tables, and JSON objects.

• Keys are unique identifiers that are used to access the corresponding values.

• Examples include 'name: John', 'age: 30', 'city: New York'.
Answered by AI
Add your answer