{"id":69241,"date":"2021-08-15T04:10:05","date_gmt":"2021-08-15T08:10:05","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/oracle-fundamental-concepts-40\/"},"modified":"2021-08-15T04:10:05","modified_gmt":"2021-08-15T08:10:05","slug":"oracle-fundamental-concepts-40","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=69241","title":{"rendered":"Oracle Fundamental Concepts #40"},"content":{"rendered":"<p>Terms<br \/>Database: In oracle, the term database refers to the files required for the operation of Oracle. These files include:data files, temporary data files, redo log files, control files, and parameter files<\/p>\n<p>Instance: All the processes and memory structures required to operate the database<\/p>\n<p>Users: Users are accounts that can be used to log in to the database.<\/p>\n<p>Schema: A schema is the collection of all the objects owned by a user<\/p>\n<p>Security: Oracle provides privilege-based securities. Oracle uses two types of privileges. System privilege, and object privilege. To facilitate the easy operation of privilege-based securities oracle uses roles.<\/p>\n<p>SYS and SYSTEM Account: Administrative Accounts. Have unrestricted access. SYS account owns the data dictionary. SYSTEM account owns the tables used to store information for features and options of the database. SYSTEM is the default administrative account. It is recommended that you do not use SYSTEM account to administer the database; rather create your own DBA account to administer.<\/p>\n<p>SQL*PLUS: Is a client tool to interact with the Oracle database using SQL. <\/p>\n<p>Data Dictionary: A repository that keeps track of all the database objects<\/p>\n<p>SQL: A language to interact with the database such as insert data into the database, update data, retrieve data from the database, control transactions<\/p>\n<p>PL\/SQL: A procedural language that can be used to write custom programs and procedural codes to run inside the database<\/p>\n<p><b>Oracle SQL Types<\/b><\/p>\n<ul>\n<li> Data Manipulation Language (DML)      <\/li>\n<li> Data Definition Language (DDL)      <\/li>\n<li> Transaction control statements      <\/li>\n<li> Session control statements      <\/li>\n<li> System control statements<\/li>\n<\/ul>\n<p><b>Joins in Oracle<\/b> <\/p>\n<p>      NATURAL<br \/>      INNER<br \/>      OUTER &#8211; LEFT <br \/>      OUTER &#8211; RIGHT <br \/>      OUTER &#8211; FULL<\/p>\n<p><b>SET Operations Supported by Oracle:<\/b><br \/>UNION, UNION ALL, INTERSECT, MINUS  <\/p>\n<p>Select, Insert, Update, Delete operations are similar to the ANSI SQL <\/p>\n<p>Transaction Management DML SQLs: COMMIT, ROLL BACK, SAVEPOINT, ROLL BACK TO , SET TRANSACTION,SET CONSTRAINT(S)<\/p>\n<p><b>User Creation in Oracle:<\/b><br \/>create user oracle_admin identified by password; <br \/>grant create session, dba to oracle_admin;<\/p>\n<p><b>Oracle Architecture Areas<\/b><\/p>\n<ul>\n<li> User Processes: Such as a client tool      <\/li>\n<li> The Oracle Listener: Runs in the oracle database server and listens to the clients      <\/li>\n<li> The Oracle Net Client: How to talk to the server processes<\/li>\n<li> Parameter files           <\/li>\n<li> Control Files         <\/li>\n<li> Data Files            <\/li>\n<li> Tablespaces           <\/li>\n<li> Segments          <\/li>\n<li> Extents           <\/li>\n<li> Data Blocks           <\/li>\n<li> Pre-allocated Files           <\/li>\n<li> Redo Log Files            <\/li>\n<li> Temporary Files           <\/li>\n<li> Oracle Managed Files      <\/li>\n<li> Memory Areas      <\/li>\n<li> Background Processes <\/li>\n<\/ul>\n<p>From: http:\/\/sitestree.com\/?p=5048<br \/> Categories:40<br \/>Tags:<br \/> Post Data:2013-05-14 18:15:24<\/p>\n<pre><code>    Shop Online: &lt;a href='https:\/\/www.ShopForSoul.com\/' target='new' rel=\"noopener\"&gt;https:\/\/www.ShopForSoul.com\/&lt;\/a&gt;\n    (Big Data, Cloud, Security, Machine Learning): Courses: &lt;a href='http:\/\/Training.SitesTree.com' target='new' rel=\"noopener\"&gt; http:\/\/Training.SitesTree.com&lt;\/a&gt; \n    In Bengali: &lt;a href='http:\/\/Bangla.SaLearningSchool.com' target='new' rel=\"noopener\"&gt;http:\/\/Bangla.SaLearningSchool.com&lt;\/a&gt;\n    &lt;a href='http:\/\/SitesTree.com' target='new' rel=\"noopener\"&gt;http:\/\/SitesTree.com&lt;\/a&gt;\n    8112223 Canada Inc.\/JustEtc: &lt;a href='http:\/\/JustEtc.net' target='new' rel=\"noopener\"&gt;http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) &lt;\/a&gt;\n    Shop Online: &lt;a href='https:\/\/www.ShopForSoul.com'&gt; https:\/\/www.ShopForSoul.com\/&lt;\/a&gt;\n    Medium: &lt;a href='https:\/\/medium.com\/@SayedAhmedCanada' target='new' rel=\"noopener\"&gt; https:\/\/medium.com\/@SayedAhmedCanada &lt;\/a&gt;\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>TermsDatabase: In oracle, the term database refers to the files required for the operation of Oracle. These files include:data files, temporary data files, redo log files, control files, and parameter files Instance: All the processes and memory structures required to operate the database Users: Users are accounts that can be used to log in to &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=69241\">Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1917],"tags":[],"class_list":["post-69241","post","type-post","status-publish","format-standard","hentry","category-fromsitestree-com","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":69233,"url":"http:\/\/bangla.sitestree.com\/?p=69233","url_meta":{"origin":69241,"position":0},"title":"Oracle Database Objects #40","author":"Author-Check- Article-or-Video","date":"August 15, 2021","format":false,"excerpt":"Oracle Database ObjectsSchema ObjectsClustersConstraintsDatabase linksDatabase triggersDimensionsExternal procedure librariesIndex-organized tablesIndexesIndextypesJava classes, Java resources, Java sourcesMaterialized viewsMaterialized view logsObject tablesObject typesObject viewsOperatorsPackagesSequencesStored functions, stored proceduresSynonymsTablesViewsNonschema Objects Contexts Directories Parameter files (PFILEs) and server parameter files (SPFILEs) Profiles Roles Rollback segments Tablespaces UsersWhat are schema objects? A collection of logical structures of data,\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":16194,"url":"http:\/\/bangla.sitestree.com\/?p=16194","url_meta":{"origin":69241,"position":1},"title":"Hacking Basics: Short Overview: A Short Breadth","author":"Sayed","date":"September 14, 2019","format":false,"excerpt":"Hacking Basics: Short Overview: A Short Breadth Audience: Ethical Hackers, Wanna be security researchers, interested to know the basics of Security Objective: Identify the key hacking concepts. Just the names primarily. key Topics: Password Cracking, Keyloggers, Trojans, Viruses, Worms, Rootkits, Social Engineering, Privilege Escalation, Denial of service attack, Botnet, Alternate\u2026","rel":"","context":"In &quot;\u09ac\u09cd\u09b2\u0997 \u0964 Blog&quot;","block_context":{"text":"\u09ac\u09cd\u09b2\u0997 \u0964 Blog","link":"http:\/\/bangla.sitestree.com\/?cat=182"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":26197,"url":"http:\/\/bangla.sitestree.com\/?p=26197","url_meta":{"origin":69241,"position":2},"title":"Hacking Basics: Short Overview: A Short Breadth #Root","author":"Author-Check- Article-or-Video","date":"April 19, 2021","format":false,"excerpt":"Hacking Basics: Short Overview: A Short Breadth Audience: Ethical Hackers, Wanna be security researchers, interested to know the basics of Security Objective: Identify the key hacking concepts. Just the names primarily. key Topics: Password Cracking, Keyloggers, Trojans, Viruses, Worms, Rootkits, Social Engineering, Privilege Escalation, Denial of service attack, Botnet, Alternate\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":20401,"url":"http:\/\/bangla.sitestree.com\/?p=20401","url_meta":{"origin":69241,"position":3},"title":"Learn some Centos\/Redhat Linux: RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS","author":"Author-Check- Article-or-Video","date":"February 20, 2021","format":false,"excerpt":"RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS Check if mariaDB is installed or not 130 yum list installed | grep ^mariadb mariaDB originated from MySQL - after MySQL Got Bought by Oracle 133 yum list installed | grep ^mariadb I see - installed though not completely Output: mariadb-libs.x86_64 1:5.5.52-1.el7 @anaconda There are\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":20403,"url":"http:\/\/bangla.sitestree.com\/?p=20403","url_meta":{"origin":69241,"position":4},"title":"Learn some Centos\/Redhat Linux: RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS","author":"Author-Check- Article-or-Video","date":"February 20, 2021","format":false,"excerpt":"The author is: the_authornRHCE: MariaDB Administration on Redhat\/Fedora\/CentOS Check if mariaDB is installed or not 130 yum list installed | grep ^mariadb mariaDB originated from MySQL - after MySQL Got Bought by Oracle 133 yum list installed | grep ^mariadb I see - installed though not completely Output: mariadb-libs.x86_64 1:5.5.52-1.el7\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":20405,"url":"http:\/\/bangla.sitestree.com\/?p=20405","url_meta":{"origin":69241,"position":5},"title":"Learn some Centos\/Redhat Linux: RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS","author":"Author-Check- Article-or-Video","date":"February 20, 2021","format":false,"excerpt":"The author is: the_authornRHCE: MariaDB Administration on Redhat\/Fedora\/CentOS Check if mariaDB is installed or not 130 yum list installed | grep ^mariadb mariaDB originated from MySQL - after MySQL Got Bought by Oracle 133 yum list installed | grep ^mariadb I see - installed though not completely Output: mariadb-libs.x86_64 1:5.5.52-1.el7\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69241","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=69241"}],"version-history":[{"count":0,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69241\/revisions"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=69241"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=69241"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=69241"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}