{"id":1586,"date":"2015-09-05T19:12:26","date_gmt":"2015-09-06T00:12:26","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=1586"},"modified":"2015-09-05T19:12:26","modified_gmt":"2015-09-06T00:12:26","slug":"oca12c-1z0-061-additional-reading-06","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2015\/1586\/","title":{"rendered":"OCA12c \u2013 1Z0-061 \u2013 Additional Reading 06"},"content":{"rendered":"<p><strong>[Additional] Reading material for 1z0-061 Oracle Database 12c SQL Fundamentals test.<\/strong><\/p>\n<p><strong>Chapter 6: Manipulating Data<\/strong>\u00a0explores how to manipulate data &#8211; adding, removing, and updating data. The chapter also covers how transaction control works.<\/p>\n<ul>\n<li>9 Managing Tables Using DML Statements\n<ul>\n<li>9.1 Truncate data<\/li>\n<li>9.2 Insert rows into a table<\/li>\n<li>9.3 Update rows in a table<\/li>\n<li>9.4 Delete rows from a table<\/li>\n<li>9.5 Control transaction<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><span style=\"text-decoration: underline;\">Reading Material<\/span><\/p>\n<ul>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/TDDDG\/tdddg_dml.htm#TDDDG99941\">DML Statements and Transactions<\/a><\/li>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/SQLRF\/statements_10007.htm#SQLRF01707\">TRUNCATE Table<\/a><\/li>\n<li><a href=\"http:\/\/java67.blogspot.com\/2013\/07\/difference-between-truncate-vs-delete-SQL-Command-database-interview-question.html\">TRUNCATE vs DELETE<\/a><\/li>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/SQLRF\/statements_9014.htm#SQLRF01604\">INSERT Statement<\/a><\/li>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/SQLRF\/statements_10008.htm#SQLRF01708\">UPDATE Statement<\/a><\/li>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/SQLRF\/statements_8005.htm#SQLRF01505\">DELETE Statement<\/a><\/li>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/CNCPT\/intro.htm#CNCPT963\">Transaction Management<\/a><\/li>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/CNCPT\/transact.htm#CNCPT1118\">Overview of Transaction Control<\/a><\/li>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/SQLRF\/statements_1001.htm#SQLRF30043\">Transaction Control Statements<\/a><\/li>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/CNCPT\/transact.htm#CNCPT016\">Transactions<\/a><\/li>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/SQLRF\/ap_locks001.htm#SQLRF55502\">Automatic Locks in DML Operations<\/a><\/li>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/CNCPT\/sqllangu.htm#CNCPT1730\">Overview of SQL Statements<\/a><\/li>\n<\/ul>\n<p style=\"text-align: center;\"><a href=\"https:\/\/bijoos.com\/oraclenotes\/certification-12c\/oracle-1z0-061\">1Z0-061\u00a0Objectives List<\/a><\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/bijoos.com\/oraclenotes\/certification-12c\">Oracle Database 12c OCA Certification<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>[Additional] Reading material for 1z0-061 Oracle Database 12c SQL Fundamentals test. Chapter 6: Manipulating Data\u00a0explores how to manipulate data &#8211; adding, removing, and updating data. The chapter also covers how transaction control works. 9 Managing Tables Using DML Statements 9.1 Truncate data 9.2 Insert rows into a table 9.3 Update rows in a table 9.4 &#8230; <a title=\"OCA12c \u2013 1Z0-061 \u2013 Additional Reading 06\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2015\/1586\/\" aria-label=\"Read more about OCA12c \u2013 1Z0-061 \u2013 Additional Reading 06\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1586","post","type-post","status-publish","format-standard","hentry","category-certification-learning"],"acf":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1586","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=1586"}],"version-history":[{"count":0,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1586\/revisions"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=1586"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=1586"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=1586"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}