Correct Answer: Oracle Enterprise Manager
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Oracle 9i Administration Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Oracle 9i Administration MCQ Questions
You issue the following command: STARTUP MOUNT Which of the following events occur when the instance is started and database is mounted?
Examine the following TRUNCATE TABLE command: TRUNCATE TABLE departments; Which of the following statements are correct with regard to this command?
Which of the following memory areas is not part of SGA?
Which of the following becomes available when an Oracle instance is started?
You have two undo tablespaces defined for your database. The instance is currently using the undo tablespace named UNDO_TBS1. You issue the following command to switch to UNDO_TBS2, while there are still transactions using UNDO_TBS1: ALTER SYSTEM SET UNDO_TABLESPACE = undo_tbs2 What will be the result?
A new user, Smith, has just joined the organization. You need to create a User Account for him in the database. The points given below are to be kept in mind: 1. Create a user who is authenticated externally. 2. Make sure that the user has CONNECT and RESOURCE privileges. 3. Make sure the user does NOT have DROP TABLE and CREATE USER privileges. 4. Set a quota of 100 MB on the default tablespace and 500 K on the temporary tablespace. 5. Assign the user to the DATA_TS default tablespace Which of the following statements would you use to create the User Account for Smith?
Which of the following background processes performs a checkpoint in the database by writing modified blocks from the database buffer cache in SGA to the data files?
Consider the under mentioned syntax, which creates a DEPARTMENT table: CREATE TABLE department (DeptnoNUMBER(4), DnameVARCNAR2(30), mgr NUMBER(6), LocNUMBER(4)) STORAGE(INITIAL 200K NEXT 200K PCTINCREASE 50 MINEXTENTS 1 MAXEXTENTS 5) TABLESPACE userdata; What is the size defined for the fifth extent?
Which of the following options enables you to increase the size of online redo log groups?
Which of the following statements is correct with regard to an Oracle instance?