Test Bank: Oracle 12c: SQL (3rd Edition) – Joan Casteel | Basic SQL SELECT Statements & Querying Fundamentals

012345789  19255452




!"#$!%&'(!)*+!),+,-!)


!
.
&
-/
!0!12&

34567899:;<=>?@9<A9<B8=:?><CD9B8=A<=98E9<C9:9?@B>F:G9E:?:H:D89?:HG89I?>G>J89?789KLMLN69D?:?898C?4
:46=I8 
H4O:GD8 
PQRSTUVW 6=I8
XYZQ[RVW 3
UT\TUTQ]TRVW^_

`45a78C9:9ID8=9:DbD9?789E:?:H:D89:9cI8D?><Cd9?789ID8=9>D9>DDI>Ce9:9cI8=@4
:46=I8 
H4O:GD8 
PQRSTUVW 6=I8
XYZQ[RVW 3
UT\TUTQ]TRVW^3

^45L:F79D8F?><C9<A9:9KfM9F<99:CE9?7:?9H8e>CD9g>?79:9b8@g<=E9>D9bC<gC9:D9:9D?:?898C?4
:46=I8 
H4O:GD8 
PQRSTUVW O:GD8
XYZQ[RVW 3
UT\TUTQ]TRVW^3

h45i9FG:ID89>D9:9D8F?><C9g>?7>C9:9KfM9D?:?898C?9?7:?9H8e>CD9g>?79:9b8@g<=E4
:46=I8 
H4O:GD8 
PQRSTUVW 6=I8
XYZQ[RVW 3
UT\TUTQ]TRVW^3

j45KfMklGID9>D9:C9m=:FG89?<<G9ID8E9?<98C?8=9:CE98E>?9KfM9D?:?898C?D4
:46=I8 
H4O:GD8 
PQRSTUVW 6=I8
XYZQ[RVW 3
UT\TUTQ]TRVW`n

