-
编辑 删除
scp的简单问题
scp -r 10.31.0.186:/home/lijiebin/a.txt b.txt我想把186这台机器的密码不用手工输入,直接写在命令行中,怎么写呢,假如密码为pwd
-
编辑 删除
啊啊啊,db_buffer可以不用重起吗
You work as a database administrator for Certkiller .com. In your production database, the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances...
-
编辑 删除
先写归档日志吗?
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which two steps are performed the first time any UPDATE statement is issued after the instance is started? Choose two A. Creating the ...
-
编辑 删除
请问这个shell怎么实现
column cdkau new_value filename;select substr(to_char(sysdate,'yyyymmddhh24mi'),1,8) cdkau from dual; spool /home/lijiebin/lijie&&filename..txt........我每天都运行a.sql的脚本产生文件名为lijie200...
-
编辑 删除
考试拉.传授点经验吧
学习oracle已经很长时间了,这个2周准备去考试oca多少题啊,2个小时内能做完吗怎么把握做题的速度呢?
-
编辑 删除
warehouse 请问temporary table可以创建index 和view吗
Which three statements are correct about temporary tables? (Choose three.) A.Indexes and views can be created on temporary tables. B.Both the data and the structure of temporary tables can be export...
-
编辑 删除
10g analyze都啥时候啊
QUESTION 144: In your Oracle 10g database , you have scheduled a job to update the optimizer statistics at 05:00 pm every Friday. The job has successfully completed. Which three pieces of informatio...
-
编辑 删除
10g的dbca有这个功能吗
While setting up an Oracle database for one of your critical applications, you want to ensure that the database is backed up at regular intervals without your intervention. What should you do to achi...
-
编辑 删除
看这题
Which is the correct sequence of steps that you would foiiowto recover the control file? 1.Shut down the instance, if not already done. 2.Copy one of the remaining control files to a new location. ...
-
编辑 删除
042这题
这题的答案对吗?QUESTION 101: Which two statements about Flashback Query are true? (Choose two.) A.It is generated by using the redo log files. B.It helps in row-level recovery from user errors. C...
-
编辑 删除
cbo认为num_rows为多少的表为小表啊
真不好意思啊,哪为大侠告诉我一下吧
-
编辑 删除
042新题库
快要考试了,谁有042的新题库,可以给我一份吗,万分的感谢我的油箱lijiebinjing@163.com
-
编辑 删除
042第160题
QUESTION 160: You execute the following set of commands to create a database user and to grant the system privileges in your production environment. SQL> CREATE USER user01 IDENTIFIED BY oracle ...
-
编辑 删除
042
Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled and database activity is halted. Database write...
-
编辑 删除
042题
一个表insert 一条记录和delete同样一条记录两个操作,哪个占用undo大呢?为什么
-
编辑 删除
关于cbo
如果optimizer_mode=choose,那么让优化器只用rbo,而不用cbo吗??
-
编辑 删除
哪个最快
select a.key from a,b where a.key=b.key输出结果为700万行a为1000万行,b为800万行的表a的key,和b的key都是唯一索引上面的查询,a走索引,b不走a走,b走a不走,b走a,b都不走...
-
编辑 删除
还能优化吗
使用oracle 输出文本文档表a,1亿行spool /home/lijiebin/a.txtselect * from a跑了半天没反应啊有什么可以变快的方法吗?
-
编辑 删除
和时能象db一样
这个周又要搬家了啊房子还没找好何时能象db一样,不时常的迁移呢?何时能象db一样,有个高可用的地方住呢?
-
编辑 删除
imp问题
[oracle@local daily]$ imp taa/gasd@wow ignore=y fromuser=lijiebin touser=taa file=/ftp/daily/pay31.dmp tables=temp_pay_charge_history_daily Import: Release 9.2.0.5.0 - Production on Tue Nov 6 15:3...
