DBA面试题

当前位置: 面试问题网 > DBA面试题 > Oracle Certification Program (OCP认证)的题目

Oracle Certification Program (OCP认证)的题目

(1) A 表中有100条记录.
     Select * FROM A Where A.COLUMN1 = A.COLUMN1
     这个语句返回几条记录? (简单吧,似乎1秒钟就有答案了:)
     (2) Create SEQUENCE PEAK_NO
     Select PEAK_NO.NEXTVAL FROM DUAL –> 假设返回1
     10秒中后,再次做
     Select PEAK_NO.NEXTVAL FROM DUAL –> 返回多少?
     (3) SQL> connect sys as sysdba
     Connected.
     SQL> insert into dual values ( ‘Y’);
        1 row created.
     SQL> commit;
        Commit complete.
     SQL> select count(*) from dual;
        COUNT(*)
        ———-
        2
     SQL> delete from dual;
        commit;
        –>DUAL里还剩几条记录?

【Oracle Certification Program (OCP认证)的题目】相关文章

1. Oracle Certification Program (OCP认证)的题目

2. 什么是Oracle的后台进程background processes?都有哪些后台进程?

3. 什么是Connection-oriented Protocol/Connectionless Protocol面向连接的协议/无连接协议

4. ORA-01033: ORACLE initialization or shutdown in progress是什么问题

5. 软件测试LoadRunner面试题:What is the difference between Overlay graph and Correlate graph?

6. 介绍一下ICMP(Internet Control Message Protocol)Internet控制信息协议

7. 软件测试LoadRunner面试题:What is the difference between standard log and extended log?

8. 什么是UTL_FILE, 她相关的Procedure和函数都有什么

9. 软件测试LoadRunner面试题:If web server, database and Network are all fine where could be the problem?

10. 了解AppleShare protocol(AppleShare协议)吗

本文来源:https://www.mianshiwenti.com/a13421.html

点击展开全部

《Oracle Certification Program (OCP认证)的题目》

将本文的Word文档下载到电脑,方便收藏和打印

推荐程度:

进入下载页面

﹝Oracle Certification Program (OCP认证)的题目﹞相关内容

「Oracle Certification Program (OCP认证)的题目」相关专题

其它栏目

也许您还喜欢