Black Friday VIP Weekend - 75% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 75brite

Oracle Updated 1z0-497 Exam Questions and Answers by farah

Page: 2 / 5

Oracle 1z0-497 Exam Overview :

Exam Name: Oracle Database 12c Essentials
Exam Code: 1z0-497 Dumps
Vendor: Oracle Certification: Oracle Database 12c Certified Implementation Specialist
Questions: 150 Q&A's Shared By: farah
Question 8

You execute the following command:

SQL> ALTER USER skd ACCOUNT LOCK;

Which two statements are correct?

Options:

A.

The SKD user cannot log in to the database instance.

B.

The objects owned by the SKD user are not accessible to any user.

C.

Other users can access objects owned by the SKD user, to which they have access.

D.

The SKD user's password expires and the user is forced to change the password at the next login.

Discussion
Question 9

What happens when you execute these SQL statements?

ALTER SYSTEM SET SGA_TARGET = 992M;

ALTER SYSTEM SET SHARED_POOL_SIZE = 0;

ALTER SYSTEM SET LARGE_POOL_SIZE = 0;

ALTER SYSTEM SET JAVA_POOL_SIZE = 0;

ALTER SYSTEM SET DB_CACHE_SIZE = 0;

ALTER SYSTEM SET STREAMS POOL SIZE = 0;

Options:

A.

The database stops (shutdown abort).

B.

B) The database Stops (shutdown immediate).

C.

You activate Automatic Shared Memory Management.

D.

You get an error message.

Discussion
Question 10

Which three statements about common and local roles are true?

Options:

A.

When a role is granted to a user, the privileges in the role are limited to the context of the PDB.

B.

Local roles can be granted only to local users.

C.

Common roles can be granted to both local and common users.

D.

A user can create common roles if the user has the CREATE ROLE privilege, and SET CONTAINER for all PDBs

E.

Common roles can be created in the root and PDBs.

Discussion
Miley
Hey, I tried Cramkey Dumps for my IT certification exam. They are really awesome and helped me pass my exam with wonderful score.
Megan Oct 14, 2026
That’s great!!! I’ll definitely give it a try. Thanks!!!
Melody
My experience with Cramkey was great! I was surprised to see that many of the questions in my exam appeared in the Cramkey dumps.
Colby Oct 22, 2026
Yes, In fact, I got a score of above 85%. And I attribute a lot of my success to Cramkey's dumps.
Wyatt
Passed my exam… Thank you so much for your excellent Exam Dumps.
Arjun Oct 19, 2026
That sounds really useful. I'll definitely check it out.
Ari
Can anyone explain what are these exam dumps and how are they?
Ocean Oct 9, 2026
They're exam preparation materials that are designed to help you prepare for various certification exams. They provide you with up-to-date and accurate information to help you pass your exams.
Cody
I used Cramkey Dumps to prepare and a lot of the questions on the exam were exactly what I found in their study materials.
Eric Oct 3, 2026
Really? That's great to hear! I used Cramkey Dumps too and I had the same experience. The questions were almost identical.
Question 11

Examine the statements:

SQL> CREATE TABLESPACE MYTBS DATAFILE '/disk1/mytbs_l.dbf ' SIZE 10M;

SQL> CREATE TABLE mytab (id NUMBER, descr VARCHAR2 (100) )

PARTITION BY RANGE(id) (

partition pi values loss than (100000) tablespacemytbs storage (initial lm),

partition p2 values less than (MAXVALUE) tablespacemytbs storage (initial 1m)

);

When inserting data, you get the error:

ORA-01688: unable to extend table SYS.MYTAB partition P2 by 128 in tablespace MYTBS

Which three operations would allow you to insert data without getting the error message?

Options:

A.

Extend the logical volume by 10 MB where the data files are stored;

# lvextend -L+10M /diskl

B.

Add a data file:

SQL>ALTER TABLESPACE MYTBS ADD DATAFILE ' /disk1/mytbs_2 .dbf SIZE 10M;

C.

Move a partition to another tablespace:

SQL> CREATE TABLESPACE ADDITIONAL_TBS DATAFILE '/disk1/additional_tbs_1 .dbf' SIZE 10M;

SQL> ALTER TABLE MYTAB MOVE PARTITION P2 TABLESPACE ADDlTIONAL_TBS;

D.

Resize the existing data file:

SQL> ALTER DATABASE DATAFILE '/diskl/mytbs_l .dbf' RESIZE 20M;

E) Remove a data file:

SQL> ALTER TABLESPACE MYTBS DROP DATAFILE '/diskl/mytbs_l - dbf';

Discussion
Page: 2 / 5

1z0-497
PDF

$27.5  $109.99

1z0-497 Testing Engine

$32.5  $129.99

1z0-497 PDF + Testing Engine

$42.5  $169.99