The three fundamental principles underlying the use of mnemonics are imagination, association and location
Answer:
The Correct answer for the given question is "elements " .
Explanation:
The number of bytes is always multiple by the number of array elements in an array to getting total memory occupy by any array .
For example :
int a[100];
Since in c language int is 2 bytes
So memory in number of bytes =2*100=200 bytes
Indexes is keep the track of physical location of any file this is also used to track the logical location of file in database so this option is wrong
Subscripts are the index number of an array so we will never used subscripts to getting total memory occupy by any array so this option is wrong
Iterators are the loop so this option is wrong.
Due to this the correct answer is elements.
Answer:
Kindly check explanation
Explanation:
The SQL statement above could be interpreted as follows :
create table command is used to create a table named 'persons' with five columns which are labeled :
person I'd : whose data type is an integer
last name column with a variable character data type with maximum length of 255
first name column with a variable character data type with maximum length of 255
address column with a variable character data type with maximum length of 255
city column with a variable character data type with maximum length of 255
The VARCHAR data type is ideal since we expect the column values to be of variable length.
Answer:
SQL queries
The command used to display the customer ID and total number of orders placed is given below
Query:
SELECT CustomerID, COUNT (orderID) AS TotalOrders
FROM Order_Table
GROUP BY CustomerID
Explanation:
SQL queries
The command used to display the customer ID and total number of orders placed is given below
Query:
SELECT CustomerID, COUNT (orderID) AS TotalOrders
FROM Order_Table
GROUP BY CustomerID
SELECT - To query the database and get back the specified fields SQL uses the select statement
CustomerID is a coloumn name
The function COUNT(OrderID) returns the number of orders
Totalorderds is a label
FROM - To query the database and get back the preferred information by specifying the table name
Order_Table is a table name
GROUP BY - The clause is used to group the result of a SELECT statement done on a table where the tuple values are similar for more than one column
The table below displays the CustomerID and total number of orders placed
CustomerID Totalorders
4 28
1 6
12 5
16 5
6 3
9 3
15 3
3 1
13 1
14 1
The table below shows the total number of orders situated for each sales person
SalesPerson_ID TotalOrders
3 16
2 3
4 3
5 3
