Answer:
Check the explanation
Explanation:
a) Consider the following SQL query to create a view TopLevelCust
Query: Create View TopLevelCust AS Select CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, Creditlimit From Customer Where Creditlimit P= 10000,
- In order to create a view for TopLevelCust, it is required to replace viewname with TopLevelCust
- select Clause is used to retrieve stored records from the table o CustomerNum, CustomerName, Street, City, State, PostalCode, Balance and Creditlimit are the attribute name
- from clause specifies one or more table from where records. be retrieved o Customer is the table name
- where clause is used in SQL query to retrieve only those records that satisfy the specified condition
- CreditlLimit>=10000 is the specified condition to retrieve the information from table.
Answer:
1. Data and 2. procedures or functions
Explanation:
The object in an object oriented programming comprises of data and the procedures, The data describes the object, and the procedures explains what that particular object can do. And that is a function and nothing else. We declare a data, and procedure or function. We then initialize the data through constructor. And finally we does the operation like here its change heat by defining a function for it. A function is first declared, then defined and finally called for getting the desired output.
Answer:
Algorithms allow automation of complex task
Explanation:
I just did it
