Onyx Mobile Interview Questions and Answers

Q1. About profession
Add your answer
Q2. About qualification
Add your answer

Q1. About yourself
Add your answer
Q2. Salary dissection
Add your answer

Q1. About digital marketing
Add your answer

Q1. What is the default index type
Ans. 
B-tree index is the default index type in Oracle database.
• Default index type in Oracle is B-tree index

• B-tree index is suitable for range queries and equality searches

• Other index types in Oracle include bitmap index and function-based index
Answered by AI
Add your answer
Q2. What is the causes of query slowness
Ans. 
Causes of query slowness can include inefficient queries, lack of indexes, outdated statistics, hardware limitations, and network latency.
• Inefficient queries - poorly written queries that do not utilize indexes or join tables unnecessarily

• Lack of indexes - missing indexes on columns frequently used in queries

• Outdated statistics - outdated or inaccurate statistics can lead to poor query execution plans

• Hardware limitatio...read more
Answered by AI
Add your answer
Q3. How to resolve query slowness
Ans. 
To resolve query slowness, analyze query execution plan, optimize indexes, update statistics, consider partitioning.
• Analyze query execution plan to identify bottlenecks

• Optimize indexes to improve query performance

• Update statistics to ensure the query optimizer has accurate information

• Consider partitioning large tables to improve query performance
Answered by AI
Add your answer

Q1. Introduction yourself
Ans. 
I am a dedicated PL/SQL developer with 5 years of experience in designing and implementing database solutions.
• Experienced in writing complex PL/SQL queries and stored procedures

• Proficient in performance tuning and optimization of SQL queries

• Skilled in database design and normalization principles

• Familiar with Oracle database technologies such as triggers and packages
Answered by AI
Add your answer
Q2. What is join and its types
Ans. 
Join is used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table

• FULL JOIN r...read more
Answered by AI
Add your answer

70 Technical and Aptitude mcqs to solve in 50 minutes

Q1. What is overloading and overriding?
Ans. 
Overloading is having multiple methods with the same name but different parameters. Overriding is implementing a method in a subclass that is already defined in the parent class.
• Overloading allows a class to have multiple methods with the same name but different parameters.

• Overriding occurs when a subclass provides a specific implementation of a method that is already provided by its parent class.

• Overloading is resolve...read more
Answered by AI
Add your answer
Q2. What is difference between Primary and unique key in dbms?
Ans. 
Primary key uniquely identifies a record in a table, while unique key ensures all values in a column are distinct.
• Primary key does not allow NULL values, while unique key allows one NULL value.

• A table can have only one primary key, but multiple unique keys.

• Primary key is a combination of unique and not null constraints.

• Primary key is used to establish relationships between tables, while unique key is used to enforce un
Answered by AI
Add your answer

Aptitude test is based on logical questions and small programs

Q1. All basics of core java and whatever you written in resume. ask about the your last projects. difference between then map, array list, collection, set etc.
Add your answer
Q2. General questions about the andorid studio. ask some logical questions
Add your answer

Q1. This will be HR round. general hr questions
Add your answer

Q1. What is MVC in Rails
Ans. 
MVC in Rails stands for Model-View-Controller, a design pattern that separates the application into three interconnected components.
• Model: Represents the data and business logic of the application

• View: Represents the user interface of the application

• Controller: Handles user input, interacts with the model, and updates the view

• Promotes code organization and separation of concerns
Answered by AI
Add your answer
Q2. What is active record
Ans. 
Active Record is an object-relational mapping (ORM) pattern in Ruby on Rails that simplifies database interactions.
• ORM pattern in Ruby on Rails

• Maps database tables to Ruby objects

• Provides methods for querying and manipulating data

• Example: User model in Rails represents users table in database
Answered by AI
Add your answer
Q3. Simple programming coding ques
Add your answer

Q1. About projects you have done
Add your answer

Q1. Basic exp details
Add your answer
Q2. Salary expectations
Add your answer

Inventory based task for web app

Q1. Overall exp discussion with CEO
Add your answer

Q1. Difference between list and set , different data types in python , questions on dictionary
Add your answer
Q2. SQL and table related questions and project discussion
Add your answer

Q1. Educational Background
Add your answer