P2Pprogrammer 2 programmer

Home > Download > SMU - Question Paper > MSc IT > MT0034

DBMS & SQL server


This is the collection of Sikkim Manipal University (SMU) question and answers for DBMS & SQL server. It will help to prepare your examination. All question paper are classified as per semester, subject code and question type of Part A, Part B and Part C with multiple choice options as same as actual examination. SMU question papers includes year 2024, 2023, 2022 Sem I, II, III, IV, V, VI examinations of all subjects.

SMU question test set of old, last and previous year are updated regularly and it is absolutely free to use. Question paper includes Visual basic 6, VB.Net, C#, ASP.Net, Web, Oracle, Database, SQL, Software Engineering, C, C++, OOPS, MBA, MCA, BSC IT I have requested you kindly send me the question paper of DBMS & SQL server, SMU - Master of Science in Information Technology.

Course Name        MSc IT (Master of Science in Information Technology)

Subject Code       MT0034 (DBMS & SQL server)

Get Questions        PART - A    PART - B    PART - C

Subject : DBMS & SQL server

     MT0034 : PART - C    


Q. 1Match the following with respect to cursors Set A i. Prior ii. First iii. Last iv. Absolute n v. Relative n Set B a. Returns last row within the result set b. Returns first row within the result set c. Returns nth row within the result set d. Returns prev
 A)i-a, ii-b, iii-c, iv-d, v-e
 B)i-d, ii-b, iii-a, iv-c, v-e
 C)i-b, ii-e, iii-c, iv-a, v-d
 D)i-c, ii-a, iii-d, iv-e, v-b
   
Q. 2SQL SERVER installation options are i. Licensing Mode ii. Network Support iii. Character Set iv. Sort Order v. Unicode Collation
 A)i, ii, iv only
 B)i, iii, v only
 C)ii, iii, iv only
 D)i, ii, iii, iv, v only
   
Q. 3In transaction model, ______ implements
start, commit, abort besides read & write,
provides resilience to failures
 A)Buffer Manager
 B)Recovery Manager
 C)Scheduler
 D)Transaction Manager
   
Q. 4To locate required block on a track is called
latency time. It is also known as ______
 A)Seek-time
 B)Rotational delay
 C)Rotational Time
 D)Transfer Rate
   
Q. 5Database server function includes:
1 Query optimization
2. Stored procedure
3. Transaction management
4. Compile queries
5. Backup & recovery
6. Data Management
 A)2, 3, 4, 5, 6
 B)1, 2,3,5,6
 C)1, 2,3,4,5
 D)1, 2, 3, 4, 5, 6
   
Click here to get DBMS & SQL server (MT0034) New Question


Home > Download > SMU - Question Paper > MSc IT > MT0034