]

Success is no accident. It is hard work, perseverance, learning, studying, sacrifice and most of all, love of what you are doing or learning to do.

Collaboration works better than competition

“There will be obstacles. There will be doubters. There will be mistakes. But with hard work, there are no limits.” —Michael Phelps

Collaboration works better than competition

“There will be obstacles. There will be doubters. There will be mistakes. But with hard work, there are no limits.” —Michael Phelps

Collaboration works better than competition

“There will be obstacles. There will be doubters. There will be mistakes. But with hard work, there are no limits.” —Michael Phelps

Collaboration works better than competition

“There will be obstacles. There will be doubters. There will be mistakes. But with hard work, there are no limits.” —Michael Phelps

Collaboration works better than competition

“There will be obstacles. There will be doubters. There will be mistakes. But with hard work, there are no limits.” —Michael Phelps

Tuesday, 15 August 2017

INDIA LEADS TO 5G TECHNOLOGY SOON





By 2019 India become the 5G 

enabler service with the top leadership country like US ,CHINA etc.
It is JIO that take a initiative step which provide the call via data packets and advancely families the rural network within a short range of time to associate the 4G service and again the data analysis based on that free data made an successful version to get a  dominating data network on India and it's started working on best 5G technology to get a better ,advance & smart India .
Apple gets NODE to test its 5G technology 

Nokia also get associated with AIRTEL and VODAFONE for selling the best product of 5G enable device as NOKIA goes down due to android its enhanced it's features to get best biting of CHINA market dominating smartphone with best authority to INDIA market JIO Also take a initiative step with data enable JIO INTELLIGENT PHONE to lead on business market of price 1500only 
Associated with different company like MIETY,CDAC and other privete commercial iot application centre the data of 4G  is changing to 5G

The Indian government it seems is aiming to adopt 5G technology alongside other developed markets, given its focus on programmes like Digital India. The government has commissioned a research team on 5G technology, 




Indian government starts work on 5G

VoLTE stands for Voice over LTE and is a new protocol for transmitting voice data over the LTE network. While 2G and 3G networks are circuit-switch based, 4G or LTE networks utilise Packet Switching. When a call is made over a 2G or a 3G network, a certain amount of network bandwidth is assigned to that call as a pipeline, which does not terminate till the call ends. On a VoLTE network, voice calls are broken up into packets of information, sent over the full data pipeline and then reconstructed at the receiver’s end. The result is that voice information can be carried over a higher bandwidth pipe, resulting in better call quality.
{*****THE TIMES OF INDIA}


which has already filed 100 patents so far, of which around 10 have already been granted. This team comprises researchers from IISc Bangalore, IIT Bombay, IIT Hyderabad, IIT Madras and Centre of Excellence in Wireless Technology, IIT Madras. Kiran Kuchi, professor at department of electrical engineering at IIT Hyderabad has said, “We are scaling up fast and switching gears because 5G is just around the corner.” To aid these researchers, companies like Reliance Jio, Tejas Networks and other similar startups have also offered help by lending their manpower and equipment. 5G is the fifth generation of wireless networks that are expected to offer not just more speed for end users, but also have the capacity to connect billions of devices like driverless cars and household appliances that will connect to the Internet in the near future.
                          

                                                                                          Multi Source:Internet 
Share:

MAGNETIC SELF HEAL TECHONOLOGY

DEVELOPING WORLD LEADS TO INNOVATION


Leading science Does Not stop with embedded sensors its act as a best way to reveal the self-healing effect automation over anything thats show the world changing the man power to automated sensors with lead the globe like 90% science of 100% ,It's seem the total techonology of old Gods magic going with special reserch and make it real seems the the magic came true into world 
possible.


                                 NOTHING IS MAGIC ITS ALL ABOUT SCIENCE STEP

self heal technology electronics

A research by the engineering lab team at University of California, San Diego, USA, is hoping to fix gadgets by creating magnetic ink particles that could self-heal these devices when these break. 
Sensors printed with this ink would magnetically attach to 
each other 
when a rip or tear occurs, 
automatically fixing the 
device at the first sign of disintegration.
 The self-healing effect is brought 
upon by the use of pulverised neodymium magnets in the ink, most often found in refrigerators and hard drives. This process is a lot faster than the conventional method of heating chemicals, which would take up to hours a day. Amay Bandodkar, a member of the team, has compared the ink’s self-healing ability to that of our skin. He has estimated that about US$ 10 worth of ink can create hundreds of small devices. This will help in waste reduction, because the need for throwing broken gadgets will reduce after the self-healing ink comes into action.
Whe
                                                           source:"internet,magazine "
                                                                     A way of betterment
