网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
Which of the following datatypes store time-zone information in the database?()
A
TIMESTAMP
B
DATE
C
TIMESTAMP WITH TIME ZONE
D
TIMESTAMP WITH LOCAL TIME ZONE
E
DATETIME
参考答案
参考解析
解析:
暂无解析
更多 “单选题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 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 command will restore all datafiles to the date 9/30/2008 at 18:00 hours? ()A、restore datafiles until time '09/28/2008:21:03:11'B、restore database files until time '09/28/2008:18:00:00'C、restore database until time '09/28/2008:18:00:00'D、recover database until time '09/28/2008:18:00:00'E、recover database until timestamp '09/28/2008:18:00:00'
考题
How does NTP help you troubleshoot network problems?()A、By calculating the time offset from the GPS or atomic clockB、By setting the router clock to the default value if the router can't connect to a time serverC、By setting all network devices to the correct timeD、By setting necessary time date in the timestamp information
考题
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
考题
You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). Identify two scenarios is which you must have a recovery catalog.()A、To store the backup information of multiple databaseB、To restrict the amount of space that is used by the backupsC、To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.D、To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.
考题
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
考题
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 are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery catalog. ()(Choose two.)A、To store the backup information of multiple databaseB、To restrict the amount of space that is used by the backupsC、To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.D、To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.
考题
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
考题
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
考题
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? ()A、 use the ALTER SYSTEM command to change the time zoneB、 use the ALTER SESSION command to change the time zoneC、 use the ALTER DATABASE command to change the time zoneD、 set the value for the operating system variable ORA_SDTZ on the client machineE、 set the value for the operating system variable ORA_SDTZ on the database server machine
考题
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 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 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
考题
多选题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
考题
单选题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.
考题
单选题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 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 are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery catalog. ()(Choose two.)ATo store the backup information of multiple databaseBTo restrict the amount of space that is used by the backupsCTo maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.DTo list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.
考题
单选题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.
考题
单选题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 command will restore all datafiles to the date 9/30/2008 at 18:00 hours? ()A
restore datafiles until time '09/28/2008:21:03:11'B
restore database files until time '09/28/2008:18:00:00'C
restore database until time '09/28/2008:18:00:00'D
recover database until time '09/28/2008:18:00:00'E
recover database until timestamp '09/28/2008:18:00:00'
考题
单选题How does NTP help you troubleshoot network problems?()A
By calculating the time offset from the GPS or atomic clockB
By setting the router clock to the default value if the router can't connect to a time serverC
By setting all network devices to the correct timeD
By setting necessary time date in the timestamp information
热门标签
最新试卷