| What is Tablespaces ? |
| What is Database's schema objects? |
| What is a SYSTEM tablespace and when it is created? |
| What is an Oracle table? |
| What is bulk copy or BCP in Oracle? |
| What is the relationship among database, tablespace and data file? |
| What is a snapshot in Oracle database? |
| What is the difference between hot backup and cold backup in Oracle? |
| What is library cache? |
| What is data dictionary cache? |
| What is save point in Oracle database? |
| What is hash cluster in Oracle? |
| What is Tables ? |
| What is Views ? |
| What is Indexes ? |
| What is Synonyms ? |
| What is the difference between pre-select and pre-query? |
| What is Form module? |
| What is Menu module? |
| What is Pl/SQL Library module? |
| What is Object Library module? |
| What is the usage of ANALYZE command in Oracle? |
| What is SUBQUERIES ? |
| What is Outer Join? |
| What is Equi-join ? |
| What is the usage of control file in Oracle? |
| What is a synonyms? |
| What is the usage of synonyms? |
| What is the difference between TRANSLATE and REPLACE in Oracle? |
| What is the usage of Save Points in Oracle database? |
| What is the difference between post-database commit and post-form commit? |
| What is Logical backup in Oracle? |
| What is the meaning of recursive hints in Oracle? |
| What is the use of GRANT option in IMP command? |
| What is the use of ROWS option in IMP command? |
| What is the use of INDEXES option in IMP command? |
| What is the use of IGNORE option in IMP command? |
| What is the use of SHOW option in IMP command? |
| What is the use of FILE param in IMP command? |
| What is RAW datatype? |
| What is the use of NVL function? |
| What is COALESCE function? |
| What is BLOB datatype? |
| What is the difference between TRANSLATE and REPLACE? |
| What is the usage of Merge Statement? |
| What is NULL value in oracle? |
| What is USING Clause and give example? |
| What is key preserved table? |
| What is WITH CHECK OPTION? |
| What is the use of Aggregate functions in Oracle? |
| What is a sub query and what are the different types of subqueries? |
| What is Correlated sub query? |
| What is Non-Correlated subquery? |
| What is cross join? |
| What is Varray ? |
| What is the difference between rename and alias? |
| What is a View? |
| What is a cursor variable? |
| What is the use of %FOUND |
| What is the use of %NOT FOUND |
| What is the use of %ISOPEN |
| What is the use of %ROWCOUNT |
| What is an integrity constraint? |
| What is an ALERT? |
| What is hash cluster? |
| What is NULL constraints? |
| What is NOT NULL constraints? |
| What is CHECK constraints? |
| What is DEFAULT constraints? |
| What is difference between SUBSTR and INSTR? |
| What is the parameter mode that can be passed to a procedure? |
| What is the difference between $ORACLE_BASE and $ORACLE_HOME? |
| What is the fastest query method to fetch data from the table? |
| What is the maximum number of triggers that can be applied to a single table? |
| What is the data type of DUAL table? |
| What is difference between Cartesian Join and Cross Join? |
| What are the various Oracle database objects? |
| What are the different types of modules in Oracle forms? |
| What are the different types of synonyms? |
| What are the different types of database objects? |
| What are the limitations of CHECK constraint? |
| What are the extensions used by Oracle reports? |
| What are nested tables? |
| What are temporal data types in Oracle? |
| What are cursor attributes? |
| What are SET operators? |
| What are the attributes of Cursor? |
| What are the various constraints used in Oracle? |
| What are the different Oracle Database objects? |
| What are the differences between LOV and List Item? |
| What are privileges and Grants? |
| What types of joins are used in writing SUBQUERIES? |
| How do you store pictures in a database? |
| How do you find current date and time in Oracle? |
| How do we represent comments in Oracle? |
| How do we display rows from the table without duplicates? |
| How do we create privileges in Oracle? |
| How do we get field details of a table? |
| How to convert a string to a date in Oracle database? |
| How to display row numbers with the records? |
| How to display employee records who gets more salary than the average salary in the department? |
| Can we store pictures in the database and if so, how it can be done? |
| Can you create a synonym without having a table? |
| Difference between varchar and varchar2 data types? |
| How can we delete duplicate rows in a table? |
| How can we view last record added to a table? |
| How many memory layers are in the Oracle shared pool? |
| In which language Oracle has been developed? |
| What do you understand by Redo Log file mirroring? |
| What do you mean by GROUP BY Clause? |
| What is DML? |
| What will be the syntax to find current date and time in format "YYYY-MM-DD"? |
| Whether any commands are used for Months calculation? If so, What are they? |
| What are Schema Objects? |
| What is a Table? |
| What is a View? |
| What is an Index? |
| What is a Data file? |
| What is the difference between UNIQUE or PRIMARY KEY Constraint? |
| What is PL/SQL ? |
| What is the basic structure of PL/SQL ? |
| What is the difference between %ROWTYPE and TYPE RECORD ? |
| What is a cursor ? Why cursor is required ? |
| What is Raise_application_error ? |
| What is the difference between a PROCEDURE and FUNCTION ? |
| What is Overloading of procedures ? |
| What is a package ? What are the advantages of package ? |
| What is difference between TRUNCATE and DELETE? |
| What is a join? Explain the different types of joins? |
| What is a Subquery? |
| What is correlated sub-query? |
| What are the Usages of SAVEPOINTS? |
| What is ROWID? |
| What is PRIMARY KEY, UNIQUE KEY, FOREIGN KEY? |
| What is ON DELETE CASCADE? |
| What is difference between CHAR and VARCHAR2? What is maximum SIZE allowed for each type? |
| What will be returned from SIGN(ABS(NVL(-32,0)))? |
| What is database? |
| What is a transaction ? |
| What is implicit cursor and how is it used by Oracle ? |
| What are the various types of parameter modes in a procedure ? |
| What are the constructs of a procedure, function or a package ? |
| What are the parts of a database trigger ? |
| What are the various types of database triggers ? |
| What is the advantage of a stored procedure over a database trigger ? |
| What are cascading triggers? What is the maximum no of cascading triggers at a time? |
| What are mutating triggers ? |
| What are constraining triggers ? |
| What is Oracle database’s physical and logical structure ? |
| What is the use of Control files ? |
| What is the use of Data Dictionary ? |
| What are the states of a rollback segment ? What is the difference between partly available and needs recovery ? |
| What is the maximum no.of columns a table can have ? |
| What are the various types of RollBack Segments ? |
| What are the disadvantages of SQL ? |
| What is the difference between a view and a synonym ? |
| What is the difference between foreign key and reference key ? |
| What is a package cursor ? |
| What are snap shots and views |
| Explain the two types of cursors ? |
| Explain UNION, MINUS, UNION ALL, INTERSECT? INTERSECT returns all commmon rows selected by both queries. |
| Explain the difference between trigger and stored procedure. |
| Why Create or Replace and not Drop and recreate procedures ? |
| How to store the results of a query into a file? |
| How to create a copy of EMP table without any data? |
| How to delete the 10th record of EMP table? |
| How can I protect my PL/SQL source code? |
| How can you avoid indexes ? |
| When to create indexes ? |
| Difference between SUBSTR and INSTR? |
| Can one read/write files from PL/SQL? |
| Can one use dynamic SQL within PL/SQL? OR Can you use a DDL in a procedure ? How ? |
| Can you pass parameters in packages ? How ? |
| Can you increase the size of a tablespace ? How ? |
| Can you pass a parameter to a cursor ? |
| Delete those employees who joined the company 10 years back from today? |
| Differences between DATE and TIMESTAMP in Oracle |
| Display the name of employees who joined on the same date? |
| Find out the number of employees whose salary is greater than their manager salary? |
| Is there a PL/SQL Engine in SQL*Plus? |
| Select the count of employees in each dept where count is greater than 3? |
| What is RAW datatype? |
| What is the use of NVL function? |
| What are nested tables? |
| What is COALESCE function? |
| What is BLOB datatype? |
| What is DML? |
| What is the difference between TRANSLATE and REPLACE? |
| What is the usage of Merge Statement? |
| What is NULL value in oracle? |
| What is USING Clause and give example? |
| What is key preserved table? |
| What is WITH CHECK OPTION? |
| What is the use of Aggregate functions in Oracle? |
| What do you mean by GROUP BY Clause? |
| What is a sub query and what are the different types of subqueries? |
| What is cross join? |
| What are temporal data types in Oracle? |
| What is VArray? |
| What is the difference between rename and alias? |
| What is a View? |
| What is a cursor variable? |
| What are cursor attributes? |
| What are SET operators? |
| What are the attributes of Cursor? |
| What is an integrity constraint? |
| What is an ALERT? |
| What is hash cluster? |
| What is difference between SUBSTR and INSTR? |
| What is the parameter mode that can be passed to a procedure? |
| What are the different Oracle Database objects? |
| What are the differences between LOV and List Item? |
| What are privileges and Grants? |
| What is the difference between $ORACLE_BASE and $ORACLE_HOME? |
| What is the fastest query method to fetch data from the table? |
| What is the maximum number of triggers that can be applied to a single table? |
| What is the data type of DUAL table? |
| What is difference between Cartesian Join and Cross Join? |
| What are packages in pl SQL and also explain its advantages? |
| What are the various constraints used in Oracle? |
| What do you mean by CDB and PDB in Oracle 12c? |
| What is a trigger and what are its types in Oracle? |
| What is an Oracle and why it is used? |
| What is Oracle join syntax? |
| What is Oracle latest version? |
| What is PL SQL and why it is used for? |
| What is the difference between primary key and unique key and foreign key in Oracle? |
| What is the difference between substr and instr function in Oracle? |
| What is the dynamic SQL in Oracle? |
| What is the new features in Oracle 12c? |
| What is translate in Oracle? |
| Write a syntax for update query in Oracle? |
| Write a trigger example in Oracle? |
| Explain Oracle insert into command? |
| Explain self joins in oracle? |
| Explain the difference between delete and truncate? |
| Explain the difference between replace() and translate() functions in Oracle? |
| Explain the difference between SAP and Oracle? |
| Explain the difference between SQL and Oracle? |
| Explain the features of Oracle? |
| Explain the truncate in Oracle? |
| How do we represent comments in Oracle? |
| How do we display rows from the table without duplicates? |
| How do we create privileges in Oracle? |
| How do we get field details of a table? |
| How can we delete duplicate rows in a table? |
| How to display row numbers with the records? |
| How can we view last record added to a table? |
| How to display employee records who gets more salary than the average salary in the department? |
| How to convert raw data type into text in Oracle? Explain |
| How to execute the package in Oracle? |
| Who developed Oracle & when? |
| Difference between varchar and varchar2 data types? |
| In which language Oracle has been developed? |
| Can we store pictures in the database and if so, how it can be done? |
| Please explain compound trigger in Oracle? |
| Please explain drop constraint Oracle? |
| Please explain joins in oracle? |
| Please explain oracle data types with examples? |
| Please explain oracle left join with an example? |
| Whether any commands are used for Months calculation? If so, What are they? |
19 January 2021
#Oracle
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment