Task 2 - Assume that you are working as a database administrator for XYZ Company. You are asked write the code(Text) and result(Screenshot of result) with discussion of Tablespace Management as given below, d. i. Revoke the privileges from the roles. ii. Revoke the privileges from the roles.

Task 2 - Assume that you are working as a database administrator for XYZ Company. You are asked write the code(Text) and result(Screenshot of result) with discussion of Tablespace Management as given below, d. i. Revoke the privileges from the roles. ii. Revoke the privileges from the roles.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter9: Joining Data From Multiple Tables

Section: Chapter Questions

Problem 10HOA: An EMPLOYEES table was added to the JustLee Books database to track employee information. Display a...

See similar textbooks

Related questions

Q: In Oracle, if you have two tables related by connecting a primary key in table B and a foreign key…

A: For Inserting a Foreign key in any table , it is mandatory that the same key should be present as…

Q: Task 3: The Driver Relationship team wants to create some workshops and increase communication with…

A: Hi .. As per my company rule i can answer to the first question. You can post task 4 as another…

Q: The WorkOrders table contains a foreign key, ClientNum, which must match the primary key of the…

A: A foreign key is a key that is used to link two or more tables together. It also helps in…

Q: Update a driver's record using the ACTIVE_DRIVERS VIEW.

A: The given database has a table DRIVERS and a view that table named as ACTIVE_DRIVERS. The…

Q: Task 2 - Assume that you are working as a database administrator for XYZ Company. You are asked…

A: Create two users using your DBA permissions---- GRANT CONNECT TO username IDENTIFIED BY password.

Q: Assume that Marcia’s has the following personnel: two owners, a shift manager, a parttime…

A: Given: Assume that Marcia’s has the following personnel: two owners, a shift manager, a parttime…

Q: Display the Employee name and designation in one column. Display all records from table whose name…

A: As per our guidelines we are supposed to answer only 1st three parts. Kindly repost the remaining…

Q: |1. which one(s) of the following change(s) the name of a database? a) sp_rename d) alter name c)…

A: (Q1)a and cit changes the namer of the database. (Q2) A,B&D these are the attributes which are…

Q: The marketing team wants to celebrate the success of StayWell with a party. The team wants a table…

A: SELECT FIRST_NAME as PARTICIPANT, SURNAME AS LAST_NAME FROM RESIDENTSUNIONSELECT FIRST_NAME as…

Q: - Assume that you are working as a database administrator for XYZ Company. You are asked write the…

A: Actually, database is a used to stores the data/information.

Q: First Task: Create Database using PHPMyAdmin that includes two tables: 1. Order (OID, Price, and…

A: Given Task : Create Database: purchasing Number of tables: 2 Table 1 : Name: Order Attributes:…

Q: write the proper command to create all the tables with the relation between the tables. Assume the…

A: Introduction: As per the given problem statement, find the way using the street and develop a python…

Q: The following tables form part of a database held in a relational DBMS (Primary Key, Foreign Key):…

A: Note: Since multiple questions have been asked at a single request, we will answer first three…

Q: true /false The system-defined database used as a template for all “to be created”…

A: Answer to the above question is in step2.

Q: descending order by duration. Name this query Q2 – CallDuration. c. For each customer who has a…

A: Finding customers for your business is not easy. And once you find them, there comes another…

Q: The Driver Relationship team wants to have quick search options for the active drivers. The team…

A: Task 4: INDEX is used search/retrieve data more quickly. It is basically used to speed up query.…

Q: Referring to Appendix A below, code a MySQL statement to display the item number and name for all…

A: As I get from your question, you want to run and show different queries.

Q: Part 7 8 9 Following script is given to you at Google Classroom. Run script to generate tables in…

A: (i)Display the employee id, name, salary, commissioned salary (incremented salary +commission) with…

Q: You have been given the task of documenting the process and commands required for creating a new…

A: Student_1 Ассess соmmаnd line аnd enter MySQL server:mysql The sсriрt will return this…

Q: Book (BookID, Price, Year, Author, Subject) BorrowLog (BID, BookID, CustomerID, DateTime) Customer…

A: DDL or Data Definition Language actually consists of the SQL commands that can be used to define the…

Q: Establish referential integrity between the Sales Rep table (the one table) and the Customer table…

A: Referential integrity constraints means when a table is referencing another table by using it's…

Q: Create dept_manager table with emp_no as primary key and auto increment and not null for other…

A: SUMMARY: -Hence, we discussed all the points.

Q: First Task: Create Database using PHPMyAdmin that includes two tables: 1. Order (OID, Price, and…

A: Below are the required queries:

Q: IN MYSQL write the command. Using the UML designed create all the necessary tables for your…

A: Necessary tables for given UML.

Q: Create Table Maintenance_Record( MaintenanceID int NOT NULL, Description_of_Maintenance…

A: Why error is occur : 1.In this sql query may be , invalid column name, 2.column name does not…

Q: 1.6) Constraints should be used to force valid data entry / modification to the database True …

A: 1.6) The Correct Answer for the above questions("True") Explanation⦁ In a relationship model,…

Q: Which is not included in the ACID properties of transactions? O A. Durability or permanency Changes…

A: In the context of transaction processing, the acronym ACID refers to the four key properties of a…

Q: Task 5: The marketing team wants to celebrate the success of StayWell with a party. The team wants…

A: The solution for the above given question is given below:

Q: Oracle APEX. EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) DEPT (DEPTNO, DNAME, LOC)…

