多选题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
多选题
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
参考解析
解析：
暂无解析
相关考题：
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 constraint types can be used to ensure the value of an INTEGER column references only positive values?() A.UniqueB.CheckC.ReferentialD.Informational
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 of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?（）A、UniqueB、CheckC、ReferentialD、Informational
The RMAN BACKUP command using the DELETE INPUT option can be used with which three types of files？ （）A、data filesB、backup setsC、control filesD、archived redo log files
For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？ （）A、RMAN image copiesB、RMAN database backupsC、RMAN tablespace backupsD、usermanaged backups placed in the flash recovery areaE、usermanaged backups that have been cataloged with RMANF、usermanaged data file backups for which the full path name is specified
You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）A、A backup of the target database when it is mountedB、A backup of online redo log files when the database is openC、A backup of only used data blocks in the file beingbeingbackup upD、A backup of online， read/write data files when the database is openE、A backup of only those data blocks that have changed since a previous backupF、A backup of online， read/write data files when the database is in the NOMOUNT state.
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.
You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?（）A、BFILE B、REF column C、Object table D、Column object E、INSTEAD-OF trigger
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 statements are true about Flashback Database?（）A、Flashback logs are written sequentially, and are archived.B、Flashback Database uses a restored control file to recover a database.C、The Oracle database automatically creates, deletes, and resides flashback logs in the Fast RecoveryArea.D、Flashback Database can recover a database to the state that it was in before a reset logs operation.E、Flashback Database can recover a data file that was dropped during the span of time of the flashback.F、Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.
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
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 three statements are true about Flashback Database?（）AFlashback logs are written sequentially, and are archived.BFlashback Database uses a restored control file to recover a database.CThe Oracle database automatically creates, deletes, and resides flashback logs in the Fast RecoveryArea.DFlashback Database can recover a database to the state that it was in before a reset logs operation.EFlashback Database can recover a data file that was dropped during the span of time of the flashback.FFlashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.
多选题You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）AA backup of the target database when it is mountedBA backup of online redo log files when the database is openCA backup of only used data blocks in the file beingbeingbackup upDA backup of online， read/write data files when the database is openEA backup of only those data blocks that have changed since a previous backupFA backup of online， read/write data files when the database is in the NOMOUNT state.
多选题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
多选题You are working on a database that must be functioning 24 hours a day， 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）AYou can perform consistent backups only.BYou can perform a complete database backup without shutting down the database instance.CYou can back up data files only when all data files have the same SCN recorded in the control file.DYou can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands
多选题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 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
多选题The RMAN BACKUP command using the DELETE INPUT option can be used with which three types of files？ （）Adata filesBbackup setsCcontrol filesDarchived redo log files
多选题On a 3550 EMI switch， which three types of interfaces can be used to configure HSRP？ （）ALoopback interfaceBSVI interfacCRouted portDAccess portEEtherChannel port channelFBVI interface
多选题Which two statements regarding external authentication servers for firewall user authentication are true?（） (Choose two.)AUp to three external authentication server types can be used simultaneously.BOnly one external authentication server type can be used simultaneously.CIf the local password database is not configured in the authentication order, and the configured authentication server bypassed.DIf the local password database is not configured in the authentication order, and the configured authentication server authentication is rejected.
多选题Cisco IOS NetFlow gathers data that can be used in which three of these？ （）AaccountingBauthenticationCauthorizationDnetwork monitoringEnetwork planning
多选题Which three statements are true about database recovery operations？（）ADamaged or lost data files are restored from backups.BRedo log file entries are used to roll forward the database.CUndo segments are used to roll back any uncommitted transactions.DTransactions that were active when the failure occurred are restarted.ETransactions that were active when the failure occurred are automatically committed during the recover procedure.
多选题When executing the massload command to load catalog data into a WebSphere Commerce database on a remote DB2 server，which of the following can be used as valid values for the -method command line parameter？（）AcreateBimportCloadDsqlimportEupdate
多选题For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？ （）ARMAN image copiesBRMAN database backupsCRMAN tablespace backupsDusermanaged backups placed in the flash recovery areaEusermanaged backups that have been cataloged with RMANFusermanaged data file backups for which the full path name is specified
多选题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