1Z0-031 Oracle - Braindumps.com.ua: список вопросов для "Oracle9i: Database Fundamentals I", страница: 6

Профиль

Бреиндампы

Получить последний дамп

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

Логин:
Пароль:
запомнить меня:

Контакты
Сайты по тематике
Cсылки

Авторизированые пользователи могут видеть ответы к вопросам.
Пожалуйста, авторизируйтесь или зарегистрируйтесь.

Список вопросов к экзамену:
Показать все комментарии

Oracle 1Z0-031: Oracle9i: Database Fundamentals I

#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?

#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.)

#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.)

#54. Extents are a logical collection of contiguous _________________.

#55. For a tablespace created with automatic segment-space management, where is free space managed?

#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?

#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?

#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?

#59. 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? (Choose two).

#60. For which two constraints are indexes created when the constraint is added? (Choose two.)

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] ... [37]

ген. 0.086

Дата сервера 09:13 09-01-2009

Oracle 1Z0-031