Amazon Web Services Database Admin Interview Questions and Answers

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

Q1. What is role of HAS in RAC systems?
Ans. 
HAS (High Availability Services) in RAC systems provides automatic failover and load balancing for improved system reliability.
• HAS monitors the health of each node in the RAC cluster

• It automatically relocates services to healthy nodes in case of node failure

• It ensures high availability and scalability for the RAC system

• Examples: Oracle Clusterware, Oracle Grid Infrastructure
Answered by AI
Add your answer

Q1. How would you manage the upcoming challenging opportunities in the new role?
Add your answer

Q1. Performance tuning and high availability
Add your answer
Q2. Allways on and log shipping
Add your answer

I am a B.sc computer science graduated
I am a fresher
I am live in Kolhapur
Shivaji University Kolhapur

Q1. Java subject interview question
Add your answer
Q2. Java subject asking me please
Add your answer

Q1. Technically questions they are asking
Add your answer
Q2. Migration errors
Add your answer

Q1. Package and team handling
Add your answer

Q1. Simple interview questions on MySQL
Add your answer
Q2. Difference between Storage engines
Ans. 
Storage engines are components that handle the storage, retrieval, and indexing of data in a database management system.
• Different storage engines have different features and capabilities.

• Examples of storage engines include InnoDB, MyISAM, and MongoDB.

• InnoDB is known for its support of transactions and foreign keys.

• MyISAM is known for its simplicity and fast read operations.

• MongoDB is a NoSQL database that uses a docume
Answered by AI
Add your answer
Q3. MySQL Crash recovery
Add your answer

Q1. They asked basic details of a database
Add your answer