Hot Topics
PWC Solution
Technical Round
What is the result if we do following Null + 90?
The result of adding a null value and 90 will be null or undefined. In most programming languages, the result of an operation involving a null or undefined value is also null or undefined. This is because a null value represents the absence of a value and cannot be used in mathematical operations.
Loop over the words in a sentence backwards.
Here is an example of how you could loop over the words in a sentence backwards in Python:
sentence = "Loop over the words in a sentence backwards"
words = sentence.split()
for word in reversed(words):
print(word)
/*
output:
backwards
sentence
a
in
words
the
over
Loop
*/How to retrieve unique rows from database without using Distinct or Unique keyword / how to retrieve first five rows from database?
To retrieve unique rows from a database without using the DISTINCT or UNIQUE keyword, you can store the results of your query in a temporary table and then select the unique rows from that table. Here’s an example in SQL:
CREATE TEMPORARY TABLE temp_table AS
SELECT *
FROM original_table;
SELECT *
FROM temp_table
GROUP BY column1, column2, column3;
To retrieve the first five rows from a database, you can use the LIMIT keyword in SQL. Here’s an example:
SELECT *
FROM table_name
LIMIT 5;
This will return the first five rows of the table. Note that the order of the rows returned by the query may not be predictable, unless you specify an ORDER BY clause.
What does SDLC stand for?
SDLC stands for software development life cycle which is a 6 stage process that involves different stages:
Planning and Requirement analysis
Defining Requirements
Designing Architecture
Developing Product
Product Testing and Integration
Documentation, Training and Support
Automata Fixing