Sawaal
  • Home/
  • Searching for

 Searching for ""

Q:

What do you mean by a tablespace?

Answer

- These are the Logical Storage Units into which a database is divided.
- It is used to group together the related logical structures.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

Q:

What is a view?

Answer

It is virtual table which is defined as a stored procedure based on one or more tables.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

Q:

Explain i) Rename ii) Alias.

Answer

- Rename : It is a permanent name provided to a table or column.
- Alias : It is a temporary name provided to a table or column which gets over after the execution of SQL statement.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

Q:

List the various Oracle database objects.

Answer

- TABLES
- VIEWS
- INDEXES
- SYNONYMS
- SEQUENCES
- TABLESPACES

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

Q:

What is ANALYZE command used for?

Answer

ANALYZE command is used to perform various functions on index, table, or cluster, as listed below:
- It helps in dentifying migrated and chained rows of the table or cluster.
- It helps in validating the structure of the object.
- It helps in collecting the statistics about object used by the optimizer. They are then stored in the data dictionary.
- It helps in deleting statistics used by object from the data dictionary.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

Q:

How does fault tolerance work in mapreduce?

Answer

In a mapreduce job the master pings each worker periodically. In case a worker does not respond to that system then the system is marked as failed. Even completed tasks are rescheduled because the output was stored in a in a local disk of a worker which failed. Hence mapreduce is able to handle large-scale failures easily by simply restarting a task. The master node always saves itself at checkpoints and in case of any failure it simply restarts from that checkpoint.

Report Error

View answer Workspace Report Error Discuss

Subject: Cloud Computing

Q:

How is mapreduce related to cloud computing?

Answer

The mapreduce framework contains most of the key architecture principles of cloud computing such as:


- Scale: The framework is able to expand itself in direct proportion to the number of machines available.


- Reliable: The framework is able to compensate for a lost node and restart the task on a different node.


- Affordable: A user can start small and over time can add more hardware.

Report Error

View answer Workspace Report Error Discuss

Subject: Cloud Computing

Q:

What do you understand by MapReduce?

Answer

MapReduce is a software framework that was created by Google. It`s prime focus was to aid in distributed computing, specifically large sets of data on a group of many computers. The frameworks took its inspiration from the map and reduce functions from functional programming.

Report Error

View answer Workspace Report Error Discuss

Subject: Cloud Computing