Skip to main content

DBMS Sessional-1 Paper


Roll No………………..                                                                                                                                               
VISION INSTITUTE OF TECHNOLOGY, ALIGARH
Session 2015-16         B .Tech. 3rd year (5th SEM) Internal Sessional-1   
Sub-DBMS(NCS-502)                                                 Branch-CS
 Max.Mark-50                                                    Max.Time-2hrs
                                 
                                 



                                           Section-A
QNo-1 Attempt any two questions from the following: (2x10=20)
a.       What is Database? What are the major advantages of database
And Explain the Database Management System.
b.      Explain Database System Vs File System and also write the
Application area of DBMS.
c.       What is ER Model? Draw the  ER Model of Library Management
System.
                                      Section-B
QNo-2 Attempt any three questions from the following:  (3X5=15)
a.       What is DBA? Explain the role of DBA in Database.
b.      What is Data Abstraction? Give details in brief.
c.       What are the Schema and Instances? Explain its Type.
d.      What is Data Independence? Explain its Type.                                                                   
                                     Section-C
QNo-3 Attempt any three questions from the following:  (3X5=15)
a.       What are the Database Languages? Explain in Brief.
b.      Write the Syntax of INSERT,UPDATE,SELECT,ALTER,DROP
Commands with examples.
c.          What is Query Processor in Database System?

d.         What are Attributes? Explain its type in brief.

Comments

Popular posts from this blog

New Upcoming Android watch

Upcoming Android Wear smartwatches Before splashing your cash on an Android Wear smartwatch already on sale, it's worth noting that as many as six more devices could land before Santa comes crashing down the chimney. Here's the hotly anticipated ones to look out for, arriving in the next couple of months... New Moto 360 The 2015 Moto 360 may still have that annoying flat-tyre at the bottom of its circular display but the rest of the setup is very promising indeed. It now comes in two sizes - 42mm and 46mm - in fact, it's three sizes if you count the different band sizes. On offer are two different sized displays: 1.37 or 1.56-inch. On the larger size the resolution is 360 x 360 - a 233ppi conut. The pixel density is greater on the smaller version, with the 1.37-inch display's resolution of 360 x 325 resulting in 263ppi. In terms of connectivity it's Bluetooth and Wi-Fi. You can pre-order now with prices ranging from $299. Take a look at our first loo...
What is "the cloud"? Moving to the cloud. Running in the cloud. Stored in the cloud. Accessed from the cloud: these days is seems like everything is happening “in the cloud”. But what exactly is this nebulous concept? The short answer is that it's somewhere at the other end of your internet connection – a place where you can access apps and services, and where your data can be stored securely. The cloud is a big deal for three reasons: It doesn't need any effort on your part to maintain or manage it. It's effectively infinite in size, so you don't need to worry about it running out of capacity. You can access cloud-based applications and services from anywhere – all you need is a device with an Internet connection. That's important because there's a shift going on from office-based work to working on the move. This shift is reflected in computer hardware sales: in 2015 about 270 million desktop and laptop computers will be ...