Reference no: EM13946241

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