Find Interview Questions for Top Companies
Ques:- Choose the statement used to manually de-allocate the extents used by a rollback segment. A. ALTER ROLLBACK SEGMENT R01 DEALLOCATE;B. ALTER ROLLBACK SEGMENT RO1 DROP EXTENTS;C. ALTER ROLLBACK SEGMENT RO1 SHRINK;D. ALTER ROLLBACK SEGMENT RO1 SIZE 10
Right Answer:
A. ALTER ROLLBACK SEGMENT R01 DEALLOCATE;
Ques:- “An army travels 50 miles long at a constant rate. A courier standing at the rear moves forward and delivers the message to the first person and then turns back and reaches the rear of the army as the army completes 50 miles. Find the distance travelled by the courier.”
Right Answer:
The distance travelled by the courier is 50 miles.
Ques:- There is a frog who can make jumps of length 3,5,7. There are stones in a river at distances a1, a2 an. The other end of the stream is n distance away. Can the frog cross the stream. What if the frog can make jumps backwards ?
Right Answer:
Yes, the frog can cross the stream if it can make jumps of lengths 3, 5, and 7, and if the distances of the stones allow for combinations of these jumps to reach or exceed the distance n. If the frog can also jump backwards, it increases the possibilities for reaching the other side, making it more likely to cross the stream.
Ques:- User JAMES has a table named JOBS created on the tablespace USERS. When you issue the following statement, what effect will it have on the JOBS table?ALTER USER JAMES QUOTA 0 ON USERS;a. No more rows can be added to the JOBS tableb. No blocks can be allo
Right Answer:
a. No more rows can be added to the JOBS table.
Ques:- Two employees were there. Employee one says to employee two — your work experience twice as me amp; employee2 to employee1 but two years before you said that your work experience is thrice as me. Employee2 said yes its also true. What are their work experience?…
Right Answer:
Employee 1 has 2 years of work experience, and Employee 2 has 4 years of work experience.
Ques:- What is the difference when Flex mode is mode on and when it is off?
Right Answer:
When Flex mode is on, it allows for more dynamic and flexible configurations in the system, enabling users to customize fields and layouts based on their needs. When Flex mode is off, the system operates in a more rigid structure with predefined configurations, limiting customization options.
Ques:- Choose the option that is not true.a. Oracle creates a profile named DEFAULT when the database is created. b. Profiles cannot be renamed. c. DEFULT is a valid name for a profile resource. d. The SESSIONS_PER_USER resource in the DEFAULT profile initially
Right Answer:
c. DEFULT is a valid name for a profile resource.
Ques:- Do you feel pressure in your job? Tell me about it.
Right Answer:
Yes, I do experience pressure in my job, especially when meeting tight deadlines or resolving critical issues. However, I manage it by prioritizing tasks, staying organized, and maintaining clear communication with my team.
Ques:- A person needs 6 steps to cover a distance of one slab. If he increases his foot length (step length) by 3 inches, he needs only 5 steps to cover the slabs length. What is the length of the each slab
Right Answer:
The length of each slab is 30 inches.
Comments
Gary Aug 23, 2021

90 inches

Slab = 6(x) where x is each step
Slab = 5(x + 3)

6(x) = 5(x + 3)
6(x) = 5(x) + 15
x = 15 inches

So 6(x) = 6(15) = 90

Check: 5( x + 3) = 5(18) = 90

Slab size is 90 inches

Bella Jul 17, 2021

18inches

Ques:- Some cats got together to decide killing the 999919 mice, each cat kills equal no. of mice and each cat kills more no. of mice than cats there were. Then what are the number of cats?
Right Answer:
The number of cats is 999.
Ques:- 2 men r playing tossing a coin. If one of them wins he gets 1$ from the loser. At the end of a no. of games, one of them had lost 3$ and the other won 3 times. How many games did they play?
Right Answer:
They played 6 games.
Comments
Admin Sep 29, 2022

Let and A and B are playing and A has 3$ and B won 3 times.

Total money earn by A = no of games A won - no of games A loss
if A loss game means B won.
Therefore
Total money earn by A = no of games A won - no of games B won
3 = no of games A won -3
no of games A won=6
So
A won = 6 games
B won = 3 games

Hence total no of games is 9

Ques:- The length and breadth of of a rectangle is in the ratio 7:5. If the length decreases by 5 and the breadth increases by 2, then the area of it was 65 sq-km. Find the actual length and breath of the rectangle.
Right Answer:
The actual length of the rectangle is 21 km and the breadth is 15 km.
Ques:- Which statement is false?A. Dictionary-managed temporary tablespace can be made permanent.B. The size of the locally managed temporary tablespace file cannot be changed. C. Once created, the extent management of a tablespace cannot be altered. D. A loc
Right Answer:
A. Dictionary-managed temporary tablespace can be made permanent.
Ques:- What happens if you create a rollback segment in the same tablespace where application data is stored? Choose the best answer. A. The tablespace will be fragmented. B. Performance improves, because when changes are made, undo information can be written
Right Answer:
B. Performance improves, because when changes are made, undo information can be written.
Ques:- The average age of a class is 15.8 years. The average age of boys in the class is 16.4 years while that of girls is 15.4 years. What is the ratio of boys to girls in the class?
Right Answer:
The ratio of boys to girls in the class is 4:3.
Comments
Ketan Dec 4, 2021

2:3



The ERP (Enterprise Resource Planning) category on takluu.com is tailored for professionals and aspirants preparing for interviews in business operations, IT, finance, and supply chain management domains. ERP systems unify multiple business functions such as finance, human resources, procurement, inventory management, and customer relationship management into a single integrated platform.

This category covers fundamental concepts like ERP architecture, modules, implementation strategies, customization, and integration with other software systems. Popular ERP solutions like SAP, Oracle ERP, Microsoft Dynamics, and NetSuite are also discussed, giving candidates a broad understanding of industry-standard tools.

Interview questions typically explore your knowledge of business process automation, data migration, user roles, report generation, and troubleshooting common ERP challenges. Understanding the benefits and limitations of ERP, along with hands-on experience in configuring workflows and managing user access, is highly valued.

ERP roles often require collaboration across departments to streamline operations, ensure data consistency, and improve decision-making capabilities. This category prepares you for roles such as ERP Consultant, Business Analyst, Functional Consultant, and ERP Project Manager by offering practical insights and scenario-based questions.

At Takluu, we provide detailed study materials, real-world case studies, and mock interview questions to help you confidently demonstrate your ERP expertise. Whether you are new to ERP systems or seeking to advance your career, this category equips you with the knowledge to successfully clear technical and functional interviews.

AmbitionBox Logo

What makes Takluu valuable for interview preparation?

1 Lakh+
Companies
6 Lakh+
Interview Questions
50K+
Job Profiles
20K+
Users