What’s the command to see the current user name?
Sql> show user; Read more »
‘Oracle Interview Questions’ - KyaPoocha.com
What’s the command to change the SQL prompt name?
SQL> set sqlprompt “database-1 > ” database-1 > database-1 > Read more »
What are the difference between DDL, DML and DCL commands?
DDL (Data Definition Language) statements are used to define the database structure or schema. Some examples: 1. CREATE - to create objects in the database 2. ALTER... Read more »
What is a mutating and constraining table?
“Mutating” means “changing”. A mutating table is a table that is currently being modified by an update, delete, or insert statement. When a trigger tries... Read more »
Is it better to put code in triggers or procedures? What is the difference?
In earlier releases of Oracle it was better to put as much code as possible in procedures rather than triggers. At that stage procedures executed faster than triggers... Read more »
How does one change the default Oracle passwords?
Passwords for SYS/CHANGE_ON_INSTALL, SYSTEM/MANAGER, and SAPR3/SAP should be changed for security reasons. The easiest way to change them is using the R3INST program.... Read more »
Give the two types of tables involved in producing a star schema and the type of data they hold.
Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables. Read more »