Practicetest 1Z0-042 Oracle it-exams
Practicetest 1Z0-042 Oracle it-exams
IT Exam,IT Certification,braindump,original questions, question pool,document, braindump, test questions, test question, dumps, test answers, it-exams.com, preparation, pdf, certification questions, answers Certification, certification test, practice test, exam dumps, certification training, answers real questions
1Z0-042 Oracle Database 10g: Administration I our products come with a 100% guarantee of success. We hold this claim because of the highly dedicated and expert team that we have and because of our past performance.
Practicetest 1Z0-042 Oracle it-exams
QUESTION NO: 1
A user receives the following error while executing a query:
ORA-01555: snapshot too old
Which two options can be the solutions to avoid such errors in future? (Choose two.)
A. increase the size of the Database Buffer Cache
B. increase the size of the default temporary tablespace
C. increase the size of redo log files
D. increase the size of the undo tablespace
E. enable the retention guarantee for the undo tablespace
Answer: D,E
QUESTION NO: 2
What are the consequences of executing the SHUTDOWN ABORT command? (Choose two.)
A. The database files are synchronized.
B. The database is closed, but the instance is still started.
C. The database undergoes automatic media recovery during the next startup.
D. Database buffers and redo buffers are not written to the disk.
E. Uncommitted changes are not rolled back.
Answer: D,E
QUESTION NO: 3
The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a
bank. As part of the year-end tax and interest calculation process, all the rows in the table need to
be accessed. The bank authorities want to track access to the rows containing balance amounts
exceeding $200,000, and then send an alert message to the administrator. Which method would
you suggest to the bank for achieving this task?
A. performing standard database auditing to audit SQL statements with granularity level set to
ACCESS
B. implementing value-based auditing by using triggers
C. performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL
parameter to EXTENDED
D. implementing fine-grained auditing with audit condition and event handler
Answer: D
Practicetest 1Z0-042 Oracle it-exams
Practicetest 1Z0-047 Oracle it-exams
Practicetest 1Z0-047 Oracle it-exams
IT Exam,IT Certification,braindump,original questions, question pool,document, braindump, test questions, test question, dumps, test answers, it-exams.com, preparation, pdf, certification questions, answers Certification, certification test, practice test, exam dumps, certification training, answers real questions
1Z0-047 Oracle Database SQL Expert our products come with a 100% guarantee of success. We hold this claim because of the highly dedicated and expert team that we have and because of our past performance.
Practicetest 1Z0-047 Oracle it-exams
1.Which two statements are true regarding the types of table joins available in Oracle Database
10g? (Choose two.)
A.You can use the JOIN clause to join only two tables.
B.You can explicitly provide the join condition with a NATURAL JOIN.
C.You can use the USING clause to join tables on more than one column.
D.You can use the ON clause to specify multiple conditions while joining tables.
Correct:C D
2.Which two statements are true regarding subqueries? (Choose two.)
A.The ORDER BY clause can be used in the subquery.
B.A subquery can be used in the FROM clause of a SELECT statement.
C.If the subquery returns NULL, the main query may still return result rows.
D.A subquery can be placed in a WHERE clause, GROUP BY clause, or a HAVING clause.
E.Logical operators, such as AND, OR and NOT, cannot be used in the WHERE clause of a subquery.
Correct:A B
3.Evaluate the following SQL statements in the given order: DROP TABLE dept; CREATE TABLE dept (deptno NUMBER(3) PRIMARY KEY, deptname VARCHAR2(10)); DROP TABLE dept; FLASHBACK TABLE dept TO BEFORE DROP; Which statement is true regarding the above FLASHBACK operation?
A.It recovers only the first DEPT table.
B.It recovers only the second DEPT table.
C.It does not recover any of the tables because FLASHBACK is not possible in this case.
D.It recovers both the tables but the names would be changed to the ones assigned in the RECYCLEBIN.
Correct:B
4.Given below is a list of functions and their purpose in random order. Function Purpose 1)NVL
a) Used for evaluating NOT NULL and NULL values 2)NULLIF b) Used to return the first non- null values in a list of expressions 3)COALESCE c) Used to compare two expressions. If both are same,
it returns NULL; otherwise, it returns only the first expression. 4)NVL2 d) Used to convert NULL
values to actual values Identify the correct combination of functions and their usage.
A.1-a, 2-c, 3-b, 4-d B.1-d, 2-c, 3-b, 4-a C.1-b, 2-c, 3-d, 4-a D.1-d, 2-b, 3-c, 4-a Correct:B
Practicetest 1Z0-047 Oracle it-exams
IT Exam,IT Certification,braindump,original questions, question pool,document, braindump, test questions, test question, dumps, test answers, it-exams.com, preparation, pdf, certification questions, answers Certification, certification test, practice test, exam dumps, certification training, answers real questions
1Z0-042 Oracle Database 10g: Administration I our products come with a 100% guarantee of success. We hold this claim because of the highly dedicated and expert team that we have and because of our past performance.
Practicetest 1Z0-042 Oracle it-exams
QUESTION NO: 1
A user receives the following error while executing a query:
ORA-01555: snapshot too old
Which two options can be the solutions to avoid such errors in future? (Choose two.)
A. increase the size of the Database Buffer Cache
B. increase the size of the default temporary tablespace
C. increase the size of redo log files
D. increase the size of the undo tablespace
E. enable the retention guarantee for the undo tablespace
Answer: D,E
QUESTION NO: 2
What are the consequences of executing the SHUTDOWN ABORT command? (Choose two.)
A. The database files are synchronized.
B. The database is closed, but the instance is still started.
C. The database undergoes automatic media recovery during the next startup.
D. Database buffers and redo buffers are not written to the disk.
E. Uncommitted changes are not rolled back.
Answer: D,E
QUESTION NO: 3
The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a
bank. As part of the year-end tax and interest calculation process, all the rows in the table need to
be accessed. The bank authorities want to track access to the rows containing balance amounts
exceeding $200,000, and then send an alert message to the administrator. Which method would
you suggest to the bank for achieving this task?
A. performing standard database auditing to audit SQL statements with granularity level set to
ACCESS
B. implementing value-based auditing by using triggers
C. performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL
parameter to EXTENDED
D. implementing fine-grained auditing with audit condition and event handler
Answer: D
Practicetest 1Z0-042 Oracle it-exams
Practicetest 1Z0-047 Oracle it-exams
Practicetest 1Z0-047 Oracle it-exams
IT Exam,IT Certification,braindump,original questions, question pool,document, braindump, test questions, test question, dumps, test answers, it-exams.com, preparation, pdf, certification questions, answers Certification, certification test, practice test, exam dumps, certification training, answers real questions
1Z0-047 Oracle Database SQL Expert our products come with a 100% guarantee of success. We hold this claim because of the highly dedicated and expert team that we have and because of our past performance.
Practicetest 1Z0-047 Oracle it-exams
1.Which two statements are true regarding the types of table joins available in Oracle Database
10g? (Choose two.)
A.You can use the JOIN clause to join only two tables.
B.You can explicitly provide the join condition with a NATURAL JOIN.
C.You can use the USING clause to join tables on more than one column.
D.You can use the ON clause to specify multiple conditions while joining tables.
Correct:C D
2.Which two statements are true regarding subqueries? (Choose two.)
A.The ORDER BY clause can be used in the subquery.
B.A subquery can be used in the FROM clause of a SELECT statement.
C.If the subquery returns NULL, the main query may still return result rows.
D.A subquery can be placed in a WHERE clause, GROUP BY clause, or a HAVING clause.
E.Logical operators, such as AND, OR and NOT, cannot be used in the WHERE clause of a subquery.
Correct:A B
3.Evaluate the following SQL statements in the given order: DROP TABLE dept; CREATE TABLE dept (deptno NUMBER(3) PRIMARY KEY, deptname VARCHAR2(10)); DROP TABLE dept; FLASHBACK TABLE dept TO BEFORE DROP; Which statement is true regarding the above FLASHBACK operation?
A.It recovers only the first DEPT table.
B.It recovers only the second DEPT table.
C.It does not recover any of the tables because FLASHBACK is not possible in this case.
D.It recovers both the tables but the names would be changed to the ones assigned in the RECYCLEBIN.
Correct:B
4.Given below is a list of functions and their purpose in random order. Function Purpose 1)NVL
a) Used for evaluating NOT NULL and NULL values 2)NULLIF b) Used to return the first non- null values in a list of expressions 3)COALESCE c) Used to compare two expressions. If both are same,
it returns NULL; otherwise, it returns only the first expression. 4)NVL2 d) Used to convert NULL
values to actual values Identify the correct combination of functions and their usage.
A.1-a, 2-c, 3-b, 4-d B.1-d, 2-c, 3-b, 4-a C.1-b, 2-c, 3-d, 4-a D.1-d, 2-b, 3-c, 4-a Correct:B
Practicetest 1Z0-047 Oracle it-exams
nina008 - 23. Dez, 05:13
