ocp 19c考題,科目082考試題(26) - order by clause
26、Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)
A. Column positions must be used in the ORDER BY clause
B. Only column names from the first SELECT statement in the compound query are recognized
C. The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause
D. Each SELECT statement in the compound query must have its own ORDER BY clause
E. Each SELECT statement in the compound query can have its own ORDER BY clause
source : cuug
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/70010796/viewspace-2856176/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ocp 19c考題,科目082考試題(27) - order by clause
- ocp 19c考題,科目082考試題(34)
- ocp 19c考題,科目082考試題(33)
- ocp 19c考題,科目082考試題-bigfile
- ocp 19c考題,科目082考試題(32) -
- ocp 19c考題,科目082考試題(24)-about sequence
- ocp 19c考題,科目082考試題(22)- drop columns
- ocp 19c考題,科目082考試題(25)- instance situations
- oracle ocp 19c考題,科目082考試題-temporary undoOracle
- oracle ocp 19c考題,科目082考試題-Oracle NetOracle
- oracle ocp 19c考題,科目082考試題-INTERSECT operatorOracle
- ocp 19c考題,科目082考試題(29) - about profiles
- ocp 19c考題,科目082考試題(28) - oracle profilesOracle
- ocp 19c考題,科目082考試題(13)-variable prompt
- ocp 19c考題,科目082考試題(30) - default profile
- ocp 19c考題,科目082考試題(15)-move datafile to
- oracle ocp 19c考題7,科目082考試題-listener tnsnamesOracle
- oracle ocp 19c考題,科目082考試題(18)-unused columnOracle
- oracle ocp 19c考題,科目082考試題-date/time functionsOracleFunction
- ocp 19c考題,科目082考試題(31) - resource_limitMIT
- ocp 19c考題,科目082考試題(14)-starting with the letter D
- oracle ocp 19c考題,科目082考試題(20)-set unused columnOracle
- oracle ocp 19c考題,科目082考試題(19)-set unused columnOracle
- oracle ocp 19c考題,科目082考試題(17)-using an invisible columnOracle
- oracle ocp 19c考題10,科目082考試題 - shared server dispatchersOracleServer
- ocp 19c考題,科目082考試題(12)-about self-join
- ocp 19c考題,科目082考試題(16)-about dropping and unused columns
- oracle ocp 19c考題8,科目082考試題-logical and physical database structuresOracleDatabaseStruct
- oracle ocp 19c考題,科目082考試題(21)-read-only tableOracle
- oracle ocp 19c考題11,科目082考試題 - about SET VERIFY ON commandOracle
- ocp 19c考題,科目082考試題(23)- space management within blocks managed ASSMBloCSSM
- Oracle 19c OCP 1Z0-082認證考試題庫(7-12)Oracle
- Oracle 19c OCP 1Z0-082認證考試題庫(13-18)Oracle
- Oracle 19c OCP 1Z0-082認證考試題庫(19-23)Oracle
- Oracle 19c OCP 1Z0-082認證考試題庫(24-29)Oracle
- Oracle 19c OCP 1Z0-082認證考試題庫(30-35)Oracle
- Oracle 19c OCP 1Z0-082認證考試題庫(36-41)Oracle
- Oracle 19c OCP 1Z0-082認證考試題庫(51-60)Oracle