Oracle 1z1-497 Actual Free Exam Questions & Community Discussion

Which three are initialization parameters for backup and recovery?

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?

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?

What happens if you execute these SQL statements?
SQL> show con_name
CON_NAME
CDB$ROOT
SQL> create user 1_freed identified by y container=current;

Oracle Database 12c provides new task-specific privileges (SYSBACKUP, SYSDG, and SYSKM) to handle standard administration duties. Which two statements about these standard administration privileges are true?

Your customer wants all email addresses from the database displayed as [hidden]@company.com. What method of data redaction must you use?

Which two statements about multitenant architecture are true?

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?