View note:ADVANCED-DBMS-10CS751



Questions of this subject!.

QuestionLikes!Dislikes!Answers!
1)How to backup database in MYSQL?

101
2)describe the architecture of dbms with a neat and clean diagram?

001
3)What is the differences between rdbms and database?

001
4)Which version of PHP introduced the instance of keyword?

101
5)How to connect to a database in node?

101
6)How to connect to a database in perl?

101
7)database management system

002
8)database management system

001
9)database management system

001
10)What are semistructured data models in the database systems?

001
11)Explain the concept of physical data independence and its importance in database systems.

001
12)Explain aggregate functions in database systems.

001
13)What is optimization of disk-block access

001
14)What is Relational Representation of System Metadata?

001
15)What is Buffer Manager?

001
16)Define-Amdahls-law--Derive-an-expression-for-CPU-clock-as-a-function-of-instruction-count-clocks-per-instruction-and-clock-cycle-time/1

001
17)What is Selection Indices?

001
18)What is External Sort-Merge?

001
19)what is Tuple Relational Calculus?

001
20)Explain set operators in dbms

001
21)What is RAID?

002
22)What are the various kinds of interactions catered by DBMS?

001
23)Who proposed the relational model?

002
24)What is a field in a database ?

102
25)What is a database transaction?

002
26)What is a Database Lock?

002
27)What are the various kinds of interactions catered by DBMS?

001
28)Segregate database technology’s development.

001
29)Define database model.

003
30)Enlist the various relationships of database.

002
31)Enlist the advantages of normalizing database.

001
32)How does Index hunting help in improving query performance?

001
33)Enlist the disadvantages of query.

001
34)Draw and explain model of transaction management in Distributed Databases.-Distributed databases-Mumbai University-Sem 6-May 2015

101
35)Draw and explain the layers of query processing in distributed databases.-Distributed databases-Mumbai University-Sem 6-May 2015

101
36)What do you mean by serializability in distributed databases?-Distributed databases-Mumbai University-Sem 6-Dec 2015

101
37)What are the issues of query processing in heterogeneous databases?-Distributed databases-Mumbai University-Sem 6-Dec 2015

101
38)What are the advantages and disadvantages of distributed DBMS?-Distributed databases-Sem 6-Mumbai University-May 2016

102
39)Consider a database that has the relation schemas EMP (EmpId, EmpName, DepId), and DEPT(DeptName, DeptId). Note that the DepId can be permitted to be NULL in the relation EMP. Consider the following queries on the database expressed in tuple relational calculus. -gate computer science 2017

001
40)Discuss Various types of Inner Join Operations? : Database Management Systems - 10CS54 VTU notes 8 Marks (Jun / July2014) (5 marks Dec 14/Jan 15)(10 Marks Jan 2016)

002
41)I have a first interview and the job title is Developer (SSRS SQL SSRS) What type of questions in SQL can they ask me over the phone?

001