Share:

Sunday, 13 August 2017

8085 MICROPROCESSOR SHORT QUESTIONS AND ANSWER GATE,IES,PSU FUNDAMENTAL Q BY SATYANARAYAN PRADHAN

MICROPROCESSOR AND MICROCONTROLLER QUESTION WITH ANSWER 8085
PROVIDED BY ASST. PROF,SATYANARAYAN PRADHAN
GANDHI ENGINEERING COLLEGE, BHUBANESWAR
ELECTRONICS AND COMMUNICATION ENGINEERING DEPT.

1. What is Microprocessor? Give the power supply & clock frequency of 8085
     
     Ans:-A microprocessor is a multipurpose, programmable logic device that reads
binary instructions from a storage device called memory accepts binary data as
input and processes data according to those instructions and provides result as
output. The power supply of 8085 is +5V and clock frequency in 3MHz. 

2. List few applications of microprocessor-based system. 
  Ans:-
It is used:
i. For measurements, display and control of current, voltage, temperature, pressure, etc. 
ii. For traffic control and industrial tool control.
iii. For speed control of machines.

3. What are the functions of an accumulator?

The accumulator is the register associated with the ALU operations and
sometimes I/O operations. It is an integral part of ALU. It holds one of data to be
processed by ALU. It also temporarily stores the result of the operation performed
by the ALU.


4. List the 16 – bit registers of 8085 microprocessor.

Stack pointer (SP) and Program counter (PC).

5. List the allowed register pairs of 8085.

  1. B-C register pair
  2. D-E register pair
  3. H-L register pair

6. Mention the purpose of SID and SOD lines
SID (Serial input data line):
It is an input line through which the microprocessor accepts serial
data.
SOD (Serial output data line):
It is an output line through which the microprocessor sends output
serial data. 
7. What is an Opcode?

The part of the instruction that specifies the operation to be performed is
called the operation code or opcode
8. What is the function of IO/M signal in the 8085?

It is a status signal. It is used to differentiate between memory locations
and I/O operations. When this signal is low (IO/M = 0) it denotes the
memory related operations. When this signal is high (IO/M = 1) it denotes
an I/O operation.
9. What is an Operand?

The data on which the operation is to be performed is called as an
Operand.
10. Control signals used for DMA operation are
HOLD & HLDA. 

11. What is meant by interrupt?

Interrupt is an external signal that causes a microprocessor to jump to a
specific subroutine. 
12. Explain priority interrupts of 8085.

The 8085 microprocessor has five interrupt inputs. They are TRAP, RST
7.5, RST 6.5, RST 5.5, and INTR. These interrupts have a fixed priority of
interrupt service. If two or more interrupts go high at the same time, the 8085 will service
them on priority basis. The TRAP has the highest priority followed bye RST 7.5,
RST 6.5, RST 5.5. The priority of interrupts in 8085 is shown in the table. 
Interrupts Priority
TRAP 1
RST 7.5 2
RST 6.5 3
RST 5.5 4
INTR 5
13. What is a microcomputer?

A computer that is designed using a microprocessor as its CPU is called
microcomputer
14. What is the signal classification of 8085

All the signals of 8085 can be classified into 6 groups
  • Address bus
  • Data bus
  • Control and status signals
  • Power supply and frequency signals
  • Externally initiated signals
  • Serial I/O ports

15. What are operations performed on data in 8085
The various operations performed are

Store 8-bit data
Perform arithmetic and logical operations
Test for conditions
Sequence the execution of instructions
Store data temporarily during execution in the defined R/W
memory locations called the stack

16. Steps involved to fetch a byte in 8085
i. The PC places the 16-bit memory address on the address bus
ii. The control unit sends the control signal RD to enable the memory
chip
iii. The byte from the memory location is placed on the data bus
iv. The byte is placed in the instruction decoder of the microprocessor and
the task is carried out according to the instruction
17. How many interrupts does 8085 have, mention them

The 8085 has 5 interrupt signals; they are INTR, RST7.5, RST6.5, RST5.5

and TRAP. 

18. What is an instruction?

An instruction is a binary pattern entered through an input device to
command the microprocessor to perform that specific function.

19. What is the use of ALE

