ITPub博客

QUESTION 111Which two statements are true about checkpointing? (Choose two.)A. The checkpoint frequency decreases with the smaller redo log file size.B. It ensures that all committed data is written to the data files during normal shutdown.C. The frequent full checkpoint in a database can cause ...

QUESTION 195Which two statements describe good practices for an application developer to reduce locking conflicts in Oracle database? (Choose two.)A. Avoid coding unnecessary longrunning transactions.B. Allow the database to handle locks in default locking mode.C. Always explicitly code the lock...

QUESTION 193In which situations does the Oracle Data Pump use external tables and not the direct path load while exporting a table? (Choose all that apply.)A. if a table is not in a clusterB. if a table has an active triggerC. if a table has an encrypted columnD. if a table has a column of data...

QUESTION 21View the Exhibit and examine the privileges granted to the SL_REP user.The EMP table is owned by the SCOTT user. The SL_REP user executes the following command:SQL> GRANT SELECT ON scott.emp TO hr;Which statement describes the outcome of the command?A. The command executes successf...

QUESTION 18Which two statements are true about alerts? (Choose two.)A. Clearing an alert sends the alert to the alert historyB. Response actions cannot be specified with server-generated alertsC. The nonthreshold alerts appear in the DBA_OUTSTANDING_ALERTS viewD. Server-generated alerts notify ...

QUESTION 141Which tablespaces are mandatory in an Oracle database for it to be operational? (Choose all that apply.)A. Undo tablespaceB. USERS tablespaceC. SYSAUX tablespaceD. SYSTEM tablespaceE. Temporary tablespaceCorrect Answer: CD参考：http://blog.csdn.net/rlhua/article/details/122331...

QUESTION 16Which two statements are true regarding Oracle Data Pump? (Choose two.)A. EXPDP and IMPDP are the client components of Oracle Data PumpB. DBMS_DATAPUMP PL/SQL packages can be used indedendently of the DATA Pump clientsC. Oracle Data Pump export and import operations can be performed o...

QUESTION 13Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)A. Failure when no standby database is configuredB. Failure because a data file is renamed accidentallyC. Failure that requires no archive logs to be applied for recoveryD. Fail...

QUESTION 197These are points that describe the contents of different memory components:1: Descriptive information or metadata about schema objects that are queried by using SQL statements2: The runtime area for data manipulation language (DML) or data definition language (DDL) statements3: Resul...

私拉乱接导致网络打印机故障接客户报告，多台网络打印机故障，不能正常打印。首先检查打印机，面板按键没有反应；断开打印机网络，面板按键反应正常。不接网络，通过USB线直连电脑，打印机工作正常。因有多台打印机均出现类似故障现象，初步排除打印机自身故障，怀疑是网络问题导致。接上笔记本，检查电脑上网情...

前二天，一台测试设备需要更换正式设备，因是同一系列的设备，考虑备份原设备的配置信息，再直接导入到新设备，一节省时间，二可以保证配置不变。没想到，在进行导入时，报系统软件版本不同，配置信息不能导入。咨询厂商工程师，答复是可以先对旧设备升级软件版本，再导出配置后在新设备上导入。设想一下这样的场景：...

对于Oracle的JDBC连接，是支持EZ-Connect写法的，即jdbc:oracle:thin:@Server:1521/Database但对于Oracle 11gR2 RAC系统，如果Server用了ScanName，Database用了数据库的ServiceName，并不能连接到数据库，而是报SID错误。原因可能是此种写法，JDBC将Database解析为了数据库的SID。经多方测试，可用如下写法实现11GR2...

Linux环境安装Oracle RAC，使用UDEV来绑定共享磁盘设备，使用如下命令创建绑定规则：for i in a b c;do    echo "KERNEL==\"sddlma*\",SUBSYSTEM==\"block\", PROGRAM==\"/sbin/scsi_id --whitelisted--replace-whitespace --device=/dev/\$name\", RESULT==\"`/sbin/scsi_id--whitelisted...

net share命令，是Windows系统中查看和设置共享文件和目录的，但在Windows Server 2008R2和2012中，PowerShell和CMD中都可以执行，但对/grant选项，PowerShell并不支持，而且报错提示有些雷人，一直报命令格式错。PSC:\Users\Administrator> net share nu=c:\users /grant:everyone,full此命令的语法是: ...

RHEL 6.4 X64系统，安装HDLM多路径软件，报如题错误。[root@I05-DB-SRV01 ~]# mount -o loop /u01/software/DLMGLM_076001.iso /mnt[root@I05-DB-SRV01 ~]# cd /mnt[root@I05-DB-SRV01 mnt]# ll总用量 110-r-xr-xr-x.  1 root root    67 10月  6 2011 Autorun.inf-r--r--r--.  1 root roo...

SQL Server 2012 AlwaysOn，提供了一主多副的实时数据的读写分离功能，通过配置只读路由，可以实现实时数据的读写分离。关于SQL Server 2012 AlwaysOn的配置，网上有很多资料可供参考，在此不作介绍，下面谈谈在实际使用中的一些体会和想法：1、关于数据库连接的附加参数：ApplicationIntent要访问SQL Server...

原文：http://technet.microsoft.com/zh-cn/library/ms366279.aspx AlwaysOn可用性组或数据库镜像不支持跨数据库事务和分布式事务。 这是因为以下原因无法保证事务的原子性/完整性： l  对于跨数据库事务：每个数据库独立提交。因此，即使对于单个可用性组中的数据库，在一个数据库提交事务后、但...

 2014年5月16日客户一直反映，网络丢包情况比较严重，影响正常的业务工作，必要时只能断开所有内部网络，保证部分重要的业务运转。根据故障现象分析，初步诊断为三个问题：一是网络流量大，超过了网络带宽限制；二是网络流量中有大量P2P流量，连接会话数超过了出口设备的能力；三是出口设备性...

 日前，客户附加一SQL Server数据库，提示错误，错误信息如下：    查服务器内部数据库引擎日志：Could not open File Control Bank (FCB) for invalid file ID 2 in database 'InfoManager'. Verify the file location. Execute DBCC CHECKDB.从文件名来看，并不是常用压缩...

 对于不同网段的服务器之间，还存在服务器名解析问题。l  (2.2.6)链接服务器和名称解析问题建立链接sql server服务器，通常有两种情况:u  第一种情况，产品选”sql server”EXEC sp_addlinkedserver @server='linkServerName',@srvproduct = N'SQL Server'这种情况@server(linkServe...