Technology Questions

Q:

Explain an ORA-01555?

Answer

You get this error when you get a snapshot too old within rollback. It can usually be solved by increasing the undo retention or increasing the size of rollbacks. You should also look at the logic involved in the application getting the error message.

Report Error

View answer Workspace Report Error Discuss

0 1434
Q:

How do you resize a data file?

Answer

ALTER DATABASE DATAFILE <datafile_name> RESIZE <new_size>; 

Report Error

View answer Workspace Report Error Discuss

0 1431
Q:

How would you handle conditional formats in BI?

Answer

There are lot of ways are there to use the conditional formatting, most of the Process flow maintains more attention in the loops, alias and contextCheers.

Report Error

View answer Workspace Report Error Discuss

0 1430
Q:

What does a Control file Contain?

Answer

A Control file records the physical structure of the database. It contains the following information. Database Name ,Names and locations of a database’s files and redolog files. Time stamp of database creation.

Report Error

View answer Workspace Report Error Discuss

0 1427
Q:

Name some of the standard Business Intelligence tools in the market?

Answer

Some of the standard Business Intelligence tools in the market According to there performance 


1)MICROSTRATEGY 


2)BUSINESS OBJECTS,CRYSTAL REPORTS 


3)COGNOS REPORT NET 


4)MS-OLAP SERVICES

Report Error

View answer Workspace Report Error Discuss

0 1409
Q:

What UNION does in SQL?

Answer

In SQL, UNION  merges the contents of two structurally-compatible tables into a single combined table.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL
Job Role: IT Trainer , Database Administration

0 1405
Q:

What are the database administrators utilities available?

Answer

SQL * DBA - This allows DBA to monitor and control an ORACLE database. SQL * Loader - It loads data from standard operating system files (Flat files) into ORACLE database tables. Export (EXP) and Import (imp) utilities allow you to move existing data in ORACLE format to and from ORACLE database.

Report Error

View answer Workspace Report Error Discuss

0 1401
Q:

What compilers apple using ?

Answer

The Apple compilers are based on the compilers of the GNU Compiler Collection.

Report Error

View answer Workspace Report Error Discuss

Subject: IOS

0 1392