Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
accessing information about permissions to all users-object level permissions with the use of data dictionary you can see the permissions to user let
the following variant of the primary copy asynchronous-update replication protocol has been proposed for totally replicated systemsa a
example revoke all on emp from example revoke all on emp from
example-grant create session to mca12this command gives system level permission on creating a session - not portablegrant select on emp to
a design a query plan for the following distributed query an application at site b wants to compute a join of student idstudid transcript where
create a new usercreate user lt user name gt identified by lt passwordgtexample create user mca12 identified by w123grant it is used to give database
a distributed transaction consists of subtransactions that execute at different sites and access local dbmss at those sites for example a distributed
data control the data control mostly refers to commands that permit system and data privileges to be passed to several users these commands are
consider a relation s over the attributes a and b with the following characteristics5000 tuples with 10 tuples per pagea 2-level b tree
sub query in the update commandexample double the commission for employees who have got at least 2
insert into command values can be inserted for all columns or for the selected columns values can be given by sub query in place of values parameter
having clause this clause is used for producing conditions on grouped informationexample find maximum salary and department number of those
group by clauses bull it is used to group database tuples on the basis of definite common attribute value like as employees of a department where
aggregate functions some of these functions are min count max and avg these functions help in getting consolidated information from a set of
order by clause by using this rows can be sortedit is used in the last portion of select statement by default it gets ascending order desc is used
logical operatorsrules of precedenceorder evaluatedoperator1all comparison operators2not3and4orexample to produce those records of salesman or
special comparison operator used in where clausea between andit gives range among two values inclusiveexampleselect ename sal from empwhere
to eliminate duplicate rows distinct operator exampleselect distinct deptno from
using literal character stringexampleto print ltnamegt is a ltjobgt as one string with column name employeeselect ename is a job as employee from
concatenation operatorexample printing name and job as one string as column name employees select enamejob employeesfrom
using column aliasesexampleto print column names as name and annual salary select ename name sal12 annual salary from
operator precedencethe basic operators used in sql are - operators of the similar priority are evaluated from left to rightparentheses are
select statementthis statement is used for retrieving information from the databases it can be coupled with many clauses let us talk about these
data manipulation languagedata manipulation language dml describes a set of commands that are used to query and change data within existing schema
drop table commandwhen an existing object is not needed for further use it is always better to eliminate it from the database to remove the existing