|
|
Authorized user can see question and answers.
Please log in or sign up. 
|
#51. Examine these statements:
1. MOUNT mounts the database for certain DBA activities but does not provide user access to the database.
2. The NOMOUNT command creates only the Data Buffer but does not provide access to the database.
3. The OPEN command enables users to access the database.
4. The STARTUP command starts an instance.
Which option correctly describes whether some or all of the statements are TRUE or FALSE?
Show comments for this question (1)
Add comments
Link to this question
|
|
#52. Examine the tablespace requirements for a new database. Tablespace Purpose Size
APP_DATA Application Data 1 Gig
APP_NDX Application Index 500M
SYSTEM System Data 300M
TEMP Temporary Data 100M
UNDOTBS Undo Data 150M
USERS User Data 100M Which three tablespaces can be created in the CREATE DATABASE statement? (Choose three.)
Show comments for this question (1)
Add comments
Link to this question
|
|
#53. You have two undo tablespaces defined for your database. The instance is currently using the undo tablespace 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? (Choose two.)
Show comments for this question (1)
Add comments
Link to this question
|
|
#56. 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?
Show comments for this question (1)
Add comments
Link to this question
|
|
#57. 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?
Show comments for this question (1)
Add comments
Link to this question
|
|
#58. 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?
Show comments for this question (1)
Add comments
Link to this question
|
|
|
|
 gen. 0.113
|
Server date 07:37 22-11-2008
|
Developed by Zip © 2006
|
|
|
|
|
Forum
Master braindump