|
Question |
Rating |
View Answer |
|
Which data dictionary view would you query to see the free extents in a tablespace? |
|
View Answer |
|
Which dictionary view shows the password expiration date for a user? |
|
View Answer |
|
What is hot backup and how it can be taken? |
|
View Answer |
|
4. Choose the option that is not true.
a. Oracle creates a profile named DEFAULT when the database is created. b. Profiles cannot be renamed. c. DEFULT is a valid name for a profile resource. d. The SESSIONS_PER_USER resource in the DEFAULT profile initially has a value of 5.
|
|
View Answer |
|
How does one create a password file? |
|
View Answer |
|
If a View on a single base table is manipulated will the changes be reflected on the base table ? |
|
View Answer |
|
What is the use of IGNORE option in IMP command ? |
|
View Answer |
|
What is a Tablespace? |
|
View Answer |
|
How to implement the multiple control files for an existing database ? |
|
View Answer |
|
What is the minimum number of extents a rollback segment can have? |
|
View Answer |
|
When creating a database, where does Oracle find information about the control files that need to be created?
|
|
View Answer |
|
Which component of the SGA contains the parsed SQL code? |
|
View Answer |
|
List all the valid database start-up option? |
|
View Answer |
|
What is the difference between Anonymous Block and subprogram? Can we call a procedure from Anonymous PL/SQL block?
|
|
View Answer |
|
What is a dirty buffer? |
|
View Answer |
|
When validating a constraint, why would you specify the EXCEPTIONS clause? |
|
View Answer |
|
A constraint is created with the DEFERRABLE INITIALLY IMMEDIATE CLAUSE. What does this mean? |
|
View Answer |
|
Difference between database triggers and form triggers? |
|
View Answer |
|
What is concurrency? |
|
View Answer |
|
What are Procedure, functions and Packages ? |
|
View Answer |