-
Tablespace Without Segments
Can we create tablespace without segments if yes then how?
-
Base Table Update
How to update base table (data dictionary) automatically in every 5 sec or 5 min?
-
Meta Data Query
What is the query to get meta and meta-meta data?
-
Databases Interoperability
How two databases can be interoperabled?
-
Combine Two Separate Tables
How to combine two separate table into one?
-
System TableSpace and Default TableSpace
Explain what are system tablespace and default tablespace? How do they differ from one another?
-
View SMON
How to view whether SMON is running or not using batch script??
-
Parent Table
A table which consist of atleast one primary or Unique key is called as Parent Table. True / False (Justify)
-
-
How to write a query to retrieve only the months from certain given duration.
I will be getting this duration from the dual table. Provide query for this.Like for example, if suppose I am going to get value from the month of 01-Jan-2006 to 31-Apr-2007 then My result should be only 4 months like Jan, Feb, Mar, Apr.Btu not the whole dates. Only four rows has to be retrieved. This should be retrieved from the dual table but not from other tables.
-
-
-
-
-
-
Oracle DBA Questions
The ORACLE db is running with session audit and the audit table is full. What happens to new sessions? Nothing, They are not audited New Connections are Not Allowed Session allowed, with audit to alert.log None of the above recordWhich of the following statements is valid? ALTER SESSION SET CONSTRAINTS=TRUE ALTER SESSION SET CONSTRAINTS = DEFERRED ALTER SESSION SET CONSTRAINTS = FORWARD None of the...
-
-
-
how to copy the tables from one system to another or from one user to another user?
means i have 150 tables in one system, i want to copy those tables into another system.
-
-
-
-
-
-
What is Rollback Segment ?
A Database contains one or more Rollback Segments to temporarily store "undo" information.
-
What is an Index Segment ?
Each Index has an Index segment that stores all of its data.
-
What is a Data Segment ?
Each Non-clustered table has a data segment. All of the table's data is stored in the extents of its data segment. Each cluster has a data segment. The data of every table in the cluster is stored in the cluster's data segment.
-
What are the different type of Segments ?
Data Segment, Index Segment, Rollback Segment and Temporary Segment.