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里还剩几条记录?
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面试题
﹝Oracle Certification Program (OCP认证)的题目﹞相关内容
- What\'s the difference between Debug and Trace class? (Debug类与Trace类有什么区别)
- What\'s the difference between an interface and abstract class? (接口与抽象类有什么区别)
- 简述synchronized和java.util.concurrent.locks.Lock的异同
- Does C# support multiple inheritance? (C#支持多重继承吗)
- AssertionError 跟一下那个类是 “is – a”的关系
- 如何反序的迭代一个序列?how do I iterate over a sequence in reverse order
- 某公司面试网管出的题目
- 下面关于"联合"的题目的输出是什么
- 什么是ARP(Address Resolution Protocol)地址解析协议
- Discard Protocol抛弃协议的作用是什么