CMS专题
多选题Which three statements are true regarding the data types in Oracle Database 10g/11g?（）AOnly one LONG column can be used per tableBA TIMESTAMP data type column stores only time values with fractional secondsCThe BLOB data type column is used to store bi
题目
Only one LONG column can be used per table
A TIMESTAMP data type column stores only time values with fractional seconds
The BLOB data type column is used to store binary data in an operating system file
The minimum column width that can be specified for a VARCHAR2 data type column is one
The value for a CHAR data type column is blank-padded to the maximum defined column width
相似问题和答案
第1题：
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
正确答案:B,D
第2题：
Which three statements are true regarding subqueries?（）
- A、Subqueries can contain GROUP BY and ORDER BY clauses
- B、Main query and subquery can get data from different tables
- C、Main query and subquery must get data from the same tables
- D、Subqueries can contain ORDER BY but not the GROUP BY clause
- E、Only one column or expression can be compared between the main query and subquery
- F、 Multiple columns or expressions can be compared between the main query and subquery
正确答案:A,B,E
第3题：
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.
第4题：
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.
正确答案:D,E,F
第5题：
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.
正确答案:A,C
第6题：
Which statement is true regarding the INTERSECT operator?（）
- A、It ignores NULL values
- B、Reversing the order of the intersected tables alters the result
- C、The names of columns in all SELECT statements must be identical
- D、The number of columns and data types must be identical for all SELECT statements in the query
正确答案:D
第7题：
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
正确答案:B,D
第8题：
ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?（）
A. The data is decrypted during SORT and JOIN operations.
B. The data remains encrypted when it is read into memory.
C. The data remains encrypted when it is stored in the redo logs.
D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.
第9题：
Which statements are true regarding the Oracle Data Pump export and import operations（）
- A、You cannot export data from a remote database.
- B、You can rename tables during an import operation.
- C、You can overwrite existing dump files during an export operation.
- D、You can compress the data during export but not the metadata because it is not supported
正确答案:B,C
第10题：
You want to make use of the object features available in the database for the form module you are developing. Which three statements about object types are true? （）
- A、An object type is a user-defined composite data type.
- B、The attributes of an object type can be those of other object types.
- C、A PL/SQL table of records is an example of a nested object type.
- D、An object type must be declared as a type before the actual object itself can be declared.
正确答案:A,B,D