Uncategorized FrontEnd Screening Test Feb 22, 2025 Collab Team Contributor 0 Comment FrontEnd Screening Test 1 / 20 Which HTTP status code represents a successful request? 400 500 302 200 2 / 20 Which of the following is a CSS preprocessor? LESS SCSS SASS All of the above 3 / 20 In JavaScript, what is the purpose of the bind() method? To execute a function immediately To prevent function execution To modify function parameters To bind a function to a specific this context 4 / 20 What is the key benefit of using Virtual DOM in React? It directly modifies the real DOM It speeds up performance by reducing direct DOM manipulation It allows using different programming languages It enables automatic CSS styling 5 / 20 What is the purpose of a service worker in a PWA? To replace JavaScript To handle offline capabilities and caching To execute server-side logic A) To manage CSS styling B)C) D) 6 / 20 How do you prevent a default event behavior in JavaScript? event.stopPropagation() event.preventDefault() event.stop() event.cancelEvent() 7 / 20 Which of the following will NOT change the original array in JavaScript? pop() push() splice() map() 8 / 20 What is the purpose of React's useEffect hook? To manage side effects in functional components To modify the state To directly manipulate the DOM To replace setState 9 / 20 What is the difference between localStorage and sessionStorage? sessionStorage stores data permanently localStorage persists data even after the browser is closed Both store data permanently localStorage can store larger data than sessionStorage 10 / 20 What is a closure in JavaScript? A function that is executed immediately A function that returns another function A function that has access to variables from its outer scope A function with no parameters 11 / 20 What will be the output of console.log(typeof NaN)? Number NaN Undefined Null 12 / 20 Which of the following is NOT a valid JavaScript data type? Character Boolean Undefined Symbol 13 / 20 What is the difference between var, let, and const? const can be reassigned var cannot be reassigned, let and const can var is function-scoped, let and const are block-scoped let is globally available 14 / 20 What will be the output of console.log(0.1 + 0.2 === 0.3)? true NaN false undefined 15 / 20 What is the primary difference between == and === in JavaScript? === is faster than == == compares values, === compares values and types There is no difference == checks only data type, while === checks only value 16 / 20 In CSS Grid, what does grid-template-columns: repeat(3, 1fr); do? All of the above Creates 3 columns of equal width Creates a flexible column layout Creates a responsive design 17 / 20 What is the purpose of React’s useState hook? To handle API requests To replace Redux To manage component state in function components To manage global state 18 / 20 In React, which lifecycle method is invoked right after a component is inserted into the DOM? componentDidUpdate shouldComponentUpdate componentDidMount componentWillUnmount 19 / 20 In CSS, which unit is relative to the width of the viewport? vh px rem em 20 / 20 What is the difference between .call() and .apply() in JavaScript? .apply() is faster than .call() .call() executes a function asynchronously .apply() is used for defining class components .call() passes arguments separately, .apply() takes an array of arguments Your score isThe average score is 57% 0% Restart quiz
Uncategorized SQL Screening Test Feb 15, 2025 Collab Team Contributor 0 Comment SQL Screening Test 1 / 20 What will happen if you try to insert a duplicate value in a column with a UNIQUE constraint? It will return an error It will ignore the duplicate and insert It will replace the existing value It will insert successfully 2 / 20 In SQL, what does the COALESCE function do? Replaces NULL values with a default value Joins multiple tables Returns the first non-null value in a list Returns the last non-null value in a list 3 / 20 Which SQL clause is used to filter grouped records? HAVING GROUP BY WHERE ORDER BY 4 / 20 What is the default isolation level in SQL Server? READ UNCOMMITTED SERIALIZABLE REPEATABLE READ READ COMMITTED 5 / 20 What is the maximum number of clustered indexes allowed per table in SQL Server? 5 1 2 Unlimited 6 / 20 What happens when a NULL value is compared using the = operator? It returns NULL It throws an error It returns TRUE It returns FALSE 7 / 20 Which SQL statement is used to check for the existence of rows in a subquery? HAVING EXISTS JOIN IN 8 / 20 Which command is used to modify an existing table structure? ALTER MODIFY CHANGE UPDATE 9 / 20 Which SQL statement is used to remove all rows from a table without logging individual row deletions? TRUNCATE DELETE DROP REMOVE 10 / 20 What does the ROW_NUMBER() function do in SQL? Assigns a unique sequential number to rows Groups rows based on a column Returns the number of rows in a table Sorts rows in descending order 11 / 20 In SQL, what is the purpose of the RANK() function? Returns the number of rows in a table Computes the sum of a column Assigns a unique rank to each row with possible gaps Assigns a unique rank to each row without gaps 12 / 20 What is the function of the DISTINCT keyword in SQL? Filters out duplicate rows in query results Joins two tables on unique values Groups rows based on unique values Deletes duplicate rows permanently 13 / 20 Which SQL function is used to remove leading and trailing spaces from a string? TRIM() LTRIM() RTRIM() REPLACE() 14 / 20 What is the primary function of an index in SQL? To enforce referential integrity To define foreign key relationships To improve query performance To store duplicate records 15 / 20 What does the UNION operator do in SQL? Combines results of multiple SELECT queries without duplicates Merges two tables permanently Combines results of multiple SELECT queries with duplicates Joins two tables on a common key 16 / 20 What will happen if a subquery returns multiple rows in a scalar subquery context? It will return all row It will return NULL It will return only the first row It will cause an error 17 / 20 In SQL Server, which function is used to get the current system date and time? CURRENT_TIMESTAMP SYSDATE() GETDATE() NOW() 18 / 20 Which type of join includes all records from the left table and only matching records from the right table? FULL JOIN LEFT JOIN INNER JOIN RIGHT JOIN 19 / 20 What does the SQL CASE statement do? Defines conditional logic inside a query Checks foreign key constraints Handles NULL values Creates a new table 20 / 20 What will be the result of a CROSS JOIN between two tables with 5 and 10 rows respectively? 5 rows 10 rows 15 rows 50 rows Your score isThe average score is 38% 0% Restart quiz
Uncategorized Advance Excel Screening Test Feb 15, 2025 Collab Team Contributor 0 Comment Advance Excel Screening Test 1 / 20 What is the maximum number of conditions that can be used in an IF function in Excel? Unlimited 64 32 128 2 / 20 What does the DAX function CALCULATE do in Power BI? Changes the calculation context Filters data dynamically Both A and B Modifies row-level security 3 / 20 What will the formula =IFERROR(10/0,"Error!") return? Error! 0 NULL #DIV/0! 4 / 20 In Excel VBA, which statement is used to handle errors? TRY CATCH HANDLE ERROR ON ERROR GOTO ERROR TRAP 5 / 20 Which Excel feature allows automation without using VBA? Macros Data Validation Solver Power Query 6 / 20 Which of the following chart types is best for showing trends over time?A) Pie ChartB) Line ChartC) Scatter ChartD) Histogram Pie Chart Histogram Line Chart Scatter Chart 7 / 20 Which of the following functions will NOT return an array in Excel? SUMIF TRANSPOSE UNIQUE SEQUENCE 8 / 20 Which formula is used to extract the sheet name from a cell reference? =EXTRACTSHEET(A1) =SHEETNAME(A1) =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) =RIGHT(A1,FIND("]",A1)-1) 9 / 20 Which of the following functions can create dynamic dependent drop-down lists? UNIQUE CHOOSE INDIRECT TEXTJOIN 10 / 20 Which of the following functions is used to return the k-th percentile of a data set in Excel? QUARTILE PERCENTILE PERCENTRANK RANK 11 / 20 Which Excel function can return multiple values from an array? INDEX FILTER VLOOKUP MATCH 12 / 20 In Power Query, what does the "Append Queries" function do? Splits queries into multiple tables Removes duplicates from queries Combines queries by adding new rows Merges queries based on a key column 13 / 20 Which function is used to evaluate multiple conditions and return a value? Both A and C SWITCH IFS IF 14 / 20 What is the default delimiter in the TEXTSPLIT function? Comma (,) There is no default Semicolon (;) Space (" ") 15 / 20 Which function can be used to generate a unique list from a dataset? SORT TEXTJOIN UNIQUE FILTER 16 / 20 Which of the following formulas will correctly return the third-largest value in a range A1:A10? =INDEX(A1:A10, 3) =RANK(A1:A10, 3) =LARGE(A1:A10, 3) =MAX(A1:A10, 3) 17 / 20 What does Power Pivot primarily help with? Simple calculations File compression Data visualization Data modeling and relationships 18 / 20 Which function is used to return the address of a cell that matches a condition? ADDRESS INDEX CELL MATCH 19 / 20 In Excel, which formula is used to retrieve the column number of a reference? ROW() COLUMN() INDEX() MATCH() 20 / 20 What does the "Goal Seek" feature in Excel do? Performs statistical analysis Finds the maximum value in a dataset Creates pivot tables automatically Adjusts an input value to reach a desired output Your score isThe average score is 31% 0% Restart quiz
Uncategorized Python Online Screening Test Feb 8, 2025 Collab Team Contributor 0 Comment Python Online Screening Test 1 / 20 Which of the following is NOT a magic method in Python? __call__() __del__() __private__() __str__() 2 / 20 Which of the following is an immutable data type in Python? Set Dictionary Tuple List 3 / 20 Which module provides an efficient implementation of heap queue operations? collections heapq queue itertools 4 / 20 Which Python construct is used to prevent race conditions in multithreading? Semaphore GIL Lock ThreadPool 5 / 20 Which function is used in asyncio to run an event loop? asyncio.start() asyncio.run() asyncio.execute() asyncio.call() 6 / 20 Which of the following methods can be used to remove an item from a dictionary safely? del dict[key] dict.pop(key, None) dict.remove(key) dict.delete(key) 7 / 20 Which statement about Python’s Global Interpreter Lock (GIL) is true? It allows true parallel execution of threads. It is only present in Jython. It improves Python’s multithreading performance. It prevents multiple threads from executing Python bytecode simultaneously. 8 / 20 What is the output of print(type(type))? 9 / 20 Which of the following is true about Python multiple inheritance? Python uses the C3 Linearization (MRO) algorithm. Multiple inheritance is done using super() only. Parent class methods override child class methods. Python does not support multiple inheritance. 10 / 20 What will bool([]) return? False True Error None 11 / 20 What is the time complexity of accessing an element in a Python dictionary? O(n) O(log n) O(n^2) O(1) 12 / 20 Which method can be used to check if a class is a subclass of another class? isSubclass() checkSubclass() issubclass() isinstance() 13 / 20 Which function in threading module starts a new thread? thread.start() thread.call() thread.run() thread.execute() 14 / 20 Which module provides process-based parallelism in Python? multiprocessing concurrent.futures threading asyncio 15 / 20 Which data structure in Python maintains insertion order but does not allow duplicate keys? Dictionary (Python 3.7+) Set Tuple List 16 / 20 Which method is called when an object is created? __start__() __new__() __init__() __create__() 17 / 20 Which method is used to override an operator like + for a class? __add__() __plus__() __sum__() __operate__() 18 / 20 Which statement about Python sets is correct? Sets support indexing like lists. Sets provide O(1) average-time complexity for lookups. Sets are ordered collections. Sets allow duplicate elements. 19 / 20 What is the output of type(object())? Error None 20 / 20 Which function is used to dynamically import a module in Python? load_module() exec() importlib.import_module() __import__() Your score isThe average score is 45% 0% Restart quiz
Uncategorized Java Online Screening Test Feb 8, 2025 Collab Team Contributor 0 Comment Java Online Screening Test 1 / 20 Which class in Java is immutable by design? HashMap String ArrayList StringBuilder 2 / 20 Which functional interface does the forEach() method accept? Consumer Function Supplier Predicate 3 / 20 Which of the following is true about volatile in Java? It ensures atomicity. It replaces synchronized blocks. It locks the variable. It ensures visibility but not atomicity. 4 / 20 Which of the following is true about Java garbage collection? Developers must manually call the garbage collector. It can be explicitly controlled. It automatically removes unreachable objects. It guarantees that all unused objects are removed. 5 / 20 What will happen if join() is called on a thread? The joined thread waits for the calling thread. The program exits. The calling thread waits for the joined thread to finish. Both threads terminate immediately. 6 / 20 Which of the following is not a valid access modifier in Java? protected internal private public 7 / 20 Which method of ConcurrentHashMap is atomic? put() remove() get() computeIfAbsent() 8 / 20 What will happen if a thread calls the wait() method inside a synchronized block? It will go to the ready state. It will continue execution. It will throw an exception. It will release the lock and enter the waiting state. 9 / 20 What does the filter() method in Java Streams do? Modifies each element in the stream Filters elements based on a predicate Sorts elements in the stream Converts elements to another type 10 / 20 Which lock mechanism in Java provides explicit control over locking? synchronized block AtomicBoolean volatile keyword ReentrantLock 11 / 20 What is the default capacity of an ArrayList when initialized with an empty constructor? 5 8 16 10 12 / 20 Which Java feature ensures that an object is not modified once it is created? Polymorphism Serialization Immutability Encapsulation 13 / 20 Which collection class allows concurrent modification by multiple threads? LinkedList HashSet ArrayList CopyOnWriteArrayList 14 / 20 Which method is used to schedule a task for execution in ScheduledExecutorService? execute() schedule() run() start() 15 / 20 Which interface provides a method to retrieve elements sequentially from a collection? HashMap Enumeration Comparator Iterable 16 / 20 Which Java collection class does not allow duplicate keys but allows duplicate values? LinkedList TreeMap HashSet HashMap 17 / 20 What will Optional.ofNullable(null).orElse("Default") return? null NoSuchElementException d Compilation error "Default" 18 / 20 Which Java class is designed for thread-safe counter updates? AtomicInteger Semaphore ThreadLocal Integer 19 / 20 Which stream operation is terminal? filter() map() collect() flatMap() 20 / 20 Which functional interface represents an operation that takes one argument and returns a result? Supplier Runnable Consumer Function Your score isThe average score is 56% 0% Restart quiz
Uncategorized Mern Technology Screening Test Feb 7, 2025 Collab Team Contributor 0 Comment MERN Technology Screening Test 1 / 20 In MongoDB, which aggregation stage is used to reshape documents, adding or removing fields? $group $match $project $sort 2 / 20 Which built-in Node.js module is used to create an HTTP server? events net http fs 3 / 20 How do you handle errors globally in an Express.js application? Using res.send(error.message) Using a middleware with (err, req, res, next) signature Using process.exit() Using throw new Error() 4 / 20 What does process.nextTick() do in Node.js? Executes a function in the next event loop iteration Pauses the event loop Runs a function immediately Delays function execution indefinitely 5 / 20 What does req.params contain in an Express route handler? Request body HTTP headers Query string parameters Route parameters from the URL 6 / 20 Which command provides a detailed execution plan of a MongoDB query? profile() queryPlanner() find().stats() explain("executionStats") 7 / 20 Which of the following statements is true about Express.js routing? Routes support HTTP methods like GET, POST, PUT, DELETE Routes can be defined using app.use() Middleware runs after route handlers by default Routes must always be defined in separate files 8 / 20 Which of the following is a recommended way to perform transactions in MongoDB? Using findAndModify() Using bulkWrite() Using a replica set and startSession() Using updateMany() 9 / 20 Which of the following methods in Mongoose is used to populate referenced documents? populate() aggregate() lean() mapReduce() 10 / 20 What is the purpose of the cluster module in Node.js? To create and manage child processes for concurrency To run multiple instances of Express.js To manage database transactions To handle event-driven communication 11 / 20 How do you update state based on the previous state in React? setState(newValue) setState({ ...prevState, newValue }) this.state = newValue setState((prevState) => newValue) 12 / 20 What will happen if a function component in React returns null? It will default to rendering an empty <div> It will crash the application It will throw an error It will render nothing 13 / 20 Which middleware is commonly used to parse JSON request bodies in Express.js? multer body-parser express-validator cookie-parser 14 / 20 What is the primary purpose of using express.static()? To define middleware for error handling To define API routes To serve static files such as images and CSS To handle dynamic data rendering 15 / 20 Which Node.js module is used to work with file systems? fs path http stream 16 / 20 In React, why should we use keys in lists? To style list elements dynamically To improve performance by helping React identify changes To manage event handlers efficiently To store additional metadata 17 / 20 In Express.js, middleware functions have access to which of the following objects? req, res, and next req and next only res and next only req and res only 18 / 20 Which hook is used to handle side effects in functional components? useState() useEffect() useContext() useReducer() 19 / 20 What is the purpose of useMemo() in React? To perform side effects in functional components To handle lifecycle methods To memoize expensive calculations between renders To manage component state 20 / 20 Which MongoDB index type is best suited for queries involving text search? Text index Single-field index Geospatial index Compound index Your score isThe average score is 46% 0%