In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
How would you best determine why your MVIEW couldn't FAST REFRESH?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How would you extract DDL of a table without using a GUI tool?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Why does Oracle not permit the use of PCTUSED with indexes?
What would you do with an "in-doubt" distributed transaction?
What are the commands you'd issue to show the explain plan for "select * from dual"?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?