An Oracle interview questions

2011-08-02  来源:本站原创  分类:Database  人气:46 

To a company interview, HR types in the database query to ask how a specified field has duplicate values ​​of the line, was a bit nervous A's are not very good, and now want to come pretty easy.

- The easy thing to learn of the ease, is very strong technical

Table test

id name

11

22

33

43

Check out the name duplicate rows:

id name

33

43

相关文章
  • Oracle interview questions twenty common 2010-11-16

    Comments] [IT168 1. Cold backup and hot backup and the respective merits of different points Answer: hot backup mode for the archive database is still in the database backup is in working condition. The cold backup means the database is closed, the b

  • oracle interview questions based on the classic 2010-11-17

    Title 1 Problem description: Job training information for the management of the business, the establishment of three tables: S (S #, SN, SD, SA) S #, SN, SD, SA representing the student number, student name, affiliation, students aged C (C #, CN) C #

  • ORACLE interview questions PDF 2010-11-06

    JAVA interview will inevitably run into some tough questions of the database, it must be your friends ORACLE

  • 4_JAVA + Oracle interview questions (with answers) 2011-07-27

    Volume-based test questions can not be any surface graffiti writing, asked to write all the answers on the answer sheet, papers must not take away. Choice 1, What will happen when you attempt to compile and run the following code? (3) public class St

  • Oracle interview questions Highlights - Technical papers 2 2010-11-19

    16. Which column can be used to distinguish the V $ views, and GV $ views? Answer: INST_ID indicate a specific cluster environment instance. 17. How to generate explain plan? Answer: Run utlxplan.sql. Create plan table For a particular SQL statement,

  • Oracle interview questions Highlights - Technical papers 3 2010-11-19

    34. Give two methods to determine DDL changes? Answer: You can use Logminer or Streams 35. Coalescing done? Answer: Coalescing in dictionary managed tablespace for the defragment will close the small extents combined into a single large extent. 36. T

  • Oracle interview questions. Collate the answers collected 2010-12-06

    1. Explain the cold backup and hot backup and the respective merits of different points A: The hot backup mode for the archive database is still in the database backup is in working condition. The cold backup means that the database is closed, the ba

  • An Oracle interview questions 2011-08-02

    To a company interview, HR types in the database query to ask how a specified field has duplicate values ​​of the line, was a bit nervous A's are not very good, and now want to come pretty easy. - The easy thing to learn of the ease, is very strong t

  • Oracle interview questions - technical articles 2010-09-08

    1 to explain the cold backup and hot backup of the differences and advantages of each Answer: hot backup mode for the archiving database, the database is still in working condition when the backup. The cold backup means the database is shut down, the

  • Oracle interview questions PL / SQL 2010-09-17

    1 PL / SQL on behalf of A PROCEDURAL LANGUAGE / SQL B PROGRAM LANGUAGE SQL C POWER LANGUAGE SQL D is not on the 2 _____ engine executes PL / SQL block A SQL B PL / SQL C ORACLE D is not on the 3 An object can show various forms of ability is called A

  • Oracle interview questions the answer of the collating 2010-12-06

    1. Explain the cold backup and hot backup of the differences and advantages of each A: The hot backup mode for the archiving database, the database is still in working condition when the backup. The cold backup refers to the database is shut down aft

  • Oracle interview questions 2011-02-21

    1 to explain the cold backup and hot backup of the differences and advantages of each Answer: hot backup mode for the archiving database, the database is still in working condition when the backup. The cold backup means the database is shut down, the

  • An Oracle interview questions [date format output by the interval] 2011-10-07

    Title: Enter the four values ​​[2008,12,2009,2], requires a SQL, not the other innovation table, the following results: 122008-12-1 2008-12-31 012009-1-1 2009-1-31 022009-2-1 2009-2-28 Conditions: the initial year, start month, as of year results as

  • Oracle interview questions Highlights - Technical papers 1 2010-11-19

    1. Explain the cold backup and hot backup and the respective merits of different points Answer: hot backup mode for the archive database is still in the database backup is in working condition. The cold backup means the database is closed, the backup

  • the basis of the classic interview questions oracle 2010-11-17

    Title 1 Problem Description: Management positions in business training for the information, the establishment of three tables: S (S #, SN, SD, SA) S #, SN, SD, SA representing the student number, student name, affiliation, students aged C (C #, CN) C

  • the oracle of the common interview questions, only for reference 2011-04-12

    the oracle of the common interview questions, only for reference Two days ago I did some oracle face questions, feel very good, ease of medium, today summed up, only for reference and learning. The following is what I do face questions, we can see. I

  • JAVA interview questions 2009-02-27

    JAVA interview questions 1, object-oriented features of what has 1. Abstract 2. Inheritance 3. Packaging 4. Polymorphisms 2, String data types are the most basic right? Basic data types include byte, int, char, long, float, double, boolean and short.

  • java interview questions large aggregate sum 2009-05-20

    java interview questions Pen ~ a very comprehensive summary of major java interview questions large aggregate sum First, to talk about the final, finally, finalize the distinction. The most commonly asked. Second, Anonymous Inner Class (anonymous inn

  • Great summary of java interview questions document 2010-06-06

    Great summary of java interview questions document Basic knowledge JAVA 1, object-oriented features are what 1. Abstract: Abstract is to overlook a topic unrelated to the current target those aspects in order to more fully pay attention to related as

  • DBA Interview questions 2010-08-05

    interview Questions with Answers for Oracle, DBA, and developer candidates [Size = large] [/ size] [Hide TOC] 1 Introduction 2 Questions / Answers 2.1 PL / SQL Questions 2.2 DBA 2.3 SQL / SQLPlus 2.4 Tuning Questions 2.5 Installation / Configuration