{"id":1068,"date":"2021-08-02T22:37:59","date_gmt":"2021-08-02T17:07:59","guid":{"rendered":"https:\/\/cbsepython.in\/?p=1068"},"modified":"2025-06-26T23:14:05","modified_gmt":"2025-06-26T17:44:05","slug":"sql-mcqs-for-class-12","status":"publish","type":"post","link":"https:\/\/cbsepython.in\/sql-mcqs-for-class-12\/","title":{"rendered":"75+ Important SQL MCQs for Class 12"},"content":{"rendered":"<h2><span style=\"color: #000000;\">75+ Important SQL MCQs for Class 12<\/span><\/h2>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>1- What is the full form of SQL?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Structured Query Language<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Structured Query List<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Simple Query Language<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None of these<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1df3900090214467' value='69d877f1df3900090214467'><input type='hidden' id='bg-show-more-text-69d877f1df3900090214467' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1df3900090214467' value='Hide Answer'><button id='bg-showmore-action-69d877f1df3900090214467' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1df3900090214467' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>a) Structured Query Language <\/strong><\/em><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>2- Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Data Definition Language(DDL)<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Data Manipulation Language(DML)<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Both of above<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1df4f93062331466' value='69d877f1df4f93062331466'><input type='hidden' id='bg-show-more-text-69d877f1df4f93062331466' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1df4f93062331466' value='Hide Answer'><button id='bg-showmore-action-69d877f1df4f93062331466' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1df4f93062331466' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>c) Both of above <\/strong><\/em><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>3- Which operator performs pattern matching?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) BETWEEN operator<\/span><\/p>\n<p><span style=\"color: #000000;\">b) LIKE operator<\/span><\/p>\n<p><span style=\"color: #000000;\">c) EXISTS operator<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None of these<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1df5946037098608' value='69d877f1df5946037098608'><input type='hidden' id='bg-show-more-text-69d877f1df5946037098608' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1df5946037098608' value='Hide Answer'><button id='bg-showmore-action-69d877f1df5946037098608' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1df5946037098608' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>b) LIKE operator <\/strong><\/em><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>4- What operator tests column for the absence of data?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) EXISTS operator<\/span><\/p>\n<p><span style=\"color: #000000;\">b) NOT operator<\/span><\/p>\n<p><span style=\"color: #000000;\">c) IS NULL operator<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None of these<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1df6208075696360' value='69d877f1df6208075696360'><input type='hidden' id='bg-show-more-text-69d877f1df6208075696360' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1df6208075696360' value='Hide Answer'><button id='bg-showmore-action-69d877f1df6208075696360' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1df6208075696360' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>c) IS NULL operator <\/strong><\/em><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>5- In SQL, which command(s) is(are) used to change a table&#8217;s storage characteristics?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) ALTER TABLE<\/span><\/p>\n<p><span style=\"color: #000000;\">b) MODIFY TABLE<\/span><\/p>\n<p><span style=\"color: #000000;\">c) CHANGE TABLE<\/span><\/p>\n<p><span style=\"color: #000000;\">d) All of the above<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1df6a98073652046' value='69d877f1df6a98073652046'><input type='hidden' id='bg-show-more-text-69d877f1df6a98073652046' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1df6a98073652046' value='Hide Answer'><button id='bg-showmore-action-69d877f1df6a98073652046' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1df6a98073652046' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>a) ALTER TABLE <\/strong><\/em><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>6- In SQL, which of the following is not a data definition language commands?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) RENAME<\/span><\/p>\n<p><span style=\"color: #000000;\">b) REVOKE<\/span><\/p>\n<p><span style=\"color: #000000;\">c) GRANT<\/span><\/p>\n<p><span style=\"color: #000000;\">d) UPDATE<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1df72d1011882604' value='69d877f1df72d1011882604'><input type='hidden' id='bg-show-more-text-69d877f1df72d1011882604' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1df72d1011882604' value='Hide Answer'><button id='bg-showmore-action-69d877f1df72d1011882604' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1df72d1011882604' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>d) UPDATE <\/strong><\/em><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>7- In SQL, which command is used to SELECT only one copy of each set of duplicable rows<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) SELECT DISTINCT<\/span><\/p>\n<p><span style=\"color: #000000;\">b) SELECT UNIQUE<\/span><\/p>\n<p><span style=\"color: #000000;\">c) SELECT DIFFERENT<\/span><\/p>\n<p><span style=\"color: #000000;\">d) All of the above<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1df7b05091845625' value='69d877f1df7b05091845625'><input type='hidden' id='bg-show-more-text-69d877f1df7b05091845625' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1df7b05091845625' value='Hide Answer'><button id='bg-showmore-action-69d877f1df7b05091845625' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1df7b05091845625' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>a) SELECT DISTINCT <\/strong><\/em><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>8- A command that lets you change one or more fields in a record is<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Insert<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Modify<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Look-up<\/span><\/p>\n<p><span style=\"color: #000000;\">d) All of the above<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1df8315087215705' value='69d877f1df8315087215705'><input type='hidden' id='bg-show-more-text-69d877f1df8315087215705' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1df8315087215705' value='Hide Answer'><button id='bg-showmore-action-69d877f1df8315087215705' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1df8315087215705' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>b) Modify <\/strong><\/em><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>9- Which of the SQL statements is correct?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) SELECT Username AND Password FROM Users<\/span><\/p>\n<p><span style=\"color: #000000;\">b) SELECT Username, Password FROM Users<\/span><\/p>\n<p><span style=\"color: #000000;\">c) SELECT Username, Password WHERE Username = &#8216;user1&#8217;<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None of these<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1df8b39029373126' value='69d877f1df8b39029373126'><input type='hidden' id='bg-show-more-text-69d877f1df8b39029373126' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1df8b39029373126' value='Hide Answer'><button id='bg-showmore-action-69d877f1df8b39029373126' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1df8b39029373126' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>b) SELECT Username, Password FROM Users<\/strong><\/em> <\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>10- The FROM SQL clause is used to&#8230;<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) specify what table we are selecting or deleting data FROM<\/span><\/p>\n<p><span style=\"color: #000000;\">b) specify range for search condition<\/span><\/p>\n<p><span style=\"color: #000000;\">c) specify search condition<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None of these<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1df9347095694781' value='69d877f1df9347095694781'><input type='hidden' id='bg-show-more-text-69d877f1df9347095694781' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1df9347095694781' value='Hide Answer'><button id='bg-showmore-action-69d877f1df9347095694781' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1df9347095694781' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>a) specify what table we are selecting or deleting data FROM <\/strong><\/em><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>11- Which SQL keyword is used to retrieve only unique values?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) DISTINCTIVE<\/span><\/p>\n<p><span style=\"color: #000000;\">b) UNIQUE<\/span><\/p>\n<p><span style=\"color: #000000;\">c) DISTINCT<\/span><\/p>\n<p><span style=\"color: #000000;\">d) DIFFERENT<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1df9d47045810068' value='69d877f1df9d47045810068'><input type='hidden' id='bg-show-more-text-69d877f1df9d47045810068' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1df9d47045810068' value='Hide Answer'><button id='bg-showmore-action-69d877f1df9d47045810068' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1df9d47045810068' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>c) DISTINCT <\/strong><\/em><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>12- Which SQL keyword is used to retrieve a maximum value?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) MAXIMUM<\/span><\/p>\n<p><span style=\"color: #000000;\">b) MOST<\/span><\/p>\n<p><span style=\"color: #000000;\">c) UPPER<\/span><\/p>\n<p><span style=\"color: #000000;\">d) MAX<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1dfa588043697614' value='69d877f1dfa588043697614'><input type='hidden' id='bg-show-more-text-69d877f1dfa588043697614' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1dfa588043697614' value='Hide Answer'><button id='bg-showmore-action-69d877f1dfa588043697614' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1dfa588043697614' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>d) MAX <\/strong><\/em><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>13- What is a view?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) A view is a special stored procedure executed when certain event occurs.<\/span><\/p>\n<p><span style=\"color: #000000;\">b) A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are.<\/span><\/p>\n<p><span style=\"color: #000000;\">c) A view is a database diagram.<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None of these<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1dfad86006807273' value='69d877f1dfad86006807273'><input type='hidden' id='bg-show-more-text-69d877f1dfad86006807273' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1dfad86006807273' value='Hide Answer'><button id='bg-showmore-action-69d877f1dfad86006807273' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1dfad86006807273' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>b) A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are <\/strong><\/em><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>14- Which of the following SQL commands is used to retrieve data?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) DELETE<\/span><\/p>\n<p><span style=\"color: #000000;\">b) INSERT<\/span><\/p>\n<p><span style=\"color: #000000;\">c) SELECT<\/span><\/p>\n<p><span style=\"color: #000000;\">d) JOIN<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1dfb595095680836' value='69d877f1dfb595095680836'><input type='hidden' id='bg-show-more-text-69d877f1dfb595095680836' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1dfb595095680836' value='Hide Answer'><button id='bg-showmore-action-69d877f1dfb595095680836' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1dfb595095680836' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>c) SELECT <\/strong><\/em><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>15- Which of the following is a SQL aggregate function?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) LEFT<\/span><\/p>\n<p><span style=\"color: #000000;\">b) AVG<\/span><\/p>\n<p><span style=\"color: #000000;\">c) JOIN<\/span><\/p>\n<p><span style=\"color: #000000;\">d) LEN<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1dfbd74071122603' value='69d877f1dfbd74071122603'><input type='hidden' id='bg-show-more-text-69d877f1dfbd74071122603' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1dfbd74071122603' value='Hide Answer'><button id='bg-showmore-action-69d877f1dfbd74071122603' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1dfbd74071122603' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>b) AVG <\/strong><\/em><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>16- Which SQL statement is used to delete data FROM a database?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) COLLAPSE<\/span><\/p>\n<p><span style=\"color: #000000;\">b) REMOVE<\/span><\/p>\n<p><span style=\"color: #000000;\">c) ALTER<\/span><\/p>\n<p><span style=\"color: #000000;\">d) DELETE<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1dfc5c5055995227' value='69d877f1dfc5c5055995227'><input type='hidden' id='bg-show-more-text-69d877f1dfc5c5055995227' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1dfc5c5055995227' value='Hide Answer'><button id='bg-showmore-action-69d877f1dfc5c5055995227' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1dfc5c5055995227' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>d) DELETE\u00a0<\/strong><\/em> <\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>17- Which SQL keyword is used to sort the result-set?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) SORT BY<\/span><\/p>\n<p><span style=\"color: #000000;\">b) ORDER<\/span><\/p>\n<p><span style=\"color: #000000;\">c) ORDER BY<\/span><\/p>\n<p><span style=\"color: #000000;\">d) SORT<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1dfd191076043648' value='69d877f1dfd191076043648'><input type='hidden' id='bg-show-more-text-69d877f1dfd191076043648' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1dfd191076043648' value='Hide Answer'><button id='bg-showmore-action-69d877f1dfd191076043648' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1dfd191076043648' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>c) ORDER BY <\/strong><\/em><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>18- Which of the following group functions ignore NULL values?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) MAX<\/span><\/p>\n<p><span style=\"color: #000000;\">b) COUNT<\/span><\/p>\n<p><span style=\"color: #000000;\">c) SUM<\/span><\/p>\n<p><span style=\"color: #000000;\">d) All of the above<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1dfda03026158156' value='69d877f1dfda03026158156'><input type='hidden' id='bg-show-more-text-69d877f1dfda03026158156' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1dfda03026158156' value='Hide Answer'><button id='bg-showmore-action-69d877f1dfda03026158156' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1dfda03026158156' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>d) All of the above <\/strong><\/em><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>19- What does DML stand for?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Different Mode Level<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Data Model Language<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Data Mode Lane<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Data Manipulation Language<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1dfe201066360452' value='69d877f1dfe201066360452'><input type='hidden' id='bg-show-more-text-69d877f1dfe201066360452' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1dfe201066360452' value='Hide Answer'><button id='bg-showmore-action-69d877f1dfe201066360452' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1dfe201066360452' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>d) Data Manipulation Language<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>20- The __________clause of SELECT query allows us to select only those rows in the results that satisfy a specified condition.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Where<\/span><\/p>\n<p><span style=\"color: #000000;\">b) from<\/span><\/p>\n<p><span style=\"color: #000000;\">c) having<\/span><\/p>\n<p><span style=\"color: #000000;\">d) like<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1dff031022649501' value='69d877f1dff031022649501'><input type='hidden' id='bg-show-more-text-69d877f1dff031022649501' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1dff031022649501' value='Hide Answer'><button id='bg-showmore-action-69d877f1dff031022649501' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1dff031022649501' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>a) Where<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>21- Which of the following function is used to FIND the largest value from the given data in MYSQL?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) MAX ()<\/span><\/p>\n<p><span style=\"color: #000000;\">b) MAXIMUM ()<\/span><\/p>\n<p><span style=\"color: #000000;\">c) LARGEST ()<\/span><\/p>\n<p><span style=\"color: #000000;\">d) BIG ()<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e00c29084473404' value='69d877f1e00c29084473404'><input type='hidden' id='bg-show-more-text-69d877f1e00c29084473404' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e00c29084473404' value='Hide Answer'><button id='bg-showmore-action-69d877f1e00c29084473404' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e00c29084473404' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>a) MAX ()<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>22- The data types CHAR (n) and VARCHAR (n) are used to create _______ and _______ types of string\/text fields in a database.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Fixed, equal<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Equal, variable<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Fixed, variable<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Variable, equal<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e02117072041391' value='69d877f1e02117072041391'><input type='hidden' id='bg-show-more-text-69d877f1e02117072041391' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e02117072041391' value='Hide Answer'><button id='bg-showmore-action-69d877f1e02117072041391' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e02117072041391' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>c) Fixed, variable<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>23- The term ___________ is use to refer to a record in a table.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Attribute<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Tuple<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Row<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Instance<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e034d3062705090' value='69d877f1e034d3062705090'><input type='hidden' id='bg-show-more-text-69d877f1e034d3062705090' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e034d3062705090' value='Hide Answer'><button id='bg-showmore-action-69d877f1e034d3062705090' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e034d3062705090' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>b) Tuple<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>24- Which command is used for cleaning up the environment (sql with Python)?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) my.close<\/span><\/p>\n<p><span style=\"color: #000000;\">b) is.close<\/span><\/p>\n<p><span style=\"color: #000000;\">c) con.close<\/span><\/p>\n<p><span style=\"color: #000000;\">d) mycon.close<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e04834041554491' value='69d877f1e04834041554491'><input type='hidden' id='bg-show-more-text-69d877f1e04834041554491' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e04834041554491' value='Hide Answer'><button id='bg-showmore-action-69d877f1e04834041554491' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e04834041554491' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>d) mycon.close<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>25- A relational database consists of a collection of<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Tables<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Fields<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Records<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Keys<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e055c5004128163' value='69d877f1e055c5004128163'><input type='hidden' id='bg-show-more-text-69d877f1e055c5004128163' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e055c5004128163' value='Hide Answer'><button id='bg-showmore-action-69d877f1e055c5004128163' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e055c5004128163' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>a) Tables<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>26- What is the full form of DDL?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Dynamic Data Language<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Detailed Data Language<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Data Definition Language<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Data Derivation Language<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e06076021939674' value='69d877f1e06076021939674'><input type='hidden' id='bg-show-more-text-69d877f1e06076021939674' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e06076021939674' value='Hide Answer'><button id='bg-showmore-action-69d877f1e06076021939674' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e06076021939674' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>c) Data Definition Language<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>27- A(n) in a table represents a logical relationship among a set of values.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Attribute<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Key<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Tuple<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Entry<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e06ab4004246150' value='69d877f1e06ab4004246150'><input type='hidden' id='bg-show-more-text-69d877f1e06ab4004246150' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e06ab4004246150' value='Hide Answer'><button id='bg-showmore-action-69d877f1e06ab4004246150' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e06ab4004246150' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>c) Tuple<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>28- Name the method which is used for displaying only one resultset.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) fetchmany<\/span><\/p>\n<p><span style=\"color: #000000;\">b) fetchno<\/span><\/p>\n<p><span style=\"color: #000000;\">c) fetchall<\/span><\/p>\n<p><span style=\"color: #000000;\">d) fetchone<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e074b6087255017' value='69d877f1e074b6087255017'><input type='hidden' id='bg-show-more-text-69d877f1e074b6087255017' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e074b6087255017' value='Hide Answer'><button id='bg-showmore-action-69d877f1e074b6087255017' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e074b6087255017' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>d) fetchone<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>29- Name the host name used for signing in the database.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) localhost<\/span><\/p>\n<p><span style=\"color: #000000;\">b) localpost<\/span><\/p>\n<p><span style=\"color: #000000;\">c) localcost<\/span><\/p>\n<p><span style=\"color: #000000;\">d) none of the above<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e07e60041020030' value='69d877f1e07e60041020030'><input type='hidden' id='bg-show-more-text-69d877f1e07e60041020030' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e07e60041020030' value='Hide Answer'><button id='bg-showmore-action-69d877f1e07e60041020030' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e07e60041020030' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>a) localhost<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>30- A relational database consists of a collection of<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a)Tuples<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Attributes<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Relations<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Keys<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e08816035762000' value='69d877f1e08816035762000'><input type='hidden' id='bg-show-more-text-69d877f1e08816035762000' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e08816035762000' value='Hide Answer'><button id='bg-showmore-action-69d877f1e08816035762000' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e08816035762000' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>c) Relations<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>31- Which is the subset of SQL commands used to manipulate database structure including tables?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Data Definition Language (DDL)<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Data Manipulation Language (DML)<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Both (a) and (b)<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e09319092658131' value='69d877f1e09319092658131'><input type='hidden' id='bg-show-more-text-69d877f1e09319092658131' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e09319092658131' value='Hide Answer'><button id='bg-showmore-action-69d877f1e09319092658131' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e09319092658131' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>b) Data Manipulation Language (DML)<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>32- The term ____________ is used to refer to a field in a table.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Attribute<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Tuple<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Row<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Instance<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e09cd6020532449' value='69d877f1e09cd6020532449'><input type='hidden' id='bg-show-more-text-69d877f1e09cd6020532449' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e09cd6020532449' value='Hide Answer'><button id='bg-showmore-action-69d877f1e09cd6020532449' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e09cd6020532449' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>a) Attribute<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><em><strong>33- Consider the following query<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000;\"><strong>SELECT name FROM stu WHERE subject LIKE \u2018_______ Computer Science\u2019;<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">Which one of the following has to be added into the blank space to select the subject which has Computer Science as its ending string?<\/span><\/p>\n<p><span style=\"color: #000000;\">a) $<\/span><\/p>\n<p><span style=\"color: #000000;\">b) _<\/span><\/p>\n<p><span style=\"color: #000000;\">c) ||<\/span><\/p>\n<p><span style=\"color: #000000;\">d) %<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e0a677041920313' value='69d877f1e0a677041920313'><input type='hidden' id='bg-show-more-text-69d877f1e0a677041920313' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e0a677041920313' value='Hide Answer'><button id='bg-showmore-action-69d877f1e0a677041920313' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e0a677041920313' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>d) %<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><em><strong>34- Consider following SQL statement. What type of statement is this?<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000;\"><strong>SELECT * FROM employee<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) DML<\/span><\/p>\n<p><span style=\"color: #000000;\">b) DDL<\/span><\/p>\n<p><span style=\"color: #000000;\">c) DCL<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Integrity constraint<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e0b016065850077' value='69d877f1e0b016065850077'><input type='hidden' id='bg-show-more-text-69d877f1e0b016065850077' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e0b016065850077' value='Hide Answer'><button id='bg-showmore-action-69d877f1e0b016065850077' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e0b016065850077' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>a) DML<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>35- Which of the following function is not an aggregate function?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Round()<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Sum()<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Count ()<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Avg ()<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e0b9a1035644981' value='69d877f1e0b9a1035644981'><input type='hidden' id='bg-show-more-text-69d877f1e0b9a1035644981' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e0b9a1035644981' value='Hide Answer'><button id='bg-showmore-action-69d877f1e0b9a1035644981' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e0b9a1035644981' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>a) Round()<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>36- Pick the correct username used for logging in database (sql with Python).<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) root<\/span><\/p>\n<p><span style=\"color: #000000;\">b) local<\/span><\/p>\n<p><span style=\"color: #000000;\">c) directory<\/span><\/p>\n<p><span style=\"color: #000000;\">d) host<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e0c341035168642' value='69d877f1e0c341035168642'><input type='hidden' id='bg-show-more-text-69d877f1e0c341035168642' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e0c341035168642' value='Hide Answer'><button id='bg-showmore-action-69d877f1e0c341035168642' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e0c341035168642' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>a) root<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>37- Aggregate functions can be used in the select list or the _____ clause of a select statement. They cannot be used in a ______ clause.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Where, having<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Having, where<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Group by, having<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Group by, where<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e0ccd9033274826' value='69d877f1e0ccd9033274826'><input type='hidden' id='bg-show-more-text-69d877f1e0ccd9033274826' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e0ccd9033274826' value='Hide Answer'><button id='bg-showmore-action-69d877f1e0ccd9033274826' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e0ccd9033274826' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>b) Having, where<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>38- Select correct SQL query from below to find the temperature in increasing order of all cites.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) SELECT city FROM weather ORDER BY temperature;<\/span><\/p>\n<p><span style=\"color: #000000;\">b) SELECT city, temperature FROM weather;<\/span><\/p>\n<p><span style=\"color: #000000;\">c) SELECT city, temperature FROM weather ORDER BY temperature;<\/span><\/p>\n<p><span style=\"color: #000000;\">d) SELECT city, temperature FROM weather ORDER BY city;<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e0d891028984211' value='69d877f1e0d891028984211'><input type='hidden' id='bg-show-more-text-69d877f1e0d891028984211' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e0d891028984211' value='Hide Answer'><button id='bg-showmore-action-69d877f1e0d891028984211' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e0d891028984211' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>d) SELECT city, temperature FROM weather ORDER BY city;<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>39- In SQL, which command is used to SELECT only one copy of each set of duplicable rows<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) SELECT DISTINCT<\/span><\/p>\n<p><span style=\"color: #000000;\">b) SELECT UNIQUE<\/span><\/p>\n<p><span style=\"color: #000000;\">c) SELECT DIFFERENT<\/span><\/p>\n<p><span style=\"color: #000000;\">d) All of the above<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e0e678051611840' value='69d877f1e0e678051611840'><input type='hidden' id='bg-show-more-text-69d877f1e0e678051611840' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e0e678051611840' value='Hide Answer'><button id='bg-showmore-action-69d877f1e0e678051611840' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e0e678051611840' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>a) SELECT DISTINCT<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>40- Which of the following is a SQL aggregate function?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) LEFT<\/span><\/p>\n<p><span style=\"color: #000000;\">b) AVG<\/span><\/p>\n<p><span style=\"color: #000000;\">c) JOIN<\/span><\/p>\n<p><span style=\"color: #000000;\">d) LEN<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e0f6b1002021333' value='69d877f1e0f6b1002021333'><input type='hidden' id='bg-show-more-text-69d877f1e0f6b1002021333' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e0f6b1002021333' value='Hide Answer'><button id='bg-showmore-action-69d877f1e0f6b1002021333' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e0f6b1002021333' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>b) AVG<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>41- The command used for modifying the records is:<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) update<\/span><\/p>\n<p><span style=\"color: #000000;\">b) add<\/span><\/p>\n<p><span style=\"color: #000000;\">c) updateall<\/span><\/p>\n<p><span style=\"color: #000000;\">d) none of the above<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e10676025315283' value='69d877f1e10676025315283'><input type='hidden' id='bg-show-more-text-69d877f1e10676025315283' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e10676025315283' value='Hide Answer'><button id='bg-showmore-action-69d877f1e10676025315283' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e10676025315283' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>a) update<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>42- An attribute in a relation is foreign key if it is the _________key in any other relation.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Candidate<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Primary<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Super<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Sub<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e116f8041770814' value='69d877f1e116f8041770814'><input type='hidden' id='bg-show-more-text-69d877f1e116f8041770814' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e116f8041770814' value='Hide Answer'><button id='bg-showmore-action-69d877f1e116f8041770814' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e116f8041770814' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>b) Primary<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>43- Which of the following sublanguages of SQL is used to query information from the data base and to insert tuples into, delete tuples from, and modify tuples in the database?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) DML (Data Manipulation Language)<\/span><\/p>\n<p><span style=\"color: #000000;\">b) DDL (Data Definition Language)<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Query<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Relational Schema<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e128d3094450730' value='69d877f1e128d3094450730'><input type='hidden' id='bg-show-more-text-69d877f1e128d3094450730' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e128d3094450730' value='Hide Answer'><button id='bg-showmore-action-69d877f1e128d3094450730' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e128d3094450730' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>a) DML (Data Manipulation Language)<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>44- Which of the following is not a legal method for fetching records from database from within Python?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) fetchone()<\/span><\/p>\n<p><span style=\"color: #000000;\">b) fetchtwo()<\/span><\/p>\n<p><span style=\"color: #000000;\">c) fetchall()<\/span><\/p>\n<p><span style=\"color: #000000;\">d) fetchmany()<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e13a78050998967' value='69d877f1e13a78050998967'><input type='hidden' id='bg-show-more-text-69d877f1e13a78050998967' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e13a78050998967' value='Hide Answer'><button id='bg-showmore-action-69d877f1e13a78050998967' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e13a78050998967' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>b) fetchtwo()<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>45- By default, ORDER BY clause lists the results in _______ order.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Descending<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Any<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Same<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Ascending<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e14a53039994300' value='69d877f1e14a53039994300'><input type='hidden' id='bg-show-more-text-69d877f1e14a53039994300' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e14a53039994300' value='Hide Answer'><button id='bg-showmore-action-69d877f1e14a53039994300' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e14a53039994300' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>d) Ascending<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>46- Which of the following attributes can be considered as a choice for primary key?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a)Name<\/span><\/p>\n<p><span style=\"color: #000000;\">b)Street<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Roll No<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Subject<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e159e1071860477' value='69d877f1e159e1071860477'><input type='hidden' id='bg-show-more-text-69d877f1e159e1071860477' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e159e1071860477' value='Hide Answer'><button id='bg-showmore-action-69d877f1e159e1071860477' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e159e1071860477' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>c) Roll No<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>47- In the given query which keyword has to be inserted?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">INSERT INTO employee______(1002, \u201cKausar\u201d, 2000);<\/span><\/p>\n<p><span style=\"color: #000000;\">a) Table<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Values<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Relation<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Field<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e16984067371942' value='69d877f1e16984067371942'><input type='hidden' id='bg-show-more-text-69d877f1e16984067371942' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e16984067371942' value='Hide Answer'><button id='bg-showmore-action-69d877f1e16984067371942' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e16984067371942' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>b) Values<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>48. What SQL statement do we use to display the record of all students whose last name contains 5 letters ending with \u201cA\u201d?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) SELECT * FROM STUDENTS WHERE LNAME LIKE \u2018_ _ _ _A\u2019;<\/span><\/p>\n<p><span style=\"color: #000000;\">b) SELECT * FROM STUDENTS WHERE LNAME LIKE \u2018 _ _ _ _ _\u2019;<\/span><\/p>\n<p><span style=\"color: #000000;\">c) SELECT * FROM STUDENTS WHERE LNAME LIKE \u2018 ????A\u2019;<\/span><\/p>\n<p><span style=\"color: #000000;\">d) SELECT * FROM STUDENTS WHERE LNAME LIKE \u2018*A\u2019;<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e17883016000650' value='69d877f1e17883016000650'><input type='hidden' id='bg-show-more-text-69d877f1e17883016000650' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e17883016000650' value='Hide Answer'><button id='bg-showmore-action-69d877f1e17883016000650' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e17883016000650' ><\/span><\/p>\n<p><span style=\"color: #000000\"><strong>a) SELECT * FROM STUDENTS WHERE LNAME LIKE \u2018_ _ _ _A\u2019;<\/strong><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>49- Consider the table with structure as:<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\"><strong>Student (ID, name, dept name, tot_cred)<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">In the above table, which attribute will form the primary key?<\/span><\/p>\n<p><span style=\"color: #000000;\">a)Name<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Dept<\/span><\/p>\n<p><span style=\"color: #000000;\">c) total_credits<\/span><\/p>\n<p><span style=\"color: #000000;\">d) ID<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e189c5019395670' value='69d877f1e189c5019395670'><input type='hidden' id='bg-show-more-text-69d877f1e189c5019395670' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e189c5019395670' value='Hide Answer'><button id='bg-showmore-action-69d877f1e189c5019395670' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e189c5019395670' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>d) ID<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>50- Which of the following will you use in the following query to display the unique values of the column dept_name?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">SELECT _____________ dept_name FROM Company;<\/span><\/p>\n<p><span style=\"color: #000000;\">a)All<\/span><\/p>\n<p><span style=\"color: #000000;\">b) From<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Distinct<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Name<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e19931055001142' value='69d877f1e19931055001142'><input type='hidden' id='bg-show-more-text-69d877f1e19931055001142' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e19931055001142' value='Hide Answer'><button id='bg-showmore-action-69d877f1e19931055001142' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e19931055001142' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>c) Distinct<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><em><strong>51- Consider the following query:<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000;\"><strong>SELECT name, instructor name, course______id <\/strong><strong>FROM instructor;<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">To display the field heading course with a different heading as id, which keyword must be used here to rename the field name?<\/span><\/p>\n<p><span style=\"color: #000000;\">a)From<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Rename<\/span><\/p>\n<p><span style=\"color: #000000;\">c) As<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Join<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e1a3b0036534535' value='69d877f1e1a3b0036534535'><input type='hidden' id='bg-show-more-text-69d877f1e1a3b0036534535' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e1a3b0036534535' value='Hide Answer'><button id='bg-showmore-action-69d877f1e1a3b0036534535' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e1a3b0036534535' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>c) As<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>52. With SQL, how do you select all the records from a table named \u201cStudents\u201d where the value of the column \u201cFirstName\u201d ends with an \u201ca\u201d?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) SELECT * FROM Students WHERE FirstName =\u2019a\u2019<\/span><\/p>\n<p><span style=\"color: #000000;\">b) SELECT * FROM Students WHERE FirstName LIKE \u2018a%\u2019<\/span><\/p>\n<p><span style=\"color: #000000;\">c) SELECT * FROM Students WHERE FirstName LIKE \u2018%a\u2019<\/span><\/p>\n<p><span style=\"color: #000000;\">d) SELECT * FROM Students WHERE FirstName =\u2019%a%\u2019<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e1adc0090188439' value='69d877f1e1adc0090188439'><input type='hidden' id='bg-show-more-text-69d877f1e1adc0090188439' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e1adc0090188439' value='Hide Answer'><button id='bg-showmore-action-69d877f1e1adc0090188439' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e1adc0090188439' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>c) SELECT * FROM Students WHERE FirstName LIKE \u2018%a\u2019<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>53. The HAVING clause does which of the following?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Acts EXACTLY like WHERE clause<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Acts like a WHERE clause but is used for columns rather than groups.<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Acts like a WHERE clause but is used form groups rather than rows.<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Acts like a WHERE clause but is used for rows rather than columns.<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e1b7b3034020484' value='69d877f1e1b7b3034020484'><input type='hidden' id='bg-show-more-text-69d877f1e1b7b3034020484' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e1b7b3034020484' value='Hide Answer'><button id='bg-showmore-action-69d877f1e1b7b3034020484' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e1b7b3034020484' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>c) Acts like a WHERE clause but is used form groups rather than rows.<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>54- Which clause is used with \u201caggregate functions\u201d?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) GROUP BY<\/span><\/p>\n<p><span style=\"color: #000000;\">b) SELECT<\/span><\/p>\n<p><span style=\"color: #000000;\">c) WHERE<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Both (a) and (b)<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e1c186003255928' value='69d877f1e1c186003255928'><input type='hidden' id='bg-show-more-text-69d877f1e1c186003255928' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e1c186003255928' value='Hide Answer'><button id='bg-showmore-action-69d877f1e1c186003255928' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e1c186003255928' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>a) GROUP BY<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>55- To open a connector to Mysql database, which statement is used to connect with mysql?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Connector<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Connect<\/span><\/p>\n<p><span style=\"color: #000000;\">c) password<\/span><\/p>\n<p><span style=\"color: #000000;\">d) username<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e1d174044838617' value='69d877f1e1d174044838617'><input type='hidden' id='bg-show-more-text-69d877f1e1d174044838617' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e1d174044838617' value='Hide Answer'><button id='bg-showmore-action-69d877f1e1d174044838617' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e1d174044838617' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>b) Connect<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>56- If column \u201cMarks\u201d contains the data set {25, 35, 25, 35, 38}, what will be the output after the execution of the given query?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\"><strong><em>SELECT MARKS (DISTINCT) FROM STUDENTS;<\/em><\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) 25, 35, 25, 35, 38<\/span><\/p>\n<p><span style=\"color: #000000;\">b) 25, 25, 35, 35<\/span><\/p>\n<p><span style=\"color: #000000;\">c) 25, 35, 38<\/span><\/p>\n<p><span style=\"color: #000000;\">d) 25, 25, 35, 35<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e1e1a4030996976' value='69d877f1e1e1a4030996976'><input type='hidden' id='bg-show-more-text-69d877f1e1e1a4030996976' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e1e1a4030996976' value='Hide Answer'><button id='bg-showmore-action-69d877f1e1e1a4030996976' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e1e1a4030996976' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>c) 25, 35, 38<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>57- Which connector is used for linking the database with Python code?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) MySQL-connector<\/span><\/p>\n<p><span style=\"color: #000000;\">b) YesSQL: connector<\/span><\/p>\n<p><span style=\"color: #000000;\">c) PostSQL: connector<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None of the above<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e1f169010760989' value='69d877f1e1f169010760989'><input type='hidden' id='bg-show-more-text-69d877f1e1f169010760989' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e1f169010760989' value='Hide Answer'><button id='bg-showmore-action-69d877f1e1f169010760989' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e1f169010760989' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>a) MySQL-connector<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>58- If column \u201cSalary\u201d contains the data set {1000, 15000, 25000, 10000, 15000}, what will be the output after the execution of the given query?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\"><em><strong>SELECT SUM(DISTINCT SALARY) FROM EMPLOYEE;<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000;\">a)75000<\/span><\/p>\n<p><span style=\"color: #000000;\">b) 25000<\/span><\/p>\n<p><span style=\"color: #000000;\">c) 10000<\/span><\/p>\n<p><span style=\"color: #000000;\">d) 50000<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e20116059192538' value='69d877f1e20116059192538'><input type='hidden' id='bg-show-more-text-69d877f1e20116059192538' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e20116059192538' value='Hide Answer'><button id='bg-showmore-action-69d877f1e20116059192538' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e20116059192538' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>d) 50000<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>59- SQL applies conditions on the groups through _____ clause after groups have been formed,<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Group by<\/span><\/p>\n<p><span style=\"color: #000000;\">b) With<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Where<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Having<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e21184053148314' value='69d877f1e21184053148314'><input type='hidden' id='bg-show-more-text-69d877f1e21184053148314' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e21184053148314' value='Hide Answer'><button id='bg-showmore-action-69d877f1e21184053148314' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e21184053148314' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>d) Having<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>60- To execute all the rows from the result set, which method is used?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) fetchall<\/span><\/p>\n<p><span style=\"color: #000000;\">b) fetchone<\/span><\/p>\n<p><span style=\"color: #000000;\">c) fetchmany<\/span><\/p>\n<p><span style=\"color: #000000;\">d) none of the above<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e22339019349171' value='69d877f1e22339019349171'><input type='hidden' id='bg-show-more-text-69d877f1e22339019349171' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e22339019349171' value='Hide Answer'><button id='bg-showmore-action-69d877f1e22339019349171' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e22339019349171' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>a) fetchall<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>61- What is the meaning of \u201cHAVING\u201d clause is SELECT query?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) To filter out the summary groups<\/span><\/p>\n<p><span style=\"color: #000000;\">b) To filter out the column groups<\/span><\/p>\n<p><span style=\"color: #000000;\">c) To filter out the row and column values<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None of the mentioned<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e22e15027979158' value='69d877f1e22e15027979158'><input type='hidden' id='bg-show-more-text-69d877f1e22e15027979158' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e22e15027979158' value='Hide Answer'><button id='bg-showmore-action-69d877f1e22e15027979158' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e22e15027979158' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>a) To filter out the summary groups<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>62- Which of the following queries contains an error?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Select * from emp where empid = 10003;<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Select empid from emp where empid=10006;<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Select empid from emp;<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Select empid where empid=1009 and lastname=\u2019GUPTA\u2019;<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e23813038464801' value='69d877f1e23813038464801'><input type='hidden' id='bg-show-more-text-69d877f1e23813038464801' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e23813038464801' value='Hide Answer'><button id='bg-showmore-action-69d877f1e23813038464801' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e23813038464801' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>d) Select empid where empid=1009 and lastname=\u2019GUPTA\u2019;<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>63- Which operator tests column for the absence of data (i.e., NULL value) ?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) EXISTS operator<\/span><\/p>\n<p><span style=\"color: #000000;\">b) NOT operator<\/span><\/p>\n<p><span style=\"color: #000000;\">c) IS operator<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None of these<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e241f1085236498' value='69d877f1e241f1085236498'><input type='hidden' id='bg-show-more-text-69d877f1e241f1085236498' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e241f1085236498' value='Hide Answer'><button id='bg-showmore-action-69d877f1e241f1085236498' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e241f1085236498' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>c) IS operator<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><em><strong>64- Consider the following query:<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000;\"><strong>SELECT name FROM class WHERE subject_____NULL;<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">Which comparison operator may be used to fill the blank space in above query?<\/span><\/p>\n<p><span style=\"color: #000000;\">a) =<\/span><\/p>\n<p><span style=\"color: #000000;\">b) LIKE<\/span><\/p>\n<p><span style=\"color: #000000;\">c) IS\/IS Not<\/span><\/p>\n<p><span style=\"color: #000000;\">d) if<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e24bb4057264573' value='69d877f1e24bb4057264573'><input type='hidden' id='bg-show-more-text-69d877f1e24bb4057264573' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e24bb4057264573' value='Hide Answer'><button id='bg-showmore-action-69d877f1e24bb4057264573' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e24bb4057264573' ><\/span><\/p>\n<p><span style=\"color: #000000\"><strong>c) IS\/IS Not<\/strong><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>65- Which SQL function is used to count the number of rows in a SQL query?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) COUNT ()<\/span><\/p>\n<p><span style=\"color: #000000;\">b) NUMBER ()<\/span><\/p>\n<p><span style=\"color: #000000;\">c) SUM ()<\/span><\/p>\n<p><span style=\"color: #000000;\">d) COUNT (*)<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e254c9048651830' value='69d877f1e254c9048651830'><input type='hidden' id='bg-show-more-text-69d877f1e254c9048651830' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e254c9048651830' value='Hide Answer'><button id='bg-showmore-action-69d877f1e254c9048651830' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e254c9048651830' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>d) COUNT (*)<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>66- With SQL, how can you return the number of not null record in the Project field of \u201cStudents\u201d table?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) SELECT COUNT (Project) FROM Students<\/span><\/p>\n<p><span style=\"color: #000000;\">b) SELECT COLUMNS (Project) FROM Students<\/span><\/p>\n<p><span style=\"color: #000000;\">c) SELECT COLUMNS (*) FROM Students<\/span><\/p>\n<p><span style=\"color: #000000;\">d) SELECT COUNT (*) FROM Students<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e25e70012733014' value='69d877f1e25e70012733014'><input type='hidden' id='bg-show-more-text-69d877f1e25e70012733014' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e25e70012733014' value='Hide Answer'><button id='bg-showmore-action-69d877f1e25e70012733014' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e25e70012733014' ><\/span><\/p>\n<p><span style=\"color: #000000\"><strong>a) SELECT COUNT (Project) FROM Students<\/strong><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>67- Which of the following is not an aggregate function?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Avg<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Sum<\/span><\/p>\n<p><span style=\"color: #000000;\">c) With<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Min<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e26783022515697' value='69d877f1e26783022515697'><input type='hidden' id='bg-show-more-text-69d877f1e26783022515697' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e26783022515697' value='Hide Answer'><button id='bg-showmore-action-69d877f1e26783022515697' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e26783022515697' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>c) With<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>68- All aggregate functions except _______ ignore null values in their input collection.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Count (attribute<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Count (*)<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Avg<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Sum<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e27138000664662' value='69d877f1e27138000664662'><input type='hidden' id='bg-show-more-text-69d877f1e27138000664662' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e27138000664662' value='Hide Answer'><button id='bg-showmore-action-69d877f1e27138000664662' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e27138000664662' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>b) Count (*)<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>69- Which of the following group functions ignore NULL values?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) MAX<\/span><\/p>\n<p><span style=\"color: #000000;\">b) COUNT<\/span><\/p>\n<p><span style=\"color: #000000;\">c) SUM<\/span><\/p>\n<p><span style=\"color: #000000;\">d) All of the above<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e27bf2008577444' value='69d877f1e27bf2008577444'><input type='hidden' id='bg-show-more-text-69d877f1e27bf2008577444' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e27bf2008577444' value='Hide Answer'><button id='bg-showmore-action-69d877f1e27bf2008577444' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e27bf2008577444' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>d) All of the above<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>70- What will be the order of the data being sorted after the execution of given query<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\"><strong>SELECT * FROM STUDENT ORDER BY ROLL_NO;<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a)Custom Sort<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Descending<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Ascending<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None of the above<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e28ec9059945215' value='69d877f1e28ec9059945215'><input type='hidden' id='bg-show-more-text-69d877f1e28ec9059945215' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e28ec9059945215' value='Hide Answer'><button id='bg-showmore-action-69d877f1e28ec9059945215' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e28ec9059945215' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>c) Ascending<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>71- Where and Having clauses can be used interchangeably in SELECT queries?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) True<\/span><\/p>\n<p><span style=\"color: #000000;\">b) False<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Only in views<\/span><\/p>\n<p><span style=\"color: #000000;\">d) With order by<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e29fa5027050338' value='69d877f1e29fa5027050338'><input type='hidden' id='bg-show-more-text-69d877f1e29fa5027050338' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e29fa5027050338' value='Hide Answer'><button id='bg-showmore-action-69d877f1e29fa5027050338' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e29fa5027050338' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>b) False<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>72- A______ is property of the entire relation, which ensures through its value that each tuple is unique in a relation.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Rows<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Key<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Attribute<\/span><\/p>\n<p><span style=\"color: #000000;\">d) fields<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e2b1f4031791078' value='69d877f1e2b1f4031791078'><input type='hidden' id='bg-show-more-text-69d877f1e2b1f4031791078' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e2b1f4031791078' value='Hide Answer'><button id='bg-showmore-action-69d877f1e2b1f4031791078' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e2b1f4031791078' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>b) Key<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>73- The operation whose result contains all pairs of tuples from the two relations, regardless of whether their attribute values match.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Join<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Cartesian product<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Intersection<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Set difference<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e2c248071215277' value='69d877f1e2c248071215277'><input type='hidden' id='bg-show-more-text-69d877f1e2c248071215277' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e2c248071215277' value='Hide Answer'><button id='bg-showmore-action-69d877f1e2c248071215277' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e2c248071215277' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>b) Cartesian product<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>74- Consider following SQL statement. What type of statement is this?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\"><em><strong>CREATE TABLE employee (name VARCHAR, id INTEGER)<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000;\">a) DML<\/span><\/p>\n<p><span style=\"color: #000000;\">b) DDL<\/span><\/p>\n<p><span style=\"color: #000000;\">c) DCL<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Integrity constraint<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e2d5c1079038745' value='69d877f1e2d5c1079038745'><input type='hidden' id='bg-show-more-text-69d877f1e2d5c1079038745' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e2d5c1079038745' value='Hide Answer'><button id='bg-showmore-action-69d877f1e2d5c1079038745' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e2d5c1079038745' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>b) DDL<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>75- The pattern \u2018- &#8211; &#8211; \u2019 matches any string of ________ three character. \u2018- &#8211; &#8211; %\u2019 matches any string of ____ three characters.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Atleast, Exactly<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Exactly, Atleast<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Atleast, All<\/span><\/p>\n<p><span style=\"color: #000000;\">d) All, Exactly<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d877f1e2ea09022116627' value='69d877f1e2ea09022116627'><input type='hidden' id='bg-show-more-text-69d877f1e2ea09022116627' value='Show Answer'><input type='hidden' id='bg-show-less-text-69d877f1e2ea09022116627' value='Hide Answer'><button id='bg-showmore-action-69d877f1e2ea09022116627' class='bg-showmore-plg-button bg-orange-button bg-arrow '   style=\" color:#4a4949;\">Show Answer<\/button><div id='bg-showmore-hidden-69d877f1e2ea09022116627' ><\/span><\/p>\n<p><span style=\"color: #000000\"><em><strong>b) Exactly, Atleast<\/strong><\/em><\/span><\/p>\n<p><span style=\"color: #000000\">\u00a0<\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h1><span style=\"color: #ff0000;\">Also Check:<\/span><\/h1>\n<h2><span style=\"text-decoration: underline;\"><a href=\"https:\/\/cbsepython.in\/term-2-sample-paper-class-12-computer-science\/\">Computer Science Sample Paper Class 12 Term 2 Set 1<\/a><\/span><\/h2>\n<h2><span style=\"text-decoration: underline;\"><a href=\"https:\/\/cbsepython.in\/class-12-term-2-sample-paper-computer-science-set-2\/\">Computer Science Sample Paper Class 12 Term 2 Set 2<\/a><\/span><\/h2>\n<h2><span style=\"text-decoration: underline;\"><a href=\"https:\/\/cbsepython.in\/class-12-term-2-sample-paper-computer-science-set-3\/\">Computer Science Sample Paper Class 12 Term 2\u00a0Set 3<\/a><\/span><\/h2>\n<h2><span style=\"text-decoration: underline;\"><a href=\"https:\/\/cbsepython.in\/class-12-term-2-sample-paper-computer-science-set-4\/\">Computer Science Sample Paper Class 12 Term 2\u00a0Set 4<\/a><\/span><\/h2>\n<h2><span style=\"text-decoration: underline;\"><a href=\"https:\/\/cbsepython.in\/class-12-term-2-sample-paper-computer-science-set-5\/\">Computer Science Sample Paper Class 12 Term 2 Set 5<\/a><\/span><\/h2>\n<h2><span style=\"text-decoration: underline;\"><a href=\"https:\/\/cbsepython.in\/class-12-term-2-sample-paper-computer-science-set-6\/\">Computer Science Sample Paper Class 12 Term 2 set 6<\/a><\/span><\/h2>\n<h2><span style=\"text-decoration: underline;\"><a href=\"https:\/\/cbsepython.in\/important-computer-network-class-12-question-answer\/\">Computer Networking Question and Answer<\/a><\/span><\/h2>\n<h2><span style=\"text-decoration: underline;\"><a href=\"https:\/\/cbsepython.in\/important-question-answer-class-12-computer-science\/\">Important Question Answer for Term 2 Exam<\/a><\/span><\/h2>\n<h2><a href=\"https:\/\/cbsepython.in\/database-questions-for-class-12\/\"><span style=\"text-decoration: underline;\">Database Management System Questions with Answer<\/span><\/a><\/h2>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>75+ Important SQL MCQs for Class 12 &nbsp; 1- What is the full form of SQL? a) Structured Query Language b) Structured Query List c) Simple Query Language d) None of these &nbsp; 2- Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? a) Data Definition Language(DDL) b) Data [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[40,20],"tags":[],"class_list":["post-1068","post","type-post","status-publish","format-standard","hentry","category-database-mysql","category-cbse-computer-science-with-python-class-12"],"_links":{"self":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts\/1068","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/comments?post=1068"}],"version-history":[{"count":1,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts\/1068\/revisions"}],"predecessor-version":[{"id":5350,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts\/1068\/revisions\/5350"}],"wp:attachment":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/media?parent=1068"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/categories?post=1068"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/tags?post=1068"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}