Home / Engineering / Database Management System (DBMS) MCQs / Page 25

Database Management System (DBMS) MCQs | Page - 25

Dear candidates you will find MCQ questions of Database Management System (DBMS) here. Learn these questions and prepare yourself for coming examinations and interviews. You can check the right answer of any question by clicking on any option or by clicking view answer button.

M

Mr. Dubey • 51.17K Points
Coach 

Q. 241) The command to remove rows from a table ‘CUSTOMER’ is __________________

(A) DROP FROM CUSTOMER
(B) UPDATE FROM CUSTOMER
(C) REMOVE FROM CUSTOMER
(D) DELETE FROM CUSTOMER WHERE
View Answer Discuss Share

M

Mr. Dubey • 51.17K Points
Coach 

Q. 242) What type of join is needed when you wish to include rows that do not have matching values?

(A) Equi-join
(B) Natural join
(C) Outer join
(D) All of the Mentioned
View Answer Discuss Share

M

Mr. Dubey • 51.17K Points
Coach 

Q. 243) What type of join is needed when you wish to return rows that do have matching values?

(A) Equi-join
(B) Natural join
(C) Outer join
(D) All of the Mentioned
View Answer Discuss Share

M

Mr. Dubey • 51.17K Points
Coach 

Q. 244) Which of the following is one of the basic approaches for joining tables?

(A) Subqueries
(B) Union Join
(C) Natural join
(D) All of the Mentioned
View Answer Discuss Share

M

Mr. Dubey • 51.17K Points
Coach 

Q. 245) 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
(B) Natural join
(C) Outer join
(D) Cartesian join
View Answer Discuss Share

M

Mr. Dubey • 51.17K Points
Coach 

Q. 246) A UNION query is which of the following?

(A) Combines the output from no more than two queries and must include the same number of columns
(B) Combines the output from no more than two queries and does not include the same number of columns
(C) Combines the output from multiple queries and must include the same number of columns
(D) Combines the output from multiple queries and does not include the same number of columns
View Answer Discuss Share

M

Mr. Dubey • 51.17K Points
Coach 

Q. 247) Which of the following statements is true concerning subqueries?

(A) Involves the use of an inner and outer query
(B) Cannot return the same result as a query that is not a subquery
(C) Does not start with the word SELECT
(D) All of the mentioned
View Answer Discuss Share

M

Mr. Dubey • 51.17K Points
Coach 

Q. 248) Which of the following is a correlated subquery?

(A) Uses the result of an inner query to determine the processing of an outer query
(B) Uses the result of an outer query to determine the processing of an inner query
(C) Uses the result of an inner query to determine the processing of an inner query
(D) Uses the result of an outer query to determine the processing of an outer query
View Answer Discuss Share

M

Mr. Dubey • 51.17K Points
Coach 

Q. 249) 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?

(A) Equi-join
(B) Natural join
(C) Outer join
(D) Cartesian join
View Answer Discuss Share

M

Mr. Dubey • 51.17K Points
Coach 

Q. 250) Which is not a type of join in T-SQL?

(A) Equi-join
(B) Natural join
(C) Outer join
(D) Cartesian join
View Answer Discuss Share

Previous

Next

Explore Sets

Database Management System (DBMS) MCQs Set 1

Database Management System (DBMS) MCQs Set 2

Database Management System (DBMS) MCQs Set 3

Database Management System (DBMS) MCQs Set 4

Database Management System (DBMS) MCQs Set 5

Database Management System (DBMS) MCQs Set 6

Database Management System (DBMS) MCQs Set 7

Database Management System (DBMS) MCQs Set 8

Database Management System (DBMS) MCQs Set 9

Database Management System (DBMS) MCQs Set 10

Database Management System (DBMS) MCQs Set 11

Database Management System (DBMS) MCQs Set 12

Database Management System (DBMS) MCQs Set 13

Database Management System (DBMS) MCQs Set 14

Database Management System (DBMS) MCQs Set 15

Database Management System (DBMS) MCQs Set 16

Database Management System (DBMS) MCQs Set 17

Database Management System (DBMS) MCQs Set 18

Database Management System (DBMS) MCQs Set 19

Database Management System (DBMS) MCQs Set 20

Database Management System (DBMS) MCQs Set 21

Database Management System (DBMS) MCQs Set 22

Database Management System (DBMS) MCQs Set 23

Database Management System (DBMS) MCQs Set 24

Database Management System (DBMS) MCQs Set 25

Database Management System (DBMS) MCQs Set 26

Database Management System (DBMS) MCQs Set 27

Database Management System (DBMS) MCQs Set 28

Database Management System (DBMS) MCQs Set 29

Database Management System (DBMS) MCQs Set 30

Database Management System (DBMS) MCQs Set 31

Database Management System (DBMS) MCQs Set 32

Database Management System (DBMS) MCQs Set 33

Database Management System (DBMS) MCQs Set 34

Database Management System (DBMS) MCQs Set 35

Database Management System (DBMS) MCQs Set 36

Database Management System (DBMS) MCQs Set 37

Database Management System (DBMS) MCQs Set 38

Database Management System (DBMS) MCQs Set 39

Database Management System (DBMS) MCQs Set 40

Database Management System (DBMS) MCQs Set 41

Database Management System (DBMS) MCQs Set 42

Database Management System (DBMS) MCQs Set 43

Database Management System (DBMS) MCQs Set 44

Database Management System (DBMS) MCQs Set 45

Database Management System (DBMS) MCQs Set 46

Database Management System (DBMS) MCQs Set 47

Database Management System (DBMS) MCQs Set 48

Database Management System (DBMS) MCQs Set 49

Database Management System (DBMS) MCQs Set 50

