Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
explain the statements present in assembly languagean assembly program consists of subsequent three types of statementsa imperative statements this
how is oracle used in plsql define the features of process and how they are definedplsql - plsql is oracles procedural language pl superset
what is data model explain object based and record based data modelsans a data model is an abstract model in which describes how data is represented
explain the disadvantages of a file processing systemans disadvantages of file processing systems include 1 data redundancy 2 data inconsistency 3
explain the following functions of oracle with suitable examples i tochar ii count iii trim iv length ans i tochar the tochar function converts a
what are the key features of oracle key features of oracle are as followsbull read consistencybull concurrencybull locking mechanismsbull quiesce
explain instance and schemasinstances and schemas databases changes over time as the information is deleted and inserted the collection of
what are the disadvantages of relational approachdisadvantages of relational approachbull substantial hardware and system software overheadbull may
write short notes on relational constraintsrelational constraints are1not null2unique3primary key4foreign key5table
explain chaining to handle collisionchaining one easy scheme is to chain all collisions in lists attached to the suitable slot this permits an
consider the relationsemployeeemp name assignedtoproject emp projectproject projectname chief express the subsequent queries in relational algebrai
what are the several kinds of the update operations on relations also explain the constraints on these update operation give instance in support of
define properties to ensure good search performancea hashing function h should possess the subsequent properties to make sure good search
express the subsequent query in sql assumes which the data is stored within employee table with relevant fieldsi display name job salary and hire
what are the constituents of file also elaborates all the possible file operationsa file is organised logically as sequence of record these records
what is bucket overflow and how bucket overflow is handled through over flow chaining or closed hashing ans bucket unit of storage holding records
what is data independencedata independence techniques which permit data to be changed without affecting the applications in which procedure it there
explain record based logical modelsrecord-based logical models also define data at the conceptual and view levels unlike object-oriented models are
what is an e-r model draw an e-r diagram for the company database with following descriptionsthe company is organized within departments each
describes the several relationship constraints through giving suitable exampleconstraints on relationships there are two kinds of constraints on
how many types of users works on database users are differentiated through the way they expect to interact along with the systemi application
what are the four necessary conditions of deadlock prevention ans four essential conditions for deadlock preventiona the
what is dbms and what are functions of dbms dbms consist of collection of integrated data and set of program to admission those datathe functions
what is oracle process explain any four processes started by oracleoracle process is as follows smon the system monitor carries out a crash recovery
write a short note on built in function in qbebuilt in function in qbe qbe involves various built in functions like avg maxminsum and cnt we must