Novel Office Data Analyst Interview Questions and Answers for Experienced

Q1. Tell about yourself
Add your answer

Q1. Basic of sql and excel
Add your answer
Q2. What is joins and types oj joins
Ans. 
Joins are used in databases 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 t...read more
Answered by AI
Add your answer

Manager round general questions about joining

Some basic sql questions

Q1. How many spheres can be accomadated in a bus if dimensions provided?
Ans. 
The number of spheres that can be accommodated in a bus depends on the dimensions of the bus and the size of the spheres.
• Calculate the volume of the bus using its dimensions

• Calculate the volume of a sphere using its radius

• Divide the volume of the bus by the volume of a sphere to get the maximum number of spheres that can fit
Answered by AI
Add your answer

Q1. TDS sections with limitations
Ans. 
TDS sections with limitations refer to the various sections of the Income Tax Act that specify the maximum amount of tax that can be deducted at source.
• TDS section 192 limits the deduction of tax at source on salary income

• TDS section 194 limits the deduction of tax at source on interest income

• TDS section 194A limits the deduction of tax at source on interest other than interest on securities
Answered by AI
Add your answer
Q2. GST compliances Basic
Add your answer

Q1. Tell me About Yourself
Ans. 
Experienced executive accountant with a strong track record in financial management and strategic planning.
• Over 10 years of experience in accounting and finance

• Expertise in budgeting, forecasting, and financial analysis

• Proven ability to streamline processes and improve efficiency

• Strong communication and leadership skills

• Previously managed a team of accountants at XYZ Corporation
Answered by AI
Add your answer
Q2. Tell us About your experience
Add your answer

Q1. GST,TDS and Journal Entries questions
Add your answer

Q1. Tell us about yourself
Add your answer
Q2. Tell us about your experiance
Add your answer

Q1. Tell us about Yourself
Add your answer
Q2. Tell Us about your company
Add your answer
Q3. Tell us about your role & responsibility
Add your answer
Q4. What do you know about the company
Add your answer

Q1. Painting Quantity & type of paint?
Ans. 
The painting quantity and type of paint depend on the project requirements and specifications.
• The painting quantity is determined by the surface area to be painted and the number of coats required.

• The type of paint depends on factors such as the surface material, desired finish, and environmental conditions.

• Common types of paint include acrylic, latex, oil-based, and epoxy paints.

• The quantity and type of paint may vary...read more
Answered by AI
Add your answer
Q2. Bar bending schedule & Reinforcement details?
Ans. 
Bar bending schedule is a document that provides details about the reinforcement steel bars used in a construction project.
• Bar bending schedule (BBS) is prepared by a structural engineer or a detailer.

• It includes information about the size, shape, and quantity of reinforcement bars required for each structural element.

• BBS helps in estimating the amount of steel required, ordering materials, and ensuring proper placemen...read more
Answered by AI
Add your answer
Q3. How to calculate Block work Quantity?
Ans. 
Block work quantity can be calculated by measuring the dimensions of the blocks and the area to be covered.
• Measure the length, width, and height of the blocks

• Calculate the volume of each block by multiplying the length, width, and height

• Determine the area to be covered by measuring the length and height of the wall

• Divide the area by the volume of each block to get the quantity needed

• Consider adding extra blocks for was
Answered by AI
Add your answer

Q1. Formula of interest
Ans. 
The formula for calculating interest is Principal x Rate x Time.
• Interest is calculated by multiplying the principal amount, the interest rate, and the time period.

• The formula is: Interest = Principal x Rate x Time

• For example, if you have a principal amount of $1000, an interest rate of 5%, and a time period of 1 year, the interest would be $50.
Answered by AI
Add your answer

Q1. Diffirence between project and project engineering
Ans. 
Project refers to a specific task with a defined start and end, while project engineering involves the technical aspects of planning, designing, and executing the project.
• Project is the overall task or objective to be completed within a specific timeframe.

• Project engineering focuses on the technical aspects such as planning, designing, and executing the project.

• Project management involves coordinating resources and tas...read more
Answered by AI
Add your answer
Q2. Types of services in interior fitout
Ans. 
Types of services in interior fitout include design, construction, project management, and installation.
• Design services involve creating layouts, selecting materials, and creating 3D visualizations.

• Construction services include building partitions, ceilings, and flooring.

• Project management services involve coordinating schedules, budgets, and contractors.

• Installation services include fitting furniture, fixtures, and eq...read more
Answered by AI
Add your answer

Q1. Problems faced in site
Ans. 
Some common problems faced on site include delays in material delivery, inclement weather, and coordination issues.
• Delays in material delivery can impact project timelines and budgets

• Inclement weather can halt work progress and cause safety concerns

• Coordination issues between different teams can lead to misunderstandings and errors
Answered by AI
Add your answer
Q2. Difference between agreement and bond
Ans. 
Agreement is a mutual understanding between parties, while a bond is a legal document that ensures fulfillment of obligations.
• Agreement is a mutual understanding between two or more parties.

• A bond is a legal document that guarantees the fulfillment of obligations.

• Agreements are usually informal and may not always be legally binding.

• Bonds are formal and legally enforceable documents.

• Examples of agreements include contra...read more
Answered by AI
Add your answer