- Explain the difference between
- What are cursor
- What are triggers
- Explain Difference between view and index
- How to transfer database(500 gb) of
- ex. one table is having 1 column with 10
- What is autonomous transaction
- Define the terms primary key foreign key
- What is meant by magic query
- How to convert .db (extention) database
- How to conver a database backup file in
- How to insert no. of records at a time.
- What is the purpose of init.ora.
- How many init.ora exist in oracle
- suppose there are 3 database on one
- what are various database objects?
- How will we identify memory related
- what is global temporary table
- what is the signification of the parameter
- How many triggers we can create on a
- How you find out version of installed
- What is the bitmap index
- What is Index and different types of
- Can Multiple instances be run on Single
- What is the difference between primary
- What is unique key
- What is foreign key
- What is primary key
- What is a view
- What is index
- Which sql command we can use to get
- What is the syntax of ALTER command
- What is the syntax of DROP command
- What is the syntax of CREATE command
- What is the syntax of DELETE command
- What is the syntax of UPDATE command
- What is the syntax of INSERT command
- What is the syntax of SELECT command
- What is referential integrity
- Which clause we are not used in where
- What is the syntax of update command
- What is difference between foreign key
- What is difference between Cartesian
- What is Hash Index
- What is Reduced List of Values
- What are the different windows events
- What are the trigger associated with
- What is trigger associated with the timer
- What are the SQL clauses supported in
- If a parameter is used in a query without
- Can a property clause itself be based on
- When a form is invoked with call_form
- Is it possible to disable the parameter
- Is it possible to insert comments into
- Can a formula column be obtained
- Can a formula column referred to columns
- The join defined by the default data link
- Can a field be used in a report without
- For a field in a repeating frame, can the
- Is it possible to center an object
- Is it possible to split the print reviewer
- Does a Before form trigger fire when the
- Is the After report trigger fired if the
- Can we have more than one content
- What are the built-in functions used for
- What is a heap related to database
- What is currency type in database
- What is DTS and purpose of DTS
- Write a simple Store procedure and
- Query to retrieve record for a many to
- Indexes in oracle
- Difference between sub query and
- What is Normalization
- Difference between primary key and
- Draw E-R diagram for many to many
- What is E-R diagram
- How do we rate yourself in oracle and
- What is COST-based approach to
- What is RULE-based approach to
- What is the effect of setting the 'RULE'
- What is the effect of setting the value
- What is the effect of setting the value
- What is the effect of setting the value
- What are the values that can be specified
- What is the effect of setting the value
- Will the Optimizer always use COST-based
- What are the values that can be specified
- What are the factors that affect
- What are the different approaches
- What is the function of Optimizer
- What is Read-Only Transaction
- What is SAVE POINT
- When does a Transaction end
- Define Transaction
- What is the main diff between Subquery and a Join ?
- What are the factors causing the
- What is meant by redo log buffer
- What is meant by recursive hints
- What is dictionary cache
- What is Database Buffers
- What is a data segment
- What is mean by Program Global Area
- What is a Shared SQL pool
- What is SGA ? How it is different from
- What is a deadlock
- What are the basic element of Base
- What is a cluster Key
- What is clusters
- What is an Index ? How it is implemented
- What is a Schema
- What is Parallel Server
- What is a Database instance
- What is the difference between normal
- What is a materialised view
- What are virtual columns
- What is the difference between implicit
- What is a cluster
- Can we create more than one index on
- Query to get max and second max in
- Can we create index on views
- What is the difference between column
- What is the use of ondelete cascade
- What is the use of composite key
- What are pseudocolumns
- How many different types of indexes
- What is the use of rank function
- What is the difference between simple
- Can we create more than one constraint
- What are the disadvantages of
- In Oracle 9i what does "i" Stands for
- What is the maximum number of CHECK
- What are the Limitations of a CHECK
- What is self-referential integrity
- What are the Referential actions
- Describe Referential Integrity
- What is difference between UNIQUE
- Describe the different type of Integrity
- Can an Integrity Constraint be enforced
- What is an Integrity Constrains
- What is a Data Dictionary
- What is the use of Control File
- What does a Control file Contain
- What is the use of Redo Log Information
- What is the function of Redo Log
- What is a Redo Log
- What are the Characteristics of Data Files
- What is a Data File
- What is a Temporary Segment
- What are the uses of Rollback Segment
- What is Rollback Segment
- What is an Index Segment
- What is a Data Segment
- What are the different type of Segments
- What is a Segment
- What is an Extent
- What is Row Chaining
- How to define Data Block size
- What is Data Block
- What is Network Database link
- What is Public Database Link
- What is Private Database Link
- What are the types of Database Links
- What is Database Link
- When can Hash Cluster used
- What is Hash Cluster
- What is Index Cluster
- What is cluster Key
- What are Clusters
- How are Indexes Update
- What is an Index
- What are synonyms used for
- What is a Public Synonyms
- What is a Private Synonyms
- What are the types of Synonyms
- What is a Synonym
- What is a Sequence
- What are the advantages of Views
- Can a View based on another View
- Do View contain Data
- What is a View
- What is Table
- Can a Tablespace hold objects from
- Can objects of the same Schema reside
- What are Schema Objects
- What is schema
- Explain the relationship among Database
- What is SYSTEM tablespace and When
- What is a Tablespace
- What are the components of Logical
- What are the components of Physical
- Define 'view' advantage
- What are indexes, how many types of
- What are stored procedures
- What are Triggers
- What are joins? how many types of
- What are inner join and outer join
- What is the difference between SQL,
- How to create DSN.. Explain
- Is the JDBC-ODBC Bridge multi-threaded
- Why can't we invoke the ResultSet
- What is the query used to display all
- How do you delete a Cookie within a JSP
- How do we find whether a parameter
- What is the difference between a
- What separates one tier from another in
- Can we ensure that my app has the latest
- What's the best way, in terms of