Advertise
     Here
Home   Contact     Site Map
Request Information   
(732) 248-1900   1-877-85-eTeam(38326)
About Us Clients Experts Resources Training News Press Releases Success stories Help/FAQ
 
Test My Skills
 
ORACLE 9i
Author : Akshat Goyal
Name: *  
1. In which case would you use a FULL OUTER JOIN?
Both tables have NULL values.
You want all unmatched data from one table.
You want all matched data from both tables.
You want all unmatched data from both tables.
One of the tables has more data than the other.
You want all matched and unmatched data from only one table.
2. Which are DML statements? (Choose all that apply)
COMMIT…
MERGE…
UPDATE…
DELETE…
CREATE…
DROP…
3. In which scenario would index be most useful?
The indexed column is declared as NOT NULL.
The indexed columns are used in the FROM clause.
The indexed columns are part of an expression.
The indexed column contains a wide range of values.
4. Which two statements about sequences are true? (Choose two)
You use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.
You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence.
You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.
You use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column.
If a sequence starting from a value 100 and incremented by 1 is used by more then one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence.
You use REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.
5. Which three statements correctly describe the functions and use of constraints? (Choose three.)
Constraints provide data independence.
Constraints make complex queries easy.
Constraints enforce rules at the view level.
Constraints enforce rules at the table level.
Constraints prevent the deletion of a table if there are dependencies.
Constraints prevent the deletion of an index if there are dependencies.
6. What is true about joining tables through an equijoin?
You can join a maximum of two tables through an equijoin.
You can join a maximum of two columns through an equijoin.
You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.
To join two tables through an equijoin, the columns in the join condition must be primary key and foreign key columns.
You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions.
7. 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?
B-Tree
Bitmap
Reverse key
Function-based
8. In which scenario would TOP N analysis be the best solution?
You want to identify the most senior employee in the company.
You want to find the manager supervising the largest number of employees.
You want to identify the person who makes the highest salary for all employees.
You want to rank the top three sales representatives who have sold the maximum number of products.
9. Which two statements about creating constraints are true? (Choose two)
Constraint names must start with SYS_C.
All constraints must be defines at the column level.
Constraints can be created after the table is created.
Constraints can be created at the same time the table is created.
Information about constraints is found in the VIEW_CONSTRAINTS dictionary view.
10. Your developers asked you to create an index on the PROD_ID column of the SALES_HISTORY table, which has 100 million rows.

The table has approximately 2 million rows of new data loaded on the first day of every month. For the remainder of the month, the table is only queried. Most reports are generated according to the PROD_ID, which has 96 distinct values.

Which type of index would be appropriate?
Bitmap
Reverse key
Unique B-Tree
Normal B-Tree
Function based
Non-unique concatenated
11. For which two constraints are indexes created when the constraint is added? (Choose two.)
Check
Unique
Notnull
Primary Key
Foreign key
12. 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
13. Which two are true regarding external tables? (Choose two)
External tables can be updated.
External tables are read-only tables.
Indexes can be created on external tables.
Indexes cannot be created on external tables.
14. The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan?
ALTER TABLE employees monitor index employee_idx_fk;
ALTER INDEX employee_idx_fk monitoring on;
ALTER TABLE employees monitor all indexes;
ALTER INDEX employee_idx_fk monitoring usage;
15. Which RMAN command do you use to verify that the RMAN repository information is synchronized with the actual files that exist on disk?
LIST
CHANGE
CATALOG
CROSSCHECK
16. What is true regarding direct-load insert?
A direct-load insert can be invoked by suing the APPEND hint.
Inserting using the NOLOGGING option is the default for direct-load inserts.
All data loaded using direct-load insert is loaded below the high-water mark.
An object that is modifies using parallel direct-load can be queried within the same transaction.
17. Which of the following SQL*Loader parameters enables you to load a specified number of records stored in the data file?
ROWS
SKIP
LOAD
BINDSIZE
18. You have a database with the DB_NAME set to PROD and ORACLE_SID set to PROD.

These files are in the default location for the initialization files:

• init.ora
• initPROD.ora
• spfile.ora
• spfilePROD.ora
The database is started with this command:
SQL> startup

Which initialization files does the Oracle Server attempt to read, and in which order?
init.ora, initPROD.ora, spfilePROD.ora
spfile.ora, spfilePROD.ora, initProd.ora
spfilePROD.ora, spfile.ora, initProd.ora
initPROD.ora, spfilePROD.ora, spfile.ora
19. Which is a complete list of the logical components of the Oracle database?
tablespaces, segments, extents, and data files
tablespaces, segments, extents, and Oracle blocks
tablespaces, database, segments, extents, and data files
tablespaces, database, segments, extents, and Oracle blocks
tablespaces, segments, extents, data files, and Oracle blocks
20. For which two constraints are indexes created when the constraint is added? (Choose two)
Check
Unique
Notnull
Primary Key
Foreign key
21. Which type of index does this syntax create?

CREATE INDEX hr.employees_last_name_idx
ON hr.employees(last_name)
PCTFREE 30
STORAGE(INITIAL 200K NEXT 200K
PCTINCREASE 0 MAXEXTENTS 50)
TABLESPACE indx;
bitmap
B-Tree
partitioned
reverse key
22. Which type of file is part of the Oracle database?
control file
password file
parameter files
archived log files
 
eTeam, Inc. provides process and technology subject matter expertise in the areas of Analytics to a large manufacturing company.
eTeam, Inc. provides training in Siebel ePharma to a sales workforce of an international pharmaceutical company.
eTeam, Inc. provides Ascential Datastage and QualityStage expertise to a healthcare provider.
  More news...
"eTeam believes in partnering itself in the whole process of the projects, which gives them an edge over other consulting organizations."
Partial client list...
 Privacy Policy Legal Join our Team  

Copyright © 2005. All rights reservered. CRM and DW ExpertsTM is owned and operated by eTeam Inc.
Site designed and developed by Ravidhu Inc.