oracle ocp

When creating a unique constraint, the OCP will forcibly create or reuse the index www.2cto.com (if no index exists in the previous column, the created index is a unique index. In this case, the index name and the constraint name are the same, and the index cannot be deleted. When unique constraint is deleted, unique index is cascaded. ② If an index already exists in the column, the previous index will be reused without changing the index type. When w

Analysis of OCP question _ 007: synonym synonyms are the alias of the base table. They are defined only in the data dictionary. They do not store synonyms. They provide location transparency for distributed databases. Accessing resources in different regions is just like accessing local resources. www.2cto.com (I) Syntax:Private synonyms without public are the synonyms created by common users. They are private, this is because only the user who create

OCP question parsing _ 043: flashback transaction query can obtain the historical information of the specified transaction from FLASHBACK_TRANSACTION_QUERY and Undo_ SQL through this UNDO_ SQL, query the operations performed by a specific firm, and then we can restore specific transactions. flashback transaction query test www.2cto.com OCP question: [SQL] 13. you executed the following query: SELECT operati

The database has opened OCP notes. Thank you very much for the blog. Thank you. I _like_cpp http://blog.csdn.net/ I _like_cpp Among them, OCP has a question like this: Q606. you realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery? A. Mount the database B. Open the

The five principles of OO refer to SRP, OCP, LSP, DIP, ISP.Open Closed Principle is the most basic design principle in the Java world, which guides how we build a stable and flexible system.Defined:A software entity such as classes, modules, and functions should be open to extensions and closed for modification.Softeware entities like classes,modules and functions should is open for extension but closed for modifications.The opening and closing princi

Design principles (1) "Open-Close" principles (OCP) The cornerstone of classical mechanics is Newton's three major laws. The first cornerstone of object-oriented reusable design is the so-called Open-Closed Principle (OCP ).I. What is the principle of opening/closing? The principle of "open-close" is that a software entity should be open to expansion and closed to modification. This principle was first prop

Opening and closing principle OCP (Open for extension,closed for modification). The core idea of open and close principle is that an object is opened to expansion and closed to modification. In fact, the opening and closing principle means that changes to the class are made by adding code rather than altering the existing code. In other words, once the software developer writes out the code that can be run, it should not change it, but to ensure th

Preface in this chapter, we will explain part 1 of the Five Principles of S.O.L. I. D: Implementation of JavaScript language, and the principle of open/closed OCP (TheOpen/ClosedPrinciple ). The open/closed principle is described as follows: Softwareentities (classes, modules, functions, etc.) shound... PrefaceIn this chapter, we will explain part 1 of The Five Principles of S.O.L. I. D: Implementation of The JavaScript language, and The Principle of

traveler and the method of arriving is very close, and the specific way to arriving is a low level problem. The above problems and implementation are a common method to achieve the [open and closed principle]-The Policy mode. There is also a common implementation method: Template Method. In fact, the essence of these two methods is the combination of object-oriented methods. And inheritance. We have learned how to encapsulate changes. How can we encapsulate changes? Mastering this skill i

Open-closed principle Software"Open-Close principle" in Design" This principle was first proposed by Bertrand Meyer.Entities shocould be open for extension, but closedModification. It means that a software entity should be open to extensions and closed to modifications. That is to say, when designing a module, we should enable this module before it is not modified.Extension. In other words, you do not need to modify the source code.To change the behavior of this module. Satisfying the

TCL: transaction control language, such as commit and rollback PLSQL: Provides object-oriented support. You can call C to manipulate the hardware. When called, PLSQL is put into the library cache in the share pool.PLSQL StructurePackagePackage body (the pakage body can be encrypted to protect the property rights of PLSQL)Differences between trigger and function:Trigger is automatically triggered, while function is manually called, and function must return values.Package is generated when packag

OCP question analysis _ 007: sequence can be designed to be unique, but continuous instances cannot be implemented. sequence disconnection number, transaction rollback, sequence disconnection number, concurrent access, sequence may be disconnected ...... www.2cto.com calls seq_name.currval, the returned result is the returned value of seq_name.nextval, which is the last time seq_name.nextval is called in this session. Therefore, when seq_name.currval

user creates a private synonym in his/her own mode, the user must have the create synonym permission; otherwise, the user cannot create a private synonym.② If you want to create a synonym in other modes, you must have the create any synonym permission.③ Create public synonym system permission is required to create a public synonym.(Iv) OCP questions Q: 16 Mary has a view called EMP_DEPT_LOC_VU that was created based onthe EMPLOYEES, DEPARTMENTS, an

Preface In this chapter, we will explain part 1 of The Five Principles of S.O.L. I. D: Implementation of The JavaScript language, and The Principle of Open and Closed OCP (The Open/Closed Principle ). The opening/closing principle is described as follows: Software entities (classes, modules, functions, etc.) shocould be open for extension but closed for modification. Software entities (classes, modules, methods, etc.) should be open to extensions and

the field header has a double-reference, and the rules for using the two-argument are as follows: 1. Suppose that the field name is composed of multiple words, with spaces in between, such as new credit Limit. You must add a double argument, or you will get an error.2. Assume that the title name is a word or multiple consecutive words. Assume no double-quotes. The format of the output is completely uppercase, such as option A, the name is output.Assuming that the plus and minus arguments are

Reclaim tables and IndexesResumable: if there is not enough space, it will be suspended for dBA for 2 hours, rather than directly reporting an error and exiting normally.If you can proceed, it will be suspended. Space management and local zone managementThe Oracle mechanism maps the usage of data files and stores them in the headers of the data files.In the EM manager, you can view the table space contents. Active maintenance:Severe warning: Warning i

tablespace is required to be in the offline state."Experiment"1. Modify the database to archive mode[[emailprotected] ~]$ sqlplus/as sysdbasql*plus:release 12.1.0.1.0 Production on Mon 14:58:41 2014Copyrigh T (c) 1982, Oracle. All rights reserved. Connected to an idle instance. [emailprotected]> Startuporacle instance started. Total System Global area 2121183232 bytesfixed size 2290360 bytesvariable size 1308626248 bytesdatabase Bu Ffers 805306368 B

release 'default' optimize for load true; # DEFAULT Configure archivelog deletion policy to none; # default Configure snapshot controlfile name to '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_testdb.f'; # default RMAN> Backup database plus archivelog delete input; Starting backup at 19-DEC-13 Current log archived Using channel ORA_DISK_1 Channel ORA_DISK_1: starting archived log backup set Channel ORA_DISK_1: specifying archived log (s) in bac

Smon System Monitoring ProcessRole: Recovery of instances--1, roll forward changes in all redo logs2. Open the database for users to access3. Rollback of Things not submitted--instance recovery does not require DBA action and is automatically completed by Oracle-After the Startup force command is executed, an instance recovery operation is performed--Related commands:ALTER DATABASE Archivelog;Shutdown mountShutdown immediateStartup MountError: Error a

, Then repairs any response upt blocks recorded in the View: Backup validate database; blockrecover upload uption list; 187. you are managing an Oracle Database 11g Database. you want to take a backup on tape drives ofthe users tablespace that has a single data file of 900 MB. you have tape drives of 300 mb each. to accomplish the backup, you issued the following RMAN command: RMAN> Backup section size 300 mtablespace users; What configuration shosh