Oracle DBA Certification

Questions: 366

Comments: 50

Oracle DBA Certification Tags

—

Backup, Restore, Metadata, Replication

Showing Questions 11-20 of 366 Questions

<< Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>

Sponsored Links

Oracle DBA Certification

Sorting Options :

What happens when online index is rebuild?

Latest Answer: It improves space utilization by removing deleted entries.And it can be rebuild with minimum table locking.Syntax:sql>alter index rebuild online; ...

Read Answers (1)

Answer Question Subscribe

What are transportable table spaces and the need to use them?

Latest Answer: One of the new features with later versions of Oracle7 and all versions of Oracle8 and oracle9i is the read-only tablespace. A read-only tablespace, as its name implies, allows read-only access to its information. This is beneficial in several ways:Â Since ...

Read Answers (2)

Answer Question Subscribe

Which outline category is used when you use ALTER SESSION to set USE_STORED_OUTLINE to true.

Latest Answer: In this case DEFAULT category will be used. If the outline for your query is not stored in DEFAULT category then this query will not use the stored outline and it will execute normally without using any stored outline. ...

Read Answers (1)

Answer Question Subscribe

What are the advantages and uses of Dynamic SGA feature?

Latest Answer: Since the inception of Oracle, the System Global Area (SGA) has been static. In Oracle8i Database Administrators (DBAs) do not have any control over the SGA size once the instance is started. Oracle9i allows a DBA to modify the SGA size dynamically. This ...

Read Answers (1)

Answer Question Subscribe

How can one reduce the impact of long running operations on other users without aborting the long

How can one reduce the impact of long running operations on other users without aborting the long running operations?

Read Answers (1)

Answer Question Subscribe

What are the advantages of data definition language (DDL) statements against a partitioned table with

What are the advantages of data definition language (DDL) statements against a partitioned table with the UPDATE GLOBAL INDEXES clause?

Read Answers (1)

Answer Question Subscribe

What is the function of Oracle9i Cache Fusion feature?

View Question

Answer Question Subscribe

What are the features and uses of external tables?

Latest Answer: The answer in ture B,D ...

Read Answers (1)

Answer Question Subscribe

What are the advantages of managing space using automatic segment space managed objects?

Latest Answer: The automatic space management is enabled by using SEGMENT SPACE MANAGEMENT AUTO clause in create tablespace statement. It uses the bitmap segments to keep track of used and free space in segments for particular tablespace. So whenever space is ...

Read Answers (1)

Answer Question Subscribe

What is the command used for monitoring a index on a table to find out whether it has been used by an

What is the command used for monitoring a index on a table to find out whether it has been used by an execution plan?

Read Answers (1)

Answer Question Subscribe

View page << Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>

Go Top

#	User Name	Count
1	kunal1017	3
2	udayasrinu	2
3	dnrao_27	1
4	sivarajdharmarajan	1
5	rajivgupta1107	1
6	chilu	1
7	sanju86	1
8	kishoredba	1
9	naveen5555	1
10	krradhakrishna	1

Get Latest Updates Via RSS Reader or by Email
Forum Discussion
Knowledge Base
Learning Series
Freelance Jobs
GeekInterview Blog
Testing Interview Questions
Oracle Interview Questions
Java Interview Questions
Latest Placement Papers
Free Training
Learn AJAX