Enlist different types of database users.

Enlist different types of database users.
by

1 Answer

Answer :

Database users are the one who really use and take the benefits of database. There will be different types of users depending on their need and way of accessing the database.

1. Application Programmers

2. Sophisticated Users

3. Specialized Users

4. Native Users/ Naïve Users
by

Related questions

List the types of Cursor.

Description : List the types of Cursor.

Last Answer : Cursor: A cursor is a temporary work area created in the system memory when a SQL statement is executed. Types of Cursor: 1.Implicit Cursor 2.Explicit Cursor

Describe the use of primary key and unique key constraints with example?

Description : Describe the use of primary key and unique key constraints with example?

Last Answer : There are two Entity constraints: 1.Primary Key constraint 2. Unique Constraint 1. Primary Key constraint: It is use to avoid redundant/duplicate value entry within the row of specified column in ... TABLE PERSONS (P_ID NUM CONSTRAINT P_UK UNIQUE , FIRSTNAME VARCHAR(20), CITY VARCHAR(20) );

State the use of sequence.

Description : State the use of sequence.

Last Answer : A sequence refers to a database object that is capable of generating unique and sequential integer values. Syntax: Create sequence [increment by num][start with num] [maxvaluenum] [ ... can be used for multiple tables. * Sequence numbers are stored and generated independently of tables

State the properties of Transaction

Description : State the properties of Transaction

Last Answer : The ACID properties of transaction. 1. Atomicity. 2. Consistency. 3. Isolation.  4. Durability

Write syntax to create view.

Description : Write syntax to create view.

Last Answer : Create view as select OR CREATE VIEW name ASSELECT column1, column2.....FROM table_nameWHERE [condition];

State the use of ‘Like’ Operator.

Description : State the use of ‘Like’ Operator.

Last Answer : The LIKE operator is used in a WHERE clause to search for a specified pattern in a column. There are two operator often used in conjunction with the LIKE operator:  %:The percent sign represents zero, one, or multiple characters  _: The underscore represents a single character.

Enlist different types of protozoa.

Description : Enlist different types of protozoa.

Last Answer : Enlist different types of protozoa.

Enlist the different types of Accidents.

Description : Enlist the different types of Accidents.

Last Answer : Different types of accidents: 1. Near accident 2. Trivial accident 3. Minor accident 4. Serious accident 5. Fatal accident

Enlist different types of staircase. Explain any one type with a neat sketch.

Description : Enlist different types of staircase. Explain any one type with a neat sketch.

Last Answer : Types of Staircase: 1. Straight Stair 2. Dog legged Stair 3. Quarter turn Stair 4. Open well Stair 5. Three quarter turn Stair 6. Bifurcated Stair 7. Geometrical Stair 8. Circular ... . This well may be rectangular or of any geometrical shape and it can be used for fixing lift.

Enlist different types of traffic island and explain any one in brief with neat sketch.

Description : Enlist different types of traffic island and explain any one in brief with neat sketch.

Last Answer : The different types of traffic island are as follow: (1) Rotary or central islands. (2) Channelising or refuse islands. (1) Rotary or central islands: A traffic island constructed in ... each site of road intersection. A few typical designs of Channelising islands are illustrated below:

Enlist different types of chips formed during machining

Description : Enlist different types of chips formed during machining

Last Answer : Different types of chips: 1. Discontinuous or segmental chips 2. Continuous chips 3. Continuous chips with built-up edge (BUE) 4. Non homogeneous chip

What is polymorphism? Enlist different types of polymorphism. What are the differences between them?

Description : What is polymorphism? Enlist different types of polymorphism. What are the differences between them?

Last Answer : Polymorphism: It is a feature of object oriented programming which allows a programmer to have a more than one function having same name but different /same parameters but performs different/ ... Compile Time polymorphism o Virtual Function Difference between Types of Polymorphism:

Enlist different types of servers.

Description : Enlist different types of servers.

Last Answer : Different types of servers are: Definition of server: The central computer which is more powerful than the clients which allows the clients to access its software, database is called as the server. Types of server: 1. File server 2. Print server 3. Application server 4. Mail server

Enlist different types of computer networks on the basis of their geography.

Description : Enlist different types of computer networks on the basis of their geography. 

Last Answer : Classification of networks based on geography LAN - Local Area Network MAN - Metropolitan Area Network WAN - Wide Area Network CAN - Campus Area Network PAN - Personal Area Network

How does one manage Oracle database users? (for DBA

Description : How does one manage Oracle database users? (for DBA

Last Answer : Oracle user accounts can be locked, unlocked, forced to choose new passwords, etc. For example, all accounts except SYS and SYSTEM will be locked after creating an Oracle9iDB database using the DB ... locked users account ALTER USER scott PASSWORD EXPIRE; -- Force user to choose a new password

How does one manage Oracle database users? (for DBA

Description : How does one manage Oracle database users? (for DBA

Last Answer : Oracle user accounts can be locked, unlocked, forced to choose new passwords, etc. For example, all accounts except SYS and SYSTEM will be locked after creating an Oracle9iDB database using the ... from SYS.V$BH log buffer spaces Increase LOG_BUFFER parameter or move log files to faster disks

Who created all these users in my database?/ Can I drop this user? (for DBA

Description : Who created all these users in my database?/ Can I drop this user? (for DBA

Last Answer : Oracle creates a number of default database users or schemas when a new database is created. Below are a few of them: SYS/CHANGE_ON_INSTALL or INTERNAL Oracle Data Dictionary/ Catalog Created ... there should be no problem altering these users to use a different default and temporary tablespace.

How does one create and drop database users?

Description : How does one create and drop database users?

Last Answer : Look at these examples: CREATE USER scott IDENTIFIED BY tiger -- Assign password DEFAULT TABLESACE tools -- Assign space for table and index segments TEMPORARY TABLESPACE temp; -- Assign sort space ... give the user some space quota on its tablespaces: ALTER USER scott QUOTA UNLIMITED ON tools;

An expert system differs from a database program in that only an expert system _____________ a) contains declarative knowledge b) contains procedural knowledge c) features the retrieval of stored information d) expects users to draw their own conclusions

Description : An expert system differs from a database program in that only an expert system _____________ a) contains declarative knowledge b) contains procedural knowledge c) features the retrieval of stored information d) expects users to draw their own conclusions

