Global Web Forum

AgentVinod12

Agent Vinod

From: India

Registered: 2012-03-23

Posts: 1,149

Website

RDBMS Interview Questions And Answers

Basic and Advance databases programming :: Relational Database Management System (RDBMS) Job Interview Questions and Answers

RDBMS Interview Questions and Answers will guide us here that relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model. Most popular commercial and open source databases currently in use are based on the relational model. Learn more about RDBMS with the help of this RDBMS Interview Questions with Answers guide

1 What is a Database?
2 What is DBMS?
3 What is a Database system?
4 Advantages of DBMS?
5 Disadvantage in File Processing System?
6 Describe the three levels of data abstraction?
7 Define the Integrity Rules?
8 What is extension and intension?
9 What is System R? What are its two major subsystems?
10 How is the data structure of System R different from the relational structure?
11 What is Data Independence?
12 What is a view? How it is related to data independence?
13 What is Data Model?
14 What is E-R model?
15 What is Object Oriented model?
16 What is an Entity type?
17 What is an Entity set?
18 What is an Extension of entity type?
19 What is Weak Entity set?
20 What is an attribute?
21 What is a Relation Schema and a Relation?
22 What is degree of a Relation?
23 What is Relationship?
24 What is DDL (Data Definition Language)?
25 What is VDL (View Definition Language)?
26 What is SDL (Storage Definition Language)?
27 What is Data Storage - Definition Language?
28 What is DML (Data Manipulation Language)?
29 What is DML Compiler?
30 What is Query evaluation engine?
31 What is DDL Interpreter?
32 What is Record-at-a-time?
33 What is Set-at-a-time or Set-oriented?
34 What is Relational Algebra?
35 What is Relational Calculus?
36 How does Tuple-oriented relational calculus differ from domain-oriented relational calculus?
37 What is normalization?
38 What is Functional Dependency?
39 When is a functional dependency F said to be minimal?
40 What is Multivalued dependency?
41 What is Lossless join property?
42 What is 1 NF (Normal Form)?
43 What is Fully Functional dependency?
44 What is 2NF?
45 What is 3NF?
46 What is BCNF (Boyce-Codd Normal Form)?
47 What is 4NF?
48 What is 5NF?
49 What is meant by Proactive, Retroactive and Simultaneous Update?
50 What are the different types of JOIN operations?
51 What do you understand by dependency preservation?
52 How can you find the minimal key of relational schema?
53 What are Armstrong rules? How do we say that they are complete and/or sound?
54 What is cold backup and hot backup (in case of Oracle)?
55 What are cursors give different types of cursors?
56 What are stand-alone procedures?
57 What is Authorization and Integrity manager?
58 What is File Manager?
59 What is Buffer Manager?
60 What is Storage Manager?
61 A dominant entity is the entity?
62 In mapping of ERD to DFD?
63 A B C is a set of attributes. The functional dependency is as followsAB -> BAC -> CC -> B?
64 Spurious tuples may occur due to?
65 Tables derived from the ERD?
66 Does PL/SQL support overloading? Explain?
67 What are stored-procedures? And what are the advantages of using them?
68 Name two utilities that Oracle provides, which are use for backup and recovery?
69 What is database Trigger?
70 What is Oracle Block? Can two Oracle Blocks have the same address?
71 What is ROWID?
72 What are database files, control files and log files. How many of these files should a database have at least? Why?
73 What are the four Oracle system processes that must always be up and running for the database to be useable?
74 Name the three major set of files on disk that compose a database in Oracle?
75 Define SQL and state the differences between SQL and other conventional programming Languages?
76 How do you communicate with an RDBMS?
77 What is the job of the information stored in data-dictionary?
78 Which part of the RDBMS takes care of the data dictionary? How?
79 Name the sub-systems of a RDBMS?
80 What is RDBMS KERNEL?
81 Are the resulting relations of PRODUCT and JOIN operation the same?
82 What are the unary operations in Relational Algebra?
83 Name the buffer in which all the commands that are typed in are stored?
84 What are the primitive operations common to all record management systems?
85 What do you mean by Correlated subquery?
86 What is a query?
87 Brief theory of Network, Hierarchical schemas and their properties?
88 What is transparent DBMS?
89 What do you mean by flat file database?
90 What are the different phases of transaction?
91 What is a checkpoint and When does it occur?
92 What is a Phantom Deadlock?
93 What do you mean by atomicity and aggregation?
94 What is durability in DBMS?
95 What is join dependency and inclusion dependency?
96 What is meant by query optimization?
97 What is system catalog or catalog relation? How is better known as?
98 What is indexing and what are the different kinds of indexing?