{"id":1588,"date":"2015-09-05T19:14:49","date_gmt":"2015-09-06T00:14:49","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=1588"},"modified":"2015-09-05T19:14:49","modified_gmt":"2015-09-06T00:14:49","slug":"oca12c-1z0-061-additional-reading-07","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2015\/1588\/","title":{"rendered":"OCA12c \u2013 1Z0-061 \u2013 Additional Reading 07"},"content":{"rendered":"<p><strong>[Additional] Reading material for 1z0-061 Oracle Database 12c SQL Fundamentals test.<\/strong><\/p>\n<p><strong>Chapter 7: Creating Tables and Constraints\u00a0<\/strong>explains how to create and manage tables and constraints. It also discusses the various data types available in Oracle Database 12c to store data.<\/p>\n<ul>\n<li>10 Introduction to Data Definition Language\n<ul>\n<li>10.1 Categorize the main database objects<\/li>\n<li>10.2 Explain the table structure<\/li>\n<li>10.3 Describe the data types that are available for columns<\/li>\n<li>10.4 Create a simple table<\/li>\n<li>10.5 Explain how constraints are created at the time of table creation<\/li>\n<li>10.6 Describe how schema objects work<\/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_objects.htm#TDDDG30000\">Creating and Managing Schema Objects<\/a><\/li>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/ADMQS\/GUID-F11F80CE-A94A-4459-ABA7-0B1E5A16ADE2.htm#ADMQS008\">Managing Schema Objects<\/a><\/li>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/SQPUG\/ch_twelve019.htm#SQPUG040\">DESCRIBE SQL*Plus Command<\/a><\/li>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/SQLRF\/sql_elements001.htm#SQLRF30020\">Oracle Built-in Data Types<\/a><\/li>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/ADMIN\/tables.htm#ADMIN01503\">Creating Tables<\/a><\/li>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/ADMIN\/general.htm#ADMIN11537\">Managing Integrity Constraints<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\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 7: Creating Tables and Constraints\u00a0explains how to create and manage tables and constraints. It also discusses the various data types available in Oracle Database 12c to store data. 10 Introduction to Data Definition Language 10.1 Categorize the main database objects 10.2 Explain the &#8230; <a title=\"OCA12c \u2013 1Z0-061 \u2013 Additional Reading 07\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2015\/1588\/\" aria-label=\"Read more about OCA12c \u2013 1Z0-061 \u2013 Additional Reading 07\">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-1588","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\/1588","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=1588"}],"version-history":[{"count":0,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1588\/revisions"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=1588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=1588"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=1588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}