Uptu previous year questions paper of database management system

uptu previous year question papers for b,tech



Database Management System NCS 502

Time : 3 Hrs                                                                           MM:100

SECTION- A

1.      Attempt all parts. All parts carry equal marks.                                       ( 2 * 10 = 20)

(a)    What is DBMS?
(b)   What is data model? List some type of data model.
(c)    What is trigger?
(d)   What is normalization?
(e)    What are ACID properties?
(f)    What is concurrency?
(g)    What are different state of transaction?
(h)   Define Data Independency?
(i)     Define Integrity Constraint?
(j)     Define Serializability ?
                 SECTION - B

2.      Attempt any five Questions                                                                  ( 5  * 10 =50)

(a)    What is Deadlock? How to prevent Deadlock?
(b)   Explain three level schema of Data Base Management System.
(c)    What are different characteristics of DBMS?
(d)   What do you understand by ER Diagram? Make an ER Diagram for Library Management system.
(e)    What is schedule? Explain View Serializability.
(f)    Write the difference between DBMS and Traditional File System.
(g)    Explain Embedded SQL and Dynamic SQL in detail.

SECTION - C

3.      Attempt any Two questions from this section.                                     ( 2 * 15=30)

(a)    What do you understand by Relational Algebra? Explain different Relational Algebra Operations supported in SQL. Write SQL statement  for each operation.
(b)   What do you mean by Normalization ? Explain 1 NF, 2 NF, 3NF, BCNF with example.
(c)    Explain the following protocol for concurrency control
(1)   Lock Based Protocol.
(2)   Time stamp based protocol.


COMMENTS

BLOGGER
Name

addressing modes types,1,advance-java,2,aktu entrance exam,1,aktu exam schedule,1,ASP,1,bare machine,1,base register and limit register,1,C Programming,12,C Plus Plus,1,C Programming,5,C Programming Questions,1,C programming study material for gate exam,7,Cache Memory,1,CBNST Program,1,Childcare,1,CJ,1,Cloud Computing,1,CN,3,Computer Architecture,2,Computer architecture based questions for gate exam,11,Computer Network,8,Computer Network Study Material,2,Computer network study material for gate,1,Computer Networks,8,Computer networks GATE Questions,2,Computer Science Study Material for Gate,14,computer science study material for gate exam,28,conditional statements in c,1,contiguous memory allocation,2,Core Java,3,cyber crime report,1,Cyber crime status,1,cybercrime and security,1,cybercrime examples,1,Data Structure,2,Data Structure Questions,1,Data Transmission Architecture,1,Data Transmission in wsn,1,database normalization,1,DBMS,6,dbms question paper,1,DE,1,Digital Electronics,1,DS,4,Dynamic memory allocation in c,1,Electroencephalogram,1,file management in operating system notes,1,Gate 2017,3,Gate 2017 Admit card,1,gate cse study material,1,gate practice set,7,gate study material for computer science,12,Gate study material for computer science 2017,1,General,3,HCL Aptitude Test,1,HR Interview Questions,1,HTML,4,Important Date of Gate 2017 Exam,1,Information Security Policy,1,internal and external fragmentation,1,JDBC,2,JS,1,lagrange's interpolation formula,1,lagrange's interpolation formula examples,1,memory fragmentation,1,memory management,1,memory management questions and answer in os,1,Motivational,4,NCER,1,Numerical Techniques Lab,1,OOT,1,Operating System,10,Operating System Gate Questions,1,Operating System Objective Questions,4,Operating System Questions Bank,1,Operating system questions for gate,1,Operating System Study material,2,operating system study material for gate exam,13,Operating system tutorial,2,page swapping,1,paged memory allocation,1,paged memory allocation in operating system,1,Pointer in C,4,Process based question for gate,1,Regression testing,1,relocation in memory management,1,relocation registe,1,relocation register,1,resident monitor,1,resident monitor in operating system,1,routing table,1,Software Engineering,10,Software Engineering baes study material for gate,1,Software Quality Assurance,3,software verification methods,1,Stack,1,Structure in C,1,Study Material for gate Computer Science,7,swapping in memory management,1,swapping in operating system,1,TCS Code Vita,1,TCS Interview Questions,1,Technical Interview,1,Technical Questions from DBMS,1,Thrashing in Operating System,1,Threads concept in operating system,1,Tips to Learn Coding,1,Types of operating system,1,UML,1,Virtualization,1,What is process control block ?,1,what is software testing?,1,Wireless Sensor Network,3,worst fit algorithm for memory allocation,1,XML,2,
ltr
item
Computer Science Junction: Uptu previous year questions paper of database management system
Uptu previous year questions paper of database management system
uptu previous year question papers for b,tech
https://2.bp.blogspot.com/-QG2-uZ8eO1k/Wwp-1XZ94wI/AAAAAAAAAyE/MzoEFAP_EfYUzZsHBTFJkB6p-uMTHk5LgCLcBGAs/s1600/dbms.png
https://2.bp.blogspot.com/-QG2-uZ8eO1k/Wwp-1XZ94wI/AAAAAAAAAyE/MzoEFAP_EfYUzZsHBTFJkB6p-uMTHk5LgCLcBGAs/s72-c/dbms.png
Computer Science Junction
https://www.computersciencejunction.in/2017/06/aktu-previous-year-questions-paper-of-dbms.html
https://www.computersciencejunction.in/
https://www.computersciencejunction.in/
https://www.computersciencejunction.in/2017/06/aktu-previous-year-questions-paper-of-dbms.html
true
425357657003182083
UTF-8
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share. STEP 2: Click the link you shared to unlock Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy