Which of the following Tasks are Oracle Database Administrators (DBs) commonly required to perform?
1) Create Users; 2) Perform Backups 3) Add Table Spaces / Or data files; 4) Change instance parameters; 5) All of the above
What does the DBA Studio Tool of DBA Management Pack administer?
1) Schemes; 2) Security; 3) Storage; 4) Instances; 5) All
Instance Management commonly includes which of the following tasks?
1) Database Star-up/Shut down; 2) Configuring instances; 3) Monitoring the current instance; 4) 1, 2, 3 or 5) 2 and 3
Which of the following comprise schemas?
1) Tables & Indexes; 2) Tables, Indexes and Oracle Objects; 3) Data files and Objects; 4) Initialization parameters; 5) Accounts and privileges
Which of the following are the prime components of security management?
1) User Accounts; 2) Rollback Segments; c) Star-Up and Shutdown; 4) Roles and Privileges; 5) 1 and 4
Which is it important to know which instance parameters are most significant?
1) A change to parameters might require shutdown; 2)) Changing instance parameters can either improve or degrade the performance of Oracle Database; 3) 1 and 2; 4) to make sure users access only that information they are allowed to view.
What should DBA look at if a user complains of frustration with response time for a particular task they are performing against the database?
1) User's Database connection Time; 2) The SQL statement the user is issuing; 3) The machine the user is using; 4) 1 and 3
Which factors most commonly can cause database performance to suffer?
1) Number of users; 2) Hardware configures; 3) Type of Activity; 4) 1 and 2; 5) All of the above
What does the Table Data Editor tool of DBA Management Pack allow you to do?
1) Select Columns are displayed; 2) Change Columns widths; 3) Modify where clauses; 4) All of the Above; 5) None of the above
What information does object statistics provide?
1) Number of row in a table; 2) Number of chained or migrated rows; 3) Index performance; 4) All of the above; 5) 1 and 2
Which of the following is / are examples of objects?
1) Dimensions; 2) Partioned & Non-Partioned Tables; 3) Hardware Configuration; 4) 1 and 2; 5) None of the above
What does the Load Wizard of DBA Management Pack allow you to do?
1) Load non-oracle data into an Oracle Database; 2) Back-up Oracle Objects from a Oracle database into an operating system export file; 3) Load Oracle Objects into an Oracle database from an Oracle export file for import; 4) Back-Up data; 5) Load Oracle data into an Oracle Database.
What does the Create Like feature of DBA Studio allow you to do?
1) Create a new user to an existing user with similar characteristics; 2) Copy data files; 3) Back-Up Data; 4) 1 and 2; 5_ 1 and 2 and 3
What do system privileges enable users to do?
1) Modify the logical structure of the Database; 2) Create Tables; 3) Manage free space in the database; 4) All of the above; 5) None
For which of the following would you use Kernel Profiles?
1) Limit users as to number of database sessions; 2) Disconnect database sessions; 3) Prohibit idle database sessions; 4) 1 and 2; 5) 1 and 2 and 3Of the following selections, which are most important in ensuring sufficient space is available in the database?
2) 1) Table spaces; 2) Data files; 3) 1 and 2; 4) Deleting unused profiles; 5) Limiting the number of users
Which of the following are features of table spaces?
1) A method for managing space; 2) The type of data store (Temp/Perm); 3) Status; 4) 1 and 2 and 3; 5) None
What does the Catalog maintenance Wizard of DBA management pack do?
1) Archive logs; 2) Keeps the RMAN up to date; 3) Recovers data files; 4) None; 3) All of the above
What type of information is stored in the control file?
1) Database Name and ID;
2) Recovery Details;
3) Max. Record sizes for the database;
4) 1 and 3 Only;
5) 1, 2, 3
Why is having a Redo Log Important?
1) To prevent poor response time;
2) To allow a DBA to redo a complicated task multiple times;
3) To ensure the database can recover from instance failure;
4) To view SQL History;
5) None
What does the SQL Plus worksheet tool of DBA Management Pack allow you to do?
1) Issue data manipulation (DML) statements;
2) Issue data definition (DDL) statements;
3) 1 and 2;
4) Control the Log Size;
5) Perform Accounting functions
Why would you want to view the SQL History?
1) You can't remember whether a task actually was performed?;
2) You need to trouble shoot
3) You made a mistake
4) You want to print summary information
5) 1, 2 and 3
What can a user granted the SELECT_Catalog_Role Database System privilege do?
1) Create tables;
2) Perform o database OPS, & can access only read features of the tools in DBA Management Pack;
3) Enter SQL Statements;
4) Log Archives;
5) None
Where does the DBA Studio Tool of DBA Management Pack allow you to connect to manage the databases in your environment?
1) An Oracle Management Server (OMS);
2) A stand-alone direct connection to a database;
3) The enterprise Manager Repository;
4) 1 and 2;
5) None of the above
When connecting stand-alone, how do you select databases?
1) From an existing tnsnames.ora file;
2) Create new database entries manually;
3) From the tblname.ora file;
4) 1 and two;
5) None of the above
Which of the following is true when you create new database entries manually?
1) The TNS Service name and address is written to the tnsnames.ora file;
2) Only service names that are addressable using the TCP/IP protocol can be added manually;
3) The service name is the unique name for connecting to the database;
4) All of the above;
5) None of the above
When connected to an OMS, what is the only way to maintain services and preferred credentials?
1) From the console;
2) From within DBA Studio;
3) Start the OMS for the first time, then launch DBA Studio connected to an OMS;
4) All of the above;
5) None of the above
What is the best general definition of instances?
1) Memory structures and processes critical for the database to function;
2) A non-essential optional part of database operation;
3) Instances are opened after you retrieve information from an Oracle database;
4) A away of synchronizing databases;
5) None of the above
What does a green instance status light indicate?
1) The instance is not yet started;
2) The instance is accepting user connections;
3) Database options are ready to be installed;
4) The database may be shut down safely;
5) None
Which following function(s) can you perform an instance parameters?
1) View parameters in bytes, Kbytes or Mbytes;
2) Change those parameters that will affect the memory size for each database session;
3) Change the values for the major parameters that affect the size of the System Global Area (SGA);
4) 1 and 2 and 3;
5) None of the above
Which of the following is true about object data?
1) Data from views and synonyms can only be viewed, not modified;
2) Data within tables can be viewed and modified;
3) 1 and 2;
4) Data from views can be modified;
5) 1 and 2
In Oracle 8i, what are tempfiles?
1) Files similar to datafiles but stored differently in the database;
2) Files created when a tablespace is created with the TEMPORARY and LOCALLY MANAGED options;
3) A place to store data temporarily;
4) 1 and 2;
5) All of the above
Why is the Instance a Critical part of database operation?
1) Information cannot be retrieved from an Oracle database until the instance is opened;
2) Modifying Instance parameter can either improve or degrade the performance of any Oracle database;
3) To tune SQL Statements;
4) 1 and 2;
5) None of the above