Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
define union compatibility explain why intersection of two relations cannot be performed if they are not union compatible two relations ra1 a2-------
for the relations r and s given belowr sabc147258369compute i
differentiate between natural join and outer joinnatural join is a binary operator which is written as r s where as r and s are relations the output
explain triggertrigger a database trigger is procedural code which is automatically executed within response to certain events on a particular table
describe database state in detailsdatabase state the actual data within the database at a particular moment in time is known as a database
describe the host languagehost language you could write applications along with sql statements embedded inside a host language the sql statements
define dbmsdbms database management system dbms is computer software designed for the reason of supervision databases based on a variety of data
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