oca ocp

12. You need to produce a report where each customer's credit limit has been incremented by $1000. InThe output, the customer's last name shoshould have the heading Name and the incremented credit limitShocould be labeled New Credit Limit. The

13. View the Exhibit and examine the structure of the PRODUCTS table. You need to generate a report in the following format:CATEGORIES5MP Digital Photo Camera's category is PhotoY Box's category is ElectronicsEnvoy Ambassador's category is

1 about undoThe database can have more than one undo tablespace;Undo segments can automatically grow, shrink on demand 2 about Oracle Data Dump export and importYou can change the table name during the import operation;You can override an existing

Exercise 2-1 Installing SQL Developer on a Windows computerIn this exercise, you will install SQL Developer on a Windows computer1. Download the current SQL Developer version from the following

5. Which SQL statements wocould display the value 1890.55 as $1,890.55? (Choose three .) A. Select to_char (1890.55, '$0g000d00 ') From dual; B. Select to_char (1890.55, '$9, 999v99 ') From dual; C. Select to_char (1890.55, '$99,999 d99 ') From dual;

4. Which two statements are true regarding single row functions? (Choose two .) A. They a ccept only a single argument. B. They can be nested only to two levels. C. Arguments can only be column values or constants. D. They a lways return a

1. view the exhibit and examine the structure of the sales, MERS MERs, products, and times tables. The prod_id column is the foreign key in the sales table, which references the Products table. Similarly, the cust_id and time_id columns are also

1. null if nvl nvl2 Nullif Function The syntax of the Oracle nullif function is nullif (expression 1, expression 2). If expression 1 and expression 2 are equal, a null value is returned. If expression 1 and expression 2 are not equal, the result

Whole database = full database + control file + archive log fileInstance recovery (system power loss)Media recovery (delete file, damaged media, DBA intervention required) Database crash:All the Members in the redo group are corrupted and crash is

OracleRestore from unimportant file loss 1. Temporary File loss, data will not be down, but an error will only be reported in alert. LogSelect * from V $ tempfile; view temporary files How to solve the problem of temporary file loss:You can add new

Definition: A software entity such as classes, modules, and functions should be open to extensions and closed for modification. The problem: in the lifecycle of the software, changes, upgrades, and maintenance, for reasons that require

QUESTION 169 When starting up your ASM instance, you receive the following error: Sql> Startup Pfile=?/dbs/init+asm.ora ASM instance started Total System Global area 104611840 bytes Fixed Size 1298220 bytes Variable Size 78147796 bytes ASM Cache 2516

This is a written exercise with no specific solutions.Determine which applications, application servers, and databases are used by your environment. Then focus on the database and experience the size and busyness of the database. Consider the number

154.which statement is true about a scheduler-generated event? B.it indicates state changes that occur within the scheduler itself 158.which Two statements are true about an image copy backup? A.It May is taken to disk C.it would contain all used

Evaluate the following command:  CREATE TABLE employees (employee_id      number (2) PR Imary key,  last_name        VARCHAR2 (+) not null,  department_id     Number (2) not null,  job_id           VARCHAR2 (8),  salary        number (10,2)); You

173.Which of the following is not a configurable attribute for a individual disk group? A. au_size B. COMPATIBLE. Rdbms C. COMPATIBLE. Asm D. Disk_repair_time E. Dg_drop_time Answer:e

QUESTION 8 Your multitenant Container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find the Sysaux tablespace are corrupted in the root container. The steps to recover the tablespace is as follows:1. Mount the

Oracle learning records: RMAN backup/recovery process oracle learning records, RMAN usage, backup and recovery. (1) create tablespace cata datafile 'cata01. dbf 'size 200 m; -- cata01.dbf is in/oracle/db11g/dbs by default (2) create user kata identified by oracle default tablespace cata; (3) grant user permissions to grant connect, resource, recovery_catalog_owner to kata; (4) Create an archive www.2cto.com $ ORACLE_SID = OCA $ sqlplus sys/oracle as s

/temp01.dbf ' reuse;Scenario 3: Rebuilding with read-only data filesStartup Nomount;CREATE controlfile Reuse DATABASE "Bxdb" Noresetlogs ...Recover database; --recover database using Backup controlfile;ALTER DATABASE open; --alter database open resetlogs;Alter DATABASE rename file '/u01/app/oracle/product/11g/dbs/missing00005 ' to '/u01/app/oracle/oradata/bxdb/tp2.dbf ';Alter Tablespace TP12 Online; --Cannot set up data file online (ALTER DATABASE datafile 7;)ALTER tablespace TEMP ADD tempfile '

local disk devices, managing file systems, installing and removing Solaris packages and patches, optimizing system startup processes and system processes. This is the first step in getting the OCP certification series. The OCA certification is known for its predecessor, Sun Certified Solaris Associate (Scsas). Authentication code: OCA Topic Type: 75 multiple Cho