A data structure in which elements can be inserted or deleted at/from both ends but not in the middle is?
Anonymous Quiz
34%
Queue
34%
Circular queue
24%
Dequeue
8%
Priority queue
👍2
A set of unordered properties that, has a name and value is called______
Anonymous Quiz
18%
String
22%
Array
24%
Serialized Object
35%
Object
👍3🥰1👏1
Which of these occupy first 0 to 127 in Unicode character set used for characters in Java?
Anonymous Quiz
69%
ASCII
13%
ISO-LATIN-1
5%
None
12%
ASCII and ISO-LATIN1
Which function finds the first occurrence of a substring in another string?
Anonymous Quiz
29%
strchr()
16%
strnset()
32%
strstr()
23%
None of these.
The C++ code which causes abnormal termination/behaviour of a program should be written under _________ block.
Anonymous Quiz
29%
catch
20%
throw
39%
try
12%
finally
❤2
How Query is Executed
Order of SQL query execution is not the same as order query is written.
You probably noticed that when you write SELECT count(*) AS column_name, you can't use that column_name in WHERE or GROUP BY clause. It's because select clause in which you defined your alias is not executed yet!
Each query begins with finding the data that we need in a database, and then filtering that data down into something that can be processed and understood as quickly as possible. Because each part of the query is executed sequentially, it's important to understand the order of execution so that you know what results are accessible where.
In general, SQL queries are executed in the following order:
1. FROM: The first step is to identify the tables or views involved in the query. This is specified in the FROM clause of the query.
2. JOIN: If the query involves multiple tables and requires a join operation, the join conditions are evaluated to combine the data from different tables.
3. WHERE: The WHERE clause is applied to filter the rows based on specified conditions. Rows that do not meet the conditions are eliminated from further processing.
4. GROUP BY: If the query includes a GROUP BY clause, the rows are grouped based on the specified columns.
5. HAVING: If a HAVING clause is present, it is applied to filter the groups generated by the GROUP BY clause. Groups that do not meet the conditions are eliminated.
6. SELECT: The SELECT clause is applied to determine the columns to be included in the result set. Any calculations or functions specified in the SELECT clause are also evaluated at this stage.
7. DISTINCT: If the query includes the DISTINCT keyword, duplicate rows are removed from the result set.
8. ORDER BY: If an ORDER BY clause is present, the result set is sorted based on the specified columns.
9. LIMIT/OFFSET: If the query includes a LIMIT and/or OFFSET clause, the result set is limited to a specific number of rows and/or skipped by a certain number of rows.
It’s important to note that not all queries will include every step mentioned above. The order of execution may vary depending on the specific query and the presence of different clauses.
Order of SQL query execution is not the same as order query is written.
You probably noticed that when you write SELECT count(*) AS column_name, you can't use that column_name in WHERE or GROUP BY clause. It's because select clause in which you defined your alias is not executed yet!
Each query begins with finding the data that we need in a database, and then filtering that data down into something that can be processed and understood as quickly as possible. Because each part of the query is executed sequentially, it's important to understand the order of execution so that you know what results are accessible where.
In general, SQL queries are executed in the following order:
1. FROM: The first step is to identify the tables or views involved in the query. This is specified in the FROM clause of the query.
2. JOIN: If the query involves multiple tables and requires a join operation, the join conditions are evaluated to combine the data from different tables.
3. WHERE: The WHERE clause is applied to filter the rows based on specified conditions. Rows that do not meet the conditions are eliminated from further processing.
4. GROUP BY: If the query includes a GROUP BY clause, the rows are grouped based on the specified columns.
5. HAVING: If a HAVING clause is present, it is applied to filter the groups generated by the GROUP BY clause. Groups that do not meet the conditions are eliminated.
6. SELECT: The SELECT clause is applied to determine the columns to be included in the result set. Any calculations or functions specified in the SELECT clause are also evaluated at this stage.
7. DISTINCT: If the query includes the DISTINCT keyword, duplicate rows are removed from the result set.
8. ORDER BY: If an ORDER BY clause is present, the result set is sorted based on the specified columns.
9. LIMIT/OFFSET: If the query includes a LIMIT and/or OFFSET clause, the result set is limited to a specific number of rows and/or skipped by a certain number of rows.
It’s important to note that not all queries will include every step mentioned above. The order of execution may vary depending on the specific query and the presence of different clauses.
❤3👍1
A normal queue, if implemented using an array of size MAX_SIZE, gets full when?
Anonymous Quiz
46%
Rear = MAX_SIZE – 1
30%
Front = (rear + 1)mod MAX_SIZE
15%
Front = rear + 1
9%
Rear = front
👍2
Forwarded from Web development
JavaScript® Notes for Professionals book
📄 400+ pages
🔗 Book Link
#Javascript
➖➖➖➖➖➖➖➖➖➖➖➖➖
Join @web_dev_bds for more
📄 400+ pages
🔗 Book Link
#Javascript
➖➖➖➖➖➖➖➖➖➖➖➖➖
Join @web_dev_bds for more
Telegram
Free programming books
JavaScript® Notes for Professionals book
📄 400+ pages
#Javascript
➖➖➖➖➖➖➖➖➖➖➖➖➖
Join @programming_books_bds for more
📄 400+ pages
#Javascript
➖➖➖➖➖➖➖➖➖➖➖➖➖
Join @programming_books_bds for more
👍2
A collection of elements of the same data type which may either in order or not, is called _____.
Anonymous Quiz
12%
String
67%
Array
11%
Serialized Object
10%
Object
What will be the output of the following JavaScript code?
Anonymous Quiz
18%
Properties
21%
property names
24%
property values
38%
objects
❤1👎1
Which one is a valid declaration of a boolean?
Anonymous Quiz
19%
boolean b1 = 1;
13%
boolean b2 = ‘false’;
61%
boolean b3 = false;
8%
boolean b4 = ‘true’
👍3