| Question | Likes! | Dislikes! | Answers! |
|---|
Questions of this subject!.
| 1)Describe the three levels of data abstraction. Presidency university, Bangalore - DBMS | 0 | 0 | 1 |
| 2)Differentiate between tuple relational calculus and domain relational calculus, with an example. Presidency University, Bangalore- Database Management System | 0 | 0 | 1 |
| 3)Define the | 0 | 0 | 1 |
| 4)What is extension and intension? Database Management System | 0 | 0 | 1 |
| 5)What is System R? What are its two major subsystems? Database Management System | 0 | 0 | 1 |
| 6) Database-Management-System | 0 | 0 | 2 |
| 7)How is the data structure of System R different from the relational structure? Database Management System | 0 | 0 | 1 |
| 8)What is Data Independence? Database Management System | 0 | 0 | 1 |
| 9)What is a view? How it is related to data independence? Database Management System | 0 | 0 | 1 |
| 10)What do database languages do? Database-Management-System | 0 | 0 | 1 |
| 11)What is a stored procedure? - database management system | 0 | 0 | 1 |
| 12)What is Object Oriented model? Database Management System | 0 | 0 | 1 |
| 13)Define database model. Database-Management-System | 0 | 0 | 1 |
| 14)What is a Trigger? - database management system | 0 | 0 | 1 |
| 15)Define the "integrity rules" in database ?Database-Management-System | 0 | 0 | 1 |
| 16)What is an Entity? Database Management System | 0 | 0 | 1 |
| 17)What is an Entity type? Database Management System | 0 | 0 | 1 |
| 18)What is the difference between Trigger and Stored Procedure? -database management system | 0 | 0 | 1 |
| 19)What is System R? What are its two major subsystems? Database-Management-System | 0 | 0 | 2 |
| 20)What is SQL? Database-Management-System | 0 | 0 | 1 |
| 21)What is an Entity set? Database Management System | 0 | 0 | 1 |
| 22)What is Weak Entity set? Database Management System | 0 | 0 | 1 |
| 23)What are indexes? -database management system | 0 | 0 | 1 |
| 24)How is the data structure of System R different from the relational structure? Database-Management-System | 0 | 0 | 1 |
| 25) Define Denormalization. Database-Management-System | 0 | 0 | 1 |
| 26)What is Data Independence? Database-Management-System | 0 | 0 | 1 |
| 27)What is a Relation Schema and a Relation? Database Management System | 0 | 0 | 1 |
| 28)Define DDL and DML. Database-Management-System | 0 | 0 | 1 |
| 29)What is degree of a Relation? Database Management System | 0 | 0 | 1 |
| 30)What is DDL (Data Definition Language)? Database Management System | 0 | 0 | 1 |
| 31)Enlist some commands of DDL. Database-Management-System | 0 | 0 | 1 |
| 32)What is a view? How it is related to data independence? Database-Management-System | 0 | 0 | 1 |
| 33)What is VDL (View Definition Language)? Database Management System | 0 | 0 | 1 |
| 34)Define Union All operator and Union. Database-Management-System | 0 | 0 | 1 |
| 35)What are clustered and non-clustered Indexes? - database management system | 0 | 0 | 1 |
| 36)What is degree of a Relation? Database-Management-System | 0 | 0 | 1 |
| 37)Define cursor. Database-Management-System | 0 | 0 | 1 |
| 38)What is SDL (Storage Definition Language)? Database Management System | 0 | 0 | 1 |
| 39)Enlist the cursor types. Database-Management-System | 0 | 0 | 2 |
| 40)What is degree of Relationship type? Database-Management-System | 0 | 0 | 1 |
| 41)What is Data Storage - Definition Language? Database Management System | 0 | 0 | 1 |
| 42)Why is group-clause used? Database-Management-System | 0 | 0 | 1 |
| 43)What is the difference between inner join and outer join?- database management system | 0 | 0 | 1 |
| 44)What is PL/SQL? Presidency University, Bangalore- Database Management System | 0 | 0 | 1 |
| 45)Compare Non-clustered and clustered index. Database-Management-System | 0 | 0 | 1 |
| 46)What is DML Compiler? Database-Management-System | 0 | 0 | 1 |
| 47)What is Query evaluation engine? Database Management System | 0 | 0 | 1 |
| 48)What are the operators in Relational Algebra - database management system | 0 | 0 | 1 |
| 49)What are the advantages of PL/SQL? - Database management system | 0 | 0 | 1 |
| 50)What is DML (Data Manipulation Language)? Database Management System | 0 | 0 | 1 |
| 51)What is Record-at-a-time? Database Management System | 0 | 0 | 1 |
| 52)Define “correlated subqueries”. Database-Management-System | 0 | 0 | 1 |
| 53)What does functionally dependent mean? - database management system | 0 | 0 | 1 |
| 54)What is Record-at-a-time? Database-Management-System | 0 | 0 | 1 |
| 55)Define a PL/SQL sample block. -Database management System | 0 | 0 | 1 |
| 56)Define Data Warehousing. Database-Management-System | 0 | 0 | 1 |
| 57)What is Set-at-a-time or Set-oriented? Database Management System | 0 | 0 | 1 |
| 58)What is Set-at-a-time or Set-oriented? Database-Management-System | 0 | 0 | 1 |
| 59)Define Join and enlist its types. Database-Management-System | 0 | 0 | 1 |
| 60)Describe the declaration section, execution section and exception section of a simple PL/SQL block. - Database management system | 0 | 0 | 1 |
| 61)What do you mean by Fill Factor concept with respect to indexes? Database-Management-System | 0 | 0 | 1 |
| 62)What is 4NF? Database-Management-System | 0 | 0 | 1 |
| 63)Define Fragmentation. Database-Management-System | 0 | 0 | 1 |
| 64)Write a PL/SQL program to find the simple interest. (take user inputs). - Database Management System | 0 | 0 | 1 |
| 65)What is 5NF? Database-Management-System | 0 | 0 | 1 |
| 66)What is Database partitioning? Database-Management-System | 0 | 0 | 1 |
| 67)What is Domain-Key Normal Form?Database-Management-System | 0 | 0 | 2 |
| 68)How do you communicate with an RDBMS? - database management system | 0 | 0 | 1 |
| 69) Explain the importance of partitioning. Database-Management-System | 0 | 0 | 1 |
| 70)What are the types of subqueries? Define each. - Database Management System | 0 | 0 | 2 |
| 71)What are partial, alternate, artificial, compound and natural key?Database-Management-System | 0 | 0 | 1 |
| 72)Name the three major set of files on disk that compose a database in Oracle. - database management system | 0 | 0 | 1 |
| 73)Enlist the various transaction phases. Database-Management-System | 0 | 0 | 1 |
| 74)What is system catalog or catalog relation? How is better known as?Database-Management-System | 0 | 0 | 1 |
| 75)What are stand-alone procedures? - database management system | 0 | 0 | 1 |
| 76)What do you mean by Entity type extension? Database-Management-System | 0 | 0 | 1 |
| 77)What is a Phantom Deadlock?Database-Management-System | 0 | 0 | 1 |
| 78)What are the fundamental operations of relational algebra. Define each. - Database management system | 0 | 0 | 1 |
| 79)What are cursors give different types of cursors? - database management system | 0 | 0 | 1 |
| 80)What do you mean by Query Evaluation Engine? Database-Management-System | 0 | 0 | 1 |
| 81)What is a checkpoint and When does it occur?Database-Management-System | 0 | 0 | 1 |
| 82)What is meant by query optimization? - database management system | 0 | 0 | 1 |
| 83)What do you mean by flat file database?Database-Management-System | 0 | 0 | 2 |
| 84)What is "transparent DBMS"?Database-Management-System | 0 | 0 | 2 |
| 85)What is set intersection operation in relational algebra? - Database management system | 0 | 0 | 1 |
| 86)What are the different phases of transaction?- database management system | 0 | 0 | 2 |
| 87)What do you mean by Correlated subquery?Database-Management-System | 0 | 0 | 1 |
| 88)What is Domain-Key Normal Form? - database management system | 0 | 0 | 2 |
| 89)What is natural join in relational algebra? - Database management system | 0 | 0 | 1 |
| 90)What are the primitive operations common to all record management systems?Database-Management-System | 0 | 0 | 1 |
| 91)How does Tuple-oriented relational calculus differ from domain-oriented relational calculus?- database management system | 0 | 0 | 1 |
| 92)Name the buffer in which all the commands that are typed in are stored?Database-Management-System | 0 | 0 | 1 |
| 93)What is assignment operation in relational algebra? - Database management system | 0 | 0 | 1 |
| 94)What are the unary operations in Relational Algebra?Database-Management-System | 0 | 0 | 1 |
| 95)Define the mathematical function sign(x) and sin(x) with an example. - Database management system | 0 | 0 | 1 |
| 96)Differentiate between the mathematical function Truncate(x) and Round(x) with an example. -Database management system | 0 | 0 | 1 |
| 97)A(n) _________ can be used to preserve the integrity of a document or a message.- database management system | 0 | 0 | 1 |
| 98)A hash function must meet ________ criteria. - database management system | 0 | 0 | 1 |
| 99) What is the main limitation of Hierarchical Databases?- database management system | 1 | 0 | 1 |
| 100)The property (or set of properties) that uniquely defines each row in a table is called the: - database management system | 0 | 0 | 1 |
| 101)The separation of the data definition from the program is known as:- database management system | 0 | 0 | 1 |
| 102)What is BCNF (Boyce -Codd Normal Form)? - Database management system | 0 | 0 | 2 |
| 103)What is 1NF and 2NF normal form? - Database management system | 0 | 0 | 3 |
| 104)What is 4NF and 5NF? - Database management system | 0 | 0 | 1 |
| 105)What is Domain-key normal form? - Database management system | 0 | 0 | 2 |
| 106)What is aggregation and generalization? - Database management system | 0 | 0 | 1 |
| 107)What is data Warehouse in database management system? | 0 | 0 | 1 |
| 108) Breifly discuss the advantages of using the DBMS Database Management Systems - 10CS54 VTU notes 8Marks (Dec/Jan 2014) | 0 | 0 | 2 |
| 109)What is Database Management System? | 1 | 0 | 1 |
| 110)What is database mysql and nosql? How is MySql different from no Sql. and which one is better to choose and why? | 1 | 0 | 3 |
| 111)Which language should be preferred for database connectivity? | 1 | 0 | 1 |
| 112)What is a Database? | 0 | 0 | 1 |
| 113)What is a Database | 0 | 0 | 1 |
| 114)What is RDBMS in Database and Management System ? Explain in Brief . | 1 | 0 | 2 |
| 115)SQL stands for in database management systems? | 1 | 0 | 1 |
| 116)what is database? | 3 | 0 | 2 |
| 117)What is SQL in Database management system? | 3 | 0 | 1 |
| 118)Explain with example about normalisation in database management system. | 4 | 0 | 1 |
| 119)what is database? | 2 | 0 | 0 |