Technology Questions

Q:

What is the information does assembly manifest provide?

Answer

Information provided by Assembly Manifest:



  1.  Assembly Name

  2.  Version Number

  3.  Culture

  4.  Strong name

  5.  List of files inside the assembly

  6.  Reference information

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 2130
Q:

What are the core BI tools that professionals work with? Which ones have you used?

Answer

SSIS, SSAS and SSRS are the most important reporting systems that BI professionals work with. On a detailed level, I have worked with data mining, master data management, data profiling and data cleansing and analysis.

Report Error

View answer Workspace Report Error Discuss

0 2128
Q:

Define "Correlated Subqueries" ?

Answer

In a SQL Database, a 'correlated subquery' is a kind of sub query yet connected subquery is dependent on another query for a value that is returned. In case of execution, the sub query is executed first and afterwards the correlated query will be executed.

Report Error

View answer Workspace Report Error Discuss

6 2128
Q:

What are different ways to integrate a CSS into a Web page?

Answer

There are three ways to integrate CSS into a Web page 


1. Inline: HTML elements may have CSS applied to them via the STYLE attribute.


2. Embedded: By placing the code in a STYLE element within the HEAD element.


3. Linked/ Imported: Place the CSS in an external file and link it via a link element.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 2123
Q:

A data warehouse is composed of

A) current data B) internal and external data sources
C) historical data from legacy systems D) historical & current data
 
Answer & Explanation Answer: C) historical data from legacy systems

Explanation:

A data warehouse is a relational database that is designed for query and analysis rather than transaction processing. It usually contains historical data that is derived from transaction data, but it can include data from other sources. Data warehouses are designed to help you analyze your data.

Report Error

View Answer Report Error Discuss

Filed Under: Oracle
Job Role: Database Administration , IT Trainer

1 2119
Q:

How to recover a dropped table?

Answer

Dropped tables can be recovered using DROP TABLE flashback. It works the way recycle bin works.
Example:
FLASHBACK TABLE EMPLOYEE TO BEFORE DROP;
The most recently dropped table with that original name is retrieved from the recycle bin, with its original name.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2118
Q:

What is the use of CSS sprites?

Answer

- A web page with large number of images takes a longer time to load. This is because each image separately sends out a http request.


- The concept of CSS sprite helps in reducing this loading time for a web page by combining various small images into one image. This reduces the numbers of http request and hence the loading time.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 2116
Q:

What are the different types of diagrams and what do you know about them?

Answer

Use case diagram, activity diagram, Collaboration diagram. 


Use case diagram :


It describes the business environment. Its primary goal is to show the series of events and actions within any given process that will be performed by an actor.  


 


Activity diagram:


The activity diagram is important because it gives an outline of the work flow within the business as well as the activities and action completed. 


For instance with a company, there is likely to be more than one department. In such a case each department, will have different access levels to the system. 


So if there’s a Medical, HR and Accounts team they will only have access to screens that relate to each. 


The activity diagram will highlight the differences within the departments which will be very helpful for developers when they are designing and coding. 


 


Collaboration diagram:


A collaboration diagram, also called a communication diagram or interaction diagram, is an illustration of the relationships and interactions among software objects in the Unified Modeling Language (UML). The concept is more than a decade old although it has been refined as modeling paradigms have evolved. 

Report Error

View answer Workspace Report Error Discuss

0 2116