The ALE is used to latch the lower order address so that it can be available
in T2 and T3 and used for identifying the memory address. During T1 the ALE
goes high, the latch is transparent ie, the output changes according to the input
data, so the output of the latch is the lower order address. When ALE goes low the
lower order address is latched until the next ALE.

20. Explain the signals HOLD, READY and SID

HOLD indicates that a peripheral such as DMA controller is requesting the
use of address bus, data bus and control bus. READY is used to delay the
microprocessor read or write cycles until a slow responding peripheral is ready to
send or accept data. SID is used to accept serial data bit by bit.

21. Explain the different instruction formats with examples

The instruction set is grouped into the following formats

One byte instruction
Two byte instruction
Three byte instruction

MOV C,A
MVI A,39H
JMP 2345H
                                        GANDHI ENGINEERING COLLEGE, BHUBANESWAR

                           ELECTRONICS AND COMMUNICATION ENGINEERING DEPT.
1. On which model is based the basic architecture of a digital computer?
ANS;

The basic architecture of a digital computer is based on Von Neumann model.

2. What is meant by distributed processing?
ANS:

Distributed processing involves the use of several microprocessors in a single

computer system. For example, for such a system, the first microprocessor may control
keyboard activities, the second controls storage devices like disk drives, the third controls
input/ output operations, while the fourth may act as the main system processor.

3. What is the technology used in microprocessor?
ANS:
NMOS technology is used in microprocessors.

4. How does the microprocessor communicate with the memory and input / output
devices?
ANS:

The microprocessor communicates with the memory and input / output
devices via three buses, viz., data bus, address bus and control bus.

5. What are the different jobs that the CPU is expected to do at any given point of time?
ANS:

The CPU may perform a memory read or write operation, an I/O read or write

operation or an internal activity.
6. What is mnemonic?
ANS:

It is very difficult to understand a program if it is written in either binary or
hex code. Thus the manufactures have devised a symbolic code for each instruction,
called a mnemonic.

7. What is machine language programming?
ANS:

Programming a computer by utilizing hex or binary code is known as machine

language programming.
8. How many different instructions microprocessor 8085 has? What is an instruction set?
ANS:

8085 microprocessor has a total 74 different instructions for performing

different operations or tasks.

The entire different instructions that a particular microprocessor can handle is

called its instruction set.
9. What an instruction consists of?
ANS:

An instruction consists of an operation code (called opcode) and the address of

the data (called operand), on which the opcode operates.

Operation code(op code) Address of data (operand)
Field1 field 2

10. In how many groups can the signals of 8085 be classified?
ANS:

The signals of 8085 can be classified into seven groups according to their

functions. These are:

(a) Power supply and frequency signals
(b) Data and Address buses
(c) Control bus
(d) Interrupt signals
(e) Serial I/O signals
(f) DMA signals
(g) Reset signals
11. What is the operating frequency of 8085?
ANS;

8085 operates at a frequency of 3 MHZ, and the maximum frequency of

operation is 500 KHz.

The versions 8085 A-2 operates at a maximum frequency of 5 MHz

12. What is the purpose of CLK signal of 8085?
ANS;

The CLK (out) signal obtained from pin 37 of 8085 is used for synchronizing

external devices.
13. What are the temporary registers of 8085?
ANS:
The temporary registers of 8085 are temporary data register W and Z registers.
These registers are not available to the programmer, but 8085 uses them internally to
hold temporary data during execution of some instructions.
14. In what other way HL pair can be used?
ANS:

HL register pair can be used as a data pointer or memory pointer.

15. Describe the Status Register of 8085?
ANS:

Explain the Flag registers and the structure.

16. What is the purpose of increment/decrement address latch register?
ANS:

These 16-bit registers increment/decrement the contents PC or SP when

instructions related to them are executed.
17. What is an instruction?
ANS:

An instruction is a command which asks the microprocessor to perform a

specific task or job.
18. What is meant by instruction set?
ANS:

The entire different instructions that a particular microprocessor can handle is

called its instruction set.
19. What are the different types of data transfer operations possible?
ANS:

The different types of data transfer operations possible are cited below;

 Between two registers.
 Between a register and a memory location.
 A data byte can be transferred between a register and a memory location.
 Between an I/O device and the accumulator.
 Between a register pair and the stack.
The term ‘data transfer’ is a misnomer – actually data is not transferred, but copied from
source to destination.

20. Explain the two instructions (a) LDAX and (b) STAX
ANS;

