Oracle9i Database Administration Fundamentals - 1 Online Test

Which background process performs a checkpoint in the database by writing modified blocks from the database buffer cache in the SGA to the data files?
LGWR
SMON
DB Wn
CKPT
What determines the initial size of a table space?
The INITIAL clause of the CREATE TABLESPACE statement
The MINEXTENTS clause of the CREATE TABLESPACE statement
The MINIMUM EXTENT clause of the CREATE TABLESPACE statement
The sum of the sizes of all data files specified in the CREATE TABLESPACE statement
Which constraint state prevents new data that violates the constraint from being entered, but allows invalid data to exist in the table?
ENABLE VALIDATE
DISABLE VALIDATE
ENABLE NOVALIDATE
DISABLE NOVALIDATE
Select the memory structure(s) that would be used to store the parse information and actual value of the bind variable id for the following set of commands: VARIABLE id NUMBER; BEGIN :id:=1; END; /
PGA only
Row cache and PGA
PGA and library cache
Shared pool only
Library cache and buffer cache
An INSERT statement failed and is rolled back. What does this demonstrate?
Insert recovery
Read consistency
Transaction recovery
Transaction rollback
You are creating a new database. You do NOT want users to use the SYSTEM table space for sorting operations. What should you do when you issue the CREATE DATABASE statement to prevent this?
Create an undo table space.
Create a default temporary table space.
Create a table space with the UNDO keyword.
Create a table space with the TEMPORARY keyword.
You used the password file utility to create a password file as follows: $orapwd file=$ORACLE_HOME/dbs/orapwDB01 password=ora pass entries =5 You created a user and granted only the SYSDBA privilege to that user as follows: CREATE USER dba_user IDENTIFIED BY dba_pass; GRANT sysdba TO dba_user; The user attempts to connect to the database as follows: connect dba_user/orapass as sysdba; Why does the connection fail?
The DBA privilege had not been granted to dba_user.
The SYSOPER privilege had not been granted to dba_user.
The user did not provide the password dba_pass to connect as SYSDBA.
The information about dba_user has not been stored in the password file.
For which two constraints are indexes created when the constraint is added?
Check & Unique
Unique & Primary key
Not null & check
Primary key& foreign key
You decide to use Oracle Managed Files in your database. Which two are requirements with respect to the directories you specify in the DB_CREATE_FILE_DEST and DB_CREATE_ONLINE_LOG_DEST_n initialization parameters?
The directory must already exist & The directory must have appropriate permissions that allow Oracle to create files in it.
The directory must already exist & The directory must not contain any other files.
The directory must already exist & The directory must be created in the $ORACLE_HOME directory.
The directory must already exist & The directory must have appropriate permissions that allow Oracle to create files in it.
After running the ANALYZE INDEX orders cust_idx VALIDATE STRUCTURE command, you query the INDEX_STATS view and discover that there is a high ratio of DEL_LF_ROWS to LF_ROWS values for this index. You decide to reorganize the index to free up the extra space, but the space should remain allocated to the ORDERS_CUST_IDX index so that it can be reused by new entries inserted into the index. Which command(s) allows you to perform this task with the minimum impact to any users who run queries that need to access this index while the index is reorganized?
ALTER INDEX REBUILD
ALTER INDEX COALESCE
ALTER INDEX DEALLOCATE UNUSED
DROP INDEX followed by CREATE INDEX
The credit controller for your organization has complained that the report she runs to show customers with bad credit ratings takes too long to run. You look at the query that the report runs and determine that the report would run faster if there were an index on the CREDIT_RATING column of the CUSTOMERS table. The CUSTOMERS table has about 5 million rows and around 100 new rows are added every month. Old records are not deleted from the table. The CREDIT_RATING column is defined as a VARCHAR2(5) field. There are only 10 possible credit ratings and a customer's credit rating changes infrequently. Customers with bad credit ratings have a value in the CREDIT_RATINGS column of 'BAD' or 'F'. Which type of index would be best for this column?
Tree
Bitmap
Reverse key
Function-based
You just created five roles using the statements shown: CREATE ROLE payclerk; CREATE ROLE oeclerk IDENTIFIED BY salary; CREATE ROLE hr_manager IDENTIFIED EXTERNALLY; CREATE ROLE genuser IDENTIFIED GLOBALLY; CREATE ROLE dev IDENTIFIED USING dev_test; Which statement indicates that a user must be authorized to use the role by the enterprise directory service before the role is enabled?
CREATE ROLE genuser IDENTIFIED GLOBALLY;
CREATE ROLE oeclerk IDENTIFIED BY salary;
CREATE ROLE dev IDENTIFIED USING dev_test;
CREATE ROLE hr_manager IDENTIFIED EXTERNALLY;
For a table space created with automatic segment-space management, where is free space managed?
In the extent
In the control file
In the data dictionary
In the undo table space
Extents are a logical collection of contiguous ________.
Segments
Database blocks
Table spaces
Operating system blocks
You have two undo table spaces defined for your database. The instance is currently using the undo table space named UNDOTBS_1. You issue this command to switch to UNDOTBS 2 while there are still transactions using UNDOTBS_1: ALTER SYSTEM SET UNDO_TABLESPACE = undotbs_2 Which two results occur?
New transactions are assigned to UNDOTBS_2. & Current transactions are switched to the UNDOTBS_2 table space.
New transactions are assigned to UNDOTBS_2 &.Current transactions are switched to the UNDOTBS_2 table space.
New transactions are assigned to UNDOTBS_2. & The switch to UNDOTBS_2 fails and an error message is returned.
New transactions are assigned to UNDOTBS_2. &The UNDOTBS_1 undo table space enters into a PENDING OFFLINE mode (status).
Description:

This test determines you knowledge about underlying architecture of the Oracle database server.The test will check your ability of exploring the components that comprise a database, practice creating a database, manage database objects, reorganize data, and implement security measures.
Disclaimer: Content, such as images used in the questions (if any), have been picked up from various places for the sole purpose of Instruction.

Discussion

Your Facebook Friends on WizIQ

More Tests By Author

ASP Server Controls
10 Questions | 667 Attempts

ASP.NET, Namespaces ASP.NET
10 Questions | 2028 Attempts

An ASP.NET Application
10 Questions | 437 Attempts

Explore Similar Courses

Oracle ADF Online

Price:$100