Answer:Table
Explanation:A relational database has structures and thus have more than one table. The tables consist of row (for entry) and column (for data). As a result, data are organized in a simple manner and are normally consistent.
The student should attempt to hold down the alt key, then enter 248 on the number pad and then release the alt key. Like so: °
Answer:
1. VLOOKUP function.
2. SUMIF function.
3. COUNT function.
4. IF function.
5. HLOOKUP function.
Explanation:
Microsoft Excel is a software application or program designed and developed by Microsoft Inc., for analyzing and visualizing spreadsheet documents. There are different types of functions used in Microsoft Excel to perform specific tasks and these includes;
1. VLOOKUP function: it's an Excel function that avails end users the ability to lookup data in a table organized vertically. Thus, it's typically used for searching values in a column.
2. SUMIF function: it is an Excel function to sum cells that meet criteria such as text, dates and numbers. This function can be used with the following logical operators; <, >, and =.
3. COUNT function: it's an Excel function to find the total number of entries in a column. For example, to count the number of entries in B1:B15; COUNT(B2:B15).
4. IF function: runs a logical test and returns one value for a TRUE result, and another for a FALSE result. For example, to fail scores that are below 40; IF (A1 < 40, "Fail", "Pass").
5. HLOOKUP function: it's an Excel function that avails end users the ability to lookup data in a table organized horizontally. Thus, it's typically used for searching values in a column.
Answer:
Create or replace trigger at_advisor
after delete or insert or update on advisor
for each row
Begin
if inserting
then
insert into
log_maj_adv
values
(
user, :new.adv_code, sysdate, 'insert'
)
;
elsif deleting
then
insert into
log_maj_adv
values
(
user, :new.adv_code, sysdate, 'delete'
)
;
else
insert into
log_maj_adv
values
(
user, :new.adv_code, sysdate, 'update'
)
;
end if;
End;
Explanation:
as per above answer.
Answer:
A. a series of actions that solve a particular problem.
Explanation:
An algorithm refers to step by step instructions used to fix a problem and they are used for tasks like make calculations and process data. Algorithms are important for computers to be able to process information as they provide the instructions on how a task has to be performed. According to this, an algorithm is a a series of actions that solve a particular problem.
