Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
define value setvalue set it is a set of values you do not always need a user to enter junk free text within all the fields therefore oracle apps
what is specializationspecialization specialization permits you to describe new types of information new structural types or latest domains of
describe hashing in dbmshashing hashing is a technique to store data within an array so which storing searching inserting and deleting data is fast
an employee record has the following structure struct employee int eno char name22 float salary char dept10i calculate the record size
what is the main goal of raid technology describe the levels 1 through 5 raid stands for redundant array of inexpensive or sometimes
discuss along with examples about several types of attributes present in the er model types of attributes arebull simple attributes are attributes
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