Explain why it is important to back up your database before running an action query.
What will be an ideal response?
Before running an action query, it is best to back up the entire database because this provides you with some insurance in case you need to recover from a mistake. You cannot undo updates or deletions performed with an action query, so once you run an action query, you are committing yourself to an irreversible change.
You might also like to view...
A(n) ________ would be used to replace null values with zeros?
A) make table query B) update query C) delete query D) append query
What function is best suited to determine how often a set of numbers appears within a dataset?
A) SUMIF B) SUMIFS C) FREQUENCY D) AVERAGEIF
Polymorphism permits existing code, which has been thoroughly tested, to be reused efficiently without the need for extensive retesting.
Answer the following statement true (T) or false (F)
Which of the following is a good precaution to take when making online purchases?
a. use the same strong password for all online accounts b. pay by debit card c. make sure http: and an open padlock displays in the address bar d. use a private browser when purchasing items from a public computer