NAV: SLTechnology News&Howtos > Database >

• 

  Database of written examination interview questions (Oracle, MySQL, etc.)

  Database written interview questions database (Oracle, MySQL, etc.) copyright notice: all rights reserved, welcome to share this article, reprint please keep the source, otherwise pursue legal liability, thank you for your cooperation. Note: this article will be updated continuously, you can follow the author's official account of Wechat to get the latest written interview materials. Thank you very much.

  2022-06-01 12:26:03 Views: 285
• 

  Windows xp installs xmanager connects to linux redhat system through Telnet service and installs oracle10g

  First, query the linux system side to see if the telnet service is started, and if not, start it: install the gpm package yum install gpm (if you set up the xmanger package required to install the oracle10G database)

  2022-06-01 12:25:59 Views: 261
• 

  MSSQL Universal restore script

  MSSQL restore script SQL Server generic restore script. Just modify the database name and path that need to be restored in the second step. After the script is executed, the corresponding restore command will be generated. You can directly create a query and execute it-- 2-Initialize variab.

  2022-06-01 12:25:56 Views: 239
• 

  The second part of T-SQL query statement (multi-table query)

  T-SQL query sentence summary security code: where there is a will, there is a way, burn the boat, hundred and two Qin Guan end belongs to Chu case 6: the table is shown in the database as shown below: experimental requirements: 1, two tables query select student table. Name, student table 1. Telephone, student table 1. Home address fro

  2022-06-01 12:25:25 Views: 282
• 

  Hadoop hbase failed to start

  Start hbase error could only be replicated to 0 nodes instead of 1hmaster can not start up to check a lot of similar problems, most of the way we deal with is more violent. Because it is a test environment

  2022-06-01 12:25:25 Views: 282
• 

  Log types in MySQL (1)-Common characteristics of digests and logs

  The log type MySQL in MySQL has a variety of logs to record the activity of mysqld. The following are the types in MySQL and their brief descriptions. The log type indicates that the General query log records the connection and statement Slow obtained from the client

  2022-06-01 12:24:55 Views: 285
• 

  Upgrade zabbix2.4 version to version 3.2

  Zabbix3.2 version of the source code has been installed, the current version 2.4 upgrade to version 3.2 operation, only need to export 2.4 database backup, and then import it into the 3.2 version of the database. 1. Stop zabbix-related services service zabbix_

  2022-06-01 12:24:55 Views: 236
• 

  MySQL database-master master replication + keepalived high availability

  MySQL database-Master replication + keepalived highly available before we learned mysql master-slave replication, mainly in the working environment to prevent database read and write on a database is easy to cause load, to achieve read-write separation is to reduce the work pressure on the server,

  2022-06-01 12:24:55 Views: 203
• 

  Environment configuration of oracle-directory structure after Oracle installation

  Directory structure after Oracle installation [oracle@oracle3 admin] $cd / u01/oracle [oracle@oracle3 oracle] $ll Total 20drwxr Murray-3 ora

  2022-06-01 12:24:54 Views: 222
• 

  Database MYSQL Learning Series II

  Database MYSQL learning series II. MySQL database objects and applications 2.1-MySQL data type Number there is more than one × × floating point × × INT SMALLINT MEDIUMINT BIGINTty

  2022-06-01 12:24:54 Views: 218
• 

  Tips for deleting DROP from large tables

  In daily work, we often encounter the migration of large historical tables from the main database to the backup machine to free up the main database space. If you directly drop table, it may cause database jitter, increase in the number of connections and other problems, thus affecting the business. So with a little trick, you can easily and smoothly learn from

  2022-06-01 12:24:53 Views: 276
• 

  SQL Server database mirroring based on availability group failover

  SQL Server database mirroring based on availability group failover Microsoft introduced database mirroring in SQL Server 2005 and quickly became a popular failover solution. A big problem with database mirroring is that failover is based on the database level, so

  2022-06-01 12:24:46 Views: 279
• 

  [reading notes] ORACLE database file management

  Database files include data files, log files, control files and password files, parameter files and so on. The management of these files can be regarded as a process of adding, deleting, changing and checking. 1. Data file management added: add data file create tablespace test_ when adding tablespace

  2022-06-01 12:24:45 Views: 297
• 

  Sqlsever judgment time interval

  Declare @ app_change_web_start nvarchar, @ app_change_web_end nvarchar, @ now nvarchar set

  2022-06-01 12:24:22 Views: 236
• 

  Use scrapy to easily climb Douban 9-point list books and store them in mysql database

  Note: most of the content refers to http://www.cnblogs.com/voidsky/p/5490798.html, but the original text is not stored in the database. First create a project douban9fenkuku@ubuntu:~/p

  2022-06-01 12:24:22 Views: 223
• 

  Oracle uses impdp to import database error report under centos 6.6!

  Oracle rookie, if you encounter a problem, please take a look at the environment: 1. Centos6.62, newly installed oracle 11gR23, using impdp to import other databases reported errors [oracle@BJ-BoHua-AssetsT]

  2022-06-01 12:24:22 Views: 281
• 

  Sybase Msg 3101: Database in u

  [sybase@cnpm_server ~] $isql-Usa-P123456781 > use master2 > go1 > load database smss from'/ opt/sybas

  2022-06-01 12:24:18 Views: 236
• 

  Install mariadb and allow remote access

  Download mariadb:yum-y install mariadb-server mariadb to enable mariadb service: systemctl start mariadb login mariadb:mysql without password

  2022-06-01 12:24:18 Views: 291
• 

  Database connection

  Database connection and disconnection: Connection conn=Jdbcutil.open (); Jdbcutil.close (conn); package database. To connect; import java.sql.*;publi.

  2022-06-01 12:24:18 Views: 296
• 

  Double master configuration of master-slave synchronization in mysql database-mutual master-slave

  Mysql database replication principle: on the whole, replication has three steps: (1) master records changes in binary log (binary log) (these records are called binary log events, binary log events); (2) sla

  2022-06-01 12:24:18 Views: 254