Last Answer : b) contains procedural knowledge

How can you view all the current users connected in your database in this moment?

Description : How can you view all the current users connected in your database in this moment?

Last Answer : SELECT COUNT(*),USERNAME FROM V$SESSION GROUP BY USERNAME;

How can you view all the users account in the database?

Description : How can you view all the users account in the database?

Last Answer : SELECT USERNAME FROM DBA_USERS

The reasons leading to popularity of client-server systems are: A) More powerful workstations on LANs B) Needed for graphical user interfaces of end users. C) Remove computing load for presentation services from the system managing a shared database resource. D) All

Description : The reasons leading to popularity of client-server systems are: A) More powerful workstations on LANs B) Needed for graphical user interfaces of end users. C) Remove computing load for presentation services from the system managing a shared database resource. D) All

Last Answer : D) All

In distributed databases, location transparency allows for database users, programmers and administrators to treat the data as if it is at one location. A SQL query with location transparency needs to specify: (A) Inheritances (B) Fragments (C) Locations (D) Local formats

Description : In distributed databases, location transparency allows for database users, programmers and administrators to treat the data as if it is at one location. A SQL query with location transparency needs to specify: (A) Inheritances (B) Fragments (C) Locations (D) Local formats 

Last Answer : (B) Fragments

Enlist the types of dc machines?

Description : Enlist the types of dc machines?

Last Answer : Answer: D.C. machines are classified into two types 1) separately excited 2) self excited which is further classified into 1)series 2)shunt and 3)compound(which is further classified into cumulative and differential).

Enlist types of dc generator?

Description : Enlist types of dc generator?

Last Answer : D.C. Generators are classified into two types 1) Separately excited d.c. generator 2) Self excited d.c. generator, which is further classified into; 1) Series 2) Shunt and 3) Compound (which is further classified into cumulative and differential).

Define shoring. Enlist types of shoring. Explain any one type with neat sketch.

