@⇒ Oracle sql and pl sql ⇒ Computer Engineering Multiple Choice Questions / Objective type questions, MCQ's, with question and answers, download free PDF, short cut notes, rapid fire notes, best theory

Home⇒ Computer Engineering⇒ Oracle sql and pl sql

Note:- You can add tough questions into your favourite list for second revision.


Q1.	What type of join is needed when you wish to include rows that do not have matching values?
A.	Equi-join [Wrong Answer]
B.	Natural join [Wrong Answer]
C.	Outer join [Correct Answer]
D.	All of the above. [Wrong Answer]
View Answer 2 -1 Explanation:- Answer : C Discuss it below : Click here for more comments


Q2.	The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID
A.	Equi-join [Correct Answer]
B.	Natural join [Wrong Answer]
C.	Outer join [Wrong Answer]
D.	Cartesian join [Wrong Answer]
View Answer 2 -1 Explanation:- Answer : A Discuss it below : Click here for more comments


Q3.	A ________ is a stored program that is attached to a table or a view.
A.	pseudofile [Wrong Answer]
B.	embedded SELECT statement [Wrong Answer]
C.	trigger [Correct Answer]
D.	None of the above is correct. [Wrong Answer]
View Answer 2 -1 Explanation:- Answer : C Discuss it below : Click here for more comments


Q4.	When using the SQL INSERT statement:
A.	rows can be modified according to criteria only. [Wrong Answer]
B.	rows cannot be copied in mass from one table to another only. [Wrong Answer]
C.	rows can be inserted into a table only one at a time only. [Wrong Answer]
D.	rows can either be inserted into a table one at a time or in groups. [Correct Answer]
View Answer 1 -1 Explanation:- Answer : D Discuss it below : Click here for more comments


Q5.	What SQL structure is used to limit column values of a table?
A.	The LIMIT constraint [Wrong Answer]
B.	The CHECK constraint [Correct Answer]
C.	The VALUE constraint [Wrong Answer]
D.	None of the above is correct. [Wrong Answer]
View Answer 3 -1 Explanation:- Answer : B Discuss it below : Click here for more comments

1 2 ..Next.>> Page 1 of 22

Or