多选题Which statements are true regarding SecureFile LOBs?（）AThe amount of undo retained is user controlled.BSecureFile LOBs can be used only for nonpartitioned tables.CFragmentation is minimized by using variable-sized chunks dynamically.DSecureFile encryption allows for random reads and writes of the encrypted data.EIt automatically detects duplicate LOB data and conserves space by storing only one copy.
多选题
Which statements are true regarding SecureFile LOBs?（）
A
The amount of undo retained is user controlled.
B
SecureFile LOBs can be used only for nonpartitioned tables.
C
Fragmentation is minimized by using variable-sized chunks dynamically.
D
SecureFile encryption allows for random reads and writes of the encrypted data.
E
It automatically detects duplicate LOB data and conserves space by storing only one copy.
参考解析
解析：
暂无解析
相关考题：
Which two statements are true regarding the USING clause in table joins?（）A、It can be used to join a maximum of three tables B、It can be used to restrict the number of columns used in a NATURAL join C、It can be used to access data from tables through equijoins as well as nonequijoins D、It can be used to join tables that have columns with the same name and compatible data types
Which statements are true regarding a tablespace（）A、It can span multiple databases.B、It can consist of multiple data files.C、It can contain blocks of different sizes.D、It can contain segments of different sizes.E、It can contain a part of a nonpartitioned segment
Which statements are true regarding the Query Result Cache？（） A、 It can be set at the system， session， or table level.B、 It is used only across statements in the same session.C、 It can store the results from normal as well as flashback queries.D、 It can store the results of queries based on normal，temporary，and dictionary tables.
Which statements are true regarding SecureFile LOBs？（） A、 The amount of undo retained is user controlled.B、 SecureFile LOBs can be used only for nonpartitioned tables.C、 Fragmentation is minimized by using variable-sized chunks dynamically.D、 SecureFile encryption allows for random reads and writes of the encrypted data.E、 It automatically detects duplicate LOB data and conserves space by storing only one copy.
Which two data types can be converted to LOBs using an ALTER TABLE… MODIFY command？（）A、RAWB、LONGC、VARCHARD、LONG RAW
Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage？（）A、 It returns space usage of only BasicFile LOB chunks.B、 It returns space usage of only SecureFile LOB chunks.C、 It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.D、 It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.
Which two statements regarding a SQL profile are true？（）A、 It is built by Automatic Tuning Optimizer.B、 It cannot be stored persistently in the data dictionary.C、 It can be used by the query optimizer automatically.D、 It can be created manually by using the CREATE PROFILE command.
Which two are true regarding direct-path exports？（）A、Direct-path export is typically faster.B、Direct-path export can be invoked interactively.C、Direct-path export is character set independent.D、Direct-path export bypasses the SQL-command processing layer.E、Direct-path export can be used to export rows containing LOBs and BFILEs.
Which two statements are true regarding subqueries? （）A、A subquery can retrieve zero or more rows B、Only two subqueries can be placed atone level C、A subquery can be used only in SQL query statements D、A subquery can appear on either side of a comparison operator E、There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement
Which three statements are true regarding single-row functions？（）A、 They can accept only one argument.B、 They can be nested up to only two levels.C、 They can return multiple values of more than one data type.D、 They can be used in SELECT， WHERE， and ORDER BY clauses. E、 They can modify the data type of the argument that is referenced.F、 They can accept a column name， expression， variable name， or a user-supplied constant as arguments.
Which two statements are true regarding transactions in an Oracle database（）A、Multiple transactions can use the same undo segment.B、A transaction is assigned an undo segment when it is started.C、More than one transaction cannot share the same extent in the undo tablespace.D、The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.
Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs?（）A、It cannot be done in parallel.B、It can be done at the table level or partition level.C、It does not require additional storage because the operation is done online.D、Local and global indexes are maintained automatically during the operation.
Which two statements are true regarding the USING and ON clauses in table joins?（）A、Both USING and ON clauses can be used for equijoins and nonequijoins B、Amaximum of one pair of columns can be joined between two tables using the ON clause C、The ON clause can be used to join tables on columns that have different names but compatible data types D、The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause
多选题Your database in running in the ARCHIVELOG mode. You issue the following command to back up datafile 2 in your database. RMAN COPY DATAFILE 2 TO ’D:///ORACLE/ORA90/MYNEWDB/DA2.DBF’； Which two statements are true regarding the backup created using this command？（）AThe copy of the datafile created is stored in the RMAN repository.BThe copy of the datafile created can be viewed using the LIST BACKUP command.CThe copy of the datafile created using this COPY command can be placed only on the disk.DThe copy of the datafile created is similar to the backup of the file created using the BACKUP command.EThe copy of the datafile created can be used for recovering the database using the user-managed recovery method.
单选题Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?（）AIt returns space usage of only BasicFile LOB chunks.BIt returns space usage of only SecureFile LOB chunks.CIt returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.DIt returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.
多选题Which two statements are true regarding the USING clause in table joins?（）AIt can be used to join a maximum of three tablesBIt can be used to restrict the number of columns used in a NATURAL joinCIt can be used to access data from tables through equijoins as well as nonequijoinsDIt can be used to join tables that have columns with the same name and compatible data types
多选题Which two statements are true regarding subqueries? （）AA subquery can retrieve zero or more rowsBOnly two subqueries can be placed atone levelCA subquery can be used only in SQL query statementsDA subquery can appear on either side of a comparison operatorEThere is no limit on the number of subquery levels in the WHERE clause of a SELECT statement
多选题Which two statements are true regarding the USING and ON clauses in table joins?（）ABoth USING and ON clauses can be used for equijoins and nonequijoinsBAmaximum of one pair of columns can be joined between two tables using the ON clauseCThe ON clause can be used to join tables on columns that have different names but compatible data typesDThe WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause
多选题Which statements are true regarding a tablespace（）AIt can span multiple databases.BIt can consist of multiple data files.CIt can contain blocks of different sizes.DIt can contain segments of different sizes.EIt can contain a part of a nonpartitioned segment
多选题Which two are true regarding direct-path exports？（）ADirect-path export is typically faster.BDirect-path export can be invoked interactively.CDirect-path export is character set independent.DDirect-path export bypasses the SQL-command processing layer.EDirect-path export can be used to export rows containing LOBs and BFILEs.
多选题Which two statements are true regarding transactions in an Oracle database（）AMultiple transactions can use the same undo segment.BA transaction is assigned an undo segment when it is started.CMore than one transaction cannot share the same extent in the undo tablespace.DThe transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.
多选题Which two statements regarding a SQL profile are true？（）AIt is built by Automatic Tuning Optimizer.BIt cannot be stored persistently in the data dictionary.CIt can be used by the query optimizer automatically.DIt can be created manually by using the CREATE PROFILE command.
单选题Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs？（）A It cannot be done in parallel.B It can be done at the table level or partition level.C It does not require additional storage because the operation is done online.D Local and global indexes are maintained automatically during the operation.
多选题Which two statements are true regarding a tablespace（）AIt can span multiple databases.BIt can consist of multiple data files.CIt can contain blocks of different sizes.DIt can contain segments of different sizes.EIt can contain a part of a nonpartitioned segment.
多选题Which statements are true regarding the Query Result Cache？（）AIt can be set at the system， session， or table level.BIt is used only across statements in the same session.CIt can store the results from normal as well as flashback queries.DIt can store the results of queries based on normal，temporary，and dictionary tables.
多选题Which three statements are true regarding single-row functions？（）AThey can accept only one argument.BThey can be nested up to only two levels.CThey can return multiple values of more than one data type.DThey can be used in SELECT， WHERE， and ORDER BY clauses.EThey can modify the data type of the argument that is referenced.FThey can accept a column name， expression， variable name， or a user-supplied constant as arguments.
多选题Which two data types can be converted to LOBs using an ALTER TABLE… MODIFY command？（）ARAWBLONGCVARCHARDLONG RAW