Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
how is the database organised in oracledatabase organized within oracle in terms of table and table holds attributes and valuesa database consists of
if one requires to access data using logical database the use of events is unavoidableyes if someone wants to access data using logical database then
is it mandatory to declare all the tables in report by the key word tables for all the tables that exist in the structure of ldb and are being
though all the abap4 dictionary structures that exists in the structure of the ldb being described in database program we are explaining the
what are the advantages of logical databases it offers a simple-to-use selection screens you can change the pre-generated selection screen to
for the relations answer the following queries in sqlstreet name location city house number streetname lives name housenumberi obtain the names of
it is mandatory that for every table in the ldb hierarchy there should exist one get statement in the report false it is not
consider the subsequent relations along with keys underlinedstreet name location city house number streetname lives name housenumber define the above
describe substring comparison in sql for the relation person name address write a sql query that retrieves the names of people whose name starts
what is null give an example to described testing for null in sqlthe null sql keyword is used to represent either a missing value or a value which
explain the exists and unique functions of sql give an example for eachexists the exists function takes one parameter that is a sql statement if any
what is recursive closure why is it not possible to describe this operation in relational algebra recursive closure is applied to recursive
differance between unordered and ordered file unordered file do no has any sequence although ordered file has arranged in a few sequence and data are
differance between open addressing and chaining for collision resolution in open addressing proceeding from the occupied position specified by hash
explain differance between primary and secondary storage primary and secondary storagecomputer storage is classified within primarymain memory and
what sorts of tables one can se in designing the hierarchy of a ldb tables which are having foreign key
discuss the types of integrity constraints in which must be checked for the update operations - insert and delete give examples insert operation can
what is entity in dbmsentity a dbms entity is either a thing in the modelled world or a drawing element in an
explain composite attribute in sql composite attribute a composite attribute has many components each of that is atomic or
explain recursive relationship typerecursive relationship type a recursive relationship is one in that the similar entity participates more than once
write a short note on participation roleparticipation role roles are indicating in e-r diagram by labelling the lines that connect diamonds to
what is the difference among a database schema and a database statethe collection of information stored in database at particular moment in time is
what are the situations while dbms should not be used dbms should not be used in situations likei no need of security ii not difficulty to access the
what three major types of actions includes databases briefly discuss these the three major types of actions including databases arei defining it
write a short note on qbe stands for query by example qbe is a feature involved along with various database applications which gives user-friendly