[이기적] SQLD 실전 모의고사 150제 - 2과목

[white-gyu]

[이기적] SQLD 실전 모의고사 150제 - 2과목
p255 ~ p309
no.31 ~ no.150

[white-gyu]

31. 1

32. 1

33. 3

34. 2

35. 2

36. 1

37. 3

38. 1

39. 1

40. 1

41. 2

42. 2

43. 1

44. 1

45. 2

46. 1

47. 3

48. 4

• sql subquery 종류 및 정리

49. 3

50. 3

51. 2
    

52. 2

53. 4

54. 3
    

55. 2

56. 1

57. 4

58. 2

59. 3

60. grant

61. 1

62. 4

63. 4

64. 4

65. where, start with, connect by prior

66. 1

67. 3

68. 4

69. 1

70. 2

71. 3

72. 3

73. 1

74. 2

75. 2

76. 1

77. 1

78. 3

79. 2

80. 2

81. 3

82. 4

83. 4

84. 3

85. 1
    

86. 3

• nested loop, sort merge, hash join 동작 원리

87. 3

88. 4

89. 1

90. 2

91. 1

92. 3

93. 4

94. 1

95. 2

96. 4
    

97. 3

98. 1

merge into emp e
using emp_copy on (e.empno = c.empno)
when matched then update
set e.ename = c.ename, e.de[tno = c.deptno, e.sal = c.sal
when not matched then insert (empno, ename, deptno, sal) values
(c.empno, c.ename, c.deptno, c.sal);

100. 3

101. 4

102. 4
     

103. 3

104. 3

105. 2

106. 3

107. 4
     

108. 3

109. 3

110. 3

111. 4

112. 1

113. 3

114. 1

115. 3

116. 3

117. 1

118. 4

119. 1

select empno, ename, deptno
from emp
where deptno = 30 and exists(
select 1
from emp
where empno = 7698);

121. right outer join

select sum(a), sum(b) from (
select 1, 0 from dual
union all
select 0, 1 from dual
) a;

create index emp_idx on emp(sal desc);

select *
from (
select *
from emp)
where rownum <= 5;

125. 4

126. 2

127. 4

128. 3

129. 1

130. 2

131. 3

132. 4

133. 4

134. 4

135. 3

136. p.사원번호 is null

137. 3

138. 2

139. 3

140. 2

141. 3

select case empno when 1 then 'A' else 'B' end from emp;

143. 3

144. 4

145. 3

146. 4

147. where, start with, connect by prior

148. 3

149. 1

150. 4