网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
Examine the list of variables and their data types： AME DATA Type TS， TS1 TIMESTAMP TSZ TIMESTAMP WITH TIME ZONE TLZ TIMESTAMP WITH LOCAL TIME ZONE IYM INTERVAL YEAR TO MONTH IDS， IDSI INTERVAL YEAR To SECOND Which three expressions using the new data and time data types are valid？（）
A
IDS* 2
B
TS + IYM
C
TS –TSI
D
IDS – TS
E
IDS + IYM
参考答案
参考解析
解析：
暂无解析
更多 “多选题Examine the list of variables and their data types： AME DATA Type TS， TS1 TIMESTAMP TSZ TIMESTAMP WITH TIME ZONE TLZ TIMESTAMP WITH LOCAL TIME ZONE IYM INTERVAL YEAR TO MONTH IDS， IDSI INTERVAL YEAR To SECOND Which three expressions using the new data and time data types are valid？（）AIDS* 2BTS + IYMCTS –TSIDIDS – TSEIDS + IYM” 相关考题
考题
Which of the following datatypes store time－zone information in the database?()
A. TIMESTAMPB. DATEC. TIMESTAMP WITH TIME ZONED. TIMESTAMP WITH LOCAL TIME ZONEE. DATETIME
考题
Which three are DATETIME data types that can be used when specifying column definitions? ()
A. TIMESTAMPB. INTERVAL MONTH TO DAYC. INTERVAL DAY TO SECONDD. INTERVAL YEAR TO MONTHE. TIMESTAMP WITH DATABASE TIMEZONE
考题
Which of the following are all valid DB2 data types?()
A.LONG VARCHAR, SMALLINT, NUMBER, BLOBB.DECIMAL, DATE, DBCLOB, INTERVALC.NUMERIC, TIMESTAMP, BYTE, FLOATD.NUM, TIME, XML, DOUBLE
考题
Which of the following are all valid DB2 data types?（）A、LONG VARCHAR, SMALLINT, NUMBER, BLOBB、DECIMAL, DATE, DBCLOB, INTERVALC、NUMERIC, TIMESTAMP, BYTE, FLOATD、NUM, TIME, XML, DOUBLE
考题
Which of the following datatypes store time-zone information in the database?（）A、TIMESTAMPB、DATEC、TIMESTAMP WITH TIME ZONED、TIMESTAMP WITH LOCAL TIME ZONEE、DATETIME
考题
You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition: Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?（）A、The valid time columns employee_time_start and employee_time_end are automatically created.B、The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.C、The valid time columns are not populated by the Oracle Server automatically.D、The valid time columns are visible by default when the table is described.E、Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulatio
考题
Which three are DATETIME data types that can be used when specifying column definitions?（）A、TIMESTAMPB、INTERVAL MONTH TO DAYC、INTERVAL DAY TO SECONDD、INTERVAL YEAR TO MONTHE、TIMESTAMP WITH DATABASE TIMEZONE
考题
These are the details about V$FLASHBACK_DATABASE_STAT： SQL DESC V$FLASHBACK_DATABASE_STAT Name Null？ Type ------------- -------- -------------- BEGIN_TIME DATE END_TIME DATE FLASHBACK_DATA NUMBER DB_DATA NUMBER REDO_DATA NUMBER ESTIMATED_FLASHBACK_SIZE NUMBER Which two statements regarding the V$FLASHBACK_DATABASE_STAT view are true？ （）A、BEGIN_TIME is the time at which Flashback logging is enabled.B、END_TIME is the time at which the query is executed on the view.C、REDO_DATA is the number of bytes of redo data written during the interval.D、This view contains information about flashback data pertaining to the last 24 hours.E、FLASHBACK_DATA is the amount of flashback data generated since the database was opened.
考题
Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement： SQL ALTER DATABASE SET TIME_ZONE =’Europe/London’； What will be the result of issuing the above statement？（）A、 The statement will be executed successfully， and a new time zone will be set for the database.B、 The statement will be executed successfully， but a new time zone will not be set for the database.C、 The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.D、 The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.
考题
You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY-MM-DD. The default format of which two data types would be affected by this setting？ （）A、 DATEB、 TIMESTAMPC、 INTERVAL YEAR TO MONTHD、 INTERVAL DAY TO SECONDE、 TIMESTAMP WITH LOCAL TIME ZONE
考题
Which three statements are true regarding the data types in Oracle Database 10g/11g?（）A、Only one LONG column can be used per table B、A TIMESTAMP data type column stores only time values with fractional seconds C、The BLOB data type column is used to store binary data in an operating system file D、The minimum column width that can be specified for a VARCHAR2 data type column is one E、The value for a CHAR data type column is blank-padded to the maximum defined column width
考题
You created the ORDERS table in your database by using the following code： SQL CREATE TABLE ORDERS （ORDER_DATE TIMESTAMP（0） WITH TIME ZONE）； Then， you inserted data in the ORDERS table and saved it by issuing the following statements：SQL INSERT INTO ORDERS VALUES（’18-AUG-00 10：26：44 PM America/New_York’）； SQL INSERT INTO ORDERS VALUES（’23-AUG-02 12：46：34 PM America/New_York’）； SQL COMMIT； Next， you issued the following statement to change the time zone for the database： SQL ALTER DATABASE SET TIME_ZONE=’Europe/London’； What will be the result of executing the above statement？（） A、 The statement will fail.B、 The statement will be executed successfully， and the new time zone will be set for the database.C、 The statement will be executed successfully， but the new time zone will be set for the current session.D、The statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.
考题
You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY/x7fMM/x7fDD. The default format of which two data types would be affected by this setting？（）A、DATEB、TIMESTAMPC、INTERVAL YEAR TO MONTHD、INTERVAL DAY TO SECONDE、TIMESTAMP WITH LOCAL TIME ZONE
考题
Examine the list of variables and their data types： AME DATA Type TS， TS1 TIMESTAMP TSZ TIMESTAMP WITH TIME ZONE TLZ TIMESTAMP WITH LOCAL TIME ZONE IYM INTERVAL YEAR TO MONTH IDS， IDSI INTERVAL YEAR To SECOND Which three expressions using the new data and time data types are valid？（）A、IDS* 2B、TS + IYMC、TS –TSID、IDS – TSE、IDS + IYM
考题
You issued the following command at the UNIX environment： % setenv ORA_SDTZ ’OZ_TZ’ What will be the impact of issuing the above command？（） A、 The operating system local time zone will be set for a user session using the operating system environment variable.B、 The database local time zone will be set for a user session using the operating system environment variable.C、 The operating system local time zone will be set for the database using the operating system environmentD、 The database local time zone will be set for the database using the operating system environment variable.
考题
You need to ensure the Order Control team is able to track the number of orders that reach the production department. What should you do?（）A、Create a new Time dimension based on the Holiday table. Use derived columns for the month and the year.B、Create a Server Time dimension. Within this dimension， enable the time periods year， month， and date. Select the Additional Manufacturing calendar option.C、Create a new Time dimension based on the date values within the ProductOrderStatus table. Flag those days on which no orders were received as Holiday.D、Create a new Time dimension based on a data source view named query. Derive the data for this data source view from unique dates within the ProductOrderStatus table. Use a subquery to identify the holidays and derived columns for the month and the year.
考题
多选题You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY/x7fMM/x7fDD. The default format of which two data types would be affected by this setting？（）ADATEBTIMESTAMPCINTERVAL YEAR TO MONTHDINTERVAL DAY TO SECONDETIMESTAMP WITH LOCAL TIME ZONE
考题
多选题Which three possible values can be set for the TIME_ZONE session parameter by using the ALTER SESSION command？ （）AosBlocalC-8：00Ddbtimezone LiEAustralia
考题
多选题Which three are DATETIME data types that can be used when specifying column definitions? （）ATIMESTAMPBINTERVAL MONTH TO DAYCINTERVAL DAY TO SECONDDINTERVAL YEAR TO MONTHETIMESTAMP WITH DATABASE TIMEZONE
考题
多选题These are the details about V$FLASHBACK_DATABASE_STAT： SQL DESC V$FLASHBACK_DATABASE_STAT Name Null？ Type ------------- -------- -------------- BEGIN_TIME DATE END_TIME DATE FLASHBACK_DATA NUMBER DB_DATA NUMBER REDO_DATA NUMBER ESTIMATED_FLASHBACK_SIZE NUMBER Which two statements regarding the V$FLASHBACK_DATABASE_STAT view are true？ （）ABEGIN_TIME is the time at which Flashback logging is enabled.BEND_TIME is the time at which the query is executed on the view.CREDO_DATA is the number of bytes of redo data written during the interval.DThis view contains information about flashback data pertaining to the last 24 hours.EFLASHBACK_DATA is the amount of flashback data generated since the database was opened.
考题
多选题You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY-MM-DD. The default format of which two data types would be affected by this setting？ （）ADATEBTIMESTAMPCINTERVAL YEAR TO MONTHDINTERVAL DAY TO SECONDETIMESTAMP WITH LOCAL TIME ZONE
考题
单选题Which of the following datatypes store time-zone information in the database?（）A
TIMESTAMPB
DATEC
TIMESTAMP WITH TIME ZONED
TIMESTAMP WITH LOCAL TIME ZONEE
DATETIME
考题
多选题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 binary data in an operating system fileDThe minimum column width that can be specified for a VARCHAR2 data type column is oneEThe value for a CHAR data type column is blank-padded to the maximum defined column width
考题
单选题You issued the following command at the UNIX environment： % setenv ORA_SDTZ ’OZ_TZ’ What will be the impact of issuing the above command？（）A
The operating system local time zone will be set for a user session using the operating system environment variable.B
The database local time zone will be set for a user session using the operating system environment variable.C
The operating system local time zone will be set for the database using the operating system environmentD
The database local time zone will be set for the database using the operating system environment variable.
考题
多选题You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition: Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?（）AThe valid time columns employee_time_start and employee_time_end are automatically created.BThe same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.CThe valid time columns are not populated by the Oracle Server automatically.DThe valid time columns are visible by default when the table is described.ESetting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulatio
考题
多选题The current time zone for one of the user sessions is set to the database local time zone. For one application， the user session requires the time zone to be set to the local operating system time zone without affecting other user sessions. Which two solutions could the user implement to achieve this objective？ （）Ause the ALTER SYSTEM command to change the time zoneBuse the ALTER SESSION command to change the time zoneCuse the ALTER DATABASE command to change the time zoneDset the value for the operating system variable ORA_SDTZ on the client machineEset the value for the operating system variable ORA_SDTZ on the database server machine
考题
单选题Which of the following datatypes store time-zone information in the database？（）A
TIMESTAMPB
DATEC
TIMESTAMP WITH TIME ZONED
TIMESTAMP WITH LOCAL TIME ZONEE
DATETIME
热门标签
最新试卷