Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
ned and un ned organisation ned and un ned organization if records are not permited to cross block boundaries then the organisation is
strong entity set and weak entity setstrong entity set and weak entity set a strong entity set has a primary key all tuples in the set are
where and having clause in sql the where clause is commonly used for implementing conditions on each tuple of the relation the having clause is used
explain the utilities which help the dba to manage the database every dba uses database utilities to maintain and control their databases but there
list any two disadvantages of a database system the disadvantages of database system arebull database systems are difficult complex and
explain dml with some examplesdml - data manipulation language statements used for managing data within schema objects some examplesbull select -
explain what is ddlddl - data definition language statements used to define the database structure or schema some examples create - to create objects
what are the four main characteristics of the database approachthe four major characteristics of the database approach are1 self-describing nature of
describe the responsibilities of the dba and the database designer the responsibilities of dba and database designer are1 planning for the databases
what are segments in oraclesegments - each table has single field of disk space known as segment set aside for it in the tablespace segments consist
explain data dictonary on oracle data dictionary - data dictionaries are the system tables in which contain descriptions of the database objects and
what is data blockdata block - in oracle the data blocks are referred to as tablespaces a tablespace is an fields of disk consisting of one or more
describe drop table command of sql along with both the options - cascade and restrict drop table command - this command drops the specified table
given the following relations vehicle regno make colour personeno name address ownereno regno write expressions in the relational algebra to answer
given the following relationstrain name start destticket pnrno start dest fare passenger name address pnrno write sql expressions for the following
define a relation relation - a relations is a named two-dimensional table of data mathematically a relation can be described as a subset of the
differance between ddl and sdlddl and sdl - the data definition language ddl is used through dba and database designers to describe internal schema
what is conceptual schemaconceptual schema - conceptual schema elaborates the structure of the overall database for a community of users it hides the
what is catalog in dbmscatalog - a relational dbms maintains information about every table and index in which it contains a catalog is a collection
explain degree of relationdegree of a relation - the degree or arity of a relation is the number of attributes n of its relation
explain interblock gapinterblock gap - a track of a disk is separated into equal-sized disk blocks blocks are separated through fixed-size gaps
what is distributed system distributed system - a distributed system consists of a number of processing parts in which are interconnected through a
what is derived and stored attributederived and stored attribute - in a few cases two or more attribute values are associated for example age and
what are the purpose for having variable length records what kinds of separator characters are required for each variable-length records -
describe participation constraintsparticipation constraints - the participation constraint exacts whether the existence of an entity depends on its