IDS* 2
TS + IYM
TS –TSI
IDS – TS
IDS + IYM
第1题:
Which of the following datatypes store time-zone information in the database?()
第2题:
Which three are DATETIME data types that can be used when specifying column definitions?()
第3题:
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?()
第4题:
Which three statements are true regarding the data types in Oracle Database 10g/11g?()
第5题:
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?()
第6题:
You issued the following command at the UNIX environment: % setenv ORA_SDTZ ’OZ_TZ’ What will be the impact of issuing the above command?()
第7题:
DATE
TIMESTAMP
INTERVAL YEAR TO MONTH
INTERVAL DAY TO SECOND
TIMESTAMP WITH LOCAL TIME ZONE
第8题:
TIMESTAMP
INTERVAL MONTH TO DAY
INTERVAL DAY TO SECOND
INTERVAL YEAR TO MONTH
TIMESTAMP WITH DATABASE TIMEZONE
第9题:
DATE
TIMESTAMP
INTERVAL YEAR TO MONTH
INTERVAL DAY TO SECOND
TIMESTAMP WITH LOCAL TIME ZONE
第10题:
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
第11题:
The valid time columns employee_time_start and employee_time_end are automatically created.
The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
The valid time columns are not populated by the Oracle Server automatically.
The valid time columns are visible by default when the table is described.
Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulatio
第12题:
TIMESTAMP
DATE
TIMESTAMP WITH TIME ZONE
TIMESTAMP WITH LOCAL TIME ZONE
DATETIME
第13题:
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?()
第14题:
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? ()
第15题:
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? ()
第16题:
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?()
第17题:
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?()
第18题:
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?()
第19题:
os
local
-8:00
dbtimezone Li
Australia
第20题:
BEGIN_TIME is the time at which Flashback logging is enabled.
END_TIME is the time at which the query is executed on the view.
REDO_DATA is the number of bytes of redo data written during the interval.
This view contains information about flashback data pertaining to the last 24 hours.
FLASHBACK_DATA is the amount of flashback data generated since the database was opened.
第21题:
TIMESTAMP
DATE
TIMESTAMP WITH TIME ZONE
TIMESTAMP WITH LOCAL TIME ZONE
DATETIME
第22题:
The operating system local time zone will be set for a user session using the operating system environment variable.
The database local time zone will be set for a user session using the operating system environment variable.
The operating system local time zone will be set for the database using the operating system environment
The database local time zone will be set for the database using the operating system environment variable.
第23题:
use the ALTER SYSTEM command to change the time zone
use the ALTER SESSION command to change the time zone
use the ALTER DATABASE command to change the time zone
set the value for the operating system variable ORA_SDTZ on the client machine
set the value for the operating system variable ORA_SDTZ on the database server machine
第24题:
IDS* 2
TS + IYM
TS –TSI
IDS – TS
IDS + IYM