Description : Define shoring. Enlist types of shoring. Explain any one type with neat sketch.

Last Answer : Shoring:- Shoring is the construction of a temporary structure to support temporarily an unsafe structure. These support walls laterally. Shoring can be used when walls bulge out, when walls crack due to ... of the structure above and transfer same to the ground on firm foundation below. 

Define settlement of foundation and its types. Enlist various causes and suggest remedial measures for the same.

Description : Define settlement of foundation and its types. Enlist various causes and suggest remedial measures for the same.

Last Answer : Settlement of foundation: Due to the self-weight and the live load of the structure and due to compressibility of the soil supporting the foundation of the structure, settlement of the ... of earthquake loads and other earthquake resisting methods during design and construction of buildings.

Enlist any four types of floor finishes.

Description : Enlist any four types of floor finishes.

Last Answer : Four types of floor finishes:- 1)Shahabad flooring 2) Kota flooring 3) Marble flooring 4) Granite flooring 5) Kadappa 6) Mosaic tiles 7) Pavement blocks 8)Tiled flooring 9) Tremix floor 10)Vitrified tiles 11) IPS 12) Ceramic

Enlist types of Gradients.

Description : Enlist types of Gradients.

Last Answer : Types of Gradient:- 1) Ruling gradient 2) Limiting gradient 3) Exceptional gradient 4) Average gradient 5) Floating gradient 6) Minimum gradient

Enlist any four types of traffic islands

Description : Enlist any four types of traffic islands

Last Answer : a) Divisional Island. b) Pedestrians Loading Islands c) Channelized Intersections d) Roundabouts or Rotaries

Enlist any four types of special bricks

Description : Enlist any four types of special bricks

Last Answer : a) Acidic bricks b) Perforated bricks c) Silica bricks d) Colored bricks e) Fire bricks f) Blue bricks g) Fly ash bricks h) Engineering bricks i) Refractory bricks j) Sand lime bricks

Enlist any four types of flooring tiles.

Description : Enlist any four types of flooring tiles.

Last Answer : Types of flooring tiles: Shahabad, Kotah, Ceramic, Granite, Marble, Vitrified, Glazed, Plastic tiles Concrete tiles, Mosaic tiles, Clay tile.

Enlist the types of paints.

Description : Enlist the types of paints. 

Last Answer : Different types of paints are : 1) Oil paint 2) Water Paint 3) Cement Paint 4) Plastic Paint 5) Aluminium Paint 6) Velvet Finish Paint 7) Elastic Paint The paints are also divided ... water and chemicals, ii) Urethane oils, iii) Ship paints, iv) Anticondensation paints, v) Antifouling paints.

Define bench mark and enlist the types of bench mark.

Description : Define bench mark and enlist the types of bench mark.

Last Answer : It is fixed reference point of known or assumed elevation. It is used either as a starting point for levelling or as a check while closing. There are four kinds of bench marks. i. Great ... ) bench mark. ii. Permanent bench mark. iii. Arbitrary bench mark. iv. Temporary bench mark.

Enlist various types of seismic waves. How it can be recorded?

Description : Enlist various types of seismic waves. How it can be recorded?

Last Answer : ii) P or Primary waves iii) S or Secondary waves iv) L or long waves The vibrations that are set up when an earthquake propagated as number of different types of waves. Different types ... A major shock recorded by seismograph and its epicenter, time of origin, depth of focus, magnitude etc.

Enlist various types of seismic waves and explain one.

Description : Enlist various types of seismic waves and explain one.

Last Answer : Types of seismic waves 1. Primary or Longitudinal Waves 2. Secondary or Traverse waves 3. Long or surface waves-Rayleigh waves and love waves Primary Waves- (P-wave)- These ... These waves gives major destruction during earthquake . these waves are complex in nature having large amplitude.

Enlist types of joints.

Description : Enlist types of joints.

Last Answer : Types of joints are 1. Strike Joint 2. Dip Joint 3. Oblique Joint 4. Columnar Joint 5. Tension Joint 6. Shear Joint 7. Tight Joint 8. Block or Mural Joint 9. Sheet Joint

