Home > Download > SMU - Question Paper
> BCA > BC0050
Oracle & Distributed Databases
This is the collection of
Sikkim Manipal University (SMU) question and answers for Oracle & Distributed Databases. 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 Oracle & Distributed Databases, SMU - Bachelor of Computer Application.
Course Name
BCA (Bachelor of Computer Application)
Subject Code BC0050 (Oracle & Distributed Databases)
Get Questions
PART - A
PART - B
PART - C
Subject : Oracle & Distributed Databases
BC0050 : PART - A
| Q. 1 | WHAT IS ACROYMN FOR SGA |
| | A) | SYSTEM GLOBAL AREA |
| B) | SYSTEM GRANT AREA | | C) | SERVER GLOBAL AREA | | D) | NONE OF THE ABOVE | | | | | Q. 2 | IN HOW MANY CATEGORIES DOES SQL COMMANDS FALLS |
| | A) | TWO |
| B) | THREE | | C) | FOUR | | D) | NONE OF THE ABOVE | | | | | Q. 3 | HOW MANY MODES DOES PARAMETER HAS |
| | A) | TWO |
| B) | THREE | | C) | FOUR | | D) | NONE OF THE ABOVE | | | | | Q. 4 | WHAT IS DEFAULT VALUE FOR SET LINESIZE COMMANDS IN REPORTS |
| | A) | 80 |
| B) | 14 | | C) | 40 | | D) | NONE OF THE ABOVE | | | | | Q. 5 | NO PRIMARY KEY VALUE CAN BE DELETED IF THERE ARE SOME FOREIGN KEY VALUES DEPENDENT ON IT IS DEFINED BY |
| | A) | DELETE RESTRICT REFERENTIAL INTEGRITY |
| B) | DELETE CASCADE REFERENTIAL INTEGRITY | | C) | BOTH A AND B | | D) | NONE OF THE ABOVE | | | | | Q. 6 | WHICH OF THE FOLLOWING IS INFORMATIVE MESSAGES THAT ARE APPLICATOIN SPECIFIC AND GENERATED BY CERTAIN TRANSACTIONS |
| | A) | ALERTS |
| B) | SECURITY | | C) | PROCEDURES | | D) | TRIGGERS | | | | | Q. 7 | ORACLE PROVIDES FULL SUPPORT FOR WHICH OF THE FOLLOWING IMPLEMENTATION |
| | A) | RELATIONAL |
| B) | OBJECT RELATIONAL | | C) | OBJECT ORIENTED | | D) | ALL OF THE ABOVE | | | | | Q. 8 | ORACLE PERFORMS RECORD LOCKING OR TABLE LOCKING WHEN TWO USERS ARE UPDATING THE SAME DATA |
| | A) | ALERTS |
| B) | SECURITY | | C) | PROCEDURES | | D) | TRIGGERS | | | | | Q. 9 | GROUPS OF PROCEDURES, FUNCTIONS, VARIABLES AND OTHER PL/SQL COMMANDS ARE CALLED |
| | A) | PACKAGE |
| B) | BLOCK | | C) | TRIGGERS | | D) | SECTION | | | | | Q. 10 | TO MODIFY THE STRUCTURE OF THE TABLE WHICH COMMAND IS USED |
| | A) | ALTER |
| B) | CREATE | | C) | UPDATE | | D) | INSERT | | | |
Click here to get
Oracle & Distributed Databases (BC0050)
New Question
Home > Download > SMU - Question Paper
> BCA > BC0050