Interview question based on skill :
Take as many assements as you can to improve your validate your skill rating
Total Questions: 10
1. Oracle server configuration is dedicated for
Correct Answer is : One server process – One user process
2. What SYSTEM VARIABLE is used to refer DATABASE TIME ?
Correct Answer is : $$dbtime$$
3. You notice that the database instance takes a long time to start up after the instance crash. How will you resolve the problem?
Correct Answer is : Decrease the value for the FAST_START_MTTR_TARGET initialization parameter
4. Which statement is correct regarding undo management?
Correct Answer is : The database can have more than one undo tablespaces
5. Which operations can be performed using the Data Recovery Ad-visor?
Correct Answer is : Diagnosing data failure
6. A user receives the following error while executing a query: ORA-01555: snapshot too old Predict one way to avoid such errors in near future.
Correct Answer is : Increase the size of the undo tablespace
7. You want to be warned automatically when more than 100 sessions are opened with your database instance.Identify the action that would help you achieve this.
Correct Answer is : Set the threshold for the Current Logons Count metric
8. While the database instance is up and running, you receive an out-of-memory error due to the under-sizing of the shared pool. You checked the trace file and observed that the following error was always recorded during peak hours: ORA-04031: unable to allocate 4000 bytes of shared memory On investigation, you found that SGA_MAX_SIZE was larger than the sum of the sizes of all System Global Area (SGA) components and you do not have the scope to increase it further. Identify a solution to reduce the probability of getting this error in future.
Correct Answer is : Implement Automatic Shared Memory Management
9. You created a new user on the database by executing the following command: SQL> CREATE USER user01 IDENTIFIED BY user01 DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; Then you granted the following privileges to user01 by executing the following command: SQL> GRANT CREATE SESSION, CREATE TABLE TO user01; Which of the following is true in this scenario?
Correct Answer is : The user can create tables
10. Examine the following settings for the initialization parameters: MEMORY_MAX_TARGET=0 MEMORY_TARGET=500M SGA_TARGET=300M PGA_AGGREGATE_TARGET=70M Which statement is true about the memory management for the newly started database instance?
Correct Answer is : SGA_TARGET and PGA_AGGREGATE_TARGET combined will never grow beyond 500M
