oracle ocp

Database DBA tasks:Managing Database AvailabilityDesign and create a databaseManaging Physical structuresManaging design-based storageManaging SecurityNetwork managementBackup and recovery (focus, difficulty)Database Tuning and optimization (focus, practice)First, overview:1, the composition of the relational databaseThere is a management between multiple tablesRelationships are used to describe data dependencies between multiple tables, including a pair of one or one-to-many, many-to-many relat

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 File:///G:/book/Oracle/E11882_01/server.112/e18951/asmdiskgrps.htm#CHDIABGJ Disk Group Attributes Disk group attributes is parameters that is bound to a disk group, rather than an Oracle ASM instance.Disk group attributes

------------------------------------------------------------------------------------------------------------------------------------------------------------------- Sid username status machine CLIENT_INFO1 70 sys inactive workgroup \ IDYLAN id = RJB rman session [Official documentation] Command id'String' Enters the specified string into the V $ SESSION. CLIENT_INFO column of all channels. use this information to determine which Oracle

"indicator. A statistic is an original number, which may be useless. An indicator is a statistical value that has been converted to make sense. 2.1 use the dynamic performance view to view statistics Oracle provides about three hundred dynamic performance views. Their names all have the "V $" leading edge, but these views are not views at all. They are used as synonyms of views whose leading edge is "V _ $.? { Copycode ('p632code2 '); } "Href =" java

1. backup and recovery problems The final result of considering business needs, performance, and capital costs is usually a compromise. It is extremely important to record this scheme, usually in the form of a service level agreemenet ). The service level agreement is related to backup and recovery in three aspects: Mean Time (mean time Betwwen failures, MTBF) Mean time to recover (MTTR) Data Loss The goal of DBA is to increase MTBF while reducing MTTR and data loss. MTBF refers to the freq

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 temporary files, or directly create a temporary tablespace group using multiple temporary tablespaces (this is a new feature of 10 Gb). If a temporary tablespace is lost,Oracle will automatically find an av

the dept_20 table in addition to the REFERENCES constraint. Before you define and enable this constraint, you must define and enable a constraint that designates the department_id column of the orders table as a primary or unique key. The foreign key constraint definition does not use the foreign key clause, because the constraint is defined inline. the data type of the department_id column is not needed, because Oracle automatically assigns to this

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 URL:Http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html (current version is 4.0.3.16.84 2015/1/2) Platform Windows 64-bit -zip file includes the JDK 7 Download 311 M Windows 32/64-bit - installation Notes Do

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 of expression 1 is returned. Note: expression 1 and expression 2 should be of the same data type or can be implicitly converted to the same data type. Expression 1 cannot use the character null. Www.2cto.com

recreate the lost files.Clear, which is equivalent to clearing the log file and recreating it.When the log file of the connected machine is deleted, alert. log will report an error alert.Loss of a redo log fileIf a member of a redo log file group is lost, as longThe Group still has at least one member, then:• The normal operation of the instance is notAffected.• You receive a message in the Alert Log policyingYou that a member cannot be found.• You can restore the missing log file by droppingTh

statement. this option also drops any dependent object segments associated with the partition being truncated. Drop all storage is not supported for clusters. Note: This functionality is available with Oracle Database 11g release 2 (11.2.0.2). truncate table emp drop all storage;Reuse storage specifies that all space currently allocated for the table or cluster remains allocated to it. for example, the following statement truncates the emp_dept clu

escaped as true single quotes.Third single quotes: single quotes indicating the actual outputThe fourth single quotation mark indicates that the string ends.For example:SQL> select ''' name from dual; N-'SQL> select 'camera's category is Photo 'name from dual; NAME--------------------------Camera's category is Photo In addition, Oracle provides a Q-quote expression to simplify the expression of strings in SQL or PLSQL. The format is Q' [Camera's cate

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 dumpfile during the export operation. 3. About invalid IndexesWill be ignored by the optimizer;It can only take effect through rebuild. 4. About listenersMultiple listeners can run on one host;Multiple datab

1,OracleOfficial preparations recommended by the company Generally speaking, Oracle has a lot of examination content, and the examination questions are also very detailed, it has a strong requirement on hands-on ability. Therefore, in order to be sure, we must make full preparations in advance, and pay attention to hands-on practices. The following authentication methods are recommended on the official Oracle