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: 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: 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: 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: 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 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: 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: 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: 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: 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: 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: a. Normalize the Bank Accounts Table to 1NF by increasing the records in the existing table.

A: AccountHolderID AccountHolderName C111 Joe Smith C222 Sue…

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

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.
Which clause is used to change a column in a table? a. SET b. MODIFY c. ALTER d. UPDATE
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
What are the mandatory clauses of a SELECT statement and what do they represent?
Create an application which can access a database. Create a database with an application user, user specific for your application to use, and 1 table of a couple of fields properly indexed. Grant permissions for the user to access the table. (submit .SQL file) Create a simple application, language of your choice, (BE languages only, no JS or Node) which can do the following operations: (submit source code file): Connect using the application user created above. Insert into the table, and select from the table using a WHERE clause, where all fields are parameterized. Display results of the select. Use a simple web server API interface for data input and output, which can be accessed via local browser or curl.
Create a user Nurse. (Screenshot 1) Create a database Hospital. (Screenshot 2) Grant Nurse privileges to Hospital (Screenshot 3) As Nurse, create a table Patients with the following structure. (Screenshot 4) PatientID RoomNo FirstName LastName Admission Temperature double(10,2) int(8) Primary Key and not null int(4) varchar(14) not null varchar(14) not null datetime Use a command to describe the table(Screenshot 5) Insert 2 patients randomly to the above table(Screenshot 6) Show all the contents of the table. (Screenshot 7)
Which one of the following statements is false? The Restrict Policy: reject modifications The Cascade Policy: automatically apply modifications to foreign key The Set Null Policy: set null in place the modified values None of the above
Discuss the difference between triggers and stored procedures.
which object can be used to speed up searches and quires in general? a) Index b) Unique c) Check d) Cascade
Task 3: The Marketing team wants to collect emails of the users on InstantStay. However, the team needs a SQL statement to execute inside their programming environment. You need to create a statement that they can easily run the EXECUTE command to return a single column table containing the USER_EMAIL addresses. Task: Create a prepared statement for use with the EXECUTE command.