Q6a: Bob is a new customer service employee and needs to be able to read data fr

Question

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

Explanation / Answer

Please find my naswer for Q7.

Please repost others in separate post.

Query is NOT VALI.

Because:

The UNION operator is used to combine the result-set of two or more SELECT statements.

Each SELECT statement within UNION must have the same number of columns
The columns must also have similar data types
The columns in each SELECT statement must also be in the same order

Here we can see from FIRST query we are geting 3 columns where as from SECOND query we are getting only 2 columns

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.