Tag: databases
Questions Related to databases
Which datatype stores data outside Oracle Database?
The DEPT table has the following data
The current time in Dubai is 04-APR-2008 08:50:00, and the time in Dallas is 03-APR-2008 23:50:00. A user from Dubai is connected to a session in the database located on a server in Dallas. What will be the result of his query?
SYS_CONTEXT can be used to know details about a session running the code?
Which are appropriate scheduling tools for use in EIP database?
COMPLETE REFRESH by default will _________________all rows in an mview before inserting new rows