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

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

Oracle 1Z0-031: Oracle9i: Database Fundamentals I

#21. The database currently has one control file. You decide that three control files will provide better protection against a single point of failure. To accomplish this, you modify the SPFILE to point to the locations of the three control files. The message "system altered" was received after execution of the statement.
You shut down the database and copy the control file to the new names and locations. On startup you receive the error ORA-00205: error in identifying control file. You look in the alert log and determine that you specified the incorrect path for the for control file.
Which steps are required to resolve the problem and start the database?

#22. Which two methods enforce resource limits? (Choose two.)

#23. 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;

#24. There are three ways to specify National Language Support parameters:
1. initialization parameters
2. environment variables
3. ALTER SESSION parameters
Match each of these with their appropriate definitions.

#25. More stringent user access requirements have been issued. You need to do these tasks for the user pward:
1. Change user authentication to external authentication.
2. Revoke the user's ability to create objects in the TEST TS tablespace.
3. Add a new default and temporary tablespace and set a quota of unlimited.
4. Assign the user to the CLERK profile.
Which statement meets the requirements?

#26. A new user, psmith, has just joined the organization. You need to create psmith as a valid user in the database. You have the following requirements:
1. Create a user who is authenticated externally.
2. Make sure the user has CONNECT and RESOURCE privileges.
3. Make sure the user does NOT have DROP TABLE and CREATE USER privileges.
4. Set a quota of 100 MB on the default tablespace and 500 K on the temporary tablespace.
5. Assign the user to the DATA_TS default tablespace and the TEMP_TS temporary tablespace.
Which statement would you use to create the user?

#27. You issue these queries to obtain information about the REGIONS table:

 SQL> SELECT segment_name, tablespace_name 
 2> FROM user_segments 
 3> WHERE segment_name = 'REGIONS';

 SEGMENT_NAME     TABLESPACE_NAME 
 REGIONS          SAMPLE

 SQL> SELECT constraint_name, constraint_type 
 2> FROM USER CONSTRAINTS 
 3> WHERE table_name = ‘REGIONS’;

 CONSTRAINT_NAME     C 
 REGION_ID_NN        C 
 REG_ID              P

 SQL> SELECT index_named 
 2> FROM USER indexes 
 3> WHERE table_name = ‘REGIONS’;

INDEX_NAME
REG_ID_PK
You then issue this command to move the REGIONS table:

 ALTER TABLE regions 
 MOVE TABLESPACE user_data;

What else must you do to complete the move of the REGIONS table?

#28. You need to create an index on the CUSTOMER_ID column of the CUSTOMERS table. The index has these requirements:
1. The index will be called CUST_PK.
2. The index should be sorted in ascending order.
3. The index should be created in the INDEX01 tablespace, which is a dictionary
4. All extents of the index should be 1 MB in size.
5. The index should be unique.
6. No redo information should be generated when the index is created.
7. 20% of each data block should be left free for future index entries.
Which command creates the index and meets all the requirements?

#29. Which data dictionary view would you use to get a list of all database users and their default settings?

#30. User A issues this command:

 UPDATE emp 
 SET id=200 
 WHERE id=1

Then user B issues this command:

 UPDATE emp 
 SET id=300 
 WHERE id=1

User B informs you that the UPDATE statement seems to be hung. How can you resolve the problem so user B can continue working?

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

ген. 0.11

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

Oracle 1Z0-031