多项选择题
Which two are character manipulation functions? ()
A.TRIM
B.REPLACE
C.TRUNC
D.TO_DATE
E.MOD
F.CASE
相关考题
-
多项选择题
Which two are attributes of iSQL*Plus? ()
A.iSQL*Plus commands cannot be abbreviated.
B.iSQL*Plus commands are accessed from a browser.
C.iSQL*Plus commands are used to manipulate data in tables.
D.iSQL*Plus commands manipulate table definitions in the database.
E.iSQL*Plus is the Oracle proprietary interface for executing SQL statements. -
单项选择题
In which case would you use a FULL OUTER JOIN?()
A.Both tables have NULL values.
B.You want all unmatched data from one table.
C.You want all matched data from both tables.
D.You want all unmatched data from both tables.
E.One of the tables has more data than the other.
F.You want all matched and unmatched data from only one table. -
多项选择题
Which three statements about subqueries are true? ()
A.Asinglerowsubquerycanretrieveonlyonecolumnandonerow.
B.Asinglerowsubquerycanretrieveonlyonerowbutmanycolumns.
C.Amultiplerowsubquerycanretrievemultiplerowsandmultiplecolumns.
D.Amultiplerowsubquerycanbecomparedusingthe";>;";operator.
E.AsinglerowsubquerycanusetheINoperator.
F.Amultiplerowsubquerycanusethe";=";operator.
