×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
Tom is the DBA of DNX Bank. The users of the banking system are complaining that all debit transactions are taking too long to execute. The details of the application used for this purpose are listed below:
Application - Bank_DNX to access banking accounts
Module - CUSTLEDGER
Action DEBIT_ENTRY
Which command should Tom execute in order to gather static for the states problem?
Application - Bank_DNX to access banking accounts
Module - CUSTLEDGER
Action DEBIT_ENTRY
Which command should Tom execute in order to gather static for the states problem?
2.
You created a database (using Database Configuration Assistant [DBCA]) by using one of the default templates. The default permanent tablespace for the non-system users, excluding DBSNMP and OUTLN
users, will be set to ________.
users, will be set to ________.
3.
Examine the following command to create an external table from EMPLOYEES and DEPARTMENTS database tables.
1. CREATE TABLE employee_ext
2. (employee_id, first_name, department_name)
3. ORGANIZATION EXTERNAL
4. (
5. TYPE ORACLE_LOADER
6. DEFAULT DIRECTORY ext_dir
7. LOCATION ('emp1.dmp')
8. )
9. PARALLEL
10. AS
11. SELECT e.emplyee_id, e.first_name, e.last_name,
1. CREATE TABLE employee_ext
2. (employee_id, first_name, department_name)
3. ORGANIZATION EXTERNAL
4. (
5. TYPE ORACLE_LOADER
6. DEFAULT DIRECTORY ext_dir
7. LOCATION ('emp1.dmp')
8. )
9. PARALLEL
10. AS
11. SELECT e.emplyee_id, e.first_name, e.last_name,
4.
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?
5.
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?
Which view would you query to determine the name and status of the stopped job?
6.
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?
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?
7.
Identify four uses of the Oracle Scheduler. (Choose four.)
8.
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?
ALTER DATABASE FLASHBACK ON;
Which view would you query to determine whether the Flashback Database has been enabled?
9.
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?
other objects?
10.
You imposed a column-level Virtual Private Database (VPD) policy as follows:
BEGIN
DBMS_RLS.ADD_POLICY (object_schema=> 'scott',
object_name => 'employees',
policy_name => 'hr_policy',
function_schema => 'pol_hr',
policy_function => 'hrpol',
sec_relevant_clos => 'salary,commission_pct');
END;
Which statement regarding hr_policy is true?
BEGIN
DBMS_RLS.ADD_POLICY (object_schema=> 'scott',
object_name => 'employees',
policy_name => 'hr_policy',
function_schema => 'pol_hr',
policy_function => 'hrpol',
sec_relevant_clos => 'salary,commission_pct');
END;
Which statement regarding hr_policy is true?