Database Management System (DBMS) MCQs Set 51

Database Management System (DBMS) MCQs Set 52

Database Management System (DBMS) MCQs Set 53

Database Management System (DBMS) MCQs Set 54

Database Management System (DBMS) MCQs Set 55

Database Management System (DBMS) MCQs Set 56

Database Management System (DBMS) MCQs Set 57

Database Management System (DBMS) MCQs Set 58

Database Management System (DBMS) MCQs Set 59

Database Management System (DBMS) MCQs Set 60

Database Management System (DBMS) MCQs Set 61

Database Management System (DBMS) MCQs Set 62

Database Management System (DBMS) MCQs Set 63

Database Management System (DBMS) MCQs Set 64

Database Management System (DBMS) MCQs Set 65

Database Management System (DBMS) MCQs Set 66

Database Management System (DBMS) MCQs Set 67

Database Management System (DBMS) MCQs Set 68

Database Management System (DBMS) MCQs Set 69

Database Management System (DBMS) MCQs Set 70

Database Management System (DBMS) MCQs Set 71

Database Management System (DBMS) MCQs Set 72

Database Management System (DBMS) MCQs Set 73

Database Management System (DBMS) MCQs Set 74

Database Management System (DBMS) MCQs Set 75

Database Management System (DBMS) MCQs Set 76

Database Management System (DBMS) MCQs Set 77

Database Management System (DBMS) MCQs Set 78

Database Management System (DBMS) MCQs Set 79

Database Management System (DBMS) MCQs Set 80

Database Management System (DBMS) MCQs Set 81

Database Management System (DBMS) MCQs Set 82

Database Management System (DBMS) MCQs Set 83

Database Management System (DBMS) MCQs Set 84

Database Management System (DBMS) MCQs Set 85

Database Management System (DBMS) MCQs Set 86

Database Management System (DBMS) MCQs Set 87

Database Management System (DBMS) MCQs Set 88

Database Management System (DBMS) MCQs Set 89

Database Management System (DBMS) MCQs Set 90

Database Management System (DBMS) MCQs Set 91

Database Management System (DBMS) MCQs Set 92

Database Management System (DBMS) MCQs Set 93

Database Management System (DBMS) MCQs Set 94

Database Management System (DBMS) MCQs Set 95

Database Management System (DBMS) MCQs Set 96

Database Management System (DBMS) MCQs Set 97

Database Management System (DBMS) MCQs Set 98

Database Management System (DBMS) MCQs Set 99

Database Management System (DBMS) MCQs Set 100

Database Management System (DBMS) MCQs Set 101

Database Management System (DBMS) MCQs Set 102

Database Management System (DBMS) MCQs Set 103

Database Management System (DBMS) MCQs Set 104

Database Management System (DBMS) MCQs Set 105

Database Management System (DBMS) MCQs Set 106

Database Management System (DBMS) MCQs Set 107

Database Management System (DBMS) MCQs Set 108

Database Management System (DBMS) MCQs Set 109

Database Management System (DBMS) MCQs Set 110

Database Management System (DBMS) MCQs Set 111

Database Management System (DBMS) MCQs Set 112

Database Management System (DBMS) MCQs Set 113

Database Management System (DBMS) MCQs Set 114

Database Management System (DBMS) MCQs Set 115

Database Management System (DBMS) MCQs Set 116

Database Management System (DBMS) MCQs Set 117

Database Management System (DBMS) MCQs Set 118

Database Management System (DBMS) MCQs Set 119

Database Management System (DBMS) MCQs Set 120

Database Management System (DBMS) MCQs Set 121

Database Management System (DBMS) MCQs Set 122

Database Management System (DBMS) MCQs Set 123

Database Management System (DBMS) MCQs Set 124

Database Management System (DBMS) MCQs Set 125

Database Management System (DBMS) MCQs Set 126

Database Management System (DBMS) MCQs Set 127

Database Management System (DBMS) MCQs Set 128

Database Management System (DBMS) MCQs Set 129

Database Management System (DBMS) MCQs Set 130

Database Management System (DBMS) MCQs Set 131

Database Management System (DBMS) MCQs Set 132

Database Management System (DBMS) MCQs Set 133

Database Management System (DBMS) MCQs Set 134

Database Management System (DBMS) MCQs Set 135

Database Management System (DBMS) MCQs Set 136

Database Management System (DBMS) MCQs Set 137

Database Management System (DBMS) MCQs Set 138

Database Management System (DBMS) MCQs Set 139

Database Management System (DBMS) MCQs Set 140

Database Management System (DBMS) MCQs Set 141

Database Management System (DBMS) MCQs Set 142

Database Management System (DBMS) MCQs Set 143

Database Management System (DBMS) MCQs Set 144

Database Management System (DBMS) MCQs Set 145

Database Management System (DBMS) MCQs Set 146

Database Management System (DBMS) MCQs Set 147

Database Management System (DBMS) MCQs Set 148

Database Management System (DBMS) MCQs Set 149

Database Management System (DBMS) MCQs Set 150

Database Management System (DBMS) MCQs Set 151

Database Management System (DBMS) MCQs Set 152

Database Management System (DBMS) MCQs Set 153

Explore More Categories

Click on category to learn MCQs of that category.

Biotechnology Engineering

Chemical Engineering

Civil Engineering

Computer Science Engineering

Electrical Engineering

Electronics and Communication Engineering

Information Technology Engineering (IT)

Mechanical Engineering

Production Engineering

Download our easy to use, user friendly Android App from Play Store. And learn MCQs with one click.

Image

Menu

Donate Us

Quiz

Forum

Hindi MCQs

Topics

Test Series

Programming Questions

Advance Search

Shop

Duo Test

Login

Sign Up