oracle-ocp-051标准答案解析.docxVIP

?Orａcle　OCP 1１G 0５1答案解析 1． Vｉｅw tｈe Exhｉｂit　ａnd ｅxaｍine　the sｔrｕcture ｏf the SALＥS, ＣＵSＴOMＥＲS, ＰROＤUCTＳ, ａnd ＴIMEＳ ｔａbles. Tｈe PRＯD_ＩD column is ｔｈe　foreｉgn　ｋey　in the SＡLES taｂle,　whicｈ ｒeｆｅｒencｅｓ thｅ PＲOＤUCTS　table. Siｍilaｒly，　the CUST_ID and TIME_IＤ ｃolumｎs are alｓo forｅiｇn ｋeys　iｎ　ｔhe SAＬES ｔabｌe refereｎcing　ｔhe ＣＵSTOMERS and TIMES tables, reｓpectｉvely. Ｅvaluatｅ　ｔhe ｆoｌloｗｉｎｇ CRＥＡTE TＡBＬＥ coｍｍａnd： CRＥＡTE ＴAＢＬE neｗ_sales(prｏｄ＿id,　ｃusｔ＿id, oｒder_dａｔｅ DＥFＡULT ＳYSDＡＴE） AS ＳＥLECＴ proｄ_iｄ, ｃｕst_ｉd， time_ｉｄ FROM sａｌes; Whicｈ　stａｔｅｍent　is　ｔrue regaｒdｉnｇ　tｈｅ ａｂovｅ cｏmmand?? ? Ａ.　Thｅ ＮEW_ＳALES tablｅ