1z1-497 by Oracle Actual Free Exam Questions And Answers

Question 1

Which two statements are true regarding SQL*Plus?

A. Operating system commands can be executed from the SQL*Plus command prompt.

B. It has to be installed separately after the Oracle Database 12c installation.

C. It can be used in interactive but not batch mode for SQL commands.

D. It has commands for performing database administration operations.

Discussion 0

Correct Answer: A,D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 2

All database users are currently connected to the database instance and are working. The HR user opens three database sessions and executes this command in one of the sessions:
SQL> UPDATE persons SET ccode='U031' WHERE ccode='U029';
123 rows updated.
SQL> DELETE FROM persons WHERE exp='Y';
3 rows deleted.
The SYS user opens a new session after HR executes the preceding commands. Which option represents the sessions that can see the effect of the UPDATE and DELETE commands?

A. all sessions for which database users have access privileges to the PERSONS table

B. all sessions of the HR user

C. the session of the HR user that executed the commands

D. all sessions of the HR user and the SYS user

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 3

Which two statements about multitenant architecture are true?

A. Although consolidated into a single physical database, PDBs mimic the behavior of non-CDBs.

B. It takes more time to apply a patch to one CDB that holds hundreds of PDBs than to hundreds of non-CDB databases.

C. It is easier to collect performance metrics for many databases in a CDB than individual non-CDB databases.

D. A PDB administrator can use Oracle Flashback or point-in-time recovery to retrieve lost data from a PDB, only by shutting down all the PDBs from the CDB.

E. Multiple PDBs on a single server need multiple database instances and multiple sets of database files.

Discussion 0

Correct Answer: A,C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 4

Your database instance is running. db01 is a net service name. You issue a connection request by using the command:
SQL> CONNECT scott/tiger@db01
Which component receives the request and establishes the appropriate connection?

A. listener

B. user process

C. server process

D. service name

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 5

Several tables are accidentally deleted from a PDB. Which database would you immediately connect to, and as which user, to recover these tables?

A. the PDB as the ROOT user

B. the CDB as the CDBADMIN user

C. the PDB as the PDB Admin user

D. the CDB as the ROOT user

Discussion 0

Correct Answer: C Vote an answer

Question 6

View the current parameter settings shown in the output below.
NAMETYPEVALUE db_file_multiblock_read_count integer 107 ddl_lock_timeout integer 60 Distributed_lock_timeout integer 60 dml_locks integer 748 lock_sga boolean FALSE enab1e_dd1_1ogging boolean FALSE resumable_timeout integer 0
A user logs in to the hrschema and issues the following commands: SQL> CREATE TABLE emp
(empno NUMBER(3),
enamo 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 hrschema and issues the following command:
SQL> ALTER TABLE emp MODIFY salNUMBER(10, 2);
What happens in this scenario?

A. The second user's command executes successfully.

B. The second user's session immediately produces a "resource busy" error.

C. A deadlock is created.

D. The second user's session waits for a time before producing a "resource busy" error.

Discussion 0

Correct Answer: B Vote an answer

Question 7

Which two statements about this policy are true?

A. It replaces the first nine digits of the value from the COMMISSION_PCTcolumn with 1.

B. It replaces the first digit of the value from the SALARY column with the number 4.

C. It uses the random redaction method.

D. It uses the full data redaction method.

E. It replaces the first four digits of the value from the SALARY column with the number 9.

F. It replaces the first digit of the value from the COMMISSION_PCTcolumn with 9.

Discussion 0

Correct Answer: A,C Vote an answer

Question 8

Which is the default isolation level in Oracle Database 12c?

A. serializable

B. read-only

C. read uncommitted

D. read committed

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 9

Examine the command:
SQL> CREATE TABLE orders(oid NUMBER (6) PRIMARY KEY, odato DATE, ccode NUMBER (6), oamt NUMBER (10, 2)) TABLESPACE users ;
Which two statements are true about the execution of the command?

A. The ORDERS table is the only object created in the USERS tablespace.

B. The ORDERS table and a unique index are created in the USERS tablespace.

C. A CHECK constraint is created on the OID column.

D. A NOT NULL constraint is created on the OID column.

E. The ORDERS table is created in the USERS tablespace and a unique index is created on the OID column in the SYSTEM tablespace.

Discussion 0

Correct Answer: B,D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 10

Your customer needs server availability that provides uninterrupted access to database services, handling any unexpected failure of one or more machines hosting the database server, due to a hardware or software fault. Which product should your customer use?

A. Oracle Streams

B. Oracle GoldenGate

C. Oracle Real Application Clusters

D. Oracle Data Guard

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Oracle Database 12c Essentials - 1z1-497 Exam Practice Test

Contact Us

Useful Links

Latest Updated