Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Q6a: Bob is a new customer service employee and needs to be able to read data from the Customer Table. Bob's database username is 'Bob'.

image text in transcribed
Q6a: Bob is a new customer service employee and needs to be able to read data from the Customer Table. Bob's database username is 'Bob'. Write the DCL (Data control language) statement to provide Bob with read access to Customer table Q6b: Bob was accidently given permissions to add records to the Customer table. Write the DCL (Data control language) statement such that Bob cannot add records to Customer table. 07: A university has two tables, Student and Alumni. STUDENT Table ALUMNI Table Attribute StudentID StudentName StudentMajor EnrollDate Data Type INTEGER(8,0) VARCHAR2/20) VARCHAR2120)|Alumn Attribute AlumnilD AlumniName Data Type INTEGER(8,0) VARCHAR2(20) VARCHAR2(20) DATE DATE GradDate In order to create a list of current students and Alumni who majored in Business, the following query was created. If the query below is valid, list how many columns will be displayed when the query is run. If the query is not valid, explain why, and describe how it can be corrected in this context. SELECT StudentID, StudentName, StudentMajor from STUDENT WHERE StudentMajor like 'Business' UNION SELECT Alumniname, AlumnilMajor, GradDate from ALUMNI WHERE AlumniMajor like 'Business

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Visualization A Practical Introduction

Authors: Kieran Healy

1st Edition

0691181624, 978-0691181622

More Books

Students also viewed these Databases questions

Question

Presentations Approaches to Conveying Information

Answered: 1 week ago