AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
CommerceIQ
Compare
Filter interviews by
CommerceIQ Office Administrator Interview Questions and Answers
CommerceIQ Office Administrator Interview Experiences
1 interview found
Anonymous
Selected
I applied via Naukri.com and was interviewed in Aug 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Excel and Google sheet
- Q2. Excel knowledge, Admin related
(1 Question)
- Q1. Salary and benefits
Interview questions from similar companies
Interview Questionnaire
9 Questions
- Q1. Questions related to the work done at my previous company
- Q2. Find if a given directed graph is cyclic or not
- Ans.
To check if a directed graph is cyclic or not
Use Depth First Search (DFS) algorithm to traverse the graph
Maintain a visited set to keep track of visited nodes
Maintain a recursion stack to keep track of nodes in the current DFS traversal
If a node is visited and is already in the recursion stack, then the graph is cyclic
If DFS traversal completes without finding a cycle, then the graph is acyclic
- Q3. You have a stream of bytes from which you can read one byte at a time. You only have enough space to store one byte. After processing those bytes, you have to return a random byte. Note: The probability of...
- Ans.
Return a random byte from a stream of bytes with equal probability.
Create a variable to store the count of bytes read
Create a variable to store the current random byte
For each byte read, generate a random number between 0 and the count of bytes read
If the random number is 0, store the current byte as the random byte
Return the random byte
- Q4. Find if a given Binary Tree is BST or not
- Ans.
Check if a binary tree is a binary search tree or not.
Traverse the tree in-order and check if the values are in ascending order.
For each node, check if its value is greater than the maximum value of its left subtree and less than the minimum value of its right subtree.
Use recursion to check if all nodes in the tree satisfy the above condition.
- Q5. Devise an algorithm to determine the Nth-to-Last element in a singly linked list of unknown length. If N = 0, then your algorithm must return the last element. You should parse the list only once
- Ans.
Algorithm to find Nth-to-Last element in a singly linked list of unknown length
Traverse the list and maintain two pointers, one at the beginning and one at Nth node from beginning
Move both pointers simultaneously until the second pointer reaches the end of the list
The first pointer will be pointing to the Nth-to-Last element
If N=0, return the last element
Parse the list only once
- Q6. Given an array of integers, print all possible permutations. Also explain your approach
- Ans.
Print all possible permutations of an array of integers
Use recursion to swap elements and generate permutations
Start with the first element and swap it with each subsequent element
Repeat the process for the remaining elements
Stop when all elements have been swapped with the first element
Print each permutation as it is generated
- Q7. Design a Stack DS that also prints in O(1) the minimum element you pushed in the stack
- Ans.
Design a stack that prints the minimum element pushed in O(1)
Use two stacks, one for storing elements and another for storing minimums
When pushing an element, compare it with the top of minimum stack and push the smaller one
When popping an element, pop from both stacks
To get the minimum element, just return the top of minimum stack
- Q8. Given a linked list with loop, how would you find the starting point of the loop ?
- Ans.
To find the starting point of a loop in a linked list, use Floyd's cycle-finding algorithm.
Use two pointers, one moving at twice the speed of the other.
When they meet, move one pointer to the head of the list and keep the other at the meeting point.
Move both pointers one step at a time until they meet again, which is the starting point of the loop.
- Q9. Find a number a matrix mat[m][n] where all the rows and columns are sorted non-decreasingly. What will be the complexity of the solution
- Ans.
To find a number in a matrix where all rows and columns are sorted non-decreasingly. Complexity of the solution.
Use binary search to find the number in each row and column
Start from the top-right corner or bottom-left corner to optimize search
Time complexity: O(m log n) or O(n log m) depending on the starting corner
Interview Preparation Tips
College Name: Na
Skills evaluated in this interview
I appeared for an interview before Apr 2021.
(2 Questions)
Round duration - 90 minutes
Round difficulty - Easy
It was on online objective test consisting of 4 sections: Aptitude, Technical MCQs, Code snippet based MCQs and Coding part.
- Q1.
Valid Parentheses Problem Statement
Given a string 'STR' consisting solely of the characters “{”, “}”, “(”, “)”, “[” and “]”, determine if the parentheses are balanced.
Input:
The first line contains an... - Ans.
The task is to determine if a given string of parentheses is balanced or not.
Iterate through the characters of the string and use a stack to keep track of opening parentheses.
When encountering an opening parenthesis, push it onto the stack. When encountering a closing parenthesis, check if it matches the top of the stack.
If the stack is empty at the end or there are unmatched parentheses, the string is not balanced.
Exa...
- Q2.
Palindrome Linked List Problem Statement
Determine if a given singly linked list of integers is a palindrome. Return
trueif it is a palindrome, otherwise returnfalse.Example:
Input:
1 -> 2 -> ...
- Ans.
Check if a given singly linked list of integers is a palindrome.
Use two pointers to find the middle of the linked list.
Reverse the second half of the linked list.
Compare the first half with the reversed second half to determine if it is a palindrome.
(3 Questions)
Round duration - 60 minutes
Round difficulty - Easy
This was a technical and managerial round. The interviewer gave me a situation where I am in testing team and I found that customer requirement was drop down list at a place but developer has used bullet selection, and is not ready to change it. How will you manage? I gave some good replies and he was convinced.
- Q1. What is a virtual function?
- Ans.
A virtual function is a function in a base class that is declared using the keyword 'virtual' and can be overridden by a function with the same signature in a derived class.
Virtual functions allow for dynamic polymorphism in object-oriented programming.
They are used to achieve runtime polymorphism by enabling late binding.
Virtual functions are declared in a base class and can be overridden in derived classes.
Example: v...
- Q2. Can you explain how to perform a level order traversal of a binary tree in spiral form?
- Ans.
Level order traversal of a binary tree in spiral form involves alternating between left and right while traversing each level.
Start by pushing the root node into a queue.
While the queue is not empty, pop a node, print its value, and push its children into the queue.
For each level, alternate between popping nodes from the queue and printing their values from left to right or right to left.
Continue this process until all
- Q3. What are abstract classes in C++?
- Ans.
Abstract classes in C++ are classes that cannot be instantiated and are designed to be base classes for other classes.
Abstract classes may contain pure virtual functions, making them incomplete and unable to be instantiated.
Derived classes must implement all pure virtual functions from the abstract class in order to be concrete classes.
Abstract classes can have non-virtual functions and member variables like regular cl...
(6 Questions)
Round duration - 60 minutes
Round difficulty - Easy
This was also a technical round. He asked to optimize the code I wrote in coding round. Then he asked me a few puzzles and questions on OOPS, OS and DBMS.
- Q1. Can you explain the ACID properties in the context of database management systems?
- Ans.
ACID properties are a set of properties that guarantee the reliability of transactions in database management systems.
ACID stands for Atomicity, Consistency, Isolation, and Durability.
Atomicity ensures that either all operations in a transaction are completed successfully or none of them are.
Consistency ensures that the database remains in a consistent state before and after the transaction.
Isolation ensures that the e...
- Q2. What is the difference between paging and segmentation in operating systems?
- Ans.
Paging and segmentation are memory management techniques in operating systems.
Paging divides physical memory into fixed-size blocks called pages, while segmentation divides logical memory into variable-size segments.
Paging allows for efficient memory allocation and management, while segmentation provides protection and sharing of memory.
Paging is simpler to implement but can lead to internal fragmentation, while segmen...
- Q3. What is concurrency control?
- Ans.
Concurrency control is a technique used in databases to manage simultaneous access and modification of data by multiple users or processes.
Concurrency control ensures that transactions are executed in a way that maintains data consistency and integrity.
Techniques like locking, timestamp ordering, and optimistic concurrency control are used to implement concurrency control.
For example, in a banking system, concurrency c...
- Q4. What is the difference between String Buffer and String Builder in Java?
- Ans.
String Buffer is synchronized and thread-safe, while String Builder is not synchronized and faster.
String Buffer is synchronized, making it thread-safe for use in multi-threaded environments.
String Builder is not synchronized, resulting in faster performance but not thread-safe.
String Builder is preferred for single-threaded operations, while String Buffer is preferred for multi-threaded operations.
- Q5. What are smart pointers in C++?
- Ans.
Smart pointers in C++ are objects that act like pointers but provide automatic memory management.
Smart pointers help prevent memory leaks by automatically managing memory allocation and deallocation.
Examples include unique_ptr, shared_ptr, and weak_ptr.
unique_ptr is used for exclusive ownership, shared_ptr for shared ownership, and weak_ptr to prevent circular references.
- Q6. What is the difference between a mutex and a semaphore?
- Ans.
Mutex is used for exclusive access to a resource, while semaphore is used for controlling access to a resource by multiple threads.
Mutex is binary and allows only one thread to access the resource at a time.
Semaphore can have a count greater than one, allowing multiple threads to access the resource simultaneously.
Mutex is typically used for protecting critical sections of code, while semaphore is used for synchronizat...
Interview Preparation Tips
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
Skills evaluated in this interview
I appeared for an interview before Apr 2021.
(2 Questions)
Round duration - 60 minutes
Round difficulty - Easy
The second round is also written but you need to write programming based on their concept.
- Q1.
Prime Numbers Identification
Given a positive integer
N, your task is to identify all prime numbers less than or equal toN.Explanation:
A prime number is a natural number greater than 1 that has no po...
- Ans.
Identify all prime numbers less than or equal to a given positive integer N.
Iterate from 2 to N and check if each number is prime
Use the Sieve of Eratosthenes algorithm for better efficiency
Optimize by only checking up to the square root of N for divisors
- Q2.
Palindrome String Validation
Determine if a given string 'S' is a palindrome, considering only alphanumeric characters and ignoring spaces and symbols.
Note:
The string 'S' should be evaluated in a case... - Ans.
Check if a given string is a palindrome after removing special characters, spaces, and converting to lowercase.
Remove special characters and spaces from the string
Convert the string to lowercase
Check if the modified string is a palindrome by comparing characters from start and end
(6 Questions)
Round duration - 60 minutes
Round difficulty - Easy
Technical round with questions mainly on Java and OOPS concepts.
- Q1. What is the difference between static methods and instance methods in Java?
- Ans.
Static methods belong to the class itself, while instance methods belong to individual objects of the class.
Static methods are called using the class name, while instance methods are called using object references.
Static methods cannot access instance variables directly, while instance methods can access both static and instance variables.
Static methods are shared among all instances of the class, while instance method...
- Q2. What is the difference between an abstract class and an interface in Java?
- Ans.
Abstract class can have both abstract and non-abstract methods, while interface can only have abstract methods.
Abstract class can have constructors, member variables, and methods with implementation.
Interface can only have abstract methods and constants.
A class can implement multiple interfaces but can only extend one abstract class.
Example: Abstract class - Animal with abstract method 'eat', Interface - Flyable with m
- Q3. What is the difference between ClassNotFoundException and NoClassDefFoundError in Java?
- Ans.
ClassNotFoundException occurs when a class is not found during runtime, while NoClassDefFoundError occurs when a class was found during compilation but not during runtime.
ClassNotFoundException is a checked exception, while NoClassDefFoundError is an Error.
ClassNotFoundException occurs when a class is not found at runtime, usually due to a missing classpath or incorrect class name.
NoClassDefFoundError occurs when a cla...
- Q4. What is the difference between an Error and an Exception in Java?
- Ans.
Error is a serious issue that cannot be handled at runtime, while Exception is a recoverable issue that can be caught and handled.
Error is a subclass of Throwable and is usually caused by the environment or system, such as running out of memory or stack overflow.
Exception is also a subclass of Throwable but is caused by the application code, such as invalid input or file not found.
Errors are unchecked and are not meant...
- Q5. What is SerialVersionUID in Java?
- Ans.
SerialVersionUID is a unique identifier used by Java to ensure the compatibility of serialized objects.
SerialVersionUID is a static final long variable in a class that implements Serializable interface.
It is used to ensure that the serialized object can be deserialized correctly even if the class definition has changed.
If the SerialVersionUID of the serialized object does not match the one in the class, an InvalidClass...
- Q6. What are the requirements for creating an immutable class in Java?
- Ans.
Requirements for creating an immutable class in Java
Make the class final so it cannot be extended
Make all fields private and final
Do not provide setter methods, only getter methods
Ensure that mutable objects are not returned in getter methods
Override equals() and hashCode() methods for proper comparison
Consider making defensive copies of mutable fields in constructor or getter methods
Interview Preparation Tips
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
Skills evaluated in this interview
I applied via Company Website and was interviewed before May 2018. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Questions about Oops, data structures based on the projects I had done, and my resume
- Q2. Questions about classes and abstraction
Interview Preparation Tips
Shubham Jain
Interview Questionnaire
3 Questions
- Q1. Write a program for snake traversal of binary tree
- Ans.
Program for snake traversal of binary tree
Use a stack to keep track of nodes to be visited
Start with the root node and push it onto the stack
While the stack is not empty, pop a node and print its value
If the level is even, push the left child first and then the right child onto the stack
If the level is odd, push the right child first and then the left child onto the stack
- Q2. To write code to check linked list is palindrome or not, in a single traversal and without using any other data structure
- Ans.
Code to check if linked list is palindrome without using any other data structure and in a single traversal.
Traverse the linked list using two pointers, one slow and one fast
Reverse the first half of the linked list while traversing
Compare the reversed first half with the second half of the linked list
- Q3. Asked about OOPS concepts like abstraction, encapsulation, inheritance and polymorphism in detail and how they are implemented while programming
Interview Preparation Tips
Experience: It was on online objective test consisting of 4 sections: Aptitude, Technical MCQs, Code snippet based MCQs and Coding part.
Coding part had questions like balanced parenthesis check, etc.
Round: Technical Interview
Experience: Technical and managerial. Gave me a situation where I am in testing team and I found that customer requirement was drop down list at a place but developer has used bullet selection, and is not ready to change it. How will you manage? I gave some good replies and he was convinced.
Then he asked 25 horses puzzle (-----.php/puzzles/25-horses-3-fastest-5-races-puzzle/). I solved it.
He then asked me to code it. I wrote an algorithm first and then the code. He was very impressed.
He asked about virtual functions, abstract classes, pure virtual functions.
Round: Technical Interview
Experience: He asked to optimize the code I wrote in coding round.
Then he asked me candle puzzle on how to measure 30 min and 45 min.
Then he asked me the chocolate puzzle (-----.html).
What is paging and segmentation?
What are ACID properties in DBMS?
What is transaction and how is concurrency control done?
What is the difference between string builder and string buffer?
What is string pool in java?
What is JVM, JRE, JDK?
Differentiate between mutex and semaphore?
Can you override private and static members?
Contiguous and non-contiguous memory allocation?
What are Smart pointers?
Skills:
College Name: NIT Jalandhar
Skills evaluated in this interview
Interview Preparation Tips
Experience: PAPER DURATION: 3 hours
NO. OF QUESTIONS: 2 (20 marks each)
MAXIMUM MARKS: 20*2 = 40 marksQUESTION 1:
JSON Prettier:-Write a program which takes JSON as input and gives prettified JSONYou need to read JSON from STDIN. Input gives one line of uglified JSON.Output should be formatted JSON. Check the standard output link.Use 2 white spaces (not‘\t’) for one indentation.SAMPLE INPUT:{“group” : {list : [1,2,3]}, “list” : [“a”,”b”,”c”]}SAMPLE OUTPUT:{“group” : {List : [1,2,3]},“list” : [“a”,”b”,”c”]}EXPLANATION: Input will be uglifiedjson in one line and output will be prettified format of that. QUESTION 2:XML parse plus series computationEvaluate an expression given in XML format. Keys will be Expr- contains the entire expression. Elem – contains the digit, sum, Prod- contains two or more keys whose evaluation needs to be summed or multiplied respectively. Sub will contain 2 keys or more, where the second key onwards will have to be subtracted from the first one. Div- will contain 2 keys in which first key will need to be divided by second. SAMPLE INPUT:
20EXPLANATION:Input will be xml file through standard input. End of xml file marked by .
Duration: 180 minutes
Total Questions: 2
College Name: NA
I applied via Naukri.com and was interviewed before Jul 2019. There were 4 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Questions about the projects you worked with. About how specific coding challenges were solved. How it could have been done other ways. etc.
- Q2. About Python versions and differences. Impact on frameworks.
- Q3. About module design, apis.
Interview Preparation Tips
I applied via Approached by Company and was interviewed before Oct 2021. There were 4 interview rounds.
(2 Questions)
- Q1. Screening of the resume
- Q2. Regarding candidature
(1 Question)
- Q1. Related to job profile and technical requirements
(1 Question)
- Q1. Salary structure and the part of joining date
Interview Preparation Tips
Associate Software Engineer Interview Questions & Answers
Bravura Solutions
Ritik Rathore
posted on 1 Mar 2024
(1 Question)
- Q1. Project based, oops concepts, average dsa questions,
CommerceIQ Interview FAQs
Tell us how to improve this page.
CommerceIQ Interviews By Designations
- CommerceIQ Software Development Engineer Interview Questions
- CommerceIQ Business Associate Interview Questions
- CommerceIQ Senior Sdet Engineer Interview Questions
- CommerceIQ Senior Data Scientist Interview Questions
- CommerceIQ Back Office Executive Interview Questions
- CommerceIQ Software Engineer III Interview Questions
- CommerceIQ Office Administrator Interview Questions
Interview Questions for Popular Designations
- System Administrator Interview Questions
- Linux Administrator Interview Questions
- Network Administrator Interview Questions
- Oracle Database Administrator Interview Questions
- Linux System Administrator Interview Questions
- IT Administrator Interview Questions
- Senior System Administrator Interview Questions
- Salesforce Administrator Interview Questions
- Show more
CommerceIQ Office Administrator Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
|
Data Analyst
26
salaries
|  ₹2.5 L/yr - ₹10 L/yr |
|
Product Operations Analyst
15
salaries
| ₹5 L/yr - ₹7.5 L/yr |
|
Software Development Engineer
15
salaries
| ₹16 L/yr - ₹26 L/yr |
|
Customer Success Manager
13
salaries
| ₹17.1 L/yr - ₹28.2 L/yr |
|
MIS Executive
11
salaries
| ₹2.1 L/yr - ₹2.8 L/yr |
Yodlee
Fingent
Bravura Solutions
CloudMoyo
- Home >
- Interviews >
- CommerceIQ Interview Questions >
- CommerceIQ Office Administrator Interview Questions