The instruction LDAX indicates that the contents of the designated register
pair point to a memory location and copies the content of the memory location into the
accumulator.
As an Example: let D=40H, E= 50H and memory location 4050H =AB H. Then LDAX D
transfers the contents of memory location 4050H to the accumulator. Thus, after the
execution of instruction, ACC = AB H.
Register contents                                     Memory                             Register contents after
Before execution                                                    location                                          instruction

A XX XX F A AB XX F
D 40 50 E 4050 AB D 40 50 E
STAX stands for ‘store accumulator indirect’. The contents of the accumulator are copied
into the memory location specified by the contents of the register pair.
As an example, let D=40 H and E = 50 H and ACC = AB H. Then STAX D stores the
accumulator contents in the memory location 4050 H.

21. What happens when HLT is executed in software?
ANS:

All the buses go into tri-state on execution of HLT instruction.

22. Explain DAA instruction with example?
ANS:

It stands for ‘decimal adjust accumulator’.
Execution of DAA instruction converts the contents of the accumulator into
two BCD values. The system utilities the AC flag (not accessible by the programmer, but
is used internally for DAA operation) for this conversion by the following the procedure
stated below,
(a) If the lower order 4-bits (D3 – D0) of the accumulator is greater than 910 or if the AC
flag is set, then this instruction (i.e., DAA) adds 0610 to the low-order 4-bits.
(b) If the higher order 4-bits (D7 - D4) of the accumulator is greater than 910 or if the CY
flag is set, then this instruction (i.e., DAA) adds 6010 to the high –order 4 – bits.
EXAMPLE: Discussed in the class
23. What the instruction DCR M stands for?
ANS:

Here the memory location M is pointed to by the content of HL register pair.
On executing DCR M, the content of the memory location is decremented by 01. Thus, if
the memory location, as pointed to by HL register pair is AB H, then DCR M makes the
content of that memory location to be AA H. 

25. What is stack?
ANS:

A stack is a group of memory locations in the R/ W.

26. How the stack is intialised?
ANS:

The stack is initialised by a 16 – bit register, called the stack pointer (SP)

register.
27. What type of memory is the stack?
ANS:

Stack is a ‘last-in first-out’ or LIFO type memory. This means that data which

is pushed last into stack is popped out of it first.
28. How the stack is initialised?
ANS:

The stack is initialised by means of the stack pointer. The software instruction

is like this: LXI SP, 0033H.
It means that the stack is initiated at the memory location 3300 by the stack pointer.
29. By how many memory locations SP is decremented / incremented when PUSH/ POP
instruction is performed?
ANS:

SP is decremented/ incremented by the two memory locations when PUSH/

POP is executed.
30. What is a subroutine?
ANS:

A subroutine is a group of instructions, written separately from the main
program, which performs a function that is required repeatedly in the main program.
31. Why a subroutine is used in a program?
ANS:

Since a subroutine is called more than once by the main program, thus, use of
subroutines saves subroutine, hexa-decimal converter subroutine, display subroutine is
called by the main program, the more is the saving of memory space.
32. Explain nesting of subroutines.
ANS:

The process of a subroutine calling a second subroutine and the second
subroutine in its turn calling a third one and so on is called nesting of subroutine.
Theoretically speaking, the number of subroutines that can be called by this

process is infinite but, in practice it is limited by the size of memory.
EXAMPLE:
33. Write a program which will store the contents of accumulator and flag register at
2000H and 2001H memory locations respectively. (Using PUSH & POP instructions)
ANS:
The following is the program for the above, using PUSH – POP instructions.
LXI SP, 4000 H: Accumulator
PUSH PSW: Accumulator and flag register contents pushed into stack
POP B: Accumulator content goes to B and flag register content goes C register
MOV A, B: Content of B taken to accumulator
STA 2000H: Accumulator content stored into memory location 2000 H
MOV A, C: Content of C moved to accumulator
STA 2001H: Accumulator content stored into memory location 2001 H
HLT: Program halted

34. What is the function of S0 & S1.






S1 S0 OPERATION
0 0 HALT
0 1 WRITE
1 0 READ
1 1 FETCH     


35. Explain different between JMP and CALL instructions?
ANS:

WEKIPIDIA
36. Why do you use XRA A instruction?
ANS:

The XRA A instruction is used to clear the contents of the Accumulator
and store the value 00H.
37. Compare CALL and PUSH instructions?
ANS:





CALL PUSH
When CALL is executed themicroprocessor
automatically stores the16-bit address oF
the instruction next toCALL on the stack.
The programmer uses the instructionPUSH
to save the contents of the registerpair on
the stack.
When CALL is executed the stack
pointeris decremented by two.
When PUSH is executed the stackpointer register
is decremented by two.


