i
Novel Office
Filter interviews by
Clear (1)
DELETE is used to remove rows from a table, while DROP is used to remove entire tables from a database.
DELETE is a DML command used to remove specific rows from a table based on a condition.
DROP is a DDL command used to remove entire tables, views, or databases from a database.
DELETE does not remove the table structure, only the data within it.
DROP removes the table structure along with all its data, and it cannot be r...
Primary Key in SQL is a unique identifier for each record in a table.
Primary Key ensures each record in a table is unique
It can consist of one or multiple columns
Primary Key values cannot be NULL
Example: 'id' column in a 'users' table
UNION combines and removes duplicates, UNION ALL combines without removing duplicates.
UNION merges the result sets of two or more SELECT statements, removing duplicates.
UNION ALL merges the result sets of two or more SELECT statements, including duplicates.
UNION is slower than UNION ALL as it involves removing duplicates.
Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;
Example: SELECT column1 FROM t
The LIKE operator is used in SQL to search for a specified pattern in a column.
The LIKE operator is used with the WHERE clause to search for a specified pattern in a column.
It allows for the use of wildcards such as % (matches any sequence of characters) and _ (matches any single character).
For example, 'SELECT * FROM table_name WHERE column_name LIKE 'a%'' will return all rows where the column starts with 'a'.
I applied via Referral and was interviewed in Feb 2023. There were 4 interview rounds.
1st round consists of IQ test followed by logical Reasoning Test if you clear you would be qualified for other rounds
Top trending discussions
I was interviewed in Dec 2024.
My short term goal is to enhance my data analysis skills through continuous learning and practical application.
Enroll in online courses or workshops to learn new data analysis techniques
Seek opportunities to work on real-world data analysis projects
Attend data analysis conferences or networking events to stay updated on industry trends
I applied via Company Website and was interviewed before May 2023. There was 1 interview round.
I applied via Approached by Company and was interviewed in Oct 2023. There were 3 interview rounds.
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...
Manager round general questions about joining
I applied via Instahyre and was interviewed before Jan 2024. There were 2 interview rounds.
Some basic sql questions
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
I applied via Naukri.com and was interviewed in May 2023. There were 3 interview rounds.
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...
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...
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
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...
I applied via LinkedIn and was interviewed before Sep 2023. There was 1 interview round.
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
I applied via Approached by Company and was interviewed in May 2024. There were 4 interview rounds.
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
based on 2 interviews
Interview experience
based on 11 reviews
Rating in categories
Data Analyst
36
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Development Manager
36
salaries
| ₹0 L/yr - ₹0 L/yr |
Project Engineer
23
salaries
| ₹0 L/yr - ₹0 L/yr |
HR Executive
16
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
13
salaries
| ₹0 L/yr - ₹0 L/yr |
Regus
WeWork India Management
Smartworks
Awfis