Technology Questions

Q:

What strategies are available for backing-up an Oracle database?

Answer

The backup strategies that are provided by Oracle are as follows:


- Logical backup using Exports and import.


- Physical file system backup


- RMAN Recovery Manger which is also known as incremental files system backup.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2710
Q:

Describe Android Application Architecture.

Answer

Android Application Architecture has the following components:
* Services – like Network Operation
* Intent - To perform inter-communication between activities or services
* Resource Externalization - such as strings and graphics
* Notification signaling users - light, sound, icon, notification, dialog etc.
* Content Providers - They share data between applications

Report Error

View answer Workspace Report Error Discuss

0 2708
Q:

How can you avoid callback hells ?

Answer

There are lots of ways to solve the issue of callback hells:


1. Modularization: break callbacks into independent functions
2. Use a control flow library, like async
3. Use generators with Promises
4. Use async/await (note that it is only available in the latest v7 release and not in the LTS version)

Report Error

View answer Workspace Report Error Discuss

Subject: Java
Job Role: Analyst , IT Trainer

3 2706
Q:

How do you insert a record with a nullable column?

Answer

To insert a NULL, move -1 to the null indicator


To insert a valid value, move 0 to the null indicator


 

Report Error

View answer Workspace Report Error Discuss

0 2705
Q:

Define cursor attributes: %FOUND, %NOTFOUND, %ROWCOUNT, and %ISOPEN

Answer

- %FOUND


 This is a Boolean variable which evaluates to TRUE if the last row is successfully fetched.


 


- %NOTFOUND


 This is a Boolean variable which evaluates to TRUE if the last row is not successfully fetched. This means there are no more rows to fetch.


 


- %ROWCOUNT


 Returns the number of rows fetched by the cursor.


 


- %ISOPEN


If the cursor is open, it evaluates to TRUE else FALSE.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2702
Q:

How do you define a traceability matrix?

Answer

Traceability matrix is a cross matrix for recording the requirements through each stage of the requirements gathering process. This matrix should also take into account any changes in the scope during the life of the project. 


     At the end of the project this matrix should show each function built into a system, its source and the reason that any stated requirements may not have been delivered. 

Report Error

View answer Workspace Report Error Discuss

3 2690
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

3 2688
Q:

How can you deploy an ASP.NET Web application?

Answer

You can deploy an ASP.NET Web application using either the Windows Installer deployment or ClickOnce deployment technique.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 2687