Your customer is planning for a maximum-availability architecture at their data center to address their planned downtime, unplanned downtime, and replication needs. Consider these options: – Instance, site recovery, and heterogeneous setup – Inter-region and intra-region load balancing across replicated…
Which two statements are true about Oracle Data Pump? A. EXPDP and IMPDP are the client components of Oracle Data Pump. B. DBMS_DATAPUMP PL/SQL packages can be used independently of Data Pump clients. C. Oracle Data Pump export and import…
In this SQL statement, what is the partitioning criteria? CREATE TABLE books_part PARTITION BY RANGE (cell_id) ( PARTITION p0l VALUES LESS THAN (2), PARTITION p02 VALUES LESS THAN (3) , . . . PARTITION pl4 VALUES LESS THAN (15), PARTITION…
Which four statements about users in Oracle Database 12c are correct? A. A common user cannot have the same name as any local user across all PDBs. B. A common user can be created only in the root container. C.…
Which three DBA operations can be performed by using Oracle SQL Developer? A. database backup and recovery using RMAN B. performance tuning operations such as generation of AWR, ADDM, and ASH reports C. storage configuration for archive logs and control…
What must you do to an application for it to take advantage of partitioning? A. recompile it B. rewrite its SQL queries C. relink D. rework the applications schema E. nothing; it is transparent
Which three statements about common and local roles are true? 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…
Which statement regarding Oracle Active Data Guard 12c is false? A. Any application compatible with a read-only database can run on an Oracle Active Data Guard standby. B. It provides new support for DML to global temporary tables and the…
Examine the command: sqlplus /nolog In which scenario would this command execute successfully? A. only from the server, if the database instance is not up B. from either a client or server, even if the database instance is not up…
John is a CDB administrator, and Mike and Tim are PDB administrators of their respective databases- John takes a complete CDB backup by using RMAN>Backup Database. Mike and Tim may need point-in-time recovery of their PDBs. Which statement is true?…