1. What actions are being audited?Options: CHOOSE ONE OPTIONA. SELECTB. DELETEC. UPDATED. INSERTE. ALL OF THE ABOVE You are given the following information:EmployeeEmp_SSN Emp_Lname Emp_SalaryDep_Num Emp_SexEXEC DBMS_FGA.ADD_POLICY(object_Schema => 'Dba643', -object_name => 'Employee', -policy_name => 'Emp_Audit_Policy', -audit_column => 'Emp_SSN, Emp_Salary', -audit_condition => 'Emp_Salary >= 50000', -audit_column_opts => DBMS_FGA.ALL_COLUMNS,-statement_types => 'SELECT');Answer the followingEmp_City Emp_State

Answer Option E All OF THE ABOVE because all these actions are typically audited in order to ensure…

Answered: 1. What actions are being audited?…

Engineering

Computer Science

1. What actions are being audited? Options: CHOOSE ONE OPTION A. SELECT B. DELETE C. UPDATE D. INSERT

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: write step - by - step command CREATE BELOW TABLE CREATE TABLE empl (month INT, emp VARCHAR (15),…

A: The table is created using the query CREATE TABLE empl (month INT, emp VARCHAR (15), dept VARCHAR…

Q: Please due in C. Thank you A sample run is as follows : ---=== EMPLOYEE DATA ===--- 1. Display…

A: Algorithm: 1. Start. 2. Create a structure called Employee with three fields, id, age, and salary.…

Q: What do we mean when we talk about triggers? What are their purposes, exactly? Access 2016: What are…

A: Data base triggers are program instructions that run routinely if a given condition is met on a…

Q: The OR condition O A. can only be used in combination with the AND condition. O B. displays records…

A: OR Condition: It is used to test multiple conditions in a SELECT, INSERT, UPDATE or DELETE…

Q: Which of the following is not true about database objects? a. You can split a form into…

A: The objective of the first question is to identify the incorrect statement about database objects.…

Q: Assume you have added eight new orders to the ORDERS table. Which of the following is true?a. Other…

A: Introduction- Insert command in a database is a DML (Data Manipulation Command) which is used to…

Q: What are the features of adjusting entries? Explain in depth

A: Characteristics of Adjusting entries

Q: Write a comand with a pipe that displays the total number of processes running on the system owned…

A: In this question we need to write a command using pipe which prints the total number of processes…

Q: The activation of one trigger may cause the activation of another. True False

A: Introduction: A SQL trigger is a data set item that triggers when an event occurs in a database.

Q: Database questions

A: The following errors are found in the code: V_count is different from v_count. Condition wrote in…

Q: 65. _________ dump schemes have been developed that allow transactions to be active while the dump…

A: Given that, 65. _________ dump schemes have been developed that allow transactions to be active…

Q: 12 return: ERROR 1410 (42000) at line

A: Given : Task 11 & 12 return: ERROR 1410 (42000) at line 1

Q: If you want to create a Cartesian product, simply do not join the tables in an SQL query statement.…

A: A) Executing SQL script file To execute commands residing in a file, type the following command:…

Q: Which of the following are the features of a primary key? a. Unique value b. Not null c. All d. Not…

A: Answer: c

Q: write the steps to design new database file as (subjtable1.dbf) that consists .(of (2) fields:…

A: Steps to design the database named subjtable1.dbf in MySQL database: Use create table command to…

Q: 105. To delete a database ___________ command is used a. Delete database database_name b. Delete…

A: c) drop database database_name

Q: When we say "triggers," what precisely do we mean? But what are their actual functions? By following…

A: In this question we have to understand triggers in Microsoft Access. A trigger is a piece of code…

Q: (a) Which command makes updates permanent? (b) Which command reverses updates? (c) Which updates…

A: (a) In most database management systems, the SQL command COMMIT is used to make updates permanent.…

Q: Make a list of the many types of use cases.

A: NOTE :- Below i explain the answer in my own words by which you understand it well. Whenever…

Q: the command that will delete all the records in the table "Books" is .a DELETE ROWS FROM Books; .b O…

A: The Delete statement removes one or more rows in a table permanently. The syntax of the Delete…

Q: The UPDATE command is used to Group of answer choices create a table. add a new record to a table.…

A: The UPDATE statement is used to modify the existing records in a table. syntax is : UPDATE…

Q: Since you operate on databases, you may use triggers or processes. Triggers—when and how?

A: Triggers and processes are powerful tools used in databases to automate actions and maintain data…

Q: 64. ________ dump, writes out SQL DDL statements and SQL insert statements to a file, which can then…

A: Please find the answer to the above question below:

Q: Your program will keep a database of employee information through an array of structures of type…

A: Algorithm of the code: Step 1: Declare the variables option, id, age, and salary. Step 2: Print the…

Q: rad is designing a form for his database. Which of the following is not true about forms? a.…

A: A "form" refers to a graphical user interface element that allows users to input data and interact…

Q: Write a script that creates and calls a stored procedure named spInsertDepartment. First, code a…

A: Answer : Stored Procedure : /*creating stored procedure*/create procedure…

Q: q15- Which statements are correct about references in Excel? a. An absolute reference will not be…

A: There are two types of cell references relative and absolute. Relative and absolute references…

Q: Which SQL statement will discard both update and delete operations after executing the below SQL…

A: Here the correct option is (d)

Q: Given the following table ТАBLE BOOKS Column Null? Туре ISBN NOT NULL NUMBER TITLE NOT NULL…

A: Given: To find the command that will delete all records that have undefined version is:

Q: Lab 8-1: KimTay Pet Supplies Task 6: Create the GET_INVOICE_DATE procedure to obtain the customer…

A: GET_INVOICE_DATE procedure: CREATE PROCEDURE GET_INVOICE_DATE @INVOICE_NUM nvarchar(10) AS SELECT…

Q: Name the button/icon of MS Access. *

A: Here image is given we have to identify it.

Q: Task 5: Create the GET_CREDIT_LIMIT procedure to obtain the full name and credit limit of the…

A: Given : Task 5: Create the GET_CREDIT_LIMIT procedure to obtain the full name and credit limit of…

Q: Exercise: Create a statement that will make a copy of the vendors table. The name of the copy should…

A: Statement to copy content of one table into another table in SQL Statement which delete a table in…

Q: Where can I find more information about the various types of triggers? What do they do specifically?…

A: Microsoft Office:Microsoft Office is a suite of productivity software developed by Microsoft for…

Q: 3. Display a decimal number and then display it rounded and truncated. Use a number where rounded…

A: decimal number- Select To_Number(456.78) from dual; round- Select ROUND(15.188,1) "Round" From Dual;…

Q: Make a list of the many types of use cases.

A: In contrast to Business Use Cases, which focus on what users want from a system, System Use Cases…

Q: 4- In SQL statement, alias is used for which purpose? a. retrieving information from the database…

A: Given: 4- In SQL statement, alias is used for which purpose? a. retrieving information from the…

Q: The given commad ALTER TABLE test MODIFY id NOT NULL; The command will always be executed…

A: ALTER TABLE command is used to add, delete or modify columns in an existing table. The basic syntax…

Q: q3- Which of the following is NOT correct when referring to a primary key a. Changes over time…

A: The question has been answered in step2

Q: QUESTION 21 Given the following table: Student ( id, first_name, last_name, address, program,…

A: - We need to highlight the correct options for the provided problems.

Q: 7. In the third row, enter the following column headings: Name Gender Age Breed 8. In cell C8,…

A: There is some information missing but based on the given question. The answer is provided in the…

Q: a. Normalize the Bank Accounts Table to 1NF by increasing the records in the existing table.

A: AccountHolderID AccountHolderName C111 Joe Smith C222 Sue…

Q: Which of the following types of constraints can’t be created at the table level? ( refer to the…

A: Constraints are the specified rules for the data in a table. Table constraints are used to limit the…

Q: Which of the following statements is NOT true regarding protection of a worksheet in Excel? a.…

A: Protection in Worksheet : In Excel, there is a provision for the sheet to provide on-view access to…

Question

1. What actions are being audited?

Options: CHOOSE ONE OPTION

A. SELECT

B. DELETE

C. UPDATE

D. INSERT

E. ALL OF THE ABOVE

You are given the following information:
Employee
Emp_SSN Emp_Lname Emp_Salary
Dep_Num Emp_Sex
EXEC DBMS_FGA.ADD_POLICY(object_Schema => 'Dba643', -
object_name => 'Employee', -
policy_name => 'Emp_Audit_Policy', -
audit_column => 'Emp_SSN, Emp_Salary', -
audit_condition => 'Emp_Salary >= 50000', -
audit_column_opts => DBMS_FGA.ALL_COLUMNS,-
statement_types => 'SELECT');
Answer the following
Emp_City Emp_State

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Which statement is not correct? The goal of batch controls is to endure that during processing a. Transactions are not omitted b. Transactions are processed more than once c. Transactions are not added d. An audit trial is created
I. Which of the following actions update a master file and which would be stored as a record in a transaction file? a. Update customer address change b. Update unit pricing information c. Record daily sales d. Record payroll checks e. Change employee pay rates f. Record production run variances g. Record Sales Commissions h. Change employee office location i. Update accounts payable balance j. Change customer credit limit k. Change vendor payment discount terms I. Record purchases
Refer to the sample tables and sample data below. Then answer questions (a), (b), (c), and (d). Tables: adult (id(pk), name, spouse_id (fk)) -- foreign key (spouse_id) references adult(id) child (id(pk), name) parent_child (parent (pk, fk), child (pk, fk)) -- foreign key (parent) references adult(id) -- foreign key (child) references child(id) mysql> SELECT * FROM adult; id | name 1 Homer Simpson 2 | Marge Simpson 3 Fred Flintstone 4 Wilma Flintstone | mysql> SELECT * FROM child; |id|name 11 Bart 12 Lisa 13 Maggie 14 Pebbles 1 2 | spouse_id mysql> SELECT * FROM parent_child; parent | child | 2 1 2 3 | 41 11 | 11 12 12 13 13 14 14 1 4 How many times will the names Bart and Homer Simpson appear in the result set from the following command? SELECT c.name, a.name FROM child c JOIN parent_child pc ON c.id = pc.child JOIN adult a ON a.id = pc.parent; (a) Bart appears [Select] (b) Homer Simpson appears [Select] times. ✓times.
Can you design the table??? I need code remember that..
de Show Review View Tell me whatyou want to do. Sign in & Share less you need to edit, it's safer to stay in Protected View. Enable Editing Calculate mean value Mean Amean value Ex = sum of all data values (x,, X, X3,) n= number of data values
Which clause is used to change a column in a table? a. SET b. MODIFY c. ALTER d. UPDATE
1: Write a stored procedure which takes Cid from user and return the Product of That Category.
108. ____________ is a special type of stored procedure that is automatically invoked whenever the data in the table is modified. a. Procedure b. Trigger c. Curser d. None of the Mentioned
In Microsoft Access, how do you add reports? What about adding controls to a report?
Task 5: The Developers team also wants you to ensure that emails are converted to lowercase after an update operation. Currently, new insertions are guaranteed to have lowercase emails, but there is no such guarantee for legacy emails. Therefore, the team wants to ensure that emails are being retained in a lowercase irrespective of any changes in the database. Create a new TRIGGER called email_update for the USERS table that runs before an UPDATE operation. Task: Create a TRIGGER to run on the USERS table before any UPDATE operation. (SQL Database Test): Create a TRIGGER before any UPDATE operations on the USERS table
please answer all questions.
Which view is used to filter and look at the data in a table, without changing the structure of the file? A.Report B.Data C.Dashboard D.Model