With New Update Passleader Real 1Z0-053 Test Questions To Pass Exam Easily (91-100)

QUESTION 91
While working on a data problem, Curt, Bill, Ben, Mike, and Matt introduced a vast amount of corrupted data into the database. Pablo has discovered this problem and he needs you to recover the database to the point in time prior to the introduction of the corruption. The logical corruption was introduced at 6:30 p.m. on September 6, 2008. Which of the following would be the correct commands to use to restore the database to a point in time before the orruption?

A.    restore database until time ’06-SEP-2008 06:30:00′); recover database until time ’06-SEP-2008 06:30:00′); alter database open;
B.    restore database until time ’06-SEP-2008 06:30:00′); recover database until time ’06-SEP-2008 06:30:00′); alter database open resetlogs;
C.    restore database until time ’06-SEP-2008 18:29:55′); recover database until time ’06-SEP-2008 18:29:55′); alter database open resetlogs;
D.    restore database until time ’06-SEP-2008 18:29:55′); alter database open resetlogs;
E.    restore database until time ’06-SEP-2008 18:29:55′); recover database; alter database open resetlogs;

Continue reading

With New Update Passleader Real 1Z0-053 Test Questions To Pass Exam Easily (51-60)

QUESTION 51
Which statements about the MEMORY_TARGET initialization parameter are true? (Choose all that apply.)

A.    MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET,
if MEMORY_MAX_TARGET is set to a value greater than zero
B.    MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set
C.    MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.
D.    MEMORY_TARGET is static and cannot be modified without shutting down the instance

Continue reading

With New Update Passleader Real 1Z0-053 Test Questions To Pass Exam Easily (41-50)

QUESTION 41
Exhibit:
411
View the Exhibit for some of the current parameter settings. A user logs in to the HR schema and issues the following commands:
SQL> CREATE TABLE emp (empno NUMBER(3), ename VARCHAR2(20), sal NUMBER(8,2));
SQL> INSERT INTO emp(empno,ename) VALUES(1,’JAMES’);
At this moment, a second user also logs in to the HR schema and issues the following command:
SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2);
What happens in the above scenario?

Continue reading