You are not logged in.

#1 2014-07-23 04:11:35

Muhammad
User RankUser RankUser RankUser RankUser RankUser Rank
بِسمِ اللَّهِ الرَّحمٰنِ الرَّحيمِ
From: Sahiwal Division
Registered: 2012-03-22
Posts: 22,197
Website

Oracle Architecture and Concepts Interview Questions And Answers

Oracle Database :: Concepts and Architecture Job Interview Questions and Answers

Oracle Architecture and Conceptual frequently Asked Questions in various Oracle Architectural job Interviews by interviewer. Get preparation of Oracle Architecture and Concepts related job interview questions

1 Explain what is Public Database Link?
2 Tell me what is the difference between materialized view and snapshot?
3 Explain what is an Index Segment?
4 Explain the different type of Segments?
5 What is Referential Integrity?
6 Explain what is Rollback Segment?
7 Do you know how are Indexes Update?
8 Explain can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint?
9 Explain what is meant by snapshot error?
10 Tell us what is the use of Control File?
11 Tell us what is an Integrity Constrains?
12 Explain what are the Referential actions supported by FOREIGN KEY integrity constraint?
13 Tell me what does a Control file Contain?
14 What is a Data Dictionary in Oracle?
15 Explain what is SYSTEM tablespace and when is it Created?
16 What is a Tablespace?
17 Explain what are the components of Physical database structure of Oracle Database?
18 Tell me what are the uses of Rollback Segment?
19 Tell me what is difference between UNIQUE constraint and PRIMARY KEY constraint?
20 Explain what are the Limitations of a CHECK Constraint?
21 Explain what is a Synonym?
22 Do you know what is an Extent?
23 Tell me do View contain Data?
24 Explain what is a Sequence?
25 What is Hash Cluster in Oracle?
26 What is a Segment in Oracle?
27 What are Clusters in Oracle?
28 What is a Data File in Oracle?
29 What is Row Chaining in Oracle?
30 What is a Temporary Segment in Oracle?
31 What is an Index in Oracle?
32 What is self-referential integrity constraint in Oracle?
33 Explain the different type of Integrity Constraints supported by ORACLE?
34 Tell me how to define Data Block size?
35 What are Schema Objects in Oracle?
36 What are the type of Synonyms in Oracle?
37 What are the advantages of Views in Oracle?
38 What is a Public Synonyms in Oracle?
39 What is a Private Synonyms in Oracle?
40 What are the Characteristics of Data Files in Oracle?
41 What is high watermark in oracle?
42 How does the SMON process performs recovery after instance failure?
43 Explain what is the back ground process in oracle architecture?
44 How to determine the physical architecture of oracle?
45 Tell me what is the name of the back ground process that modifies the db buffer cache?
46 When does the LGWR writes all redo-enteries to the redo-log buffer?
47 Explain what is the command to find the database that already present before connecting?
48 What is a Data Segment in Oracle?
49 Can we add a column to view in Oracle?
50 Which parameter specifies the number of DBWn processes?
51 What is the use of archive log file?
52 How to apply archive log file in Oracle?
53 How does archive log file helps to make backup consistent?
54 What is schema in Oracle Architecture?
55 Where does the process dumps information about the error?
56 What is the use of Redo Log Information in Oracle?
57 Explain Virtual tables?
58 What is Oracle Identity Analytics?
59 What is the diff b/w BTREE INDEX and BITMAP INDEX?
60 If a user executes a query which is already being used by a view exactly will oracle use already existing view to retrieve data or use the query executed by user?
61 What is Private Database Link in Oracle?
62 What is Data Block in Oracle Architecture?
63 Explain can objects of the same Schema reside in different tablespaces?
64 What is Table in Oracle Architecture?
65 What is a View in Oracle?
66 From where does PMON gets the conformance about failure? How is the user process terminated?
67 What is SID (System Identifier)?
68 What is Global Database Name?
69 What are synonyms used for in Oracle?
70 Tell me what are advantage of Data Dictionary manage Tablespace?
71 Do you know what is the maximum number of CHECK constraints that can be defined on a column?
72 Explain what is the difference between SID and Global Database Name?
73 Explain can a Tablespace hold objects from different Schemes?
74 Tell me the relationship among Database, Tablespace and Data file?
75 Tell me what are the Large object types supported by Oracle?
76 What is Database Link in Oracle?
77 Tell me how to encrypt and decrypt oracle procedure?
78 Explain what are the components of Logical database structure of ORACLE database?
79 How to identify database size when you create a database first time?
80 Explain what is remote login user and local user in database? And sid is used when user want to login as local user and Glodal database name is used when user wants to login as remote user..What does it mean?
81 What is a Redo Log in Oracle Architecture?
82 Explain what is the function of Redo Log?

Download Oracle Architecture and Concepts Interview Questions And Answers PDF


Online Web Tutorials And Interview Questions With Answers Forum:
https://globalguideline.com/forum/

2014-07-23 04:11:35

Advertisement
Ads By Google

Re: Oracle Architecture and Concepts Interview Questions And Answers



\n
The following user say "Thank You" for this post:Guest

Board footer