InterviewSolution
Saved Bookmarks
InterviewSolution
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your ORACLE knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
_________commands in SQL allow controlling access to data within database.(a) Database(b) Data(c) Data control(d) All of the MentionedThe question was asked by my college professor while I was bunking the class.I want to ask this question from DCL,TCL Command topic in division SQL Basics of Oracle |
| Answer» <html><body><p>The correct option is (c) <a href="https://interviewquestions.tuteehub.com/tag/data-25577" style="font-weight:bold;" target="_blank" title="Click to know more about DATA">DATA</a> <a href="https://interviewquestions.tuteehub.com/tag/control-425557" style="font-weight:bold;" target="_blank" title="Click to know more about CONTROL">CONTROL</a><br/><br/>Easiest explanation: Data control is <a href="https://interviewquestions.tuteehub.com/tag/used-2318798" style="font-weight:bold;" target="_blank" title="Click to know more about USED">USED</a> for the controlling the access to database.</p></body></html> | |
| 2. |
A Database Language Concerned With The Definition Of The Whole Database Structure And Schema Is ________(a) DCL(b) DML(c) DDL(d) All of the MentionedThis question was posed to me in a job interview.This question is from DCL,TCL Command in division SQL Basics of Oracle |
| Answer» <html><body><p>The <a href="https://interviewquestions.tuteehub.com/tag/correct-409949" style="font-weight:bold;" target="_blank" title="Click to know more about CORRECT">CORRECT</a> answer is (c) DDL<br/><br/>Best explanation: <a href="https://interviewquestions.tuteehub.com/tag/data-25577" style="font-weight:bold;" target="_blank" title="Click to know more about DATA">DATA</a> Definition Language is <a href="https://interviewquestions.tuteehub.com/tag/used-2318798" style="font-weight:bold;" target="_blank" title="Click to know more about USED">USED</a> for the to define the data structure of the Table.</p></body></html> | |
| 3. |
To obtain the structure of an Oracle table, the command to use is:(a) STRUCTURE [TableName].(b) DESCRIBE [TableName].(c) DESCRIBE STRUCTURE [TableName].(d) DESC TABLE [TableName].The question was posed to me in class test.My query is from DCL,TCL Command in section SQL Basics of Oracle |
| Answer» <html><body><p>Correct option is (b) <a href="https://interviewquestions.tuteehub.com/tag/describe-437592" style="font-weight:bold;" target="_blank" title="Click to know more about DESCRIBE">DESCRIBE</a> [TableName].<br/><br/>To explain I <a href="https://interviewquestions.tuteehub.com/tag/would-3285927" style="font-weight:bold;" target="_blank" title="Click to know more about WOULD">WOULD</a> <a href="https://interviewquestions.tuteehub.com/tag/say-1195451" style="font-weight:bold;" target="_blank" title="Click to know more about SAY">SAY</a>: DESCRIBE command is used to get the <a href="https://interviewquestions.tuteehub.com/tag/structure-1230280" style="font-weight:bold;" target="_blank" title="Click to know more about STRUCTURE">STRUCTURE</a> of the Oracle Table.</p></body></html> | |
| 4. |
The Database Language That Allows You To Access Or Maintain Data In A Database(a) DCL(b) DML(c) DDL(d) All of the MentionedThe question was asked in class test.I'm obligated to ask this question of DCL,TCL Command topic in portion SQL Basics of Oracle |
| Answer» <html><body><p>Correct answer is (a) DCL<br/><br/>Explanation: DCL <a href="https://interviewquestions.tuteehub.com/tag/command-11508" style="font-weight:bold;" target="_blank" title="Click to know more about COMMAND">COMMAND</a> like Grant and Revoke is used for to give <a href="https://interviewquestions.tuteehub.com/tag/access-846773" style="font-weight:bold;" target="_blank" title="Click to know more about ACCESS">ACCESS</a> on the database.</p></body></html> | |
| 5. |
A transaction completes its execution is said to be(a) Committed(b) Aborted(c) Rolled back(d) FailedThe question was posed to me in semester exam.This intriguing question originated from DCL,TCL Command topic in division SQL Basics of Oracle |
| Answer» <html><body><p>Right choice is (a) Committed<br/><br/>The best <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a>: A transaction the <a href="https://interviewquestions.tuteehub.com/tag/completes-2532986" style="font-weight:bold;" target="_blank" title="Click to know more about COMPLETES">COMPLETES</a> its execution is <a href="https://interviewquestions.tuteehub.com/tag/said-629244" style="font-weight:bold;" target="_blank" title="Click to know more about SAID">SAID</a> to be Committed.</p></body></html> | |
| 6. |
Which of the following keyword is used with Data Control Language (DCL) statements?(a) SELECT(b) INSERT(c) DELETE(d) GRANTI have been asked this question in an online interview.This key question is from DCL,TCL Command in chapter SQL Basics of Oracle |
| Answer» <html><body><p>Right answer is (d) <a href="https://interviewquestions.tuteehub.com/tag/grant-476241" style="font-weight:bold;" target="_blank" title="Click to know more about GRANT">GRANT</a><br/><br/>To <a href="https://interviewquestions.tuteehub.com/tag/elaborate-967511" style="font-weight:bold;" target="_blank" title="Click to know more about ELABORATE">ELABORATE</a>: GRANT is the keyword which is <a href="https://interviewquestions.tuteehub.com/tag/used-2318798" style="font-weight:bold;" target="_blank" title="Click to know more about USED">USED</a> with Data <a href="https://interviewquestions.tuteehub.com/tag/control-425557" style="font-weight:bold;" target="_blank" title="Click to know more about CONTROL">CONTROL</a> Language statements.</p></body></html> | |
| 7. |
DCL Provides Commands To Perform Actions Like _____________(a) Change The Structure Of Tables(b) Insert, Update Or Delete Records And Data Values(c) Authorizing Access And Other Control Over Database(d) None of the MentionedThe question was asked in my homework.This intriguing question comes from DCL,TCL Command in portion SQL Basics of Oracle |
| Answer» <html><body><p>Right answer is (c) Authorizing Access And Other <a href="https://interviewquestions.tuteehub.com/tag/control-425557" style="font-weight:bold;" target="_blank" title="Click to know more about CONTROL">CONTROL</a> Over <a href="https://interviewquestions.tuteehub.com/tag/database-11539" style="font-weight:bold;" target="_blank" title="Click to know more about DATABASE">DATABASE</a><br/><br/>Explanation: DCL is <a href="https://interviewquestions.tuteehub.com/tag/used-2318798" style="font-weight:bold;" target="_blank" title="Click to know more about USED">USED</a> to <a href="https://interviewquestions.tuteehub.com/tag/perform-1150848" style="font-weight:bold;" target="_blank" title="Click to know more about PERFORM">PERFORM</a> the action <a href="https://interviewquestions.tuteehub.com/tag/like-1073845" style="font-weight:bold;" target="_blank" title="Click to know more about LIKE">LIKE</a> authorization, Access and other control over database.</p></body></html> | |
| 8. |
In an SQL statement, which of the following parts states the conditions for row selection?(a) Where(b) From(c) Order By(d) Group ByThis question was addressed to me in final exam.I would like to ask this question from DCL,TCL Command topic in chapter SQL Basics of Oracle |
| Answer» <html><body><p>The correct choice is (a) Where<br/><br/>The best I can <a href="https://interviewquestions.tuteehub.com/tag/explain-447165" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLAIN">EXPLAIN</a>: In an <a href="https://interviewquestions.tuteehub.com/tag/sql-4621" style="font-weight:bold;" target="_blank" title="Click to know more about SQL">SQL</a> statement where <a href="https://interviewquestions.tuteehub.com/tag/clause-918411" style="font-weight:bold;" target="_blank" title="Click to know more about CLAUSE">CLAUSE</a> states the <a href="https://interviewquestions.tuteehub.com/tag/conditions-424384" style="font-weight:bold;" target="_blank" title="Click to know more about CONDITIONS">CONDITIONS</a> for rowselection.</p></body></html> | |
| 9. |
A type of query that is placed within a WHERE or HAVING clause of another query is called(a) Master query(b) Sub query(c) Super query(d) Multi-queryI had been asked this question in a job interview.This is a very interesting question from DML Command in chapter SQL Basics of Oracle |
| Answer» <html><body><p>Right <a href="https://interviewquestions.tuteehub.com/tag/choice-915996" style="font-weight:bold;" target="_blank" title="Click to know more about CHOICE">CHOICE</a> is (b) Sub query<br/><br/>The best I can explain: Sub-query that is <a href="https://interviewquestions.tuteehub.com/tag/placed-591674" style="font-weight:bold;" target="_blank" title="Click to know more about PLACED">PLACED</a> <a href="https://interviewquestions.tuteehub.com/tag/within-732414" style="font-weight:bold;" target="_blank" title="Click to know more about WITHIN">WITHIN</a> a WHERE or HAVING <a href="https://interviewquestions.tuteehub.com/tag/clause-918411" style="font-weight:bold;" target="_blank" title="Click to know more about CLAUSE">CLAUSE</a> of another query.</p></body></html> | |
| 10. |
TCL stands for:(a) Transaction control languages(b) Transaction command languages(c) Transaction connect languages(d) None of the MentionedThis question was posed to me in an online quiz.My question is based upon DCL,TCL Command in section SQL Basics of Oracle |
| Answer» <html><body><p>The <a href="https://interviewquestions.tuteehub.com/tag/correct-409949" style="font-weight:bold;" target="_blank" title="Click to know more about CORRECT">CORRECT</a> <a href="https://interviewquestions.tuteehub.com/tag/choice-915996" style="font-weight:bold;" target="_blank" title="Click to know more about CHOICE">CHOICE</a> is (a) Transaction <a href="https://interviewquestions.tuteehub.com/tag/control-425557" style="font-weight:bold;" target="_blank" title="Click to know more about CONTROL">CONTROL</a> <a href="https://interviewquestions.tuteehub.com/tag/languages-683" style="font-weight:bold;" target="_blank" title="Click to know more about LANGUAGES">LANGUAGES</a><br/><br/>Explanation: <a href="https://interviewquestions.tuteehub.com/tag/tcl-659352" style="font-weight:bold;" target="_blank" title="Click to know more about TCL">TCL</a> for Transaction control languages.</p></body></html> | |
| 11. |
DCL stands for :(a) Data Control Language(b) Data Console Language(c) Data Console Level(d) Data Control LevelI had been asked this question during a job interview.Enquiry is from DCL,TCL Command in division SQL Basics of Oracle |
| Answer» <html><body><p>Right choice is (a) <a href="https://interviewquestions.tuteehub.com/tag/data-25577" style="font-weight:bold;" target="_blank" title="Click to know more about DATA">DATA</a> Control <a href="https://interviewquestions.tuteehub.com/tag/language-1066208" style="font-weight:bold;" target="_blank" title="Click to know more about LANGUAGE">LANGUAGE</a><br/><br/>Easy explanation: <a href="https://interviewquestions.tuteehub.com/tag/dcl-431120" style="font-weight:bold;" target="_blank" title="Click to know more about DCL">DCL</a> stands for Data Control Language.</p></body></html> | |
| 12. |
A table that displays data redundancies yields ____________ anomalies.(a) Update(b) Insertion(c) Deletion(d) All of the MentionedI got this question in a job interview.I would like to ask this question from DML Command in portion SQL Basics of Oracle |
| Answer» <html><body><p>The correct answer is (d) All of the Mentioned<br/><br/>To elaborate: Table that displays <a href="https://interviewquestions.tuteehub.com/tag/data-25577" style="font-weight:bold;" target="_blank" title="Click to know more about DATA">DATA</a> <a href="https://interviewquestions.tuteehub.com/tag/redundancies-1181474" style="font-weight:bold;" target="_blank" title="Click to know more about REDUNDANCIES">REDUNDANCIES</a> <a href="https://interviewquestions.tuteehub.com/tag/yields-1465159" style="font-weight:bold;" target="_blank" title="Click to know more about YIELDS">YIELDS</a> <a href="https://interviewquestions.tuteehub.com/tag/update-718077" style="font-weight:bold;" target="_blank" title="Click to know more about UPDATE">UPDATE</a>, insertion, <a href="https://interviewquestions.tuteehub.com/tag/deletion-947565" style="font-weight:bold;" target="_blank" title="Click to know more about DELETION">DELETION</a> anomalies.</p></body></html> | |
| 13. |
Stack is also called __________(a) First In First Out (LIFO)(b) Last In First Out (FIFO)(c) First In Last Out (FILO)(d) First Come First Served (FCFS)The question was posed to me at a job interview.I'm obligated to ask this question of DML Command in section SQL Basics of Oracle |
| Answer» <html><body><p>The correct <a href="https://interviewquestions.tuteehub.com/tag/choice-915996" style="font-weight:bold;" target="_blank" title="Click to know more about CHOICE">CHOICE</a> is (<a href="https://interviewquestions.tuteehub.com/tag/c-7168" style="font-weight:bold;" target="_blank" title="Click to know more about C">C</a>) First In Last Out (<a href="https://interviewquestions.tuteehub.com/tag/filo-457433" style="font-weight:bold;" target="_blank" title="Click to know more about FILO">FILO</a>)<br/><br/>To <a href="https://interviewquestions.tuteehub.com/tag/explain-447165" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLAIN">EXPLAIN</a>: Stack works on the First In Last Out.</p></body></html> | |
| 14. |
In SQL, which command is used to add new rows to a table?(a) Alter Table(b) Add row(c) Insert(d) AppendThe question was asked in a national level competition.This interesting question is from DML Command in section SQL Basics of Oracle |
| Answer» <html><body><p>The correct choice is (c) Insert<br/><br/>To <a href="https://interviewquestions.tuteehub.com/tag/elaborate-967511" style="font-weight:bold;" target="_blank" title="Click to know more about ELABORATE">ELABORATE</a>: Alter Table will <a href="https://interviewquestions.tuteehub.com/tag/change-913808" style="font-weight:bold;" target="_blank" title="Click to know more about CHANGE">CHANGE</a> the <a href="https://interviewquestions.tuteehub.com/tag/structure-1230280" style="font-weight:bold;" target="_blank" title="Click to know more about STRUCTURE">STRUCTURE</a> of the table.</p></body></html> | |
| 15. |
TRUNCATE statement in SQL is a –(a) DML statement(b) DDL statement(c) DCL statement(d) TCL statementI had been asked this question in examination.The query is from DML Command topic in division SQL Basics of Oracle |
| Answer» <html><body><p>Right option is (<a href="https://interviewquestions.tuteehub.com/tag/b-387190" style="font-weight:bold;" target="_blank" title="Click to know more about B">B</a>) DDL statement<br/><br/>Easiest <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a>: The SQL <a href="https://interviewquestions.tuteehub.com/tag/truncate-661938" style="font-weight:bold;" target="_blank" title="Click to know more about TRUNCATE">TRUNCATE</a> TABLE command is used to <a href="https://interviewquestions.tuteehub.com/tag/delete-947531" style="font-weight:bold;" target="_blank" title="Click to know more about DELETE">DELETE</a> <a href="https://interviewquestions.tuteehub.com/tag/complete-423576" style="font-weight:bold;" target="_blank" title="Click to know more about COMPLETE">COMPLETE</a> data from an existing table.so its a DDL statement.</p></body></html> | |
| 16. |
Which of the following is not included in DML (Data Manipulation Language)(a) INSERT(b) UPDATE(c) DELETE(d) CREATEI had been asked this question in an internship interview.I want to ask this question from DML Command in chapter SQL Basics of Oracle |
| Answer» <html><body><p>The correct option is (d) <a href="https://interviewquestions.tuteehub.com/tag/create-427332" style="font-weight:bold;" target="_blank" title="Click to know more about CREATE">CREATE</a><br/><br/>For <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a>: The CREATE TABLE statement is used to create a table in a database.Tables are organized into rows and columns; and each table <a href="https://interviewquestions.tuteehub.com/tag/must-2185568" style="font-weight:bold;" target="_blank" title="Click to know more about MUST">MUST</a> have a <a href="https://interviewquestions.tuteehub.com/tag/name-573193" style="font-weight:bold;" target="_blank" title="Click to know more about NAME">NAME</a>.</p></body></html> | |
| 17. |
Which of the following is not a type of SQL statement?(a) Data Manipulation Language (DML)(b) Data Definition Language (DDL)(c) Data Control Language (DCL)(d) Data Communication Language (DCL)I have been asked this question during an online interview.Query is from DML Command topic in chapter SQL Basics of Oracle |
| Answer» <html><body><p>The <a href="https://interviewquestions.tuteehub.com/tag/correct-409949" style="font-weight:bold;" target="_blank" title="Click to know more about CORRECT">CORRECT</a> choice is (d) Data Communication Language (DCL)<br/><br/>To <a href="https://interviewquestions.tuteehub.com/tag/explain-447165" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLAIN">EXPLAIN</a>: Data Communication Language (DCL) is not a <a href="https://interviewquestions.tuteehub.com/tag/type-715478" style="font-weight:bold;" target="_blank" title="Click to know more about TYPE">TYPE</a> of <a href="https://interviewquestions.tuteehub.com/tag/sql-4621" style="font-weight:bold;" target="_blank" title="Click to know more about SQL">SQL</a> statement.</p></body></html> | |
| 18. |
The language used application programs to request data from the DBMS is referred to as __________(a) DML(b) DDL(c) Query language(d) All of the MentionedI have been asked this question during an internship interview.I would like to ask this question from DML Command topic in chapter SQL Basics of Oracle |
| Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/right-1188951" style="font-weight:bold;" target="_blank" title="Click to know more about RIGHT">RIGHT</a> choice is (a) DML<br/><br/>The best explanation: Data Manipulation Language (DML) statements are used for <a href="https://interviewquestions.tuteehub.com/tag/managing-1085882" style="font-weight:bold;" target="_blank" title="Click to know more about MANAGING">MANAGING</a> data in <a href="https://interviewquestions.tuteehub.com/tag/database-11539" style="font-weight:bold;" target="_blank" title="Click to know more about DATABASE">DATABASE</a>. DML commands are not auto-committed. It means changes made by DML command are not permanent to database, it can be rolled <a href="https://interviewquestions.tuteehub.com/tag/back-389278" style="font-weight:bold;" target="_blank" title="Click to know more about BACK">BACK</a>.</body></html> | |
| 19. |
In SQL, which of the following is not a data Manipulation Language Commands?(a) Delete(b) Truncate(c) Update(d) CreateI had been asked this question in examination.Question is from DML Command in chapter SQL Basics of Oracle |
| Answer» <html><body><p>Correct answer is (<a href="https://interviewquestions.tuteehub.com/tag/b-387190" style="font-weight:bold;" target="_blank" title="Click to know more about B">B</a>) <a href="https://interviewquestions.tuteehub.com/tag/truncate-661938" style="font-weight:bold;" target="_blank" title="Click to know more about TRUNCATE">TRUNCATE</a><br/><br/>Explanation: The SQL TRUNCATE TABLE command is used to delete complete data from an existing table.You can also use DROP TABLE command to delete complete table but it would remove complete table structure form the database and you would need to re-create this table once again if you <a href="https://interviewquestions.tuteehub.com/tag/wish-1457925" style="font-weight:bold;" target="_blank" title="Click to know more about WISH">WISH</a> you <a href="https://interviewquestions.tuteehub.com/tag/store-1228239" style="font-weight:bold;" target="_blank" title="Click to know more about STORE">STORE</a> some data.</p></body></html> | |
| 20. |
Which command is used for removing a table and all its data from the database:(a) Create command(b) Drop table command(c) Alter table command(d) All of the MentionedI had been asked this question during an interview for a job.The doubt is from DDL Command in section SQL Basics of Oracle |
| Answer» <html><body><p>Right answer is (b) Drop table command<br/><br/>For <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a> I <a href="https://interviewquestions.tuteehub.com/tag/would-3285927" style="font-weight:bold;" target="_blank" title="Click to know more about WOULD">WOULD</a> <a href="https://interviewquestions.tuteehub.com/tag/say-1195451" style="font-weight:bold;" target="_blank" title="Click to know more about SAY">SAY</a>: The DROP INDEX <a href="https://interviewquestions.tuteehub.com/tag/statement-16478" style="font-weight:bold;" target="_blank" title="Click to know more about STATEMENT">STATEMENT</a> is used to delete an index in a table.</p></body></html> | |
| 21. |
Which command allows the removal of all rows from a table but flushes a table more efficiently since no rollback information is retained:(a) TRUNCATE command(b) Create command(c) Drop table command(d) Alter table commandThe question was posed to me during an online interview.The origin of the question is DDL Command in section SQL Basics of Oracle |
| Answer» <html><body><p>Right choice is (a) TRUNCATE command<br/><br/>Easy explanation: The <a href="https://interviewquestions.tuteehub.com/tag/sql-4621" style="font-weight:bold;" target="_blank" title="Click to know more about SQL">SQL</a> TRUNCATE TABLE command is <a href="https://interviewquestions.tuteehub.com/tag/used-2318798" style="font-weight:bold;" target="_blank" title="Click to know more about USED">USED</a> to delete complete data from an <a href="https://interviewquestions.tuteehub.com/tag/existing-979526" style="font-weight:bold;" target="_blank" title="Click to know more about EXISTING">EXISTING</a> table.You can <a href="https://interviewquestions.tuteehub.com/tag/also-373387" style="font-weight:bold;" target="_blank" title="Click to know more about ALSO">ALSO</a> use DROP TABLE command to delete complete table but it would remove complete table structure form the database and you would need to re-create this table once again if you <a href="https://interviewquestions.tuteehub.com/tag/wish-1457925" style="font-weight:bold;" target="_blank" title="Click to know more about WISH">WISH</a> you store some data.</p></body></html> | |
| 22. |
Which commanddefines its columns, integrity constraint in create table:(a) Create command(b) Drop table command(c) Alter table command(d) All of the MentionedI had been asked this question during an interview.My query is from DDL Command topic in chapter SQL Basics of Oracle |
| Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/correct-409949" style="font-weight:bold;" target="_blank" title="Click to know more about CORRECT">CORRECT</a> <a href="https://interviewquestions.tuteehub.com/tag/choice-915996" style="font-weight:bold;" target="_blank" title="Click to know more about CHOICE">CHOICE</a> is (a) <a href="https://interviewquestions.tuteehub.com/tag/create-427332" style="font-weight:bold;" target="_blank" title="Click to know more about CREATE">CREATE</a> command<br/><br/>To elaborate: The CREATE TABLE <a href="https://interviewquestions.tuteehub.com/tag/statement-16478" style="font-weight:bold;" target="_blank" title="Click to know more about STATEMENT">STATEMENT</a> is used to create a table in a database.Tables are organized into rows and columns.</body></html> | |
| 23. |
SQL has how many main commands for DDL:(a) 1(b) 2(c) 3(d) 4This question was addressed to me during an interview.This intriguing question originated from DDL Command topic in section SQL Basics of Oracle |
| Answer» <html><body><p>Correct <a href="https://interviewquestions.tuteehub.com/tag/option-25810" style="font-weight:bold;" target="_blank" title="Click to know more about OPTION">OPTION</a> is (c) <a href="https://interviewquestions.tuteehub.com/tag/3-301577" style="font-weight:bold;" target="_blank" title="Click to know more about 3">3</a><br/><br/>Explanation: <a href="https://interviewquestions.tuteehub.com/tag/create-427332" style="font-weight:bold;" target="_blank" title="Click to know more about CREATE">CREATE</a>, Delete, Alter these are 3 main command.</p></body></html> | |
| 24. |
___________ defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.(a) Column(b) Constraint(c) Index(d) TriggerI had been asked this question during an interview.My question is based upon DDL Command in chapter SQL Basics of Oracle |
| Answer» <html><body><p>The <a href="https://interviewquestions.tuteehub.com/tag/correct-409949" style="font-weight:bold;" target="_blank" title="Click to know more about CORRECT">CORRECT</a> answer is (<a href="https://interviewquestions.tuteehub.com/tag/b-387190" style="font-weight:bold;" target="_blank" title="Click to know more about B">B</a>) Constraint<br/><br/>Explanation: SQL constraints are <a href="https://interviewquestions.tuteehub.com/tag/used-2318798" style="font-weight:bold;" target="_blank" title="Click to know more about USED">USED</a> to specify <a href="https://interviewquestions.tuteehub.com/tag/rules-1192084" style="font-weight:bold;" target="_blank" title="Click to know more about RULES">RULES</a> for the data in a table.If there is any violation between the constraint and the data action, the action is aborted by the constraint.</p></body></html> | |
| 25. |
________clause is an additional filter that is applied to the result.(a) Select(b) Group-by(c) Having(d) Order byI got this question during an interview.My question is taken from DDL Command in portion SQL Basics of Oracle |
| Answer» <html><body><p>Right <a href="https://interviewquestions.tuteehub.com/tag/option-25810" style="font-weight:bold;" target="_blank" title="Click to know more about OPTION">OPTION</a> is (c) Having<br/><br/>Easy <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a>: The HAVING clause was added to SQL because the WHERE keyword could not be <a href="https://interviewquestions.tuteehub.com/tag/used-2318798" style="font-weight:bold;" target="_blank" title="Click to know more about USED">USED</a> with aggregate <a href="https://interviewquestions.tuteehub.com/tag/functions-13351" style="font-weight:bold;" target="_blank" title="Click to know more about FUNCTIONS">FUNCTIONS</a>.</p></body></html> | |
| 26. |
In SQL, which of the following is not a data definition language commands?(a) RENAME(b) REVOKE(c) GRANT(d) UPDATEThe question was posed to me in exam.I'd like to ask this question from DDL Command in chapter SQL Basics of Oracle |
| Answer» <html><body><p>Right <a href="https://interviewquestions.tuteehub.com/tag/answer-15557" style="font-weight:bold;" target="_blank" title="Click to know more about ANSWER">ANSWER</a> is (a) RENAME<br/><br/>Explanation: With RENAME statement you can rename a table.RENAME, REVOKE and GRANT are <a href="https://interviewquestions.tuteehub.com/tag/ddl-431261" style="font-weight:bold;" target="_blank" title="Click to know more about DDL">DDL</a> commands and <a href="https://interviewquestions.tuteehub.com/tag/update-718077" style="font-weight:bold;" target="_blank" title="Click to know more about UPDATE">UPDATE</a> is DML <a href="https://interviewquestions.tuteehub.com/tag/command-11508" style="font-weight:bold;" target="_blank" title="Click to know more about COMMAND">COMMAND</a>.</p></body></html> | |
| 27. |
In SQL, which command(s) is(are) used to change a table’s storage characteristics?(a) ALTER TABLE(b) MODIFY TABLE(c) CHANGE TABLE(d) All of the MentionedThe question was asked in an internship interview.I need to ask this question from DDL Command in section SQL Basics of Oracle |
| Answer» <html><body><p>Right <a href="https://interviewquestions.tuteehub.com/tag/answer-15557" style="font-weight:bold;" target="_blank" title="Click to know more about ANSWER">ANSWER</a> is (a) ALTER TABLE<br/><br/>The <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a>: To change the structure of the table we <a href="https://interviewquestions.tuteehub.com/tag/use-1441041" style="font-weight:bold;" target="_blank" title="Click to know more about USE">USE</a> ALTER TABLE <a href="https://interviewquestions.tuteehub.com/tag/syntax-14178" style="font-weight:bold;" target="_blank" title="Click to know more about SYNTAX">SYNTAX</a>:<br/><br/>ALTER TABLE “table_name” ADD “column_name” datatype<br/><br/>OR<br/><br/>ALTER TABLE “table_name” DROP <a href="https://interviewquestions.tuteehub.com/tag/column-922494" style="font-weight:bold;" target="_blank" title="Click to know more about COLUMN">COLUMN</a> “column_name”.</p></body></html> | |
| 28. |
Which of the following is/are the DDL statements?(a) Create(b) Drop(c) Alter(d) All of the MentionedThis question was addressed to me during an interview.This question is from DDL Command in section SQL Basics of Oracle |
| Answer» <html><body><p>Correct option is (d) All of the <a href="https://interviewquestions.tuteehub.com/tag/mentioned-1093838" style="font-weight:bold;" target="_blank" title="Click to know more about MENTIONED">MENTIONED</a><br/><br/>To <a href="https://interviewquestions.tuteehub.com/tag/explain-447165" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLAIN">EXPLAIN</a> I would say: All the mentioned commands are the <a href="https://interviewquestions.tuteehub.com/tag/part-596478" style="font-weight:bold;" target="_blank" title="Click to know more about PART">PART</a> of <a href="https://interviewquestions.tuteehub.com/tag/ddl-431261" style="font-weight:bold;" target="_blank" title="Click to know more about DDL">DDL</a> <a href="https://interviewquestions.tuteehub.com/tag/statements-17642" style="font-weight:bold;" target="_blank" title="Click to know more about STATEMENTS">STATEMENTS</a>.</p></body></html> | |
| 29. |
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?(a) Data Definition Language(DDL)(b) Data Manipulation Language(DML)(c) DML and DDL(d) None of the MentionedThe question was posed to me by my school teacher while I was bunking the class.Asked question is from DDL Command in chapter SQL Basics of Oracle |
| Answer» <html><body><p>The correct option is (a) Data Definition Language(DDL)<br/><br/>The best <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a>: The DDL is used to manage table and index structure.CREATE, <a href="https://interviewquestions.tuteehub.com/tag/alter-373421" style="font-weight:bold;" target="_blank" title="Click to know more about ALTER">ALTER</a>, RENAME, <a href="https://interviewquestions.tuteehub.com/tag/drop-443018" style="font-weight:bold;" target="_blank" title="Click to know more about DROP">DROP</a> and TRUNCATE <a href="https://interviewquestions.tuteehub.com/tag/statements-17642" style="font-weight:bold;" target="_blank" title="Click to know more about STATEMENTS">STATEMENTS</a> are the names of few data definition elements.</p></body></html> | |
| 30. |
In SQL, which command is used to SELECT only one copy of each set of duplicable rows(a) SELECT DISTINCT(b) SELECT UNIQUE(c) SELECT DIFFERENT(d) All of the MentionedThe question was posed to me in final exam.My doubt is from Structured Query Language topic in portion SQL Basics of Oracle |
| Answer» <html><body><p>Correct <a href="https://interviewquestions.tuteehub.com/tag/option-25810" style="font-weight:bold;" target="_blank" title="Click to know more about OPTION">OPTION</a> is (a) <a href="https://interviewquestions.tuteehub.com/tag/select-630282" style="font-weight:bold;" target="_blank" title="Click to know more about SELECT">SELECT</a> DISTINCT<br/><br/>The best explanation: The keyword allows us to grab all information from a column (or columns) on a table. This, of <a href="https://interviewquestions.tuteehub.com/tag/course-937885" style="font-weight:bold;" target="_blank" title="Click to know more about COURSE">COURSE</a>, necessarily means that there will be <a href="https://interviewquestions.tuteehub.com/tag/redundancies-1181474" style="font-weight:bold;" target="_blank" title="Click to know more about REDUNDANCIES">REDUNDANCIES</a>. What if we only want to select each distinct element? This is easy way to accomplish in SQL. All we need to do is that to addafterThe syntax is:SELECT DISTINCT column_name FROM table_name;.</p></body></html> | |
| 31. |
Find the temperature in increasing order of all cities(a) SELECT city FROM weather ORDER BY temperature;(b) SELECT city, temperature FROM weather;(c) SELECT city, temperature FROM weather ORDER BY temperature;(d) SELECT city, temperature FROM weather ORDER BY city;I had been asked this question during a job interview.Enquiry is from Structured Query Language topic in portion SQL Basics of Oracle |
| Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/correct-409949" style="font-weight:bold;" target="_blank" title="Click to know more about CORRECT">CORRECT</a> answer is (c) <a href="https://interviewquestions.tuteehub.com/tag/select-630282" style="font-weight:bold;" target="_blank" title="Click to know more about SELECT">SELECT</a> city, temperature FROM <a href="https://interviewquestions.tuteehub.com/tag/weather-1450884" style="font-weight:bold;" target="_blank" title="Click to know more about WEATHER">WEATHER</a> ORDER BY temperature;<br/><br/>To explain I would say: SELECT column_name, aggregate_function(column_name)<br/><br/> FROM table_name<br/><br/> WHERE column_name <a href="https://interviewquestions.tuteehub.com/tag/operator-1137101" style="font-weight:bold;" target="_blank" title="Click to know more about OPERATOR">OPERATOR</a> value<br/><br/> <a href="https://interviewquestions.tuteehub.com/tag/group-1013370" style="font-weight:bold;" target="_blank" title="Click to know more about GROUP">GROUP</a> BY column_name<br/><br/> HAVING aggregate_function(column_name) operator value<br/><br/> ORDER BY ; <br/><br/>So base on [SELECT city, temperature FROM weather ORDER BY temperature;] this will be the correct answer.</body></html> | |
| 32. |
Which of the following is illegal?(a) SELECT SYSDATE – SYSDATE FROM DUAL;(b) SELECT SYSDATE – (SYSDATE – 2) FROM DUAL;(c) SELECT SYSDATE – (SYSDATE + 2) FROM DUAL;(d) None of the MentionedThe question was asked in my homework.The above asked question is from Structured Query Language in section SQL Basics of Oracle |
| Answer» <html><body><p>Right answer is (d) None of the Mentioned<br/><br/>The <a href="https://interviewquestions.tuteehub.com/tag/best-390038" style="font-weight:bold;" target="_blank" title="Click to know more about BEST">BEST</a> explanation: SELECT SYSDATE – SYSDATE FROM DUAL; outputs <a href="https://interviewquestions.tuteehub.com/tag/0-251616" style="font-weight:bold;" target="_blank" title="Click to know more about 0">0</a> SELECT SYSDATE – (SYSDATE – <a href="https://interviewquestions.tuteehub.com/tag/2-283658" style="font-weight:bold;" target="_blank" title="Click to know more about 2">2</a>) FROM DUAL; outputs 2<br/><br/>SELECT SYSDATE – (SYSDATE + 2) FROM DUAL; outputs -2.</p></body></html> | |
| 33. |
A command that lets you change one or more fields in a record is(a) Insert(b) Modify(c) Look-up(d) All of the MentionedThis question was posed to me in homework.My enquiry is from Structured Query Language topic in portion SQL Basics of Oracle |
| Answer» <html><body><p>The correct <a href="https://interviewquestions.tuteehub.com/tag/option-25810" style="font-weight:bold;" target="_blank" title="Click to know more about OPTION">OPTION</a> is (<a href="https://interviewquestions.tuteehub.com/tag/b-387190" style="font-weight:bold;" target="_blank" title="Click to know more about B">B</a>) Modify<br/><br/>To elaborate: Sometimes we need to <a href="https://interviewquestions.tuteehub.com/tag/change-913808" style="font-weight:bold;" target="_blank" title="Click to know more about CHANGE">CHANGE</a> the data type of a <a href="https://interviewquestions.tuteehub.com/tag/column-922494" style="font-weight:bold;" target="_blank" title="Click to know more about COLUMN">COLUMN</a>. To do this, we use the ALTER TABLE Modify Column ALTER TABLE table_name, MODIFY column_name “<a href="https://interviewquestions.tuteehub.com/tag/new-1114486" style="font-weight:bold;" target="_blank" title="Click to know more about NEW">NEW</a> Data Type”.</p></body></html> | |
| 34. |
Which of the SQL statements is correct?(a) SELECT Username AND Password FROM Users(b) SELECT Username, Password FROM Users(c) SELECT Username, Password WHERE Username = ‘user1’(d) None of the MentionedThis question was posed to me during an online interview.This key question is from Structured Query Language in section SQL Basics of Oracle |
| Answer» <html><body><p>Right answer is (<a href="https://interviewquestions.tuteehub.com/tag/b-387190" style="font-weight:bold;" target="_blank" title="Click to know more about B">B</a>) SELECT Username, Password FROM Users<br/><br/>The best explanation: <a href="https://interviewquestions.tuteehub.com/tag/correct-409949" style="font-weight:bold;" target="_blank" title="Click to know more about CORRECT">CORRECT</a> order of SELECT, FROM and WHERE <a href="https://interviewquestions.tuteehub.com/tag/clause-918411" style="font-weight:bold;" target="_blank" title="Click to know more about CLAUSE">CLAUSE</a> is as <a href="https://interviewquestions.tuteehub.com/tag/follow-994211" style="font-weight:bold;" target="_blank" title="Click to know more about FOLLOW">FOLLOW</a>:<br/><br/>SELECT column_name1, column_name2 FROM table_name WHERE condition So, only SELECT Username, Password FROM Users follows the above syntax.</p></body></html> | |
| 35. |
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?(a) Data Definition Language(DDL)(b) Data Manipulation Language(DML)(c) DDL and DML(d) None of the MentionedThis question was addressed to me in class test.This interesting question is from Structured Query Language in division SQL Basics of Oracle |
| Answer» <html><body><p>The correct <a href="https://interviewquestions.tuteehub.com/tag/option-25810" style="font-weight:bold;" target="_blank" title="Click to know more about OPTION">OPTION</a> is (a) Data Definition Language(<a href="https://interviewquestions.tuteehub.com/tag/ddl-431261" style="font-weight:bold;" target="_blank" title="Click to know more about DDL">DDL</a>)<br/><br/>Explanation: The Data Definition Language is <a href="https://interviewquestions.tuteehub.com/tag/used-2318798" style="font-weight:bold;" target="_blank" title="Click to know more about USED">USED</a> to <a href="https://interviewquestions.tuteehub.com/tag/manage-546710" style="font-weight:bold;" target="_blank" title="Click to know more about MANAGE">MANAGE</a> table and index structure.CREATE, ALTER, RENAME, DROP and TRUNCATE statements are the <a href="https://interviewquestions.tuteehub.com/tag/names-1110573" style="font-weight:bold;" target="_blank" title="Click to know more about NAMES">NAMES</a> of few data definition elements.</p></body></html> | |
| 36. |
What is the full form of SQL?(a) Structured Query Language(b) Structured Query List(c) Simple Query Language(d) None of the MentionedThis question was addressed to me in a job interview.This intriguing question comes from Structured Query Language in section SQL Basics of Oracle |
| Answer» <html><body><p>The correct answer is (a) Structured Query <a href="https://interviewquestions.tuteehub.com/tag/language-1066208" style="font-weight:bold;" target="_blank" title="Click to know more about LANGUAGE">LANGUAGE</a><br/><br/>To elaborate: SQL (Structured Query Language) is a special-purpose programming language designed for managing data held in a relational <a href="https://interviewquestions.tuteehub.com/tag/database-11539" style="font-weight:bold;" target="_blank" title="Click to know more about DATABASE">DATABASE</a> <a href="https://interviewquestions.tuteehub.com/tag/management-1085657" style="font-weight:bold;" target="_blank" title="Click to know more about MANAGEMENT">MANAGEMENT</a> system.Originally based upon relational algebra and tuple relational calculus, SQL consists of a data definition language and a data manipulation language. The scope of SQL includes data <a href="https://interviewquestions.tuteehub.com/tag/insert-516457" style="font-weight:bold;" target="_blank" title="Click to know more about INSERT">INSERT</a>, query, update and delete, <a href="https://interviewquestions.tuteehub.com/tag/schema-11583" style="font-weight:bold;" target="_blank" title="Click to know more about SCHEMA">SCHEMA</a> creation and modification, and data access control.</p></body></html> | |