www.thecareerplus.com
The CareerPlus
Home
Technical Resources
DBMS
Thursday 09th September 2010
Main Menu
Home
Technical Resources
CareerPlus Specials!
HR FAQs
TheCareerPlus Blog
CareerPlus Forum
About Us
Data Models and schemas
What is database?
What is DBMS?
What is a Database system?
Advantages of DBMS?
Disadvantage in File Processing System?
Describe the three levels of data abstraction?
Define the "integrity rules"
What is extension and intension?
What is System R? What are its two major subsystems?
How is the data structure of System R different from the relational structure?
What is Data Independence?
What is a view? How it is related to data independence?
What is Data Model?
What is E-R model?
What is Object Oriented model?
What is an Entity?
What is an Entity type?
What is an Entity set?
What is an Extension of entity type?
What is Weak Entity set?
What is an attribute?
What is a Relation Schema and a Relation?
What is degree of a Relation?
What is Relationship?
What is Relationship set?
What is Relationship type?
What is degree of Relationship type?
What is DDL (Data Definition Language)?
What is VDL (View Definition Language)?
What is SDL (Storage Definition Language)?
What is Data Storage - Definition Language?
What is DML (Data Manipulation Language)?
What is DML Compiler?
What is Query evaluation engine?
What is DDL Interpreter?
What is Record-at-a-time?
What is Set-at-a-time or Set-oriented?
What is the basic difference between DBMS and RDBMS ?
Relational Algebra and Relational Calculus
What is super key ?
Whats is candidate key ?
What is weak entity set ?
What is Primary key ?
what is foreign keys ?
what is Discriminator ?
What are partial, alternate,, artificial, compound and natural key?
What is trigger ?
Authorization in SQL ?
What is Roles ?
Drop and Alter Command ?
Aggregate Functions
When is a functional dependency F said to be minimal?
What is Multivalued dependency?
What is Lossless join property?
What is Relational Algebra?
What is Relational Calculus?
How does Tuple-oriented relational calculus differ from domain-oriented relational calculus
What are the unary operations in Relational Algebra?
Are the resulting relations of PRODUCT and JOIN operation the same?
Normalization
What is normalization?
what is goal of normalization? ?
tell me abt 1NF, 2NF, and 3NF ,4NF
How to eliminate the values in an attribute having moe than one?
what is Functional Dependency in Database Normalization
what is Transitive Dependency in Database Normalization
Boyce Boyce-Codd Codd Normal Form ?
What is 5NF?
What is 1 NF (Normal Form)?
What is Fully Functional dependency?
What is 2NF?
What is 3NF?
What is BCNF (Boyce-Codd Normal Form)?
What is 4NF?
Storage, Indexing and Query Processing
What is indexing and what are the different kinds of indexing?
How many kinds of indices
What is Dense Index ?
what is Sparse Index ?
Explain B+ Tree Index ?
Explain B Tree Index ?
What is hash function ?
Explain Dyanmic Hashing ?
Explain Bitmap Indices?
Transactions
What is database transaction ?
what is rollback ?
What are savePoints ?
what is commit ?
What is atomic commit ?
Two phase commit ?
Three phase commit ?
What is durability in DBMS?
What do you mean by atomicity and aggregation?
What are the different phases of transaction?
What are ACID properties ?
SQL
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
What operator performs pattern matching?
What operator tests column for the absence of data?
Which command executes the contents of a specified file?
What is the parameter substitution symbol used with INSERT INTO command?
Which command displays the SQL command in the SQL buffer, and then executes it?
What are the wildcards used for pattern matching?
State true or false. EXISTS, SOME, ANY are operators in SQL.
State true or false. !=, <>, ^= all denote the same operation.
What are the privileges that can be granted on a table by a user to others?
What command is used to get back the privileges offered by the GRANT command?
Which system tables contain information on privileges granted and privileges obtained?
Which system table contains information on constraints on all the tables created?
TRUNCATE TABLE EMP;
What is the difference between TRUNCATE and DELETE commands?
What command is used to create a table by copying the structure of another table?
What will be the output of the following query?
What does the following query do?
Which date function is used to find the difference between two dates?
Why does the following command give a compilation error?
What is the advantage of specifying WITH GRANT OPTION in the GRANT command?
What is the use of the DROP option in the ALTER TABLE command?
What is the value of ?comm? and ?sal? after executing the following query if the initial value of ?sal? is 10000?
What is the use of DESC in SQL?
What is the use of CASCADE CONSTRAINTS?
What is the output of the following query?
What are stored-procedures? And what are the advantages of using them.
How are exceptions handled in PL/SQL? Give some of the internal exceptions' name
Does PL/SQL support Overloading? Explain.
CrackTheIntervew.NET
Advertisement
