Database Administrator

To some extent, any software that we take advantage of will add to our learning and life. This blog will talk about how I feel when using Power Designer.   *************************　PowerDesignerCommon

SQL20321N was reported during a recent DB2 database migration. Scenario: a clean environment, just installed with DB2, is expected to migrate an old DB2 database to this point. Perform cold backup at the source end: Db2 backup db sundb to/db2sys

Catalog Database:Catalog indirect: db2 catalog database on/db2sys [dir_name]Catalog remote: db2 catalog database as at node example: db2 catalog tcpip node NODESUN remote 192.168.1.1 server 50000 ostype aix db2 catalog db SUNDB as SUN at node

27. Which two statements are true regarding tables? (Choose two .)A. A table name can be of any length.B. A table can have any number of columns.C. A column that has a DEFAULT value cannot store null values.D. A table and a view can have the same

28. Which two statements are true regarding constraints? (Choose two .)A. A foreign key cannot contain NULL values.B. A column with the UNIQUE constraint can contain NULL values.C. A constraint is enforced only for the INSERT operation on a table.D.

Granularity is one of the most important aspects of data warehouse design. Granularity refers to the level at which the data stored in the data unit of the Data Warehouse is refined or comprehensive. The higher the level of refinement, the smaller

By qx. zhongHangzhou 29 Jun 2014Development EnvironmentOS: Win8.1 x64JDK: 1.8 SEDB: MySQL 5.5 Lib: mysql-connector-java.jar1. Special correspondence between MySQL database data types and JDKThe following table lists only a few special value type

The DECODE function is one of the powerful functions of oracle pl/SQL. Currently, only oracle SQL provides this function, and other database vendors do not yet implement this function. What is the purpose of DECODE? First, let's construct an example.

Preface: Oracle is a typical C/S structure. The server provides oracle service instances, which are mainly used for database management, object management and storage, and data Storage, query, database resource monitoring, monitoring, and other

The field "automatic number" type changed in Access cannot be changed back! (Resolved) When the auto-increment field in access is changed to a value and then to an auto-increment field, the following message is displayed: After data is entered in

As the database data volume continues to grow, some tables need to be converted from normal heap tables to partition tables. There are several different methods for this operation, such as exporting table data, creating a partition table, and then

To ensure database integrity and consistency, You need to execute multiple SQL statements to achieve the desired purpose. In a one-to-many database relationship, such as the relationship between the card number category and card number. If you want

Use the exact numeric data type of integer data.BigintInteger Data from-2 ^ 63 (-9223372036854775808) to 2 ^ 63-1 (9223372036854775807) (All numbers ). The storage size is 8 bytes.IntInteger Data from-2 ^ 31 (-2,147,483,648) to 2 ^ 31-1 (2,147,483,64

10. View the Exhibit and examine the structure of the PROMOTIONS table. Each promotion has a duration of at least seven days.Your manager has asked you to generate a report, which provides the weekly cost for each promotionDone to l date.Which

Download the patch package p8202632_10205_linux-x86-64.zip from the cluster environment 10.2.0.5 or above this day. decompress the package and install the package. An error is reported during the process: I/O ERROR cannt reading or opening file

Create table student (id varchar2 (5) primary key, name varchar2 (20) not null, sex char (2) check (sex = 'male' or sex = 'female ')) -- insert a piece of data into student and use a function to verify whether the insertion is correct. create or

SQL> SELECT deptno FROM emp WHERE mgr = 7698 OR job = 'salesman' ORDER BY 1; DEPTNO ---------- 30 30 30 30 30SQL> SELECT deptno FROM emp WHERE mgr = 7698 2 UNION 3 SELECT deptno FROM emp WHERE job = 'salesman' 4 order by 1; DEPTNO ---------- 30SQL>

Create a primary key (example) SQL> alter table emp_ogg add constraint PK_empno primary key (empno ); -- Create a primary key Queries the constraints of a table.SQL> desc user_constraints;   Name Null? Type ---------------------------------------

The update operation nodes of GoldenGate are not synchronized.Fault description: synchronization cannot be implemented after update is performed on node 1 and node 2.Solution Process:1. Regular inspection: Check the Process status: normalGGSCI (gc1)

Brazil: tactical strategy: 4222 unshakable, no suspense in the main lineup The core system has no objection, 4222 complete explanation, and the system architecture is so clear World Top Team: Brazil Core database technology team: Oracle COACH: DBA