Home > Download > SMU - Question Paper
> BSc IT > BT0066
Database Management Systems
This is the collection of
Sikkim Manipal University (SMU) question and answers for Database Management Systems . 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 2025, 2024, 2023 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 Database Management Systems , SMU - Bachelor of Science in Information Technology.
Course Name
BSc IT (Bachelor of Science in Information Technology)
Subject Code BT0066 (Database Management Systems )
Get Questions
PART - A
PART - B
PART - C
Subject : Database Management Systems
BT0066 : PART - A
| Q. 1 | SQL server supports the_________ |
| | A) | SMP |
| B) | NNTP | | C) | HTTP | | D) | None of the above | | | | | Q. 2 | SQL *Plus is used by Database
administrator to ____ |
| | A) | Specify rights and privileges to users |
| B) | Query and retrieve data from the database | | C) | Generate reports | | D) | All the above | | | | | Q. 3 | To determine whether a constraint is
enabled or disabled on a table, execute the
____ system stored procedure |
| | A) | Help |
| B) | Sp_Help | | C) | SPHELP | | D) | None of these | | | | | Q. 4 | An extent is ____ contiguous pages or ____
KB |
| | A) | 8, 64 |
| B) | 10,640 | | C) | 4, 16 | | D) | 16, 960 | | | | | Q. 5 | In which of the following situations,
sequential file organization is not preferred? |
| | A) | When the file has low hit ratio but infrequent
updates |
| B) | For intermediate results of operations | | C) | For small files | | D) | None of these | | | | | Q. 6 | Relationship of department with employer is
an example for.________ relationship |
| | A) | one to one |
| B) | many to one | | C) | one to many | | D) | many to many | | | | | Q. 7 | __________ is a user interface for Microsoft
back office server management . |
| | A) | Microsoft Management console |
| B) | Microsoft distributed transaction coordinator | | C) | Microsoft system management server | | D) | Non of the above | | | | | Q. 8 | A global variable is shown with _______
symbol preceding is name |
| | A) | Q |
| B) | QQ | | C) | @ | | D) | @@ | | | | | Q. 9 | To eliminate duplicate rows _____ is used |
| | A) | NODUPLICATE |
| B) | ELIMINATE | | C) | DISTINCT | | D) | None of these | | | | | Q. 10 | Select the wrong statement |
| | A) | A primary key is a minimal superkey |
| B) | An entity may have many candidate keys | | C) | A weak entity is always related to one or
more strong entities | | D) |
All the above | | | |
Click here to get
Database Management Systems (BT0066 )
New Question
Home > Download > SMU - Question Paper
> BSc IT > BT0066