State the types of production system. Enlist four features of mass production system.

Description : State the types of production system. Enlist four features of mass production system.

Last Answer : List of Production System: 1. Intermittent production a. Job order production system. b. Batch order production system. 2. Continuous production a. Mass production system. b. Process production. ... on account of constant repetition of the same job. 9. Per unit cost of product is less

Enlist types of joints used in robotic arm and draw sketch of any two

Description : Enlist types of joints used in robotic arm and draw sketch of any two

Last Answer : Types of Joints [1] Linear Joint or Prismatic joint [2] Orthogonal Joint [3] Rotational joint [4] Twisting Joint [5] Revolving joint

State the types of production system. Enlist four features of batch production system.

Description : State the types of production system. Enlist four features of batch production system.

Last Answer : Types of production system: a. Intermittent production:  1. Job Production 2.Batch production b. Continuous production:  1. Mass production 2. Flow production Features of batch ... adopted in batch production. Example: Pharmaceutical products, ready-made Clothes, Furniture, castings, etc

Define polymorphism. Enlist its types.

Description : Define polymorphism. Enlist its types.

Last Answer : Definition: Polymorphism means ability to take more than one form that means a program can have more than one function with same name but different behavior. Types of polymorphism: 1) Compile time polymorphism 2) Runtime polymorphism 

Enlist types of operating system. Explain multiprogramming OS in detail.

Description : Enlist types of operating system. Explain multiprogramming OS in detail.

Last Answer : Types of operating system 1.Batch Systems 2.Multiprogramming 3.Multitasking 4.Time-Sharing Systems 5.Desktop Systems 6.Distributed system 7.Clustered system 8.Real Time system: Multiprogramming ... multiprogramming: user can open word, excel, access and other applications in a system.

Enlist the types of shapers.

Description : Enlist the types of shapers.

Last Answer : Types of shapers: Based on the type of driving mechanism: a) Crank type shaper. b) Geared type shaper. Based on ram travel: a) Horizontal shaper. b) Vertical shaper. Based on the table design: a ... shaper. b) Universal shaper. Based on cutting stroke. a) Push cut type. b) Draw cut type.

Enlist types of weir and explain any one in detail.

Description : Enlist types of weir and explain any one in detail.

Last Answer : Types of weirs are a) Based on materials of construction 1) Masonry weir 2) Rock-fill weir 3) Concrete weir b) Based on use and function 1) Storage weir 2) Pick- ... Canal has to run idle c) The terrain is geographically difficult so that canal alignment is very costly or impossible

Enlist the types of gates provided to reservoir.

Description : Enlist the types of gates provided to reservoir.

Last Answer : A. Non-automatic Gates: i) Radial ot Taintor gate  ii) Vertical gate: 1) Sliding gate  2) Fixed gate  3) Stony gate  iii) Rolling gate B. Automatic Gate: i) Reynolds Gate  ii) Vishveshrayya gate

Define Spillway and Enlist types of spillway

Description : Define Spillway and Enlist types of spillway

Last Answer : Spillway: It is the overflow portion of every dam , over which the surplus water flows from the upstream side of reservoir to the downstream side of reservoir. It is the safety valve of a ... Chute spillway vi) Shaft spillway vii) Conduit or Tunnel spillway 2. Subsidiary or Emergency Spillway

Enlist types of electrical wiring systems. Explain casing and capping type wiring system.

Description : Enlist types of electrical wiring systems. Explain casing and capping type wiring system.

Last Answer : List the types of Internal wiring in residential installations - 1) Cleat wiring 2) Batten wiring 3) Wooden casing capping wiring 4) PVC conduit wiring 5) PVC casing capping ... less chances of mechanical injury. Future expansion is possible and repairing and maintenance is easily possible. 

Enlist any four types of enclosures with their applications.

Description : Enlist any four types of enclosures with their applications. 

Last Answer : Types of enclosures & their Applications: i) Open type enclosure:- It is used where motor is installed in clean atmosphere and in closed room.  ii) Screen Protected enclosure:-( ... is circulated through pipe forcefully for cooling of motors and hot air is taken out through pipe.