All categories

3 years ago

Swathi is using Base database software. Which filter function will enable her to filter data based on the field she clicks on?

Computers and Technology

1 answer:

anygoal [31]3 years ago

4 0

Answer:

The answer to the following question is "Autofilter".

Explanation:

Filtering is a technique for finding some data of a group of data or tables. Autofilter is a part of the Microsoft excel. In this filter it allows you to view specific rows in a spreadsheet while hiding the other rows. In other databases like Oracle Database, MySQL, MongoDB, etc. it is the same as a select command.

You might be interested in

Would anyone know this

Darina [25.2K]

Time in transit would be correct

5 0

3 years ago

Read 2 more answers

Write a function solution that given an array a of n integers (between -100 and 100), returns the sign (-1,0,1) of product of al

JulijaS [17]

left[0]=a[0];

for(int i=1;i<=n-1;i++)

left[i]=(left[i-1]*a[i])%M;

right[n-1]=a[n-1];

for(int i=n-2;i>=0;i--)

right[i]=(right[i-1]*a[i])%M;

for query q

if(q==0)

return right[1]%M;

if(q==n-1)

return left[n-2]%M;

return (left[q-1]*right[q+1])%M;

4 0

2 years ago

A(n) _____ might be written by a programmer or it might be created through a DBMS utility program.

valkas [14]

Answer:

The correct answer to the following question will be "Application program".

Explanation:

Applications include database programs, word processors, browsers, development tools, picture editors, and platforms for communication.
It use the OS (Operating System) of the computer and many other assisting programs, frequently system software, to work.
An application program is a detailed, body-contained program that directly works a given function for just the user.

There are some examples of application programs such as:

Includes various bundled software.
Addresses an organization's data management and application requirements, covering all divisions.
It allows users can create and manage information.
Used primarily to get content access without editing.

6 0

3 years ago

Task 5: Create the GET_CREDIT_LIMIT procedure to obtain the full name and credit limit of the customer whose ID currently is sto

lidiya [134]

The SQL statement that would create the GET_CREDIT_LIMIT procedure to obtain the full name and credit limit of the customer is:

GET_CREDIT_LIMIT

SELECT CUST_ID 125

FROM FIRST_NAME, LAST_NAME, CREDIT_LIMIT

WHERE LAST_NAME ="Smith"

This is an acronym that means Structured Query Language that is used in handling data in a database.

Hence, we can see that from the attached image, there is a table that contains the details of customers and their various data such as their first and last names, credit limits, address, etc, and the GET_CREDIT_LIMIT procedure is shown above.