Database Administrator

User Logon Failed. This user is not associated with a trusted SQL Server connection. Error: 18452, sql18452 After installing SQLServer2005 (or the SQLServer2005 that comes with Visual Studio 2008), you can use SQL Server authentication to log on to

Configure PL/SQL Developer to connect to the server database, pldeveloperConfigure PL/SQL Developer to connect to the server database Install client software on the Remote Application Server, which can be downloaded from the official oracle website.

ORACLE not available, oracleavailableERROR Description: ERROR: ORA-01034: ORACLE not availableORA-27101: shared memory realm does not exist process ID: 0 session ID: 0 serial number: 0  Solution: 1. Execute [Oracle @ ay1401_135826z admin] $ sqlplus '

View the database again -- (2) view and database viewConcept * It is from the user's point of view on using the database. * Exported from one or more tables (Views) * A virtual table or a query table Why use a view? FirstSimpleAnd you can see what

An invalid column is inserted when MySQL inserts data. 1. Error description Com. mysql. jdbc. exception: jdbc4.MySQLSyntaxErrorException: Unknown column 'man' in 'field list' 2. Error cause Field in the database table: sno sname sage ssex

Typical Oracle query Cases 1. Create a student management database named student2. At least three tables are contained.S (SNO, SNAME) Student Relationship. SNO is the student ID, and SNAME is the nameC (CNO, CNAME, CTEACHER) Course relationship. CNO

Mysql Character Set settings Recently, I have been working on a mysql proxy project, which involves parsing SQL statements. I didn't know much about mysql before. As the project progresses, I had to make up for it. Today, I suddenly saw mysql's

Database naming rules 1Purpose Standardizes naming rules for various objects in the database. 2Database naming principles 2.1Data Files If the database uses a file system instead of a bare device, the following naming rules are agreed: 1) Data

A friend asked a question in the QQ group two days ago. The background is as follows: After continuing to ask, I have the following reply: 1. The connection to the other server is normal. 2. The slave client can telnet port 1521 of the server. 3.

1. The first connection string connecting to SQL SERVER: For the database Authentication Mode "SQL SERVER and windows, The connection string is: CString strConn; StrConn = "Provider = SQLOLEDB.1 ;\ Persist Security Info = true ;\ User ID = sa

14.Using the MERs table, you need to generate a report that shows 50% of each creditAmount in each income level. The report shocould NOT show any repeated credit amounts in each income level.Which query wocould give the required result?(Meaning: to

16.Evaluate the following query: SQL> SELECT promo_name q'{'s start date was }' promo_begin_date AS "Promotion Launches"FROM promotions;What wocould be the outcome of the above query? A.It produces an error because

6. Examine the structure of the SHIPMENTS table: Name Null Type PO_ID not null number (3) PO_DATE NOT NULL DATE SHIPMENT_DATE NOT NULL DATE SHIPMENT_MODE VARCHAR2 (30) SHIPMENT_COST NUMBER (8, 2) You want to generate a report that displays the PO_ID

7. Which two statements are true regarding the USING and ON clses in table joins? (Choose two .) A. Both USING and ON clses can be used for equijoins and nonequijoins. B. A maximum of one pair of columns can be joined between two tables using the ON

When we install RAC, sometimes the incorrect ASM instance or LISTENER is installed due to various errors, or the CLUSTERWARE resource is added, but it does not really work, such: The two nodes have created ASM1 and ASM2 instances respectively. The

MYSQL contains Blob fields, which is inconvenient to export and import. I will introduce how I did it. 1. Add a line at the end of MYSQL my. ini to configure max_allowed_packet = 100 M and restart the MYSQL service. Set the size of this value

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

Master xinju database-summer public welfare experience course 1. Do not miss out on DBAs (students) 1. the largest and most professional ORACLE software service provider in China: the organizer of this event, Shanghai xinju Network Technology Co.,

Problem description: [Celladmin @ vrh4 ~] $ CellcliCellCLI: Release 11.2.3.2.0-Production on Sat Jun 14 09:11:08 EDT 2014 Copyright (c) 2007,201 2, Oracle. All rights reserved.Cell Efficiency Ratio: 1 CellCLI> create celldisk all CELL-02559: There

Source: http://blog.csdn.net/dba_huangzj/article/details/31374037 reproduced Please reference I have seen a discussion on in/exists in the forum. I am too lazy to find the original post. Here I will introduce the recent study summary: Not in and