A: DUE TO GUIDELINES, WE CAN ANSWER ONLY ONE QUESTION CREATING TABLES USING oracle APEX CREATE TABLE…

Q: Using your knowledge of BITS, determine the functional dependencies that exist in the following…

A: To convert to 3NF, we need to ensure that no non-key attribute is transitively dependent on the…

Q: Task 1: Create a database in Access or in SQL server or in any other RDBMS: Create a database…

A: Find the required answer given as below :

Q: To create the update to the Table of orders which breaches referential integrity, a customer table…

A: Information Provided: CustomerNum is a foreign key in the Orders table and a primary key in the…

Q: Create a trigger on WORKS_ON, if a new tuple with Hours=NULL is inserted, set the Hours to 0. 6.…

A: Actually, A trigger is a stored procedure in database which automatically invokes whenever a…

Q: 15. A table is said to exhibit referential integrity if: a. it has no foreign key. b. it has a…

A: A table is said to exhibit referential integrity if : it has a foreign key, and all the foreign key…

Q: 2) Task 2 - Assume that you are working as a database administrator for XYZ Company. You are asked…

A: The complete answer is given below .

Q: Match each of the following actions according to their designated function used to enforce…

A: database managemnt design function used to enforce Confidentiality , Integrity and Availability.

Q: Task 10: User Oliver must be able to retrieve data from the PROPERTY table. Task 11: Users Crandall…

A: Given: Task 10: User Oliver must be able to retrieve data from the PROPERTY table. Task 11: Users…

Q: WORKING IN CENGAGE AND CAN'T FIGURE OUT THIS TASK. I TRIED OTHER STAEMENTS BUT DID NOT WORK EITHER.…

A: CONCAT is an SQL function that combines two or more than two strings together. Syntax for it is…

Q: Driver Relationship team wants to create some workshops and increase communication with the active…

A: Here I am giving solution with tables , active drivers.

Q: Assume that you are working as a database administrator for XYZ Company. You are asked write the…

A: Actually, database is a used to stores the data/information.

Q: Match each of the following actions according to their designated function used to enforce…

A: Confidentiality means the encrypted data which kept secret and contains limited access. Integrity…

Q: Differentiate between left outer join and right outer join with respect to their functionality and…

A: Actually, database is a used to stores the data.

Q: How would you add PK to a table, without dropping it, for which no PK was declared with Create.

A: You can add primary key using alter table command. Below is the syntax , set it accordingly .

Q: Task 4: The Driver Relationship team wants to have quick search options for the active drivers.…

A: Here we write a simple mysql code for find the active driver id,name: we write two method to get…

Q: TASK 2 Design a database to store student personal details, module details, and assessment results…

A: Answer: I have done code and also I have attached code as well as code screenshot.

Q: Referring to Appendix A below, code a MySQL statement to display the sales order number and customer…

A: code a MySQL statement to display the sales order number and customer name for all sales orders.…

Q: Assignment 1. Create a database called book_store that has a table called books in which has…

A: Solution Given that 1 Create a Database called Book_store that has a table called Books. 2 Create…

Q: Create Blank database Create table using datasheet view and design view Enter at least 3 rows in…

A: A database is a systematic collection of data. That can be stored and accessed electronically from a…

Q: Which of the following is a valid characteristic of a VIEW?

A: Views are virtual tables that can be a great way to optimize your database experience. They also…

Concept explainers

Procedures in SQL

