-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathInterviewQuestions
185 lines (106 loc) · 32.7 KB
/
InterviewQuestions
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
Problem Solving (Sample Easy Questions)
Write a program to find the prime numbers from 1 to 100.
Write a program to find the factorial of the number
Determine if a number is an Armstrong number or not
Write a Python program to reverse a string.
Write a Python program to check if a given string is a palindrome.
Write a Python program to print the Fibonacci sequence up to n terms
Write a Python program to find the largest among three numbers.
Write a Python program to count the occurrences of a specific element in a list.
Write a Python function to count the number of vowels in a string.
Write a Python program to print the even numbers in a list
Write a Python program to print the odd numbers in a list
Write a Python program to check if a given number is prime.
Problem Solving (Sample Medium Questions)
1.Kth Largest Element in an Array
Question:
Given an integer array nums and an integer k, return the kth largest element in the array.
Note that it is the kth largest element in the sorted order, not the kth distinct element.
Can you solve it without sorting?
Example:1
Input: nums = [3,2,1,5,6,4], k = 2 Output: 5 Example:2
Input: nums = [3,2,3,1,2,4,5,5,6], k = 4 Output: 4
Longest Substring Without Repeating Characters
Question:
Given a string s, find the length of the longest substring without repeating characters.
Example 1:
Input: s = "abcabcbb" Output: 3 Explanation: The answer is "abc", with the length of 3. Example 2:
Input: s = "bbbbb" Output: 1 Explanation: The answer is "b", with the length of 1.
Reverse Integer
Question:
Given a signed 32-bit integer x, return x with its digits reversed. If reversing x causes the value to go outside the signed 32-bit integer range [-231, 231 - 1], then return 0.
Assume the environment does not allow you to store 64-bit integers (signed or unsigned).
Example 1:
Input: x = 123 Output: 321 Example 2:
Input: x = -123 Output: -321
Rotate Array
Question:
Given an integer array nums, rotate the array to the right by k steps, where k is non-negative.
Example 1:
Input: nums = [1,2,3,4,5,6,7], k = 3 Output: [5,6,7,1,2,3,4] Explanation: rotate 1 steps to the right: [7,1,2,3,4,5,6] rotate 2 steps to the right: [6,7,1,2,3,4,5] rotate 3 steps to the right: [5,6,7,1,2,3,4] Example 2:
Input: nums = [-1,-100,3,99], k = 2 Output: [3,99,-1,-100] Explanation: rotate 1 steps to the right: [99,-1,-100,3] rotate 2 steps to the right: [3,99,-1,-100]
Longest Palindromic Substring
Question:
Given a string s, return the longest palindromic substring in s
Example 1:
Input: s = "babad" Output: "bab" Explanation: "aba" is also a valid answer. Example 2:
Input: s = "cbbd" Output: "bb"
Maximum Subarray
Question:
Given an integer array nums, find the subarray with the largest sum, and return its sum.
Example 1:
Input: nums = [-2,1,-3,4,-1,2,1,-5,4] Output: 6 Explanation: The subarray [4,-1,2,1] has the largest sum 6. Example 2:
Input: nums = [1] Output: 1 Explanation: The subarray [1] has the largest sum 1. Example 3:
Input: nums = [5,4,-1,7,8] Output: 23 Explanation: The subarray [5,4,-1,7,8] has the largest sum 23.
Transpose of a matrix.
Description:
Given a matrix A, return the transpose of A.
The transpose of a matrix is the matrix flipped over its main diagonal, switching the row and column indices of the matrix.
Input:
A list of lists A representing the matrix. The length of A is m and the length of each list inside A is n. (1 ≤ m, n ≤ 1000) Each element of the matrix is an integer in the range [-10^9, 10^9]. Output:
Return the transpose of the matrix A. Example:
Input: [ [1,2,3], [4,5,6], [7,8,9] ]
Output: [ [1,4,7], [2,5,8], [3,6,9] ]
Search a 2D Matrix
Question:
You are given an m x n integer matrix matrix with the following two properties:
Each row is sorted in non-decreasing order. The first integer of each row is greater than the last integer of the previous row. Given an integer target, return true if target is in matrix or false otherwise.
You must write a solution in O(log(m * n)) time complexity.
Example 1:
1 3 5 7 10 11 16 20 23 30 34 60
Input: matrix = [[1,3,5,7],[10,11,16,20],[23,30,34,60]], target = 3 Output: true Example 2:
1 3 5 7 10 11 16 20 23 30 34 60 Input: matrix = [[1,3,5,7],[10,11,16,20],[23,30,34,60]], target = 13 Output: false
HTML, CSS, Bootstrap, JavaScript, React, Python, SQL
HTML Easy Questions
What is HTML? How do you create hyperlinks in HTML? What are HTML tags? How do you insert an image in an HTML page? How do you create a list in HTML? How do you create a table in HTML? How do you use comments in HTML? How do you make text bold in HTML? How do you make text italic in HTML? How do you create a hyperlink that opens in a new tab? What is the purpose of the alt attribute for images? How do you create a dropdown list in HTML? What are inline elements and block-level elements in HTML? How do you include audio and video files in an HTML document? How do you create a navigation bar in HTML? What is an HTML fragment? How do you make an HTML element draggable? What are some new form elements introduced in HTML5? How do you make a web page HTML5 compliant? How do you validate HTML5 code? How do you handle multimedia files in HTML5? What are Web Workers in HTML5, and how do you use them? How do you create a responsive web design with HTML5? What are semantic tags in HTML5? Give examples. How do you handle graphical elements in HTML5? Explain the difference between cookies, sessionStorage, and localStorage in HTML5. How do you optimize a website's performance with HTML? What is the purpose of the bdi and bdo tags in HTML? How do you create a citation or a definition in HTML? How do you use the col and colgroup elements in HTML tables? How do you define a description list in HTML? What is the difference between em and strong tags? How do you use the embed tag in HTML5? How do you use the label tag in HTML forms? What is the purpose of the meter tag in HTML5? What is the role of the noscript tag in HTML? How do you use HTML5's picture element for responsive images? If you wanted to pass parameters, how would you pass them in a GET and a POST request? How we can create a form in HTML? What is HR tag in HTML?
HTML Medium Questions
Can you explain the basic structure of an HTML document? What's the difference between an element and a tag in HTML? Describe the difference between
and . What is the purpose of the doctype in an HTML document? What are HTML attributes? Explain the difference between id and class attributes. What is the purpose of the head and body sections in HTML? What is an HTML form and how do you create one? Explain the concept of semantic HTML. What is an iframe and how is it used? What is the purpose of meta tags in HTML? Explain inline, internal, and external CSS in HTML. What are HTML entities? How do you embed JavaScript in an HTML document? What are the different types of lists in HTML? Explain the difference between GET and POST methods in form submission. What is an HTML canvas element? What is the purpose of the title tag in HTML? What is the difference between link and @import for including CSS? How do you structure a webpage using HTML5 semantic elements? What is the purpose of the article element in HTML5? How do you use the section element in HTML5? What are data attributes in HTML5? What is the aside element used for in HTML5? Explain the purpose of the header and footer elements in HTML5. How do you use the figure and figcaption elements in HTML5? What is the nav element and how is it used? How do you use HTML5 for web storage? What is the output element in HTML5 forms? What is the role of doctype in HTML5? What is the purpose of the canvas element in HTML5? How can you use custom data attributes in HTML5? What are the differences between HTML and XHTML? What is the purpose of the main element in HTML5? Explain the use of the progress element in HTML5. Explain the use of the template tag in HTML5. Explain the use of the code tag in HTML. Explain the dialog element in HTML5. Explain the ins and del tags in HTML. Explain the legend tag in HTML. Explain the use of the object tag in HTML5. What is the optgroup and option tags' usage in dropdown lists? What are section tags used for in HTML5? can you tell me how we can handle events in HTML? Where we can use a script tag and when we can use a script in the body?
HTML Hard Questions
Explain the difference between block and inline-block display values. What is the purpose of the mark element in HTML5? What are some common accessibility considerations in HTML? How do you implement drag-and-drop functionality using HTML5? What is the role of the audio and video tags in HTML5? How do you use the details and summary elements in HTML5? What is the purpose of the datalist element in HTML5? How do you use the fieldset and legend tags in forms? What is the purpose of the figcaption element in HTML5? How do you use the figure tag in HTML5? Explain the purpose of the footer tag in HTML5. What is the head tag and what does it contain? How do you use the header tag in HTML5? What is the hgroup tag in HTML5? How do you use the i tag in HTML, and what is its significance? What is the purpose of the kbd tag in HTML? What is the purpose of the data element in HTML5? What is NBSP?
CSS Easy Questions
What is CSS and how is it used in web development? What is the difference between padding and margin in CSS? How do you apply a CSS style to a specific HTML element? What are selectors in CSS and what types are there? What is the purpose of the display property in CSS? How do you center an element horizontally and vertically in CSS? What are pseudo-classes in CSS? How do you add a background image in CSS? What are the different ways to apply CSS styles to a web page? How do you create a gradient in CSS? What is the CSS float property and how is it used? How do you create a border radius in CSS? How do you create a sticky footer in CSS? How do you create a multi-column layout in CSS? What is the purpose of the overflow property in CSS? How can you vertically align text in a div in CSS? What is the difference between visibility hidden and display none? How do you create a hover effect in CSS? What is the CSS position property and how is it used? How do you use the CSS clip property? What is the difference between inline and block elements in CSS? How can you create a navigation bar with CSS? What is the outline property in CSS and how does it differ from border? How do you implement print styles with CSS? How do you create a scalable container in CSS? What is the purpose of the content property in CSS? How do you apply multiple background images to a single element in CSS? Can you explain the use of CSS counters and how they are used? What is the filter property in CSS and how is it applied? Can you explain the use of the transform property in CSS? Can you explain the box model in CSS? How do you make a website responsive using CSS? Can you explain the concept of CSS Flexbox? Explain the concept of CSS specificity. What are media queries in CSS? What are the roles of HTML, CSS and JavaScript? Explain the elements of the CSS box model. So, and what is the difference between difference between sticky and fixed positions? What is the property space between in flexbox? How do you select an element with an ID? What kind of CSS did you use? What is !important? What is the default value of a position property? Do you know what is attribute selector in CSS? What is the default value of FlexDirection? And on which axis justifyContent and alignItem works? What are the values are there for justifyContent? What is the difference between space around and space between?
CSS Medium Questions
What is the purpose of the z-index property in CSS? What is the :nth-child pseudo-class and how do you use it? How do you use the clip-path property in CSS? What is the purpose of the will-change property in CSS? How do you create a CSS shape, such as a circle or triangle? How do you use the ::placeholder pseudo-element in CSS? What is the purpose of the object-fit and object-position properties? What is CSS Grid and how does it differ from Flexbox? What are pseudo-elements in CSS and how are they used? How can you create a dropdown menu in CSS? How do you implement a web font in a CSS file? What is the difference between em and rem units in CSS? How do you create a CSS animation? Explain how CSS transitions work. What are CSS preprocessors, and why are they useful? How can you vertically align text in a CSS div? Can you explain the concept of CSS inheritance? What are the benefits of using CSS sprites and how do you implement them? What is the role of the clear property in CSS? Can you explain the use of CSS variables? Can you explain the use of the ::after pseudo-element? How do you implement a CSS grid layout with named areas? What is the calc() function in CSS and how can it be useful? Can you explain the difference between position: absolute and position: fixed? How do you use the column-count property for responsive designs? What are the advantages of using CSS Flexbox over traditional layouts? How do you create a masonry layout with CSS Grid? Can you explain the use of the blend-mode property in CSS? What is the difference between cohesion, absolute and relative? What is the difference between display none or visibility hidden? What is the use of min width and min height. Can we use width property instead of min width? How does the browser process CSS? For a particular page, can I have multiple CSS files or is it limited to only a single file? there are a number of units available in CSS. Can you please name any three or four units? CSS Hard Questions
How do you override browser-specific styles? How do you optimize CSS for performance? What are keyframes in CSS animations and how are they defined? How do you handle cross-browser compatibility issues in CSS? Can you explain the use of relative, absolute, fixed, and sticky positioning? What is CSS normalization and why is it important? How do you create a parallax scrolling effect with CSS? How do you implement a CSS grid layout with named areas? What is the difference between REM and EM. Inside a div there are 3 image elements. The 3 images should display one above the above, like they should overlap each other. How will approach this. What is float menu.
JS Easy Questions
What is JavaScript? Who developed JavaScript, and what is the first name of JavaScript? What are the differences between Java and JavaScript? What are the JavaScript Data Types? Difference between var, const and let keyword in JavaScript. What is the basic use of the isNaN function in JavaScript? What do you mean by negative infinity? What are undeclared and undefined variables? What is a prompt box? What do you mean by the 'this' keyword in JavaScript? Explain it. How do we Define comments in JavaScript? What do you mean by the "===" operator? Does JavaScript support automatic type conversion (AutoConversion)? How should we change the style/class of an element? What are all the loops available in JavaScript? What is called Variable typing in JavaScript? Explain the difference between the "==" and "===" operator? What Should be the answer of 3+2+ "7"? What is a continue statement in JavaScript? Is JavaScript case-sensitive? What are the different functional components of JavaScript? What do you mean by the unshift() method? What are the unescape() and escape() functions in JavaScript? Are ECMAScript and JavaScript related? How? What do you mean by NULL in JavaScript? What is the use of the delete operator? What do you mean by undefined value in JavaScript? Name all the types of Pop-up boxes available in JavaScript? Define the use of Void(0) in JavaScript? What is the data type of variables in JavaScript? State the Difference between an Alert Box and a Confirmation Box? Is JavaScript a statically typed or a dynamically typed language? What is NaN property in JavaScript? How to include javascript code in HTML? When to use scripts in the head and when to use scripts in the body? What is Promises in JavaScript? What is Async/Await in JavaScript? How JavaScript promotes Asynchronous Programming? Which keywords are used to handle exceptions? What is the fetch() Method in JavaScript? What is an Event Loop? What is context execution? What is a call stack? What is stack and Heap Memory? What is event handlers? What is debouncing? What is module pattern? What is throttling? What is a pure function What are lambda or arrow functions What is a Temporal Dead Zone? Define an anonymous function. What are JavaScript prototypes? What is the Document Object Model (DOM)? What are JavaScript Modules? What are template literals in JavaScript? Explain destructuring in JavaScript. What are default parameters in JavaScript functions? What is the spread operator and how is it used? How does JavaScript handle asynchronous code? What is event delegation in JavaScript? Explain the map, filter, and reduce methods in JavaScript. What are JavaScript mixins? What is function currying in JavaScript? Explain the concept of memoization in JavaScript. What is scope in JavaScript? Explain global and local scope in JavaScript. Explain the difference between synchronous and asynchronous JavaScript. How do you handle API requests with JavaScript? Explain Cross-Origin Resource Sharing (CORS). How do you handle memory leaks in JavaScript? How does JavaScript handle Garbage Collection? Explain the role of JavaScript in web accessibility. What are the latest ECMAScript features? How do you ensure your JavaScript code follows best practices? Explain the role of JavaScript in server-side development (Node.js). What is the new keyword in JavaScript? How do you perform form validation using JavaScript? How do you handle cross-browser compatibility issues in JavaScript? What are the different ways to create objects in JavaScript? Explain the difference between Object-Oriented Programming and Functional Programming in JavaScript. What is promise chaining? What is promise.all? What are the differences between cookie, local storage, and session storage? What is a callback hell? What is the difference between null value and undefined value in JavaScript? What is the difference between a double equal to sign and a triple equal to sign? What is the difference between a PROMISE and a CALLBACK? What is the difference between equality and strict equality? Explain about setTimeout and setInterval? Is it possible to declare an array with random numbers and alphabets as well?
JS Medium Questions
How do you manipulate the DOM using JavaScript? What is a callback function? Explain the working of timers in JavaScript? Explain Hoisting in JavaScript. Explain Implicit Type Coercion in JavaScript. How closures work in JavaScript? How Cookies work in JavaScript Explain the use of the bind, call, and apply methods. Explain event bubbling and event capturing. Describe the role of deferred scripts in JavaScript. Explain the concept of higher-order functions. Explain the concept of a singleton in JavaScript. How do you handle exceptions in JavaScript? What is stack and Heap Memory? What is debouncing? What is throttling? Explain the concept of memoization in JavaScript. Explain Cross-Origin Resource Sharing (CORS). How do you handle memory leaks in JavaScript? How does JavaScript handle Garbage Collection? Explain the role of JavaScript in web accessibility. How do you ensure your JavaScript code follows best practices? Explain the role of JavaScript in server-side development (Node.js). How do you handle cross-browser compatibility issues in JavaScript? What is promise chaining? What is promise.all? What are the differences between cookie, local storage, and session storage? Can you tell me the most basic advantage of using arrow function. What are Axios? What is the difference between Fetch and Axios? When should you use asynchronous programming? Where is the DOM created? Server side or client side? What is a timeout? How we can avoid callback hells? What is ESL 6? What's the difference between an arrow function and a normal function?
JS Hard Questions
Explain about Read and Write of a file using JavaScript? Function's for converting a string of any base to integer in JavaScript? List the disadvantages of using innerHTML in JavaScript. What are all the loops available in JavaScript? What is an Immediately Invoked Function in JavaScript? How to include javascript code in HTML? How do you handle exceptions in JavaScript? What is an Event Loop? What is context execution? What is a call stack? What is module pattern? What is a pure function What is a Temporal Dead Zone? What are JavaScript prototypes? What is the Document Object Model (DOM)? What are default parameters in JavaScript functions? How does JavaScript handle asynchronous code? Explain the map, filter, and reduce methods in JavaScript. What are JavaScript mixins? What is function currying in JavaScript? Explain global and local scope in JavaScript. How do you handle API requests with JavaScript? How do you perform form validation using JavaScript? What are the different ways to create objects in JavaScript? Explain the difference between Object-Oriented Programming and Functional Programming in JavaScript. What are observables What are event emitters in JavaScript? Is JavaScript single threaded or multi-threaded?
React JS Easy Questions
What is React? What are some important features of React? Can you explain the virtual DOM and its significance in React? Differentiate between Virtual DOM and Real DOM. What is JSX and how does it work in React? What are the disadvantages of React? Difference between React and Angular. How does rendering work in React? What are the states in React? What are the props? What is a class component in React? What is a functional component in React? What is the difference between props and state? Explain the lifecycle methods of React components in detail. How is routing in React different from conventional routing? What are stateful components in React? What are refs in React? What are the controlled components in React? What are the uncontrolled components in React? What is React Router? Can you explain the use of React Router? What are pure components in React? What are keys in React? What is the significance of keys in React lists? What does calling super() in a React constructor do? Why is props passed to the super() function in React? What are PropTypes in React? What are predefined prop types in React? What is a React Hook? How do you use state in a functional component in React? Can you explain the useEffect Hook? What are custom Hooks in React? How do you optimize performance in a React application? How do you use the Context API in React? Can you explain the concept of "lifting state up" in React? How do you handle forms in React? How do you implement routing in React? How do you manage global state in React? How do you handle errors in React applications? Can you explain the concept of props.children in React? What is the significance of the render() method in React? Can you describe the process of reconciliation in React? How do you pass a parameter to an event handler or callback in React? What are fragments in React? How do you implement lazy loading in React? What is the purpose of the useState Hook in React? What is prop drilling and how do you avoid it? How do you use the useCallback Hook in React? Can you explain the concept of controlled inputs in React? What are the benefits of using React? How do you use context in React? What are the differences between class components and functional components in React? How do you implement a search functionality in a React application? How do you handle styling in React? How do you handle API calls in React? How do you manage state in large React applications? What are the different lifecycle methods in React class components?
React JS Medium Questions
What is a Higher-order component (HOC)? What is Redux and how does it work with React? Difference between Flux and Redux. Can Ajax be used in React? What are the components of Redux in React? How to set React to production build? What is the difference between cloneElement and createElement? What is strict mode in React? What will you do if your React Application is rendering slow? What is memoization in React? What are synthetic events in React? Can you describe how to implement server-side rendering in React? How do you manage local state in a component? How do you optimize React component rendering? React JS Hard Questions
What are React Portals? How do you create a ref in React? What are the common use cases for using Refs in React? Can you explain forward refs in React? What is the use of the useMemo Hook in React?
Python Easy Questions
What is Python and why is it popular? How do you install Python on your computer? What is the difference between Python 2 and Python 3? How do you write a basic Python program? What are Python's key features and strengths? What are variables in Python? How do you comment code in Python? What are the basic data types in Python? How do you perform arithmetic operations in Python? What is type conversion in Python? How do you take input from the user in Python? How does string formatting work in Python? What are Python's lists and how do you use them? How do you access elements in a list? What are tuples in Python and how are they different from lists? What is slicing in Python? How do you iterate over a list in Python? What are dictionaries in Python? How do you add or remove elements from a dictionary? What are sets in Python? How do you perform set operations in Python? What are Python functions? How do you define a function in Python? What are global and local variables in Python? What is object-oriented programming in Python? How do you create a class in Python? What is inheritance in Python? How do you create a child class in Python? What is recursion in Python and how do you use it? How do you use the range function in Python? How do you handle strings in Python? What is the difference between == and is in Python? How do you check if a key exists in a dictionary? What are the uses of args and *kwargs in Python? What is the pass statement in Python? What is the purpose of the with statement in Python? How do you use loops in Python? What is the difference between break, continue, and pass? How do you format strings in Python? How do you sort lists in Python? How do you concatenate strings in Python? What is a namespace in Python? What is a Python slice and how is it used? What are Python comprehensions? How do you reverse a string in Python? What is the purpose of the init method in Python? How do you use the filter function in Python? How do you check the version of Python being used? What are Python's built-in data structures? How do you use the map function in Python? What is Python's None type? What are Python's built-in types? How do you create a multi-line string in Python? What is OOP, and why is it important in Python? What is a class in Python? What is an object in Python? How do you create an instance of a class in Python? What is the constructor in a Python class? How is inheritance implemented in Python? What is the use of the super() function? How can you achieve multiple inheritance in Python? How can you prevent method overriding in Python? What type of language is python? How is Python an interpreted language? What are the benefits of using Python? What are the common built-in data types in Python? Is indentation required in python? What is the difference between Python Arrays and lists? Python Medium Questions
How do you execute a Python script? What is a lambda function in Python? How do you handle exceptions in Python? What are Python modules? How do you import a module in Python? What is the if name == "main" statement? What are Python decorators? How do you read and write files in Python? What are Python iterators? What are Python generators? What is list comprehension in Python? How do you handle errors and exceptions in Python? How do you create and use a virtual environment in Python? What are Python packages? How do you manage packages with pip? What is the Python Standard Library? What are Python's anonymous functions? What is the difference between shallow and deep copying? What are Python's magic methods? How does Python handle memory management? What is the Global Interpreter Lock (GIL) in Python? What is duck typing in Python? How do you debug a Python program? What is the purpose of self in Python classes? How do you use the enumerate function in Python? What is the Python pathlib module and how is it used? How do you use regular expressions in Python? What are Python docstrings and how are they used? What is the difference between a shallow and a deep copy? How do you measure the performance of a Python script? How do you use the assert statement in Python? What is the purpose of Python's os and sys modules? What is the purpose of the self keyword in methods? How does polymorphism work in Python? Python Hard Questions
What is PYTHON PATH? What is the difference between .py and .pyc files?
SQL Easy Questions
Define joins and list the types of joins. Explain about LEFT JOIN and RIGHT JOIN. Explain about INNER JOIN and FULL JOIN. What is CROSS-JOIN? What is SELF-JOIN? What is SQL? What will be the result when a join operation is performed on two tables? What is the difference between a primary key and a foreign key in SQL? What is the full form of SQL? What is the difference between DBMS and RDBMS? What are the differences between the WHERE and HAVING clauses? What is the difference between DROP, DELETE, and TRUNCATE statements in SQL? What are functions in SQL? How can we use functions in SQL? What is the purpose of the ORDER BY command in SQL? What is the purpose of the HAVING command in SQL? What is the purpose of the GROUP BY command in SQL? What are the operations performed in DBMS? What is a database? What are aggregations in SQL? What is the use of the ORDER BY clause in SQL? What is the use of the GROUP BY clause in SQL? What are constraints in SQL? What are the various types of constraints used in SQL? What are keys in SQL? Define primary key, foreign key, and unique key What is DML? Explain the relationships known as "one-to-many," "one-to-one," and "many-to-many." What are the types of commands in SQL? Where do we use clauses such as 'where' and 'having'? Explain the different types of joins available in SQL. List five commands used in DML. What is the difference between the left operand and the right operand? What is a foreign key? How many types of clauses do we have in SQL? What types of files are stored in DBMS and RDBMS? What is the difference between DDL and DML? What is the difference between insert and replace? Can you name the aggregate functions in SQL? What is the difference between relational and non-relational database? What is the use of GROUP BY clause in SQL? Difference between primary key and composite key Difference between HAVING and WHERE? What are the characteristics of the primary key? Difference between UNION and UNION ALL in SQL? What is an example of a real-time scenario where you have used a left join? How a SQL query is stored? Do you know about Types of databases? Write some basic SQL queries. What is Left JOIN and Right JOIN? How to add a column in SQL?
SQL Medium Questions
What are triggers in SQL? Explain the types of triggers in SQL Explain the concept of normalization in databases. What is the purpose of a "VIEW" in SQL? What is the purpose of Data Definition operations in a DBMS? What are Data Manipulation operations in DBMS? What is the purpose of Data Control operations in a DBMS? What are Data Querying and Reporting operations in DBMS? What is a stored procedure in SQL? What is SQLite? What are transactions in SQL? Can we use the JOINS in the MongoDB? What is view in SQL? What are wildcard characters in SQL?
SQL Hard Questions
What is Index in SQL? Explain the different types of indexes in SQL What are the different normal forms in database normalization? Define First Normal Form (1NF) in database normalization. Define Second Normal Form (2NF) in database normalization? Define Third Normal Form (3NF) in database normalization? What are the features of a database related to data organization and integrity? What are the features of a database related to data security and querying? What are the features of a database related to transactions, scalability, and data recovery? What is a non-relational database? What are the advantages of using DBMS? Define SQL injection, and explain the methods to prevent it? What is store procedure? Explain the difference between SQL and NoSQL databases. How to design database schema and implement in PostgreSQL? what is correlation? What is denormalization in SQL? What is scalar function in SQL How can time complexity be reduced in SQL? What is the difference between 'commit' and 'rollback'? How can you alter or stop a trigger? Do you have any idea on indexes? What is a Rollback in SQL? What is sub-query in SQL? What are the advantages of MongoDB compared with SQL? How an SQL query is processed? ACID properties in the database and their use case? How a SQL query is optimized? How SQLite is different from Mongodb?