CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.




Get it now !!
Send your Resume to 6000 Companies
Network Database Model Interview Questions & Answers - Learning Mode
COOLINTERVIEW.COM DATABASE INTERVIEW QUESTIONS NETWORK DATABASE MODEL INTERVIEW QUESTIONS QUESTIONS & ANSWERS - LEARNING MODE

Network Database Model Interview Questions & Answers - Learning Mode

The network model is a database model conceived as a flexible way of representing objects and their relationships. Its distinguishing feature is that the schema, viewed as a graph in which object types are nodes and relationship types are arcs, is not restricted to being a hierarchy or lattice. A network database is a type of database model wherein multiple member records or files can be linked to multiple owner files and vice versa. The model can be viewed as an upside-down tree where each member information is the branch linked to the owner, which is the bottom of the tree.

Try Network Database Model Interview Questions & Answers - Exam Mode

1 2 3 4 Next

Sort By : Latest First | Oldest First | By Rating

Network Database Model Interview Questions & Answers - Learning Mode
Try Network Database Model Interview Questions & Answers - Exam Mode
Question: What is Load balancing?

Answer: If the number of incoming clients requests exceeds the number of processes in a server class, the TP Monitor may dynamically start new ones and this is called Load balancing. Source: CoolInterview.com
Question: What are the two types of OLTP?



Answer: TP lite, based on stored procedures. TP heavy, based on the TP monitors. Source: CoolInterview.com
Question: What are all the Extended services provided by the OS?

* Ubiquitous communications
* Network OS extension
* Binary large objects (BLOBs)
* Global directories and Network yellow pages
* Authentication and Authorization services
* System management
* Network time
* Database and transaction services
* Internet services
* Object- oriented services


Answer: * Ubiquitous communications
* Network OS extension
* Binary large objects (BLOBs)
* Global directories and Network yellow pages
* Authentication and Authorization services
* System management
* Network time
* Database and transaction services
* Internet services
* Object- oriented services Source: CoolInterview.com
Question: What is a intranet ?

Answer: An Intranet is a private network that is contained within an enterprise.It may consists of many interlinked Local area network and also use leased lines in the wide area network. Typically an intranet includes connections through one or more gateway computers to the outside internet. The main purpose of an intranet is to share company information and computing resources among employees. An intranet can also be used to facilitate working in groups and for teleconferences. Source: CoolInterview.com
Question: What are called Transactions?

Answer: The grouped SQL statements are called Transactions (or) A transaction is a collection of actions embused with ACID properties. Source: CoolInterview.com
Question: What is meant by 3-Tier architecture?

Answer: In 3-tier Client/Server systems, the application logic (or process) lives in the middle tier and it is separated from the data and the user interface. In theory, the 3-tier Client/Server systems are more scalable, robust and flexible.
Example: TP monitor, Web. Source: CoolInterview.com
Question: What is a Transaction server?


Answer:
With a transaction server, the client invokes remote procedures that reside on the server with an SQL database engine. These remote procedures on the server execute a group of SQL statements. The network exchange consists of a single request/reply message. The SQL statements either all succeed or fail as a unit. Source: CoolInterview.com
Question: What are the roles of SQL?



Answer:
* SQL is an interactive query language for ad hoc database queries.
* SQL is a database programming language.
* SQL is a data definition and data administration language.
* SQL is the language of networked database servers
* SQL helps protect the data in a multi-user networked environment.
* Because of these multifacted roles it plays, physicists might call SQL as "The grand unified theory of database". Source: CoolInterview.com
Question: What is a Transaction server?

Answer: With a transaction server, the client invokes remote procedures that reside on the server with an SQL database engine. These remote procedures on the server execute a group of SQL statements. The network exchange consists of a single request/reply message. The SQL statements either all succeed or fail as a unit Source: CoolInterview.com
Question: What are the most typical functional units of the Client/Server applications?


Answer: * User interface
* Business Logic and
* Shared data. Source: CoolInterview.com
Question: What are Triggers and Rules?

Answer: Triggers are special user defined actions usually in the form of stored procedures, that are automatically invoked by the server based on data related events. It can perform complex actions and can use the full power of procedural languages.
A rule is a special type of trigger that is used to perform simple checks on data. Source: CoolInterview.com
Question: What is a TP Monitor?

There is no commonly accepted definition for a TP monitor. According to Jeri Edwards' a TP Monitor is "an OS for transaction processing".


Answer: There is no commonly accepted definition for a TP monitor. According to Jeri Edwards' a TP Monitor is "an OS for transaction processing". Source: CoolInterview.com
Question: What are the types of Transparencies?




Answer: The types of transparencies the NOS middleware is expected to provide are:-

* Location transparency
* Namespace transparency
* Logon transparency
* Replication transparency
* Local/Remote access transparency
* Distributed time transparency
* Failure transparency and
* Administration transparency. Source: CoolInterview.com
Question: What is Structured Query Langauge (SQL)?



Answer:
SQL is a powerful set-oriented language which was developed by IBM research for the databases that adhere to the relational model. It consists of a short list of powerful, yet highly flexible, commands that can be used to manipulate information collected in tables. Through SQL, we can manipulate and control sets of records at a time. Source: CoolInterview.com
Question: What is a Transaction server?

Answer: With a transaction server, the client invokes remote procedures that reside on the server with an SQL database engine. These remote procedures on the server execute a group of SQL statements. The network exchange consists of a single request/reply message. The SQL statements either all succeed or fail as a unit Source: CoolInterview.com
Question: What are the roles of SQL?

Answer: * SQL is an interactive query language for ad hoc database queries.
* SQL is a database programming language.
* SQL is a data definition and data administration language.
* SQL is the language of networked database servers
* SQL helps protect the data in a multi-user networked environment.
* Because of these multifacted roles it plays, physicists might call SQL as "The grand unified theory of database".
Source: CoolInterview.com
Question: What are the characteristics of Client/Server?

Answer: * Service
* Shared resources
* Asymmentrical protocols
* Transparency of location
* Mix-and-match
* Message based exchanges
* Encapsulation of services
* Scalability
* Integrity
Source: CoolInterview.com
Question: What are the main components of Transaction-based Systems?

Answer: * Resource Manager
* Transaction Manager and
* Application Program.
Source: CoolInterview.com
Question: What are the functions of the typical server program?

Answer: It waits for client-initiated requests. Executes many requests at the same time. Takes care of VIP clients first. Initiates and runs background task activity. Keeps running. Grown bigger and faster.

Source: CoolInterview.com
Question: What is OLTP?

Answer: In the transaction server, the client component usually includes GUI and the server components usually consists of SQL transactions against a database. These applications are called OLTP (Online Transaction Processing) OLTP Applications typically,
Receive a fixed set of inputs from remote clients. Perform multiple pre-compiled SQL comments against a local database. Commit the work and Return a fixed set of results. Source: CoolInterview.com

1 2 3 4 Next



India News Network
Latest 20 Questions
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
"Holiday Packages" announced as an advertisement are an example of _________: (a) Offer (b) Counter Offer (c) Invitation to Offer (d) None of the above
A match fixing contract between a player and a broker is a: (a) Valid Contract (b) Unenforceable Contract (c) Void Contract (d) Illegal Contract
When a bookseller sells a book on cash payment then it is called as ___________: (a) Unilateral Contract (b) Bilateral Contract (c) Executed Contract (d) Executory Contract
____________ agreements are created by situation: (a) Written (b) Oral (c) Void (d) Implied
Cache = 0.140625 Seconds