38. Compare RET and POP instructions?
ANS:



RET POP
RET transfers the contents of the
top twolocations of the stack to the PC.
POP transfers the contents of the top
twolocations
of the stack to the specified registerpair
When RET is executed the SP is
incrementedby two.
When POP is executed the SP is
incrementedby two.
Has 8 conditional RETURN instructions. No conditional POP instructions.
39. Write the Evolution of Microprocessors?
ANS:
SEARCH WEKIPEDIA


40. What is memory capacity? How it can be expressed?
ANS;

Memory capacity is specified with the product of address (i.e. 2n. Where ‘n’ is

the number of address bit) and data line.

(a) Generally memory capacity can be expressed as,
Memory capacity = Address * Data
(b) The standard expressions are, 1 KB, 2 KB, 16 KB etc.

41. How memory address lines are calculated for a given memory locations?
ANS:

The following procedure are used for calculation of memory address line

i.e. log (2x) = log (memory locations)
=> x log (2) = log (memory locations)
=> x = log (memory location) / log (2)
42. What is memory capacity? How it can be expressed?
ANS:

Memory capacity is specified with the product of address (i.e. 2n. Where ‘n’ is

the number of address bit) and data line.

(a) Generally memory capacity can be expressed as,
Memory capacity = Address * Data
(b) The standard expressions are, 1 KB, 2 KB, 16 KB etc.
43. Write the comparison between static RAM & Dynamic RAM.
ANS:


SEARCH WEKIPEDIA

44. Explain in brief the difference Read Only Memory.
ANS:

The different kinds of Read only Memory is given below,
(a) PROM (b) EPROM (c) EEPROM (d) MASKED ROM (e) FLASH MEMORY
Write two points for each ROM.

45. (Write an assembly language program)
Ten number 8-bit data are stored starting from memory location 2100H. Transfer this
entire block of data to memory location starting from 3100H.
ANS:

MVI B, 0A H
LXI H, 2100 H
LXI D, 3100 H
LOOP: MOV A, M
STAX D
INX H
INX D
DCR B
JNZ LOOP
HLT

ASST. PROF. SATYANARAYAN PRADHAN




DOWNLOAD LINK FOR PDF VERSION   CLICK HERE
Share:

Monday, 6 March 2017

MINOR DBMS QUESTION BANK FOR PRACTICE,Branch : MECH-B,EEE,CIVIL,ECE




MINOR DBMS QUESTION BANK FOR PRACTICE 
QUESTION BANK
Session: 2017-18
Sem : 4th
Branch : MECH-B,EEE,CIVIL,ECE
Department :CSE
Subject : DBS(MINOR)
Code : PCCS4304
Course Name : B.TECH
Subject Teacher:ELINA PATTNAIK MAM, R.SUBBA RAO SIR(GEC)
Full Mark: 50

A) MCQ(multiple choice question) :
1. Files are located by operating system with help of
    a)addressing system    b)path file system c)directory file system d)header file system
2. Which of the following is the oldest database model?
  a) Relational  b) Hierarchical  c) Physical  d) Network
3.E-R modeling technique is
    a)Tree structure b)Top- down method c)Bottom-up method d)Right -left approach
4. which of the following is record based logical model(s)?
a)Network Model  b)Object-oriented model c) Relational Model Entity d)Relationship Model
5. Entity is a
a) Object of relation b) Present working model c) Thing in real world d) Model of relation
6.  The term attribute refers to a ___________ of a table.
a) Record b) Column c) Tuple d) Key
7. .Course(course_id,sec_id,semester)
Here the course_id,sec_id and semester are __________ and course is a _________ .
a) Relations, Attribute b) Attributes, Relation c) Tuple, Relation d) Tuple, Attributes
8.  The tuples of the relations can be of ________ order.
a) Any b) Same c) Sorted d) Constant
9. RAID level ____ spreads parity and data among all N+1 disks rather than storing data in N disks and parity in 1.
a) 3 b) 4 c) 5 d) 6

10. Collection of information stored in database at particular instance of time is called as __________.



a) Data Structure b) Database Schema c)Instance of Database      d) Objects in Database
11. Database supports _______ types of database schema's.
a)2 b)3 c)1 d)4
12. The property (or set of properties) that uniquely defines each row in a table is called the:
a) Identifier b) Index c) Primary key d) Symmetric key
13. The database design that consists of multiple tables that are linked together through matching data stored in each table is called
  a) Hierarchical databas
