{"id":18040,"date":"2024-04-15T05:21:07","date_gmt":"2024-04-15T05:21:07","guid":{"rendered":"https:\/\/exam.pscnotes.com\/mcq\/?p=18040"},"modified":"2024-04-15T05:21:07","modified_gmt":"2024-04-15T05:21:07","slug":"the-_____-command-is-used-to-allocates-an-extent-for-the-table-in-sql-a-modify-allocates-b-modify-table-c-alter-table-d-redefine-table-e-none-of-the-above","status":"publish","type":"post","link":"https:\/\/exam.pscnotes.com\/mcq\/the-_____-command-is-used-to-allocates-an-extent-for-the-table-in-sql-a-modify-allocates-b-modify-table-c-alter-table-d-redefine-table-e-none-of-the-above\/","title":{"rendered":"The _____ command is used to allocates an extent for the table in SQL A. MODIFY ALLOCATES B. MODIFY TABLE C. ALTER TABLE D. REDEFINE TABLE E. None of the above"},"content":{"rendered":"

[amp_mcq option1=”MODIFY ALLOCATES” option2=”MODIFY TABLE” option3=”ALTER TABLE” option4=”REDEFINE TABLE E. None of the above” correct=”option3″]<\/p>\n

The correct answer is: C. ALTER TABLE<\/strong><\/p>\n

The ALTER TABLE<\/code> command is used to change the structure of a table. This can include adding or removing columns, changing the data type of a column, or changing the constraints on a column. The ALTER TABLE<\/code> command can also be used to allocate an extent for a table. An extent is a contiguous block of storage that is used to store data for a table.<\/p>\n

The MODIFY ALLOCATES<\/code> command is not a valid SQL command. The MODIFY<\/code> command is used to change the properties of a table, but it does not allow you to allocate an extent for the table. The MODIFY TABLE<\/code> command is a synonym for the ALTER TABLE<\/code> command. The REDEFINE TABLE<\/code> command is used to completely redefine a table, including its structure and data.<\/p>\n

Here is an example of how to use the ALTER TABLE<\/code> command to allocate an extent for a table:<\/p>\n

sql
\nALTER TABLE my_table ALLOCATE EXTENT;<\/code><\/p>\n

This command will allocate a new extent for the table my_table<\/code>. The size of the extent will be determined by the table’s data type and the amount of data that is currently stored in the table.<\/p>\n","protected":false},"excerpt":{"rendered":"

[amp_mcq option1=”MODIFY ALLOCATES” option2=”MODIFY TABLE” option3=”ALTER TABLE” option4=”REDEFINE TABLE E. None of the above” correct=”option3″]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[677],"tags":[],"class_list":["post-18040","post","type-post","status-publish","format-standard","hentry","category-database-systems","no-featured-image-padding"],"yoast_head":"\nThe _____ command is used to allocates an extent for the table in SQL A. MODIFY ALLOCATES B. MODIFY TABLE C. ALTER TABLE D. REDEFINE TABLE E. None of the above<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exam.pscnotes.com\/mcq\/the-_____-command-is-used-to-allocates-an-extent-for-the-table-in-sql-a-modify-allocates-b-modify-table-c-alter-table-d-redefine-table-e-none-of-the-above\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The _____ command is used to allocates an extent for the table in SQL A. MODIFY ALLOCATES B. MODIFY TABLE C. ALTER TABLE D. REDEFINE TABLE E. None of the above\" \/>\n<meta property=\"og:description\" content=\"[amp_mcq option1=”MODIFY ALLOCATES” option2=”MODIFY TABLE” option3=”ALTER TABLE” option4=”REDEFINE TABLE E. None of the above” correct=”option3″]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exam.pscnotes.com\/mcq\/the-_____-command-is-used-to-allocates-an-extent-for-the-table-in-sql-a-modify-allocates-b-modify-table-c-alter-table-d-redefine-table-e-none-of-the-above\/\" \/>\n<meta property=\"og:site_name\" content=\"MCQ and Quiz for Exams\" \/>\n<meta property=\"article:published_time\" content=\"2024-04-15T05:21:07+00:00\" \/>\n<meta name=\"author\" content=\"rawan239\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"rawan239\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"The _____ command is used to allocates an extent for the table in SQL A. MODIFY ALLOCATES B. MODIFY TABLE C. ALTER TABLE D. REDEFINE TABLE E. None of the above","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:\/\/exam.pscnotes.com\/mcq\/the-_____-command-is-used-to-allocates-an-extent-for-the-table-in-sql-a-modify-allocates-b-modify-table-c-alter-table-d-redefine-table-e-none-of-the-above\/","og_locale":"en_US","og_type":"article","og_title":"The _____ command is used to allocates an extent for the table in SQL A. MODIFY ALLOCATES B. MODIFY TABLE C. ALTER TABLE D. REDEFINE TABLE E. None of the above","og_description":"[amp_mcq option1=”MODIFY ALLOCATES” option2=”MODIFY TABLE” option3=”ALTER TABLE” option4=”REDEFINE TABLE E. None of the above” correct=”option3″]","og_url":"https:\/\/exam.pscnotes.com\/mcq\/the-_____-command-is-used-to-allocates-an-extent-for-the-table-in-sql-a-modify-allocates-b-modify-table-c-alter-table-d-redefine-table-e-none-of-the-above\/","og_site_name":"MCQ and Quiz for Exams","article_published_time":"2024-04-15T05:21:07+00:00","author":"rawan239","twitter_card":"summary_large_image","twitter_misc":{"Written by":"rawan239","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exam.pscnotes.com\/mcq\/the-_____-command-is-used-to-allocates-an-extent-for-the-table-in-sql-a-modify-allocates-b-modify-table-c-alter-table-d-redefine-table-e-none-of-the-above\/","url":"https:\/\/exam.pscnotes.com\/mcq\/the-_____-command-is-used-to-allocates-an-extent-for-the-table-in-sql-a-modify-allocates-b-modify-table-c-alter-table-d-redefine-table-e-none-of-the-above\/","name":"The _____ command is used to allocates an extent for the table in SQL A. MODIFY ALLOCATES B. MODIFY TABLE C. ALTER TABLE D. REDEFINE TABLE E. None of the above","isPartOf":{"@id":"https:\/\/exam.pscnotes.com\/mcq\/#website"},"datePublished":"2024-04-15T05:21:07+00:00","dateModified":"2024-04-15T05:21:07+00:00","author":{"@id":"https:\/\/exam.pscnotes.com\/mcq\/#\/schema\/person\/5807dafeb27d2ec82344d6cbd6c3d209"},"breadcrumb":{"@id":"https:\/\/exam.pscnotes.com\/mcq\/the-_____-command-is-used-to-allocates-an-extent-for-the-table-in-sql-a-modify-allocates-b-modify-table-c-alter-table-d-redefine-table-e-none-of-the-above\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exam.pscnotes.com\/mcq\/the-_____-command-is-used-to-allocates-an-extent-for-the-table-in-sql-a-modify-allocates-b-modify-table-c-alter-table-d-redefine-table-e-none-of-the-above\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/exam.pscnotes.com\/mcq\/the-_____-command-is-used-to-allocates-an-extent-for-the-table-in-sql-a-modify-allocates-b-modify-table-c-alter-table-d-redefine-table-e-none-of-the-above\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/exam.pscnotes.com\/mcq\/"},{"@type":"ListItem","position":2,"name":"mcq","item":"https:\/\/exam.pscnotes.com\/mcq\/category\/mcq\/"},{"@type":"ListItem","position":3,"name":"Database systems","item":"https:\/\/exam.pscnotes.com\/mcq\/category\/mcq\/database-systems\/"},{"@type":"ListItem","position":4,"name":"The _____ command is used to allocates an extent for the table in SQL A. MODIFY ALLOCATES B. MODIFY TABLE C. ALTER TABLE D. REDEFINE TABLE E. None of the above"}]},{"@type":"WebSite","@id":"https:\/\/exam.pscnotes.com\/mcq\/#website","url":"https:\/\/exam.pscnotes.com\/mcq\/","name":"MCQ and Quiz for Exams","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exam.pscnotes.com\/mcq\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/exam.pscnotes.com\/mcq\/#\/schema\/person\/5807dafeb27d2ec82344d6cbd6c3d209","name":"rawan239","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/exam.pscnotes.com\/mcq\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/761a7274f9cce048fa5b921221e7934820d74514df93ef195a9d22af0c1c9001?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/761a7274f9cce048fa5b921221e7934820d74514df93ef195a9d22af0c1c9001?s=96&d=mm&r=g","caption":"rawan239"},"sameAs":["https:\/\/exam.pscnotes.com"],"url":"https:\/\/exam.pscnotes.com\/mcq\/author\/rawan239\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/posts\/18040","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/comments?post=18040"}],"version-history":[{"count":0,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/posts\/18040\/revisions"}],"wp:attachment":[{"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/media?parent=18040"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/categories?post=18040"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/tags?post=18040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}