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 three are DATETIME data types that can be used when specifying column definitions?()

  • A、TIMESTAMP
  • B、INTERVAL MONTH TO DAY
  • C、INTERVAL DAY TO SECOND
  • D、INTERVAL YEAR TO MONTH
  • E、TIMESTAMP WITH DATABASE TIMEZONE

相关考题:

若想使时钟控件每隔0.25秒触发一次Timer()事件,则可将Interval属性值设为( )。A.Interval=0.25B.Interval=25C.Interval=250D.Interval=2500

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 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

When the Cisco IOS OSPF command ip ospf dead-interval minimal hello-multiplier 5 is configured, which two statements are true? ()A、OSPF hello interval is 5 secondsB、OSPF hello interval is 1 secondC、OSPF dead interval is 1 secondD、OSPF dead interval is 5 secondsE、OSPF dead interval is 20 secondsF、OSPF hello interval is 0.2 second

When monitoring a system using /usr/bin/vmstat with an interval, the metrics under page pi and page po represent which of the following phrases?()A、 The pages to and from paging space per secondB、 The page intervals and page operations per secondC、 The page interrupts and page operations per secondD、 The page segments transferred between pi and po devices per second

When monitoring a system using vmstat with an interval, the metrics under page po represent which of the following phrases?() A、 The number pages over the limitB、 The pages to paging space per secondC、 The number of page operations per secondD、 The number of processes waiting for page out

Which of the following commands should be used to monitor the number of threads on the scheduler’s run queue for any given interval?()A、 sarB、 pstatC、 iostatD、 filemon

Which of the following commands should be used to monitor the average number of threads in the scheduler’s run queue for any given interval?()A、 tprofB、 iostatC、 vmstatD、 filemon

Which three tasks can be performed using regular expression support in Oracle Database 10g?()A、 it can be used to concatenate two strings.B、 it can be used to find out the total length of the string.C、 it can be used for string manipulation and searching operations.D、 it can be used to format the output for a column or expression having string data.E、 it can be used to find and replace operations for a column or expression having string data.

Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package?()A、It can be used to allow the access privilege settings for users but not roles.B、It can be used to allow the access privilege settings for users as well as roles.C、It can be used to control the time interval for which the access privilege is available to a user.D、It can be used to selectively restrict the access for each user in a database to different host computers.E、It can be used to selectively restrict a user's access to different applications in a specific host computer.

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 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 are attempting to increase the checkpoint interval on your database. Each of the following choices will affect the duration and/or frequency of checkpoints, except one.  Which is it?()A、Size of redo logs B、Number of datafiles C、LOG_CHECKPOINT_INTERVAL D、LOG_CHECKPOINT_TIMEOUT

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

单选题Which of the following commands should be used to monitor the number of threads on the scheduler’s run queue for any given interval?()A sarB pstatC iostatD filemon

多选题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

单选题The radiotelegraph alarm signal is().ASOS sent three timesBten one-second dashes with a four-second interval between themCtwelve four-second dashes with a one-second interval between themDtwelve one-second dashes with a short interval between them

多选题Which three initialization parameters are no longer needed when FAST_START_MTTR_TARGET is defined?()ATARGET_REDO_BLKSBFAST_START_IO_TARGETCLOG_CHECKPOINT_TIMEOUTDRECOVERY_ESTIMATED_IOSELOG_FILE_SIZE_REDO_BLKSFLOG_CHECKPOINT_INTERVAL

多选题Which three tasks can be performed using regular expression support in Oracle Database 10g?()Ait can be used to concatenate two strings.Bit can be used to find out the total length of the string.Cit can be used for string manipulation and searching operations.Dit can be used to format the output for a column or expression having string data.Eit can be used to find and replace operations for a column or expression having string data.

多选题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

多选题Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package?()AIt can be used to allow the access privilege settings for users but not roles.BIt can be used to allow the access privilege settings for users as well as roles.CIt can be used to control the time interval for which the access privilege is available to a user.DIt can be used to selectively restrict the access for each user in a database to different host computers.EIt can be used to selectively restrict a user's access to different applications in a specific host computer.

单选题When monitoring a system using vmstat with an interval, the metrics under page po represent which of the following phrases?()A The number pages over the limitB The pages to paging space per secondC The number of page operations per secondD The number of processes waiting for page out

多选题When the Cisco IOS OSPF command ip ospf dead-interval minimal hello-multiplier 5 is configured, which two statements are true? ()AOSPF hello interval is 5 secondsBOSPF hello interval is 1 secondCOSPF dead interval is 1 secondDOSPF dead interval is 5 secondsEOSPF dead interval is 20 secondsFOSPF hello interval is 0.2 second

单选题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