Sreenath Ravva,one of the readers of HowToDoInJava, has appeared in aninterview in Oraclefor a position in theOracle Enterprise Manager product.The below-listed questions were shared by him so that I can share
Program compiles. But at runtime throws an error “NoSuchMethodError”. Why oracle Type 4 driver is named as oracle thin driver? Oracle provides a Type 4 JDBC driver, referred to as the Oracle “thin” driver. This driver includes its own implementation of a TCP/IP version of Oracle’s N...
● 显式游标的操作:打开游标、操作游标、关闭游标;PL/SQL隐式地打开SQL游标,并在它内部处理SQL语句,然后关闭它。 4、Oracle中字符串用什么连接? Oracle中使用||这个符号连接字符串如‘abc’||‘d’的结果是abcd。 5、Oracle中是如何进行分页查询的? Oracle中使用rownum来进行分页,这个是效率最好的分页方法,hiber...
Using this mechanism, Oracle can provide additional, powerful behavior for existing libraries without requiring developers to track different kinds of classes. There’s no SkippingIterator class that developers now have to downcast to for those collections that support it. In fact, no code anywhere ...
This core Java question is followup of previous question and expecting candidate to write Java singleton using double checked locking. Remember to use volatile variable to make Singleton thread-safe. check 10 Interview questions on Singleton Pattern in Java for more details and questions answers ...
31) How to connect to Oracle DB from Java application? JDBC (Java Database Connectivity) to connect Oracle DB. Oracle JDBC driver, use `DriverManager. Establishing a Connection: By calling `DriverManager.getConnection()`, and executing queries using `Statement` or `PreparedStatement`. ...
1.JDBC Interview Questions and Answers If you are working on Enterprise applications, I am sure that JDBC API is a part of it. JDBC API provides database connectivity for relational databases, such as MySQL and Oracle. This article has a collection of 40+ interview questions related to the ...
oracle What is the difference between ArrayList and Vector? What is the difference between ArrayList and LinkedList? What is the difference between List and Set? The List and Set both extend the collection interface. However, there are some differences between the both which are listed below. ...
Java 8 Interview Questions and Answers Why do we need change to Java again? Oracle Corporation has introduced a lot of new concepts in Java SE 8 to introduce the following benefits: To Utilize Current Multi-Core CPUs EfficientlyRecently, we can observe drastic changes in Hardware. Nowadays, all...
oracle:一般是使用rownum 加select 嵌套查询 27、触发器的使用场景? 触发器:触发器需要有触发条件,当条件满足后,做什么操作 应用场景:某些社交软件的日志更新,会通知好友; 一些论坛中,当插入新帖时,会更改当前帖子总数以及最后发帖时间. CREATE [or REPLACE] TRIGGER 触发器名 ...