1.
In Oracle, if a metric reaches its predetermined alert, then which of the following statements is true?
2.
How do you provide a hint to a query in an existing application when you have only the binary?
3.
Your application requirement is to get the value of a parameter associated with the context namespace. Your developer mentions that sys_context can be used. However, you want to use global variables. Which approach is better and why?
4.
In Oracle, which of the following data dictionaries is queried to verify if the UPDATE privileges have been granted?
5.
In Oracle, the physical backups can be taken using __________ and __________.
6.
In Oracle, which of the following is a mandatory process to perform a backup of a whole database consistently?
7.
Oracle makes the control files and data files consistent to the same SCN during ________________________.
8.
In Oracle, which of the following files is not created when the database is in the NOARCHIVELOG mode?
9.
Suppose you are trying to perform RMAN backup. There are three data files: 1, 2 and 3. In file 1, Oracle reads the 10th block and finds that this block is fragmented and hence does not provide consistent information. What does RMAN do?
10.
In Oracle, which of the following views is queried to check whether a data file is part of a current online tablespace backup?