1Z0-035 Oracle - Braindumps.com.ua: question list for "Oracle 7.3 & 8 to Oracle9i DBA OCP Upgrade", page: 20

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Authorization

Login:
Password:
remember me:

Contacts
Certification links
Links

Authorized user can see question and answers.
Please log in or sign up.

Exam question list:
Show all comments

Oracle 1Z0-035: Oracle 7.3 & 8 to Oracle9i DBA OCP Upgrade

#191. Evaluate the SQL statement:

 CREATE TABLESPACE hr_tbs 
 DATAFILE '/usr/oracle9i/OraHomel/hr_data.dbf' SIZE 2M 
 AUTOEXTEND ON 
 MINIMUM EXTENT 4K 
 NOLOGGING 
 DEFAULT STORAGE (INITIAL 5K NEXT 5K PCTINCREASE 50) 
 EXTENT MANAGEMENT DICTIONARY 
 SEGMENT SPACE MANAGEMENT AUTO;

Why does the statement return an error?

#192. You query DBA_CONSTRAINTS to obtain constraint information on the HR_EMPLOYEES table:

 SQL> SELECT constraint_name, constraint_type, deferrable, 
 2> deferred, validated 
 3> FROM dba_constraints 
 4> WHERE owner = 'HR' AND table_name='EMPLOYEES';

Which type of constraint is EMP_JOB_NN?

#193. Evaluate the following SQL:

 CREATE USER sh IDENTIFIED BY sh; 
 GRANT 
 CREATE ANY MATERIALIZED VIEW 
 CREATE ANY DIMENSION 
 , DROP ANY DIMENSION 
 , QUERY REWRITE 
 , GLOBAL QUERY REWRITE 
 TO dw_manager 
 WITH ADMIN OPTION; 
 GRANT dw_manager TO sh WITH ADMIN OPTION;

Which three actions is the user SH able to perform? (Choose three.)

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

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

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

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

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

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

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

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?

[1] ... [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] [21] ... [85]

gen. 0.098

Server date 05:06 08-01-2009

Oracle 1Z0-035

Forum

Start online exam simulation

Master braindump