Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

15 Consider the table name company identify which of the following SQL statement is valid with respect to view wo a.create view as select from

image text in transcribed
15 Consider the table name company identify which of the following SQL statement is valid with respect to view wo a.create view as select from company b. None of the three c create or replace view v1 select from company d.create or replace view v1 as select from company 16 wto Identity the correct SQL statement to remove insert privilege from the user Raja on the table result a. Revoke insert on result to Raja b. Grant insert on result to Raja c Revoke insert on result from Raja d. Grant insert on result from Raja 17 Choose the correct SQL query to create a role admin from the following a Create role admin b. Create admin c. None of the three d. Create tole rolname admin 18 Identify the TCL statement that will save all the changes permanently after executing the below SOL statements Sovepoint 51 Update emp set designation = "clerk Savepoint S2 Delete from emp Rollback b. Rollback to savepoint 51 Savepoint d. Commit

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

Select Healthcare Classification Systems And Databases

Authors: Katherine S. Rowell, Ann Cutrell

1st Edition

0615909760, 978-0615909769

More Books

Students also viewed these Databases questions

Question

=+C&B (especially taxation) laws, regulations, and practices?

Answered: 1 week ago