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 - C    

Q. 1	WHICH OF THE FOLLOWING SYSTEM EXCEPTION CAN BE RAISED 1) DUP_VAL_ON_INDEX 2) LOGIN_DENIED 3) STORAGE_ERROR 4) VALUE_ERROR 5) TRANSACTION_BACKED_OUT 6) PROGRAM_ERROR 7) TIMEOUT_ON_RESOURCE
	A)	1,2,3,4,6,7
	B)	1,2,3,4,5,6
	C)	1,2,3,4,5,6,7
	D)	1,2,4,5,6,7
Q. 2	SQL PROVIDES STATEMENTS FOR A VARIETY OF TASKS INCLUDING 1) QUERYING DATA 2) INSERTING,UPDATING AND DELETING ROWS IN A TABLE 3) CREATING,REPLACING,ALTERING AND DROPPING OBJECTS 4) CONTROLLING ACCESS TO THE DATABASE AND ITS OBJECTS 5) G
	A)	1,2,3,4,5
	B)	1,2,3,4
	C)	1,2,3,5
	D)	1,2,4,5
Q. 3	WHICH OF THE FOLLOWING IS THE EXAMPLE OF NUMBER FUNCTIONS 1) ABS(DATA) 2) CEIL(DATA) 3) FLOOR(DATA) 4) TRUNC(DATA,N) 5) INITCAP(DATA) 6) LENGTH(DATA)
	A)	1,2,3,4
	B)	1,2,3,4,5
	C)	1,2,3,4,6
	D)	1,2,3
Q. 4	WHICH OF THE FOLLOWING IS TRUE FOR SUBQUERIES 1) THE NESTED QUERY MUST RETURN A SINGLE COLUMN 2) THE RESULT CAN ONLY CONTAIN COLUMNS FROM THE TABLES REFERENCED IN THE OUTERMOST QUERY 3) THE NESTED QUERY MUST RETURN A SINGLE ROW WHEN A STANDARD
	A)	2,3,4,5
	B)	1,2,3,4
	C)	2,3,5
	D)	1,2,3,4,5
Q. 5	VIEWS CANNOT BE UPDATED IF IT CONTAINS 1) JOINS 2) SET OPERATORS 3) GROUP FUNCTIONS 4) GROUP BY CLAUSE 5) DISTINCT
	A)	1,3,4,5
	B)	1,2,3,4,5
	C)	1,2,3,4
	D)	1,2,4,5

Click here to get Oracle & Distributed Databases (BC0050) New Question

---

Home > Download > SMU - Question Paper > BCA > BC0050

---