A2Z Infraservices Software Testing Engineer Interview Questions and Answers

What is DBa role do when they find out issue on tablepsace

Q1. What is oracle database?
Ans. 
Oracle database is a relational database management system developed by Oracle Corporation.
• Oracle database is used for storing and managing data in a structured format.

• It supports SQL as a query language for accessing and manipulating data.

• Oracle database offers features like data security, scalability, and high availability.

• Examples of Oracle database editions include Oracle Database Standard Edition, Enterprise Editi
Answered by AI
Add your answer
Q2. Expain oracle database architecture?
Ans. 
Oracle database architecture is a multi-tiered system with components like client, server, and storage.
• Consists of physical and logical structures

• Includes processes like SQL processing, memory management, and I/O management

• Client communicates with server through SQL*Net

• Server manages data storage and retrieval

• Storage includes data files, control files, and redo log files
Answered by AI
Add your answer

Basic accounting knowledge and account software and compliance required

Q1. Basice knowledge of accounting
Add your answer

Basic logical pogrmaminh

Smaall cart mabnagenebt system i have to built from scratch in laravel

Q1. Technical question about technologies
Add your answer
Q2. Negaotiation ha done in this
Add your answer

Q1. Why are interested to work at Sodexo
Add your answer
Q2. Do you know the job at canteen
Add your answer

Q1. How to clean the raw data
Ans. 
Raw data can be cleaned by removing duplicates, handling missing values, standardizing formats, and correcting errors.
• Remove duplicates by identifying unique identifiers and filtering out redundant entries.

• Handle missing values by imputing with mean, median, or mode values or removing rows with missing data.

• Standardize formats by converting data into a consistent format (e.g. date formats, units of measurement).

• Correct...read more
Answered by AI
Add your answer
Q2. How to give relationship for two tables.
Ans. 
To establish a relationship between two tables, use a common key or field that links the records in both tables.
• Use primary and foreign keys to establish relationships between tables.

• Primary key in one table should match the foreign key in another table.

• Types of relationships include one-to-one, one-to-many, and many-to-many.

• Examples: CustomerID in a Customers table can be linked to CustomerID in Orders table.
Answered by AI
Add your answer