o45KfMklGID9F:C9<CG@9H89:FF8DD8E9p>:9:C9>C?8=C8?9>C?8=A:F84
:46=I8 
H4O:GD8 
PQRSTUVW O:GD8
XYZQ[RVW 3
UT\TUTQ]TRVW`n

n45i9DF=>B?9A>G89F<C?:>C>Ce9KfM9D?:?898C?D9F:C9H898q8FI?8E9A=<99KfMklGID4
rstuv:u4
5s6wx=yIs8vzt{tuwx|s}~{tuwx€‚szsƒwx„wxrutszw †‡ˆ‰5Š‹5


,/ 0123456892 0424554
-
01/23456/ /
789:;<=> ?@A6/
BCD8E9=> F/
<;G;<;8H;9=>IJ/
-
K1-?L6/MNOPQRSTO/MUVMM3WX/MY5/MA56X/MZV/M[Y6\/MX3Z3/MYW/M3/MZ30461/
31/?@A6/ /
01/23456/ /
789:;<=> 23456/
BCD8E9=> F/
<;G;<;8H;9=>I]/
^_/
/
]1-̀/MaA6@b/MY5/M3UUVMc4Y5L6X/M0b/MY55AYWd/M3/MPOeOQ?/M5Z3Z6M6WZ1/
31/?@A6/ /
01/23456/ /
789:;<=> ?@A6/
BCD8E9=> F/
<;G;<;8H;9=>^F/
/
F_1-?L6/M35Z6@Y5f/M5bM0V4/Mghi/MU3W/M06/MA56X/MYW/M3/MPOeOQ?/M5Z3Z6M6WZ/MZV/MYWXYU3Z6/MZL3Z/M344/M@V\5/MYW/MZL6/MZ3046/
M5LVA4X/M06/MXY5c43b6X/MYW/MZL6/M@65A4Z51/
31/?@A6/ /
01/23456/ /
789:;<=> 23456/
BCD8E9=> F/
<;G;<;8H;9=>^F/
^I/
/
FF1-̀/MA56@/MU3W/MYWXYU3Z6/MZL3Z/M344/MUV4AMW5/MVj/M3/MZ3046/M5LVA4X/M06/MXY5c43b6X/MYW/MZL6/M@65A4Z5/MVj/M3/MPOeOQ?/
M5Z3Z6M6WZ/M0b/MYWU4AXYWd/M3W/M35Z6@Y5f/Mghi/MYW/MZL6/MPOeOQ?/MU43A561/
31/?@A6/ /
01/23456/ /
789:;<=> ?@A6/
BCD8E9=> F/
<;G;<;8H;9=>^F/
^I/
/
FI1-QV4AMW/ML63XYWd5/MM3b/M06/MZ@AWU3Z6X/MYW/MZL6/M@65A4Z5/MVj/M3/MPOeOQ?/M5Z3Z6M6WZ1/
31/?@A6/ /
01/23456/ /
789:;<=> ?@A6/
BCD8E9=> F/
<;G;<;8H;9=>^I/
/
F^1-?L6/MPOeOQ?/MU43A56/MVj/MZL6/MPOeOQ?/M5Z3Z6M6WZ/MY5/MA56X/MZV/MYX6WZYjb/M\LYUL/M@V\5/M3@6/MZV/M06/M@6Z@Y6[6X/Mj@VM/M3/
/ 


!
"#$%
&'($
$ )*+,-.-

,/ 0123456892 0424554
0123456537/




/ 


!
"#$%
&'($
$ )*+,-.-

, / 0123456892 0424554
012345/
15/6784/ /
25/913:4/ /
;<=>?@AB 913:4/
CDE<F=AB G/
@?H?@?<I?=ABJG/
/
GK5-LMNN:OPQ/R:S4TOUOT/RTN38RP:/R0N/R24/RVO:S31W4V/R2W/R1/RXYZYL6/R:0104R4P0/RO:/R[PN\P/R1:/R:434T0ONP5/
15/6784/ /
25/913:4/ /
;<=>?@AB 913:4/
CDE<F=AB G/
@?H?@?<I?=ABJJ/
/
G]5-LMNN:OPQ/R:S4TOUOT/RTN38RP:/R0N/R24/RVO:S31W4V/R2W/R1/RXYZYL6/R:0104R4P0/RO:/R[PN\P/R1:/RS7N^4T0ONP5/
15/6784/ /
25/913:4/ /
;<=>?@AB 6784/
CDE<F=AB G/
@?H?@?<I?=ABJJ/
/
G_5-̀U/R1/RTN38RP/RP1R4/RO:/R4P0474V/ROP/R3N\47/RT1:4/ROP/R0M4/RXYZYL6/R:0104R4P0a/R0M4/RV101/RUN7/R0M4/RTN38RP/R\O33/R24/
RVO:S31W4V/ROP/R3N\47/RT1:4/ROP/R0M4/R74:830:5/
15/6784/ /
25/913:4/ /
;<=>?@AB 913:4/
CDE<F=AB G/
@?H?@?<I?=ABJK/
/
Gb5-̀U/RR830OS34/RTN38RP/RP1R4:/R174/R3O:04V/ROP/R0M4/RXYZYL6/RT318:4/RNU/R1/RXYZYL6/R:0104R4P0a/R0M4/RTN38RP:/RR8:0/R24/
R:4S17104V/R2W/R1/RTNRR1/Rcad5/
15/6784/ /
25/913:4/ /
;<=>?@AB 6784/
CDE<F=AB G/
@?H?@?<I?=ABJK/
J]/
/
Ge5-6M4/RTN38RP:/RVO:S31W4V/ROP/R0M4/R74:830:/RNU/R1/RXYZYL6/R:0104R4P0/R\O33/R24/ROP/R0M4/R:1R4/RN7V47/R1:/R0M4W/
R174/R:0N74V/ROP/R0M4/RV10121:4/R012345/
15/6784/ /
25/913:4/ /
;<=>?@AB 913:4/
CDE<F=AB G/
@?H?@?<I?=ABJ]/
/ 


!
"#$%
&'($
$ )*+,-.-