- How to create DSN.. Explain
- What is the difference between SQL, DDL, and DML
- What are inner join and outer join
- What are joins? how many types of joins are there
- What are Triggers
- What are stored procedures
- What are indexes, how many types of index's are there and what are they
- Define 'view' advantage
- What are the components of Physical database structure of Oracle Database
- What are the components of Logical database structure of ORACLE database
- What is a Tablespace
- What is SYSTEM tablespace and When is it Created
- Explain the relationship among Database, Tablespace and Data file
- What is schema
- What are Schema Objects
- Can objects of the same Schema reside in different tablespaces
- Can a Tablespace hold objects from different Schemes
- What is a View
- Do View contain Data
- Can a View based on another View
- What are the advantages of Views
- What is a Sequence
- What is a Synonym
- What are the types of Synonyms
- What is a Private Synonyms
- What is a Public Synonyms
- What are synonyms used for
- What is an Index
- How are Indexes Update
- What are Clusters
- What is cluster Key
- What is Index Cluster
- What is Hash Cluster
- When can Hash Cluster used
- What is Database Link
- What are the types of Database Links
- What is Private Database Link
- What is Public Database Link
- What is Network Database link
- What is Data Block
- How to define Data Block size
- What is Row Chaining
- What is an Extent
- What is a Segment
- What are the different type of Segments
- What is a Data Segment
- What is an Index Segment
- What is Rollback Segment
- What are the uses of Rollback Segment
- What is a Temporary Segment
- What is a Data File
- What are the Characteristics of Data Files
- What is a Redo Log
- What is the function of Redo Log
- What is the use of Redo Log Information
- What does a Control file Contain
- What is the use of Control File
- What is a Data Dictionary
- What is an Integrity Constrains
- When does a Transaction end
- Define Transaction
- What is the main diff between Subquery and a Join
- What are the factors causing the reparsing of SQL statements in SGA
- What is mean by Program Global Area (PGA)
- What is a Shared SQL pool
- What is SGA ? How it is different from Ver 6.0 and Ver 7.0
- What is a deadlock ? Explain
- What are the basic element of Base configuration of an oracle Database
- What is a cluster Key
- What is clusters
- What is an Index ? How it is implemented in Oracle Database
- What is a Schema
- What is Parallel Server
- What is a Database instance ? Explain
- What is the difference between normal and corelated subqueries
- What is a materialised view
- What are virtual columns
- What is the difference between implicit index and explicit index
- Can we create more than one index on particular column
- Can we create index on views
- What is the difference between column level constraints and table level constraints
- What is the use of ondelete cascade
- What is the use of composite key constraint
- What are pseudocolumns
- How many different types of indexes we have in oracle
- What is the use of rank function
- What is the difference between simple view and complex view
- Can we create more than one constraint to column
- What are the disadvantages of hierarchical database over RDBMS
- In Oracle 9i what does "i" Stands for
- What is the maximum number of CHECK constraints that can be defined on a column
- What are the Limitations of a CHECK Constraint
- What is self-referential integrity constraint
- Describe Referential Integrity
- What are the Referential actions supported by FOREIGN KEY integrity constraint
- What is difference between UNIQUE constraint and PRIMARY KEY constraint
- Describe the different type of Integrity Constraints supported by ORACLE
- Can an Integrity Constraint be enforced on a table if some existing table
- What is SAVE POINT
- What is Read-Only Transaction
- What is the function of Optimizer
- What are the different approaches used by Optimizer in choosing an execution plan
- What are the factors that affect OPTIMIZER in choosing an Optimization approach
- What are the values that can be specified for OPTIMIZER MODE Parameter
- What is the effect of setting the value of OPTIMIZER_MODE to 'RULE'
- Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"
- 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 pass parameter to it
- Query to get max and second max in oracle in one query
- Query to retrieve record for a many to many relationship
- Difference between sub query and nested query
- Draw E-R diagram for many to many relationship
- What is E-R diagram
- How do you rate yourself in oracle and sql server
- What is COST-based approach to optimization
- What is RULE-based approach to optimization
- What is Hash Index
- What is Reduced List of Values
- What are the different windows events activated at runtime
- What is difference between Cartesian join & cross join even they give same result
- What is unique key
- What is foreign key
- What is primary key
- What is index
- Which sql command we can use to get a print out from oracle
- 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 clause
- What is difference between foreign key and reference key
- What is the difference between primary key & foreign key
- What is Index and different types of Indexes
- What is the bitmap index
- How you find out version of installed workflow
- How many triggers we can create on a table
- What is autonomous transaction
- Explain Difference between view and index
- What is meant by magic query
- What are the built-in functions used for sending Parameters to forms
- Does a Before form trigger fire when the parameter form is suppressed
- Difference between primary key and unique key
- Is the After report trigger fired if the report execution fails ?
- What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER
- What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter
- What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter
- What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter
- What is the effect of setting the 'RULE' for OPTIMIZER_GOAL parameter of the ALTER
- What is the difference between oracle 8i,9i,11i
- How client makes connection with server in client/server architecture
- What are the main diff. between oracle 7.3 and oracle 8i
- For web applications from which version of Oracle is suitable
- What is the Symbol use for Inner Join
- How do you switch from an init.ora file to a spfile
- When the procedures or packages become invalidate
- How do you use trigger to create mutating state of table
- What is the difference between TRUNCATE and DELETE command in SQL
- Is Oracle 7.3 is a single user or multi user. Is it possible to use this as a backend
- How shall we differentiate between primary key and foriegn key
- How can you rebuild an index
- How would you determine who has added a row to a table
- What view would you use to determine free space in a tablespace