Technology Questions

Q:

How does Microsoft classify security threats to its software?

Answer

Microsoft classifies such threats into 4 indicators, which are low, moderate, important, and critical. Such indicators are available as reference under the Microsoft bulletin.

Report Error

View answer Workspace Report Error Discuss

0 2195
Q:

What is a synonym? What are its various types?

Answer

A synonym can be called as an alias for a table, view, sequence or program unit. It is basically of two types:
- Private - Only the owner can access it.
- Public - Can be accessed by any database user.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2194
Q:

Mention the difference between clustered and a non-clustered index?

Answer

- A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index.


- A non clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a non clustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 2193
Q:

What is BAS? What is its function ?

Answer

The Business Application Support (BAS) functional area at SLAC provides administrative computing services to the Business Services Division and Human Resources Department. We are responsible for software development and maintenance of the PeopleSoft applications and consultation to customers with their computer-related tasks.


It's called Broadcast Agent Server. Its function is torun the jobs or reports scheduled and can be monitored using Broadcast Agent Console.

Report Error

View answer Workspace Report Error Discuss

0 2191
Q:

What are the uses of synonyms?

Answer

- Mask the real name and owner of an object.
- Provide public access to an object
- Provide location transparency for tables, views or program units of a remote database.
- Simplify the SQL statements for database users.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

1 2190
Q:

How do you change the session time-out value?

Answer

The session time-out value is specified in the web.config file within sessionstate element.You can change the session time-out setting by changing value of timeout attribute of sessionstate element in web.config file.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET
Job Role: Software Architect

0 2186
Q:

Explain about creating VB applications in excel ?

Answer

User defined functions can be created into the Microsoft spreadsheet. Spreadsheets can be customized according to the user needs by using VB applications. To create visual basic functions useful for spreadsheet you need to click Tools and select Macros where you will need to click on Visual basic editor.

Report Error

View answer Workspace Report Error Discuss

0 2186
Q:

Explain the difference between value types and reference types

Answer

Value type :


 



  • Stores the data

  • The value of value types is stored on the managed stack

  • They are lighter objects 

  • One variable can have only one value


Reference Type :



  • Stores the reference to the data

  • A reference type is allocated on the heap

  • They are heavier objects

  • Several variables can reference the same data


 

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 2184