ITPub博客

OCP证书的含金量Oracle和MySQL数据库是世界上最流行的两种数据库，根据数据库权威网站db-engines的排名，这两种数据库是唯一超过1000分的两种数据库。对于IT人士，这两种数据库是必须掌握的技能。掌握一门技术最好的方法是考一个认证。Oracle公司针对这两门数据库推出了OCP认证。自OCP认证进入中国以来，越来越被大多数DBA所认可，也越来越被企业所重视，90%以上DBA深造，都会

7 、Which three actions will add a resource to an Oracle Restart configuration? A)creating a database service using Oracle Database Configuration Assistant(DBCA) B)creating a disk group using

51.View the Exhibit and examine the description of the tables You execute this SQL statementWhich three statements are true?A.The sales table has five foreign keysB.The statement will execute successf

36.Examine this commandWhich two statements are true?A.DML,  may  be  performed  on  tables  with  one  or  more  extents  in  this  da

30.Which three are types of segments in an Oracle Database? A.clustersB.sequences C.stored procedures D.viewsE.undoF.tables答案：AEF31.Which two statements are true about the SET VERIPY ON

24.Which three statements are true regarding the UNION and UNION ALL operators?A.The number of columns selected by the first SELECT statement can be greater than the number selected in subsequent SELE

19.Which three statements are true about Deferred Segment Creation in Oracle databases? A.It is the default behavior for tables and indexes.B.It is supported for sys-owned tables contained in loc

13.Which three statements are true about the naming methods and their features supported by Oracle database used to resolve connection information?A.Directory Naming can be used if Connect-Time Failov

7.Which three statements are true?A.The second ROLLBACK command restores the row that was inserted B.The first ROLLBACK command leaves the inserted row lockedC.The second ROLLBACK command restore

1、Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases?A)Space is only reclaimed when there is space pressure in the Fast Recovery Area(FRA)B)Spac

考试科目：1Z0-082考试题量：90通过分数：60%官方考试说明：https://education.oracle.com/产品目录-ouexam-pexam_1z0-082/pexam_1Z0-0821.Which two statements are true about space-saving features in an Oracle Database? A.An index

考试题量：85通过分数：62%官方考试说明

数据库机器的CPU和主板都换了，重新开机，发现mysql数据库无法启动！Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint  .... and ...这个问题出

在本地主机sshd的配置文件/etc/ssh/sshd_config加两行 X11Forwarding yes  X11UseLocalhost no如果这两个参数已经存在，注意观察对应的值是否正确。然后重新启动服务让它生效： systemctl restart sshd有时是sshd的后台进程有问题，用ps -ef 查一下，可能要重新启动。还不行就是系统

bind-address如果是127.0.0.1，mysql只接受localhost，不接受远程连接。在bind-address后面增加远程访问IP地址或者禁掉这句话就可以让远程机登陆访问了。在配置文件里面加入bind-address    = 127.0.0.1，然后重新启动，可以看到下面监听地址的变化。root@scutech:~# netstat -p

检查 MySQL 数据库的启动时间Linux 系统中的 systemd 和 mysqld_safe 会在 mysqld 进程 crash 后自动重新启动 MySQL 的服务，需要注意的是使用 kill -9 杀死 mysqld 进程系统会自动重新启动，而只使用 kill 命令则不会重新启动，因为执行 kill 命令，系统会发送一个 SIGTERM 信号给 mysqld，mysql 数据库会正常关闭

[oracle@localhost ~]$ /u01/app/oracle/product/version/db_1/bin/sqlplus -bash: /u01/app/oracle/product/version/db_1/bin/sqlplus: Structure needs cleaning [oracle@localho

数据库恢复后打开时遇到 ORA-01152数据库恢复后打开时遇到：RMAN> alter database open resetlogs; ...... ORA-01152: file 1 was not restored from a sufficiently&nbs

fdisk不能创建大于2T的分区，创建大分区得用parted，我在用parted创建分区时遇到下面的警告提示：# parted /dev/sdb (parted) mkpart primary 0 100%           

MySQL建表时指定另外一个目录，结果出错：mysql>  create table t1 (id int primary key,n varchar(10)) data directory='/home/mysql/data'; ERROR 1030&n