1. What are the different types of components in Oracle?
There are two different components in Oracle .One would be components of Physical database and other would be components of Logical database.
2. What are the components of Physical database in oracle?
The Different components of physical database are one or more data files, two or more redo log files and one or more control files.
3. What are the components of logical database in oracle?
The Components of logical database are Table spaces and Database Schema Objects
4. What is the difference between varchar and varchar2 datatypes in oracle?
Varchar occupies space for Nullvalues where as varchar2 will not . Varchar will store up to 2000 bytes where as varchar2 will store up to 4000 bytes
5. What are nested tables in oracle?
A table inside another table is called nested table. It will support columns with multi valued attributes
6. How do we represent comments?
In Oracle comments can be represented by using two dashes(-) before the beginning of single statement and /*--*/ symbol to block the set of statements.
7. What are the different Data Manipulation statements available in Oracle?
Insert, Update, Select, Delete are four different Data Manipulation statements available in oracle
8. What are the different aggregate functions in Oracle?
The Different aggregate functions in Oracle are Average, Sum and Count.
9. What is the use of GROUP BY Clause in Oracle?
GROUP BY Clause in Oracle will be used along with Select statement in which multiple records of data are grouped to one record by one or more columns.
10. What are the different sub queries available in Oracle
There are two different sub queries available in Oracle One is Correlated query and Non Correlated Query.
11. What is sub query?
Sub query is a nested query which will fetch data from multiple tables .It is also called as Inner Query.
12. Mention the different temporal data types in Oracle?
Datedatatype, Intervaldatatype and Timestampdatatype are three different temporal data types in oracle
13. What is the syntax for granting privileges in oracle?
[SQL] GRANT user1 to user2 WITH MANAGER OPTION;[/SQL]
14. What do you mean by Alias ?
Alias is nothing but a temporary or alternate name which we are going to give for table or column
15. What are different SET Operators available in Oracle?
Union,Union All,Intersect and Minus are the different SET Operators available in Oracle
16. What is command which we will use for deletion for Duplicate rows in a table?
We can Delete Duplicate rows in Oracle by using ROWID Command
17. Mention few cursor attributes in oracle?
%FOUND,%NOT FOUND,%ISOPEN and %ROWCOUNT are some of the cursor attributes we are using in Oracle.
18. What do you mean by an Integrity constraint?
An integrity constraint in Oracle is defined as a business rule declaration for a table column which is mainly meant for ensuring accuracy and consistency of data.
19. What are the different types of Integrity constraints?
Domain Integrity and Referential Integrity are the two different types of Integrity constraints used in Oracle.
20. Mention different Constraints in Oracle?
NULL,NOTNULL,CHECK and DEFAULT are the constraints used in Oracle
21. What are the different data objects in Oracle?
The Different objects that are there in Oracle database are Tables,Views,Synonyms,Indexes,Sequences and Tablespaces.
22. How many triggers can be applied in a single table ?
We can apply a maximum of 12 triggers in a single table.
23. What is the command to display row numbers with the record numbers?
Select Rownumber <fieldname> from table;
24. What do you mean by Cluster in Oracle?
Cluster is nothing but group of one or more tables together to share common columns .
25. Mention the different types of queries in Oracle ?
The Different Queries in Oracle are Normal Queries,Nested Queries,Sub Queries,Nested Queries and Co-related Queries.
Related Interview Questions and Answers:
Oracle Interview Questions for More
Oracle DBA Interview Questions
SQL Server DBA Interview Questions
0 comments:
Post a Comment