Technology Questions

Q:

What is a Universe?

Answer

A universe is a business-oriented mapping of the data structure found in databases: tables, columns, joins, etc. It can represent any specific application, system, or group of users. For example, a universe can relate to a department in a company such as marketing or accounting.


In the BusinessObjects User module, universes enable end users to build queries from which they can generate and perform analysis.

Report Error

View answer Workspace Report Error Discuss

0 1240
Q:

What are the responsibilities of a Database Administrator?

Answer

- Installing and upgrading the Oracle Server and application tools.


- Allocating system storage and planning future storage requirements for the database system.


- Managing primary database structures (tablespaces)


- Managing primary objects (table, views, indexes)


- Enrolling users and maintaining system security.


- Ensuring compliance with Oracle license agreement


- Controlling and monitoring user access to the database.


- Monitoring and optimizing the performance of the database.


- Planning for backup and recovery of database information.


- Maintain archived data on tape


- Backing up and restoring the database.


- Contacting Oracle Corporation for technical support.

Report Error

View answer Workspace Report Error Discuss

0 1237
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 1234
Q:

What is meant by a dedicated computer?

A) Which is assigned one and only one task B) Which is meant for application software
C) Which is used by one person only D) Which uses one kind of software
 
Answer & Explanation Answer: A) Which is assigned one and only one task

Explanation:

What_is_meant_by_a_dedicated_computer1560341069.jpg image

It is a single computer in a network reserved for serving the needs of the network.

Report Error

View Answer Report Error Discuss

0 1233
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 1230
Q:

How do you add a data file to a tablespace?

Answer

ALTER TABLESPACE ADD DATAFILE <datafile_name> SIZE <size>

Report Error

View answer Workspace Report Error Discuss

0 1230
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 1229
Q:

What is MDM ?

Answer

MDM is short for Mobile Device Management. The term generally refers to a system that hooks into the operating system on smartphones to collect information or apply restrictions and security precautions that may be sound company policy. This is true for Miradore Online, our free MDM product you can get started with today.

Report Error

View answer Workspace Report Error Discuss

2 1221