Explain the man feature of RDBMS ?
What are the package used in DBMS ?
what are primary key and foreign key ?
What are ACID properties?
Explain the key constraints and constraints on Null Values with examples?
Explain the classification of Database Management System?
What are the Roles and responsibilities of database administrator?
Write a note on File based system/ Data base system?
what is the difference between unique and primary key?
wat is meant by oracle?
wHAT IS THE difference between foreign key and reference key?
WHAT IS INDEXING?
what is dba_segment ?
what do u mean by canvases and alerts?
What is relational database ?
What are indexes ? What are the advantages ?
what is the difference between filters and conditions?
Explain about the critical recovery scenario you had experiencedE?
what do u mean by implementation?
write a query to Find the Maximun second value in table?
what are the differences you find when working with oracle 91 and sql server 2005?
What file is read by ODBC to load drivers ?
Can we assign Explicitly transaction to a rollback segment?
How the status of the Rollback segment can be viewed ?
What is the use of NOARCHIEVELOG parameter in Database?
Which parameters are optional in init.ora parameter file?
what is the use of EXP command ?
How the SMON process is used to write into LOG files ?
When the SYSTEM TABLESPACE can be made off-line ?
What are the different Sequence of events takes place while starting a Database ?
What are the types of Calculated columns available ?
What are the SQL clauses supported in the link property sheet ?
What is TERM ?
what Kind of COMMENT statements placed within SQL statements ?
Oracle precompiler translates the EMBEDDED SQL statemens into ?
How many number of columns can a RECORD GROUP have ?
Can we create an List of Values without an RECORD GROUP ?
Can an Alert message be changed at runtime ?
What is an ALERT ?
What is a RADIO GROUP ?
What is a Built_in subprogram ?
How do you pass values from one form to another form ?
Can we attach the same List of Values to different fields in Design time ?
When a form is invoked with CALL_FORM does Oracle forms issues?
What built_in procedure is used to get IMAGES in Forms 4.5 ?
What is Library in Forms 4.0?
what the List of Values (LOV) supports?
What do you mean by Checkbox ?
Can A CONTROL BLOCK can sometimes refer to a Basetable ?
what is GET_BLOCK property ?
What is built_in Subprogram?
When do you get a .PLL extension ?
How can you CALL Reports from Forms4.0?
What SYSTEM VARIABLE is used to refer DATABASE TIME?
What will the SHOW_ALERT function returns?
What built in subprogram is used to manipulate images in image items ?
What are the different events in Triggers ?
What are the the different Data Manipulation Language statements are?
what is Data Definiton Language ?
Explain different types of Views ?
Is it possible to modify a Datatype of a column when column contains values?
Does the Database trigger will fire when the table is TRUNCATED ?
what is "TABLE" datatype ?
PL/SQL supports which datatypes?
Explain about User_Defined Exceptions?
Explain what is an Exception ?
What does a COMMIT statement do to a CURSOR?
Which factors does not affect the size of the SGA ?
What is Dedicated server configuration ?
where a Database Procedure is stored ?
Can A column defined as PRIMARY KEY can have NULL values ?
What is a DATABLOCK ?
when A set of Dictionary tables are created ?
How the size of the table space can be increased?
when All datafiles related to a Tablespace are removed ?
Explain ERASE packaged procedure ?
What is a trigger?
Name the two files that are created when you generate a form ?
What is SQL FORMS ?
Which of the packaged procedure is UNRESTRICTED ?
What is the maximum size of the page ?
what is postback trigger?
What does DLL stands for ?
what are the advantages of a client or server model ?
Why is it better to use an Integrity Constraint to validate data ?
What is the difference between a LIST BOX and a COMBO BOX ?
what are the advantages of GUI systems ?
Can a DIALOG WINDOW have scroll bar attached to it ?
What is the difference between a MESSAGEBOX and an ALERT ?
What is difference between a DIALOG WINDOW and a DOCUMENT WINDOW ?
can Constraints cannot be exported through EXPORT command ?
Where the Databases overall structure is maintained ?
Where does the LGWR process writes information?
From where ENQUEUE resources parameter information is derived ?
From where the Transactions per rollback segment is derived ?
What is the use of Snapshot?
What are the factors causing the reparsing of SQL statements in SGA?
What are the basic elements of Base configuration of an oracle Database ?
What is the mechanism provided by ORACLE for table replication ?
Describe two phases of Two-phase commit ?
What is Two-Phase Commit ?
What is Distributed database ?
What is cursor and where do you use them?
What is hot backup and how it can be taken ?
What are the different kind of export backups ?
What is cold backup ? What are the elements of it ?
What is a logical backup ?
What are the different methods of backing up oracle database ?
What are the steps involved in Instance Recovery ?
What is Log Switch ?
What is Archived Redo Log ?
What is Mirrored on-line Redo Log ?
What is On-line Redo Log?
What is Partial Backup ?
What is Full Backup ?
What are the different modes of mounting a Database with the Parallel Server ?
What is Restricted Mode of Instance Startup ?
Which parameters are optional in init.ora parameter file?
when All datafiles related to a Tablespace are removed ?
Explain the classification of Database Management System?
what is GET_BLOCK property ?
What do you mean by Checkbox ?
what do u mean by canvases and alerts?
What is a Built_in subprogram ?
what is the difference between filters and conditions?
What is SQL?
What is SELECT statement?
How can you compare a part of the name rather than the entire name?
What is the INSERT statement?
How do you delete a record from a database?
How could I get distinct entries from a table?
How to get the results of a Query sorted in any order?
How can I find the total number of records in a table?
What is GROUP BY?
What are the Large object types suported by Oracle?
Difference between a "where" clause and a "having" clause ?
What's the difference between a primary key and a unique key?
What are cursors? Explain different types of cursors? What are the disadvantages of cursors? How can you avoid cursors?
What are triggers? How to invoke a trigger on demand?
What is a join and explain different types of joins?
What is a self join?
What is difference between stack and queue?
Can you take Image Backups using RMAN?
What is Data Storage? Definition Language?
What is DML Compiler?
What is serialization? What is the difference between sql and oracle?
What is difference between oracle8i,oracle9i and oracle 10g?
What is the meaning for data base without using technical terms?
What is the difference between oracle 9i and 10g database?
What is basic difference between SQL Server2000 and oracle?
What is Trigger?
What magic table What happen when we run any command or stored procedure is it compile ?
What does OFA stands for?
What is dblink and how use it ?
What is oracle d2k? why we use it?
Explain about primary key?
How grid work? is it possible grid in 9i. how?
How we determine index require rebuilding ?
Disadvantage in File Processing System?
Describe the three levels of data abstraction?
What is Data Independence?
What is Weak Entity set?
What is lock and latch?
What is data base?
what are Advantages of DBMS?
What is Data Model?
What is Object Oriented model?
What is an Entity?
What is a Relation Schema and a Relation?
What is degree of a Relation?
How to modify already created table?
What is DML (Data Manipulation Language)?
What is Functional Dependency?
What is the difference between oracle and sql?
Explain about what a database is?
Explain about the database management systems?
EExplain about XML databases?
What is standard parameter at database creation?
Explain about the hierarchical model of database?
what is listner how u can change default name & port?
Explain about Network model?
What are the three basic rules which are to be followed for relational model of database?
Explain about relational database?
Explain about relational operator join?
Explain about the process of user request and data generating?
Explain about normal forms?
Explain about relational database management systems?
Explain about post relational databases?
what type of indexes?
Explain about the Storage and physical database design?
How data store in bitmap & btree index what is benefit?
Explain the role of indexing in databases?
State the ACID rules?
How you can determine query use full table scan?
How we determine index require rebuilding ?
What is row changing how u eliminate ?
What is view is it possible to create index on view on view & how ?
What is primary & unique key which type index oracle create when we make those key ?
What is steps of cloning?
When is a database is not a database?
What is the difference between sql and pl/sql?
What is dynamic data replication?
What is DBMS?
What are the package used in DBMS ?
what are primary key and foreign key ?
What are ACID properties?
Explain the key constraints and constraints on Null Values with examples?
Explain the classification of Database Management System?
What are the Roles and responsibilities of database administrator?
Write a note on File based system/ Data base system?
what is the difference between unique and primary key?
wat is meant by oracle?
wHAT IS THE difference between foreign key and reference key?
WHAT IS INDEXING?
what is dba_segment ?
what do u mean by canvases and alerts?
What is relational database ?
What are indexes ? What are the advantages ?
what is the difference between filters and conditions?
Explain about the critical recovery scenario you had experiencedE?
what do u mean by implementation?
write a query to Find the Maximun second value in table?
what are the differences you find when working with oracle 91 and sql server 2005?
What file is read by ODBC to load drivers ?
Can we assign Explicitly transaction to a rollback segment?
How the status of the Rollback segment can be viewed ?
What is the use of NOARCHIEVELOG parameter in Database?
Which parameters are optional in init.ora parameter file?
what is the use of EXP command ?
How the SMON process is used to write into LOG files ?
When the SYSTEM TABLESPACE can be made off-line ?
What are the different Sequence of events takes place while starting a Database ?
What are the types of Calculated columns available ?
What are the SQL clauses supported in the link property sheet ?
What is TERM ?
what Kind of COMMENT statements placed within SQL statements ?
Oracle precompiler translates the EMBEDDED SQL statemens into ?
How many number of columns can a RECORD GROUP have ?
Can we create an List of Values without an RECORD GROUP ?
Can an Alert message be changed at runtime ?
What is an ALERT ?
What is a RADIO GROUP ?
What is a Built_in subprogram ?
How do you pass values from one form to another form ?
Can we attach the same List of Values to different fields in Design time ?
When a form is invoked with CALL_FORM does Oracle forms issues?
What built_in procedure is used to get IMAGES in Forms 4.5 ?
What is Library in Forms 4.0?
what the List of Values (LOV) supports?
What do you mean by Checkbox ?
Can A CONTROL BLOCK can sometimes refer to a Basetable ?
what is GET_BLOCK property ?
What is built_in Subprogram?
When do you get a .PLL extension ?
How can you CALL Reports from Forms4.0?
What SYSTEM VARIABLE is used to refer DATABASE TIME?
What will the SHOW_ALERT function returns?
What built in subprogram is used to manipulate images in image items ?
What are the different events in Triggers ?
What are the the different Data Manipulation Language statements are?
what is Data Definiton Language ?
Explain different types of Views ?
Is it possible to modify a Datatype of a column when column contains values?
Does the Database trigger will fire when the table is TRUNCATED ?
what is "TABLE" datatype ?
PL/SQL supports which datatypes?
Explain about User_Defined Exceptions?
Explain what is an Exception ?
What does a COMMIT statement do to a CURSOR?
Which factors does not affect the size of the SGA ?
What is Dedicated server configuration ?
where a Database Procedure is stored ?
Can A column defined as PRIMARY KEY can have NULL values ?
What is a DATABLOCK ?
when A set of Dictionary tables are created ?
How the size of the table space can be increased?
when All datafiles related to a Tablespace are removed ?
Explain ERASE packaged procedure ?
What is a trigger?
Name the two files that are created when you generate a form ?
What is SQL FORMS ?
Which of the packaged procedure is UNRESTRICTED ?
What is the maximum size of the page ?
what is postback trigger?
What does DLL stands for ?
what are the advantages of a client or server model ?
Why is it better to use an Integrity Constraint to validate data ?
What is the difference between a LIST BOX and a COMBO BOX ?
what are the advantages of GUI systems ?
Can a DIALOG WINDOW have scroll bar attached to it ?
What is the difference between a MESSAGEBOX and an ALERT ?
What is difference between a DIALOG WINDOW and a DOCUMENT WINDOW ?
can Constraints cannot be exported through EXPORT command ?
Where the Databases overall structure is maintained ?
Where does the LGWR process writes information?
From where ENQUEUE resources parameter information is derived ?
From where the Transactions per rollback segment is derived ?
What is the use of Snapshot?
What are the factors causing the reparsing of SQL statements in SGA?
What are the basic elements of Base configuration of an oracle Database ?
What is the mechanism provided by ORACLE for table replication ?
Describe two phases of Two-phase commit ?
What is Two-Phase Commit ?
What is Distributed database ?
What is cursor and where do you use them?
What is hot backup and how it can be taken ?
What are the different kind of export backups ?
What is cold backup ? What are the elements of it ?
What is a logical backup ?
What are the different methods of backing up oracle database ?
What are the steps involved in Instance Recovery ?
What is Log Switch ?
What is Archived Redo Log ?
What is Mirrored on-line Redo Log ?
What is On-line Redo Log?
What is Partial Backup ?
What is Full Backup ?
What are the different modes of mounting a Database with the Parallel Server ?
What is Restricted Mode of Instance Startup ?
Which parameters are optional in init.ora parameter file?
when All datafiles related to a Tablespace are removed ?
Explain the classification of Database Management System?
what is GET_BLOCK property ?
What do you mean by Checkbox ?
what do u mean by canvases and alerts?
What is a Built_in subprogram ?
what is the difference between filters and conditions?
What is SQL?
What is SELECT statement?
How can you compare a part of the name rather than the entire name?
What is the INSERT statement?
How do you delete a record from a database?
How could I get distinct entries from a table?
How to get the results of a Query sorted in any order?
How can I find the total number of records in a table?
What is GROUP BY?
What are the Large object types suported by Oracle?
Difference between a "where" clause and a "having" clause ?
What's the difference between a primary key and a unique key?
What are cursors? Explain different types of cursors? What are the disadvantages of cursors? How can you avoid cursors?
What are triggers? How to invoke a trigger on demand?
What is a join and explain different types of joins?
What is a self join?
What is difference between stack and queue?
Can you take Image Backups using RMAN?
What is Data Storage? Definition Language?
What is DML Compiler?
What is serialization? What is the difference between sql and oracle?
What is difference between oracle8i,oracle9i and oracle 10g?
What is the meaning for data base without using technical terms?
What is the difference between oracle 9i and 10g database?
What is basic difference between SQL Server2000 and oracle?
What is Trigger?
What magic table What happen when we run any command or stored procedure is it compile ?
What does OFA stands for?
What is dblink and how use it ?
What is oracle d2k? why we use it?
Explain about primary key?
How grid work? is it possible grid in 9i. how?
How we determine index require rebuilding ?
Disadvantage in File Processing System?
Describe the three levels of data abstraction?
What is Data Independence?
What is Weak Entity set?
What is lock and latch?
What is data base?
what are Advantages of DBMS?
What is Data Model?
What is Object Oriented model?
What is an Entity?
What is a Relation Schema and a Relation?
What is degree of a Relation?
How to modify already created table?
What is DML (Data Manipulation Language)?
What is Functional Dependency?
What is the difference between oracle and sql?
Explain about what a database is?
Explain about the database management systems?
EExplain about XML databases?
What is standard parameter at database creation?
Explain about the hierarchical model of database?
what is listner how u can change default name & port?
Explain about Network model?
What are the three basic rules which are to be followed for relational model of database?
Explain about relational database?
Explain about relational operator join?
Explain about the process of user request and data generating?
Explain about normal forms?
Explain about relational database management systems?
Explain about post relational databases?
what type of indexes?
Explain about the Storage and physical database design?
How data store in bitmap & btree index what is benefit?
Explain the role of indexing in databases?
State the ACID rules?
How you can determine query use full table scan?
How we determine index require rebuilding ?
What is row changing how u eliminate ?
What is view is it possible to create index on view on view & how ?
What is primary & unique key which type index oracle create when we make those key ?
What is steps of cloning?
When is a database is not a database?
What is the difference between sql and pl/sql?
What is dynamic data replication?
What is DBMS?
Hi
ReplyDeleteI read this post two times.
I like it so much, please try to keep posting.
Let me introduce other material that may be good for our community.
Source: System analyst interview questions
Best regards
Henry