b) Network database
c) Object oriented database
d) Relational database
14. The association role defines:
a) How tables are related in the database
b) The relationship between the class diagram and the tables in the database
c) The tables that each attribute is contained
d) Which attribute is the table’s primary key
15.  A unit of storage that can store one or more records in a hash file organization is denoted as
` a) Buckets b) Disk pages c) Blocks d) Nodes
16. The file organization which allows us to read records that would satisfy the join condition by using one block read is
a) Heap file organization
b) Sequential file organization
c) Clustering file organization
d) Hash file organization
17. Foreign key is the one in which the ________ of one relation is referenced in another relation.
a) Foreign key b) Primary key c) References d) Check constraint
18. ____________ is an interface between low level database and application program.
a) Database Associator b) Database Server c) Database Manager d) None of these
19. A main purpose of DBMS is to provide ____________ view of data to user.
a) Abstract b)Partial c) Complete d) None of these


20. Consider attributes ID , CITY and NAME . Which one of this can be considered as a super key ?
a) NAME b) ID c) CITY d) CITY , ID
21. The subset of super key is a candidate key under what condition ?
a) No proper subset is a super key
b) All subsets are super keys
c) Subset is a super key
d) Each subset is a super key
22.  A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.
a) Rows b) Key c) Attribute d) Fields
23. Database __________ , which is the logical design of the database, and the database _______,which is a snapshot of the data in the database at a given instant in time.
a) Instance, Schema
b) Relation, Schema
c) Relation, Domain
d) Schema, Instance
24.  A domain is atomic if elements of the domain are considered to be ____________ units.
a) Different b) Indivisbile c) Constant d) Divisible
25. In E-R diagram generalization is represented by
a)Rectangle b)Elipse c)Triangle d) Dashed ellipse






B) Short questions :
1. What is  the difference between DATABASE  and DBMS?
2. What is a Database system?
3. What are the advantages of DBMS?
4. What are the disadvantage in File Processing System?
5. Describe the three levels of data abstraction?
6. What is Data Independence?
7. What is a view? How it is related to data independence?
8. What is Data Model?
9. What is E-R model?
10. What is Object Oriented model?
11. What the difference between  entity,entity set and entity type?
12. What is an attribute?
13. What is Relationship?
14. What is degree of Relationship type?
15. What are diff. types of attributes?
16. What is cold backup and hot backup (in case of Oracle)?
17. Define and discuss data constraints.
18.What is the difference between mirroring and stripping ?
19.What is the difference between candidate key and composite key?
20.What are the major functions of the database administrator?

C .LONG QUESTION
1.What is File processing system and disadvantage of file processing system ?
2.What is Data Abstraction and how it is implemented in three levels of database?
3.Explain  with diagram of a Three tier Architecture in database ?
4. What are the Advantages of DBMS and disadvantage of DBMS ?
5.What are different levels of Raid,explain with diagram ?
6.What are different type of file organization ,explain with Examples?
7.What is mapping?Give a brief idea about different type of relationship exist in DBMS?
8.Construct an ER diagram on Online Railway Reservation System .
9. Construct an ER diagram on Banking Transaction system .
10. Construct an ER diagram on BPUT database.
11.Write short notes
a)Hierarchical and Network model
b)Generalization
12. Write short notes
a)Data independence
b)DBA




ANSWER


1. What is database?
A database is a logically coherent collection of data with some inherent meaning, representing some aspect of real world and which is designed, built and populated with data for a specific purpose. What is DBMS?
It is a collection of programs that enables user to create and maintain a database. In other words it is general-purpose software that provides the users with the processes of defining, constructing and manipulating the database for various applications.
2. What is a Database system?
The database and DBMS software together is called as Database system.
3.  What are the advantages of DBMS?
Redundancy is controlled.
Unauthorised access is restricted.
Providing multiple user interfaces.
Enforcing integrity constraints.
Providing backup and recovery.
4.  What are the disadvantage in File Processing System?
Data redundancy and inconsistency.
Difficult in accessing data.
Data isolation.
Data integrity.
Concurrent access is not possible.
Security Problems.
5.  Describe the three levels of data abstraction?
The are three levels of abstraction:
Physical level: The lowest level of abstraction describes how data are stored.
Logical level: The next higher level of abstraction, describes what data are stored in database and what relationship among those data.
View level: The highest level of abstraction describes only part of entire database.

What is a view? How it is related to data independence?
A view may be thought of as a virtual table, that is, a table that does not really exist in its own right but is instead derived from one or more underlying base table. In other words, there is no stored file that direct represents the view instead a definition of view is stored in data dictionary.

Growth and restructuring of base tables is not reflected in views. Thus the view can insulate users from the effects of restructuring and growth in the database. Hence accounts for logical data independence
What is Data Model?
A collection of conceptual tools for describing data, data relationships data semantics and constraints.
What is E-R model?
This data model is based on real world that consists of basic objects called entities and of relationship among these objects. Entities are described in a database by a set of attributes.
What is Object Oriented model?
This model is based on collection of objects. An object contains values stored in instance variables with in the object. An object also contains bodies of code that operate on the object. These bodies of code are called methods. Objects that contain same types of values and the same methods are grouped together into classes.
What is an Entity?
It is a 'thing' in the real world with an independent existence.
What is an Entity type?
It is a collection (set) of entities that have same attributes.
What is an Entity set?
It is a collection of all entities of particular entity type in the database.
What is cold backup and hot backup (in case of Oracle)? 
1. Cold Backup: It is copying the three sets of files (database files, redo logs, and control file) when the instance is shut down. This is a straight file copy, usually from the disk directly to tape. You must shut down the instance to guarantee a consistent copy. If a cold backup is performed, the only option available in the event of data file loss is restoring all the files from the latest backup. All work performed on the database since the last backup is lost. 2. Hot Backup: Some sites (such as worldwide airline reservations systems) cannot shut down the database while making a backup copy of the files. The cold backup is not an available option
Define and discuss data constraints.
 Data constraints on a column are the limits put on the values the data can have. There are four types of data constraints: (1) domain constraints, which define a limited set of values for the column, (2) range constraints, which specify that the values must fall within a certain range, (3) intrarelation constraints, which define what values the column can have based on values of other columns in the same table, and (4) interrelation constraints, which define values the column can have based on values of columns in other tables
.What are the major functions of the database administrator? 
Managing database structure, controlling concurrent processing, managing processing rights and responsibilities, developing database security, providing for database recovery, managing the DBMS and maintaining the data repository.

.


What are diff. types of attributes?
Ans:
1. Composite Vs simple attributes.
2. Single valued Vs multi-valued attributes.
3. Stored Vs derived attribute.
4. Null valued attributes.
5. Complex attributes.

What is a degree of a relationship?
A relationship degree indicates the number of entities or participants associated with a relationship



THIS IS PREPARED BY ELINA MAM FOR QUERY COMMENT BELOW OR CONTACT MAM











Share:

Sunday, 5 March 2017

(OB) ORGANISATIONAL BEHAVIOUR EXPECTED QUESTIONS FOR 1ST INTERNAL by prof Bhagyasree Padhi Mam

ORGANISATIONAL BEHAVIOUR
EXPECTED QUESTIONS FOR 1ST INTERNAL
LONG TYPE
1. Discuss the issues and challenges faced by the organisation in the present scenario. State the
importance of study of OB?
2. Define personality? Explain psychoanalytic theory of personality development?
3. Define personality? Explain Erikson's theory of personality development?
4. Do you think that money can act as a motivator? Why motivation is a critical issue of
interest to managers in organisation? How is the ERG theory of Aldefer is different from
Need Hirarachy Theory?
5. Explain determinants of personality?
6. Define motivation? Explain Two-Factor theory of motivation?
7. Define OB? Discuss its different models and approaches?
8. Discuss the Myers-Briggs Type Indicator and identify the personality type that would be
best for the students in your class?
9. Why is it important for managers to have a working knowledge of perception and
attribution?
10. Identify and describe the Big-Five personality dimensions. Specify which one is correlated
most strongly with job performance?
11. Define Perception? Explain perpetual process?
12. Define attitude? Discuss its components and functions?
SHORT TYPE
1. Define OB?
2. Define the term Attitude?
3. What do you mean by Emotional Intelligence?
4. What do you mean by Figure Ground principles?
5. What do you mean by an organisation?
6. What are the different contributing disciplines of OB?
7. List of certain factors which influence personality?
8. What is Halo-Effect?
9. What is a formal organisation?
10. What is an infoormal organisation?
11. What do you mean by Type-A personality?
12. What do you mean by Type-B personality?
13. What do you mean by Ego states?
14. What is Id?
15. Outline the Hygine factors and Motivators according to Herzberg?
16. What is Locus of Control?
17. Define Motivation?
18. What is Ambivalence?
19. What is Steriotyping?
20. What is Pull mechanism in motivation?
21. What is Paranoid-Perception?
22. What is Collegial model in OB?
23. Define Social Intelligence?
24. What do you mean by Cognitive Satisfaction?
25. According to Vroom, Motivation = .........................X.........................X..........................

OBJECTIVE TYPE
1. The Motivation-Hygiene theory developed by:
a. Aldefer c. Fredrick Herzberg
b. Dublin d. William Ouchi
2. The concept of Emotional Intelligence developed by:
a. Max Weber c. Melvin Kohn
b. Kanter d. Daniel Goleman
3. Judging people on the basis of a single trait and drawing a general impression about him or her is known
as:
a. Recency Effect c. Stereotyping
b. Projection d. Halo Effect
4. The ................ are perspectives of motivation that identify specific needs that energize behaviour.
a. Content Theory c. Equity Theory
b. Process Theory d. Expectancy Theory
5. Which motivation theory focuses on establishing future performance target?
a. Goal Theory c. Equity Thoery
b. Reinforcement Theory d.None of the Above
6. Which theory is considered to deal with consequences?
a. Reinforcement Theory c. Equity Theory
b. Two Factor Theory d. Need – Hirarchy Theory
7. The four main dimensions which influence behaviour in work organisation are:
a. Individual,Organisation,Group,Gender
b. Individual, Group, Organisation, Environment
c. Group, Environment, Organisation, Gender
d. Environment, Group, Individual, Gender
8. The psychological or internal factors affecting perpetual selection are ............, .............. and ..............
a. Motive, Personality, Mental Process
b. Personality, Ego, Mental Process
c. Learnning, Personality, Ego
d. Personality, Learning, Motive
e. None of Above
9. The tendency to complete an incomplete figure to (mentally) fill in the gaps and to perceive them as whole
is called........................
a. Figure c. Grouping e. None of Above
b. Closure d. All of Above
10.The process by which the perception of a person is formulated on the basis of a single favorable trait or
impression, where other relevant characteristics of that person are dismissed is called:
a. Halo Effect c. Angel Effect
b. Stereotyping d. Clouded Judgment
11. For something to be a part of personality it should:
a. Always be evident c. Be relatively stable over time
b. Never Change d. Apply to all people
12. Need and expectations at work are sometimes divided into two types:
a. Effort – Reward c. Social – Spiritual
b. External – Internal d. Extrinsic – Intrinsic
13. Which of the following is a positive reaction to the blockage of a desired goal?
a. Fixation c. Withdrawl
b. Regression d. Problem – Solving
14. Negative responses to the blockage of a desired goal include:
a. Withdrawl c. Fixation
b. Aggression d. All of the above
15. Managers can attempt to reduce levels of frustration in organisation members by:
a. Effective recruitment c. All of the above
c. Participative management d. None of the above
16. Aldefer & Mc Celland are two examples of ................... theories of motivation?
a. Equity c. Process
c. Content d. Expectancy
17. According to Herzberg, Which of the following may be regarded as Hygiene factors?
a. Salary c. Working Conditions
b. Company Policy d. All of the above
18. Performance-Satisfaction theory of motivation developed by..................... .
a. Victor Vroom c. John. T. Dunlop
b. Porter & Lawler d. Frederick Herzberg
19. In ERG theory 'R' stands for
a. Regression c. Revolution
b. Relatedness d. None of above
20. Which is not the Maslow's need?
a. Esteem c. Control
b. Social d. Self-Actualisation
21. A motive is defined as
a. a price of product c. An inner state that energizes the behaviour for a goal
b. A cost d. An inner state that provides difficult task to the player
22. Expectancy Theory was developed by:
a. Robbins c. Maslow
b. Vroom d. Aldefer
23. Which is a component of Attitude:
a. Cognitive c.Conative
b. Affective d. All of above
24. Machiavellianism is related to
a. Power c. Position
c. Manipulation of Power d. None of above
25. Figure – Ground Concept is related to
a. Personality c. Motivation
d. Learning d. Perception

by prof Bhagyasree Padhi,


Posted by Harekrishna & Sudarsan Puhan

click here to download pdf


Share:

COMMENT TO DISCUSS

share to learn by GEC student. Powered by Blogger.

Do the best

"Always do your best. What you plant now, you will harvest later. "

Total Pageviews

Recent Posts

Unordered List

Pages

Theme Support