1z0-040 Oracle - Braindumps.com.ua: question list for "Oracle Database 10g: New Features for Administrators", page: 4

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2461)

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-040: Oracle Database 10g: New Features for Administrators

#31. You have three production database, HRDB, FINDB, and ORGDB, that use the ASM instance. At the end of the day, you execute the following command on the ASM instance to shut down:
SQL> shutdown immediate;
What is the result of executing this command?

#32. Exhibit

Examine the SQL statement used to create the EMP table. You need to shrink the EMP table segment. Which SQL statement would you execute as a prerequisite before you execute the ALTER TABLE emp SHRINK SPACE; command?

#33. While exporting data by using Data Pump, you find that the export runs for long period. Because this action is being performed during peak hours, you decide to stop the job and restart it during off-peak hours. Which view would you query to determine the name and status of the stopped job?

#34. In the server parameter file (SPFILE), the UNDO_TABLESPACE initialization parameter is set to UNDOTBS. You executed the following SQL statement to rename the UNDOTBS undo tablespace:

 ALTER TABLESPACE undotbs RENAME TO undotbs_old;

Which statement is correct in this scenario?

#35. Identify four uses of the Oracle Scheduler. (Choose four.)

#36. You enabled Flashback Database with the following command:

 ALTER DATABASE FLASHBACK ON;

Which view would you query to determine whether the Flashback Database has been enabled?

#37. You flashed back the jobs table at 11:00 a.m. to its state at 9:30 a.m. At 11:15 a.m., you decided to retrieve the jobs table as it was at 10:12 a.m. What would you do to retrieve the jobs table fast and with minimum impact to other objects?

#38. You executed the following command to drop a user:

 DROP USER scott CASCADE;

Which two statement regarding the above command are correct? (Choose two.)

#39. You want to execute the following statements in resumable mode:

 CREATE TABLE … AS SELECT 
 CREATE INDEX 
 CREATE MATERIALIZED VIEW

Which two methods can be used to enable a session for resumable space allocation? (Choose two.)

#40. You created a tablespace with the following statement:

 CREATE BIGFILE TABLESPACE adtbs 
 DATAFILE ‘/proddb/data/adtbs.dbf’ SIZE 10G;

There is now a requirement to increase the size of the tablespace. Which two ALTER statements are correct in this scenario? (Choose two.)

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

gen. 0.086

Server date 06:39 02-12-2008

Oracle 1z0-040

Forum

Start online exam simulation

Master braindump

User braindumps