Technology Questions

Q:

List the various Oracle database objects.

Answer

- TABLES
- VIEWS
- INDEXES
- SYNONYMS
- SEQUENCES
- TABLESPACES

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2871
Q:

Describe the foreign key columns in fact table and dimension table.

Answer

The primary keys of entity tables are the foreign keys of dimension tables.


The Primary keys of fact dimensional table are the foreign keys of fact tablels.

Report Error

View answer Workspace Report Error Discuss

1 2871
Q:

By whom will the unallocated memory that is no longer needed will be cleared in java?

A) Java Virtual Machine B) Garebage collector
C) Both A and B D) None
 
Answer & Explanation Answer: B) Garebage collector

Explanation:

The Java programming language provides a system-level thread to track memory allocation.

Garbage collection has the following characteristics:

• Checks for and frees memory no longer needed

• Is done automatically

• Can vary dramatically across JVM implementations

Report Error

View Answer Report Error Discuss

Filed Under: Java

0 2870
Q:

What are the Advantages of Node.js?

Answer

Aynchronous and Event Driven - All APIs of Node.js library area unit aynchronous that's non-blocking. It basically means that a Node.js based mostly server not waits for a API to return information. Server moves to next API when calling it and a notification mechanism of Events of Node.js helps server to induce response from the previous API decision.


Very FastNode.js library is very fast in execution of code.


Single Threaded but highly Scalable Node.js uses a single threaded model with event looping. Node.js uses a single threaded program and same program can services much larger number of requests than traditional server like open source.


No Buffering - Node.js applications never buffer any data. These applications simply output the data in faster.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology
Job Role: Software Architect

0 2870
Q:

What do you mean by Redo Log file mirroring ?

Answer

-  The process of having a copy of redo log files is called mirroring.
-  It is done by creating group of log files together. This ensures that LGWR automatically writes them to all the members of the current on-line redo log group.
-  In case a group fails, the database automatically switches over to the next group. It diminishes the performance.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2869
Q:

What is the difference between an unspecified passive open and a fully specified passive open?

Answer

An unspecified passive open has the server waiting for a connection request from a client. A fully specified passive


open has the server waiting for a connection from a specific client.

Report Error

View answer Workspace Report Error Discuss

0 2863
Q:

What is LINQ?

Answer

Language Integrated Query (LINQ) adds the ability to query objects using .NET languages. The LINQ to SQL object/relational mapping (O/RM) framework provides the following basic features:


- Tools to create classes (usually called entities) mapped to database tables


- Compatibility with LINQ's standard query operations


- The DataContext class, with features such as entity record monitoring, automatic SQL statement generation, record concurrency detection, and much more

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 2863
Q:

How do you define a sort file in JCL that runs the COBOL program?

Answer

Use the SORTWK01, SORTWK02,..... dd names in the step. Number of sort datasets depends on the volume of data being sorted, but a minimum of 3 is required.

Report Error

View answer Workspace Report Error Discuss

0 2860