A pre-compiled stored procedure is a logical unit made up of one/more SQL statements (SQL stands for Structured Query Language). The database server saves it as an object. An SQL procedure is a collection of SQL statements and logic that is written and saved to accomplish a specified goal. An SQL procedure consists of a name, a parameter list, and a set of Transact-SQL statements. Stored procedures are stored as named objects in SQL Database Server.

Question

d.
i. Revoke the privileges from the roles.
ii. Revoke the privileges from the roles.

Organized collection of structured information, or data, typically stored in a computer system.

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

i. Revoke the privileges from the roles.

VIEW

ii. Revoke the privileges from the roles.

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

An EMPLOYEES table was added to the JustLee Books database to track employee information. Display a list of each employee’s name, job title, and manager’s name. Use column aliases to clearly identify employee and manager name values. Include all employees in the list and sort by manager name.
Task 2 - Assume that you are working as a database administrator for XYZ Company. You are asked write the code(Text) and result(Screenshot of result) with discussion of Tablespace Management as given below, a. iv. Insert values until it now longer has space for new rows.
Task 6: The StayWell Property Management team considers creating a discount scheme for the property owners with more than one property in the system. You will need to provide all the owner IDs (OWNER_NUM) and the count of properties of the owners with more than one active property in the database. The output columns should be OWNER_NUM and COUNT(*) respectively.
2) Task 2 - Assume that you are working as a database administrator for XYZ Company. You are asked write the code(Text) and result(Screenshot of result) with discussion of Tablespace Management as given below, A)ii. create a table with four columns in the tablespace created.
Task 2 - Assume that you are working as a database administrator for XYZ Company. You are asked write the code(Text) and result(Screenshot of result) with discussion of Tablespace Management as given below, B)Create two users using your DBA permissions. Allot tablespace created to these users.
Given the schema below: Developer(DevCode, DevName, DevAddr, DevEmail, DevTel) Proj(ProjCode, ProjTitlee, BeginDate, EndDate) SW(SWCode, SWName, SWPrice, ProjCode) Task(DevCode, ProjCode) Create a view that contains all projects and the SW developped within the project grouped by project. Write a PL / SQL block to display the details of projects which have software having a price more than 100. This block should display ProjCode, ProjTitleName, SWTitle and SWPrice.
Create the database name Company which consists of one Entity name Employee which consists of 10 attributes (ID/First Name/Last Name/CNIC/Gender/Department/Salary/Address/Age) ID should be primary key Insert at least 10 records in the Entity Employee with respect to their type. Implementation the example of stored procedure now creates the stored procedure which: Have an ability to insert the record in the table. Have an ability to delete the record in table. Have an ability to update the record in the table. Have an ability to display the record in the table.
Create a user etec224. (Screenshot 1) Create a database Bank. (Screenshot 2) Grant etec224 privileges to Bank(Screenshot 3) As etec 224, create a table customers with the following structure. (Screenshot 4) CustomerID int(12) Primary Key and not null AccountNo int(12) FirstName varchar(15) not null LastName varchar(15) not null Birthday datetime Balance double(10,2) use a command to describe the table(Screenshot 5) insert 3 customers randomly to the above table(Screenshot 6) show all the contents of the table. (Screenshot 7) Were you able to complete the commands? True False
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.
Implement your table design by creating table statements. Your tables should have constraints such as primary keys and foreign keys. (You can use MySQL Workbench or any other database management system of your choosing). Types such as Char, Integer must be correctly placed. 2) Add one trigger to your database that utilizes a default function of your DBMS 3) Add dummy data to your database. (5 manual entries for each table should be sufficient.) 4) Consider the nominal forms and integrity of your database, it will affect your grade. Export your database from your DBMS, zip it and submit the zip file. Thank you!
Task 1: Create a database in Access or in SQL server or in any other RDBMS: Create a database having a table with appropriate fields and properties as per the scenario. Include records for at least 10 employees with attributes such as employee ID, employee name, number of doses, and vaccination status (unvaccinated, partially vaccinated, and fully vaccinated). Provide screenshot(s) of the process of creating the database including the database server role together with explanations of the steps taken to complete the task.
Task 5: The marketing team wants to celebrate the success of StayWell with a party. The team wants a table with the names of all residents and owners combined into single column named PARTICIPANT. You need to combine this information from the tables and send it back to the team. You do not need to create a new table in the database schema. Task Return a list of all the residents and owners Task 6: The StayWell marketing team wants to send mail to all residents. You need to return the first name and surname of all the residents combined as NAME, with their addresses named ADDRESS. However, the address should be retrieved from the PROPERTY table for residents.