×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
In Oracle, what is the format-mask used for generating the output for the following query:
SQL > SELECT sysdate FROM dual;
SYSDATE— - — -— -— -— -— -— -
WEDNESDAY, SEPTEMBER 16 2002 06: 11 PM
SYSDATE— - — -— -— -— -— -— -
WEDNESDAY, SEPTEMBER 16 2002 06: 11 PM
2.
In Oracle, which of the following pieces of information have to be provided while creating a new listener using the enterprise manager database control?
1. The port used by the listener.
2. The server name where the listener runs.
3. The protocol used by the listener.
4. The log file and trace file destination for the listener.
5. The database services to be registered with the listener.
1. The port used by the listener.
2. The server name where the listener runs.
3. The protocol used by the listener.
4. The log file and trace file destination for the listener.
5. The database services to be registered with the listener.
3.
In Oracle, which of the following determines the lifetime of a password (in days) after which the password expires?
4.
During the Oracle database startup, if SPFILE is not found, Oracle will search for__________________________.
5.
In Oracle database, which of these is a system-wide central tracing and logging repository?
6.
In Oracle, which of the following dynamic performance views is used for all the view names?
7.
In Oracle, which of these must not be performed using the shared server?
8.
In Oracle, which of the following parameter's non-zero value enables automatic checkpoint tuning?
9.
In Oracle, which of the following undo information is overwritten by an active transaction?
10.
Execute below SQL Statements:
SQL>delete from employee;
There are no other uncommitted transactions on the SALES table. Which of the following is true about the DELETE statement?
SQL>delete from employee;
There are no other uncommitted transactions on the SALES table. Which of the following is true about the DELETE statement?