Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
let consider the given partial relation emp let us make some sub-queries for
nested querieslet us see some more complex queries in this sectionsub-queriessome of the basic concerns of sub-queries are a sub-query is a select
a multiplattered hdd is formatted into twenty sectors and 16 hundred cylinders there are eight platters and 16 rw heads the total capacity of the
draw a memory map for a system with a memory capacity of 256mb each memory location in the system is 8 bits assume the system has one 4 mb memory
consider an 8-bit system with 32 memory locations numbered from 0 to 31 and 8 different instructions assume op code for load accumulator instruction
outer join the use of outer join is that it still joins those tuples that do not have matching values in common columns are also contained in the
assume 64 different op codes and 19-bit instruction word in a computer system two bits in the instruction are reserved to indicate the addressing
natural join it is the similar like equi join except one of the duplicate columns is removed in the result table the natural join is the most usually
equi join a join in which the joining condition is based on equality among values in the common columns common columns show redundantly in the result
table handling in rdbms more than one table can be tackled at a time by using join operation join operation is a relational operation that causes
synonyms it allows short names or alternative names for objectsexample create synonym
creation of indexesautomatically when a primary key or unique constraint is show in a table definition then a unique index is formed
synonyms and indexessome of the essential properties of indexes are an index is a schema object indexes can be formed explicitly or automatically
modify a sequencealter sequence seqssincrement 2maxvalue 3000 removing a sequencedrop sequence
gaps in sequence values can happen when- a rollback happens that is when a statement changes are not accepted- when
flatten the treeconsider the following xml input which groups people into two categories-salaried and
attributes to elementscreate an xslt stylesheet that converts all attributes found in a given xml document to elementsuse the sample instance from
consider the following schema dtd and sample instance documentltdoctype census ltelement census persongtltelement person persongtltattlist
you are to build a schema in xml schema language that will be used to support the development of the new central course information management system
example create a sequence named seqss that starts at 105 has a step of 1 and can take maximum value as 2000 create sequence seqss start with
sequencessequences automatically produce unique numbers are sharable are typically used to make a primary key value replace application code speed up
creating views with replace option this option is used to alter the definition of the view without recreating and dropping it or regranting object
creating views with read only option in the view definition this option is used to make sure that no dml operations can be done on the
creating views with check option this option limits those updates of data values that cause records to go off the view the following instance tells