{"id":128,"date":"2019-11-28T06:19:54","date_gmt":"2019-11-28T06:19:54","guid":{"rendered":"http:\/\/52.66.89.59\/?p=128"},"modified":"2022-03-03T10:00:04","modified_gmt":"2022-03-03T10:00:04","slug":"top-10-oracle-interview-questions","status":"publish","type":"post","link":"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/","title":{"rendered":"Top 10 Oracle Interview Questions"},"content":{"rendered":"\"\"\r\n\r\n

Want to work for Oracle? Here we discuss some of the commonly asked interview questions<\/a>.<\/p>\r\n\r\n\r\n\r\n

Explain differences between DDL and DML with examples<\/h2>\r\n\r\n\r\n\r\n

DDL(Data Definition Language):<\/strong> DDL or Data Definition Language actually consists of the SQL commands that can be used to define the database schema. It simply deals with descriptions of the database schema and is used to create and modify the structure of database objects in database.<\/p>\r\n\r\n\r\n\r\n

Examples of DDL commands:<\/strong><\/p>\r\n\r\n\r\n\r\n

CREATE \u2013 is used to create the database or its objects (like table, index, function, views, store procedure and triggers).
ALTER-is used to alter the structure of the database.
TRUNCATE\u2013is used to remove all records from a table, including all spaces allocated for the records are removed.
COMMENT \u2013is used to add comments to the data dictionary.
RENAME \u2013is used to rename an object existing in the database.<\/p>\r\n\r\n\r\n\r\n

<\/p>\r\n\r\n\r\n\r\n

DML(Data Manipulation Language):<\/strong> The SQL commands that deals with the manipulation of data present in database belong to DML or Data Manipulation Language and this includes most of the SQL statements.
Examples of DML commands:<\/strong>
SELECT \u2013 is used to retrieve data from the a database.
INSERT \u2013 is used to insert data into a table.
UPDATE \u2013 is used to update existing data within a table.
DELETE \u2013 is used to delete records from a database table.<\/p>\r\n\r\n\r\n\r\n

Write an efficient C program to find the sum of contiguous subarray within a one-dimensional array of numbers which has the largest sum.<\/h2>\r\n\r\n\r\n\r\n

Above problem can be solved using Kadane’s Algorithm Kadane\u2019s Algorithm:<\/strong><\/p>\r\n\r\n\r\n\r\n

<\/code><\/pre>\r\n\r\n\r\n\r\n
C Program to find the contiguous subarray with largest sum<\/strong><\/p>\r\n\r\n\r\n\r\n
int maxSubArraySum(int a[], int size) {\r\n  int max_so_far = INT_MIN, max_ending_here = 0;\r\n\r\n  for (int i = 0; i < size; i++) {\r\n    max_ending_here = max_ending_here + a[i];\r\n    if (max_so_far < max_ending_here)\r\n      max_so_far = max_ending_here;\r\n\r\n    if (max_ending_here < 0)\r\n      max_ending_here = 0;\r\n  }\r\n  return max_so_far;\r\n}\r\n\r\nint main() {\r\n  int a[] = {\r\n    -2,\r\n    -3,\r\n    4,\r\n    -1,\r\n    -2,\r\n    1,\r\n    5,\r\n    -3\r\n  };\r\n  int n = sizeof(a) \/ sizeof(a[0]);\r\n  int max_sum = maxSubArraySum(a, n);\r\n  printf(\u201cMaximus continous sum is % d\u201d, max_sum)\r\n  return 0;\r\n}<\/code><\/pre>\r\n\r\n\r\n\r\n
Given linked list, write a function to detect if there is a loop in it.<\/h2>\r\n\r\n\r\n\r\n
Given problem can be solved using Floyd’s Cycle-Finding AlgorithmFloyd\u2019s Cycle-Finding Algorithm:<\/strong><\/p>\r\n\r\n\r\n\r\n
This is the fastest method. Traverse linked list using two pointers. Move one pointer by one and other pointer by two. If these pointers meet at some node then there is a loop. If pointers do not meet then linked list doesn\u2019t have loop.<\/p>\r\n\r\n\r\n\r\n
Implementation of Floyd\u2019s Cycle-Finding Algorithm:<\/strong><\/p>\r\n\r\n\r\n\r\n
int detectloop(struct Node * list) {\r\n  struct Node * slow_p = list, * fast_p = list;\r\n\r\n  while (slow_p && fast_p && fast_p - > next) {\r\n    slow_p = slow_p - > next;\r\n    fast_p = fast_p - > next - > next;\r\n    if (slow_p == fast_p) {\r\n      printf(\"Found Loop\");\r\n      return 1;\r\n    }\r\n  }\r\n  return 0;\r\n}<\/code><\/pre>\r\n\r\n\r\n\r\n
Output:<\/strong>
Found loop
Time Complexity: O(n)
Auxiliary Space: O(1)<\/p>\r\n\r\n\r\n\r\n
Write a code for reversing a string , example if input is \u201cPrepBytes\u201d output should be \u201csetyBperp\u201d<\/h2>\r\n\r\n\r\n\r\n
C Program to Reverse the String using Recursion<\/p>\r\n\r\n\r\n\r\n
void reverse(char[], int, int);\r\nint main() {\r\n    char str1[20];\r\n    int size;\r\n\r\n    printf(\"Enter a string to reverse: \");\r\n    scanf(\"%s\", str1);\r\n    size = strlen(str1);\r\n    reverse(str1, 0, size - 1);\r\n    printf(\"The string after reversing is: %s\r\n      \", str1);\r\n      return 0;\r\n    }\r\n\r\n    void reverse(char str1[], int index, int size) {\r\n      char temp;\r\n      temp = str1[index];\r\n      str1[index] = str1[size - index];\r\n      str1[size - index] = temp;\r\n      if (index == size \/ 2) {\r\n        return;\r\n      }\r\n      reverse(str1, index + 1, size);\r\n    }<\/code><\/pre>\r\n\r\n\r\n\r\n
What are collections in Java?<\/h2>\r\n\r\n\r\n\r\n
Collections in java is a framework that provides an architecture to store and manipulate the group of objects.
All the operations that you perform on a data such as searching, sorting, insertion, manipulation, deletion etc. can be performed by Java Collections.
Java Collection framework provides many interfaces (Set, List, Queue, Deque etc.) and classes (ArrayList, Vector, LinkedList, PriorityQueue, HashSet, LinkedHashSet, TreeSet etc).<\/p>\r\n\r\n\r\n\r\n
What is a Friend function?<\/h2>\r\n\r\n\r\n\r\n
A friend function can be given special grant to access private and protected members. A friend function can be:
<\/p>\r\n\r\n\r\n\r\n
  • A method of another class<\/li>
  • A global function<\/li><\/ul>\r\n\r\n\r\n\r\n
    To declare a function as a friend of a class, precede the function prototype in the class definition with keyword friend as follows:<\/p>\r\n\r\n\r\n\r\n
    class Volume {\r\n  private:\r\n    int width, height, breadth;\r\n\r\n  friend long Box::calculateVolume();\r\n  \/\/only calculateVolume() of Box class can access private members of Volume\r\n};<\/code><\/pre>\r\n\r\n\r\n\r\n
    Friendship is not mutual. If a class A is friend of B, then B doesn\u2019t become friend of A automatically.<\/p>\r\n\r\n\r\n\r\n
    What is the difference between class and structure?<\/h2>\r\n\r\n\r\n\r\n
    In terms of language, except one little detail, there is no difference between struct and class.
    Contrary to what younger developers, or people coming from C believe at first, a struct can have constructors, methods (even virtual ones), public, private and protected members, use inheritance, be templated\u2026 just like a class.
    <\/p>\r\n\r\n\r\n\r\n
    The only difference is if you don\u2019t specify the visibility (public, private or protected) of the members,
    they will be public in the struct and private in the class AND the visibility by default goes just a little further than members:
    for inheritance if you don\u2019t specify anything then the struct will inherit publicly from its base class<\/p>\r\n\r\n\r\n\r\n
    What is convoy effect?<\/h2>\r\n\r\n\r\n\r\n
    Convoy effect occurs in case of FCFS when all the other processes wait for one big process to get off the CPU.
    This effect results in lower CPU and device utilization that might be possible if the shorter processes were allowed to go first.<\/p>\r\n\r\n\r\n\r\n
    What is Table Normalization in DBMS?<\/h2>\r\n\r\n\r\n\r\n
    Normalization is a process of organizing the data in database to avoid data redundancy, insertion anomaly, update anomaly & deletion anomaly. Let\u2019s discuss about anomalies first then we will discuss normal forms with examples.Anomalies in DBMS<\/strong><\/p>\r\n\r\n\r\n\r\n
    There are three types of anomalies that occur when the database is not normalized. These are \u2013 Insertion, update and deletion anomaly. Let\u2019s take an example to understand this.<\/p>\r\n\r\n\r\n\r\n
    Example: Suppose a textile company stores the employee details in a table named employee that has four attributes: emp_id for storing employee\u2019s id, emp_name for storing employee\u2019s name, emp_address for storing employee\u2019s address and emp_dept for storing the department details in which the employee works. At some point of time the table looks like this:<\/p>\r\n\r\n\r\n\r\n
    emp_id<\/td>emp_name<\/td>emp_address<\/td>emp_dept<\/td><\/tr>
    101<\/td>Krishna<\/td>Delhi<\/td>D001<\/td><\/tr>
    101<\/td>Krishna<\/td>Delhi<\/td>D002<\/td><\/tr>
    123<\/td>Asha<\/td>Agra<\/td>D890<\/td><\/tr>
    166<\/td>Nisha<\/td>Chennai<\/td>D900<\/td><\/tr>
    166<\/td>Nisha<\/td>Chennai<\/td>D004<\/td><\/tr><\/tbody><\/table><\/figure>\r\n\r\n\r\n\r\n
    The above table is not normalized. We will see the problems that we face when a table is not normalized.<\/p>\r\n\r\n\r\n\r\n
    Update anomaly:<\/strong> In the above table we have two rows for employee Krisha as he belongs to two departments of the company. If we want to update the address of Krisha then we have to update the same in two rows or the data will become inconsistent. If somehow, the correct address gets updated in one department but not in other then as per the database, Krishna would be having two different addresses, which is not correct and would lead to inconsistent data.<\/p>\r\n\r\n\r\n\r\n
    Insert anomaly:<\/strong> Suppose a new employee joins the company, who is under training and currently not assigned to any department then we would not be able to insert the data into the table if emp_dept field doesn\u2019t allow nulls.<\/p>\r\n\r\n\r\n\r\n
    Delete anomaly:<\/strong> Suppose, if at a point of time the company closes the department D890 then deleting the rows that are having emp_dept as D890 would also delete the information of employee Maggie since she is assigned only to this department.<\/p>\r\n\r\n\r\n\r\n
    To overcome these anomalies we need to normalize the data<\/p>\r\n\r\n\r\n\r\n
    Explain Abstraction with example.<\/h2>\r\n\r\n\r\n\r\n
    Abstraction in Java is achieved by using interface and abstract class in Java.
    An interface or abstract class is something which is not concrete , something which is incomplete. We just declare the methods without implementing it.
    In order to use interface or abstract class, we need to extend and implement an abstract method with concrete behavior.

    One example of Abstraction is creating interface to denote common behavior without specifying any details about how that behavior works e.g.

    You create an interface called Vehicle which has the start() and stop() method.

    This is called abstraction of Vehicle because every server should have a way to start and stop and details may differ.<\/p>\r\n","protected":false},"excerpt":{"rendered":"
    Want to work for Oracle? Here we discuss some of the commonly asked interview questions. Explain differences between DDL and DML with examples DDL(Data Definition Language): DDL or Data Definition Language actually consists of the SQL commands that can be used to define the database schema. It simply deals with descriptions of the database schema and […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[8],"tags":[19],"class_list":["post-128","post","type-post","status-publish","format-standard","hentry","category-oracle-interview-questions","tag-oracle"],"yoast_head":"\nOracle Interview Questions | Top 10 Oracle Interview Questions|<\/title>\n<meta name=\"description\" content=\"DDL or Data Definition Language actually consists of the SQL commands that can be used to define the database schema.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Interview Questions | Top 10 Oracle Interview Questions|\" \/>\n<meta property=\"og:description\" content=\"DDL or Data Definition Language actually consists of the SQL commands that can be used to define the database schema.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/\" \/>\n<meta property=\"og:site_name\" content=\"PrepBytes Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prepbytes0211\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-28T06:19:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-03T10:00:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1646217892779-Article_509-Oracle.png\" \/>\n<meta name=\"author\" content=\"PrepBytes\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"PrepBytes\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/\"},\"author\":{\"name\":\"PrepBytes\",\"@id\":\"http:\/\/43.205.93.38\/#\/schema\/person\/39fcf072e04987f16796546f2ca83c2e\"},\"headline\":\"Top 10 Oracle Interview Questions\",\"datePublished\":\"2019-11-28T06:19:54+00:00\",\"dateModified\":\"2022-03-03T10:00:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/\"},\"wordCount\":1163,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\/\/43.205.93.38\/#organization\"},\"image\":{\"@id\":\"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1646217892779-Article_509-Oracle.png\",\"keywords\":[\"oracle\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/\",\"url\":\"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/\",\"name\":\"Oracle Interview Questions | Top 10 Oracle Interview Questions|\",\"isPartOf\":{\"@id\":\"http:\/\/43.205.93.38\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1646217892779-Article_509-Oracle.png\",\"datePublished\":\"2019-11-28T06:19:54+00:00\",\"dateModified\":\"2022-03-03T10:00:04+00:00\",\"description\":\"DDL or Data Definition Language actually consists of the SQL commands that can be used to define the database schema.\",\"breadcrumb\":{\"@id\":\"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/#primaryimage\",\"url\":\"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1646217892779-Article_509-Oracle.png\",\"contentUrl\":\"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1646217892779-Article_509-Oracle.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/43.205.93.38\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle\",\"item\":\"https:\/\/prepbytes.com\/blog\/category\/oracle-interview-questions\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Top 10 Oracle Interview Questions\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/43.205.93.38\/#website\",\"url\":\"http:\/\/43.205.93.38\/\",\"name\":\"PrepBytes Blog\",\"description\":\"ONE-STOP RESOURCE FOR EVERYTHING RELATED TO CODING\",\"publisher\":{\"@id\":\"http:\/\/43.205.93.38\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/43.205.93.38\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"http:\/\/43.205.93.38\/#organization\",\"name\":\"Prepbytes\",\"url\":\"http:\/\/43.205.93.38\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/43.205.93.38\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/blog.prepbytes.com\/wp-content\/uploads\/2025\/07\/uzxxllgloialmn9mhwfe.webp\",\"contentUrl\":\"https:\/\/blog.prepbytes.com\/wp-content\/uploads\/2025\/07\/uzxxllgloialmn9mhwfe.webp\",\"width\":160,\"height\":160,\"caption\":\"Prepbytes\"},\"image\":{\"@id\":\"http:\/\/43.205.93.38\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/prepbytes0211\/\",\"https:\/\/www.instagram.com\/prepbytes\/\",\"https:\/\/www.linkedin.com\/company\/prepbytes\/\",\"https:\/\/www.youtube.com\/channel\/UC0xGnHDrjUM1pDEK2Ka5imA\"]},{\"@type\":\"Person\",\"@id\":\"http:\/\/43.205.93.38\/#\/schema\/person\/39fcf072e04987f16796546f2ca83c2e\",\"name\":\"PrepBytes\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/43.205.93.38\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/850669d326db1e1531f04db0c63145d941c2a26792aaeee226a9e6675b0ac698?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/850669d326db1e1531f04db0c63145d941c2a26792aaeee226a9e6675b0ac698?s=96&d=mm&r=g\",\"caption\":\"PrepBytes\"},\"url\":\"https:\/\/prepbytes.com\/blog\/author\/prepbytes\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Interview Questions | Top 10 Oracle Interview Questions|","description":"DDL or Data Definition Language actually consists of the SQL commands that can be used to define the database schema.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Interview Questions | Top 10 Oracle Interview Questions|","og_description":"DDL or Data Definition Language actually consists of the SQL commands that can be used to define the database schema.","og_url":"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/","og_site_name":"PrepBytes Blog","article_publisher":"https:\/\/www.facebook.com\/prepbytes0211\/","article_published_time":"2019-11-28T06:19:54+00:00","article_modified_time":"2022-03-03T10:00:04+00:00","og_image":[{"url":"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1646217892779-Article_509-Oracle.png","type":"","width":"","height":""}],"author":"PrepBytes","twitter_card":"summary_large_image","twitter_misc":{"Written by":"PrepBytes","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/#article","isPartOf":{"@id":"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/"},"author":{"name":"PrepBytes","@id":"http:\/\/43.205.93.38\/#\/schema\/person\/39fcf072e04987f16796546f2ca83c2e"},"headline":"Top 10 Oracle Interview Questions","datePublished":"2019-11-28T06:19:54+00:00","dateModified":"2022-03-03T10:00:04+00:00","mainEntityOfPage":{"@id":"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/"},"wordCount":1163,"commentCount":0,"publisher":{"@id":"http:\/\/43.205.93.38\/#organization"},"image":{"@id":"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/#primaryimage"},"thumbnailUrl":"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1646217892779-Article_509-Oracle.png","keywords":["oracle"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/","url":"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/","name":"Oracle Interview Questions | Top 10 Oracle Interview Questions|","isPartOf":{"@id":"http:\/\/43.205.93.38\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/#primaryimage"},"image":{"@id":"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/#primaryimage"},"thumbnailUrl":"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1646217892779-Article_509-Oracle.png","datePublished":"2019-11-28T06:19:54+00:00","dateModified":"2022-03-03T10:00:04+00:00","description":"DDL or Data Definition Language actually consists of the SQL commands that can be used to define the database schema.","breadcrumb":{"@id":"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/#primaryimage","url":"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1646217892779-Article_509-Oracle.png","contentUrl":"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1646217892779-Article_509-Oracle.png"},{"@type":"BreadcrumbList","@id":"https:\/\/prepbytes.com\/blog\/top-10-oracle-interview-questions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/43.205.93.38\/"},{"@type":"ListItem","position":2,"name":"Oracle","item":"https:\/\/prepbytes.com\/blog\/category\/oracle-interview-questions\/"},{"@type":"ListItem","position":3,"name":"Top 10 Oracle Interview Questions"}]},{"@type":"WebSite","@id":"http:\/\/43.205.93.38\/#website","url":"http:\/\/43.205.93.38\/","name":"PrepBytes Blog","description":"ONE-STOP RESOURCE FOR EVERYTHING RELATED TO CODING","publisher":{"@id":"http:\/\/43.205.93.38\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/43.205.93.38\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"http:\/\/43.205.93.38\/#organization","name":"Prepbytes","url":"http:\/\/43.205.93.38\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/43.205.93.38\/#\/schema\/logo\/image\/","url":"https:\/\/blog.prepbytes.com\/wp-content\/uploads\/2025\/07\/uzxxllgloialmn9mhwfe.webp","contentUrl":"https:\/\/blog.prepbytes.com\/wp-content\/uploads\/2025\/07\/uzxxllgloialmn9mhwfe.webp","width":160,"height":160,"caption":"Prepbytes"},"image":{"@id":"http:\/\/43.205.93.38\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/prepbytes0211\/","https:\/\/www.instagram.com\/prepbytes\/","https:\/\/www.linkedin.com\/company\/prepbytes\/","https:\/\/www.youtube.com\/channel\/UC0xGnHDrjUM1pDEK2Ka5imA"]},{"@type":"Person","@id":"http:\/\/43.205.93.38\/#\/schema\/person\/39fcf072e04987f16796546f2ca83c2e","name":"PrepBytes","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/43.205.93.38\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/850669d326db1e1531f04db0c63145d941c2a26792aaeee226a9e6675b0ac698?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/850669d326db1e1531f04db0c63145d941c2a26792aaeee226a9e6675b0ac698?s=96&d=mm&r=g","caption":"PrepBytes"},"url":"https:\/\/prepbytes.com\/blog\/author\/prepbytes\/"}]}},"_links":{"self":[{"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/posts\/128","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/comments?post=128"}],"version-history":[{"count":4,"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/posts\/128\/revisions"}],"predecessor-version":[{"id":7778,"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/posts\/128\/revisions\/7778"}],"wp:attachment":[{"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/media?parent=128"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/categories?post=128"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/tags?post=128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}