Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your 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»

The correct option is (c) DATA CONTROL

Easiest explanation: Data control is USED for the controlling the access to database.
Discussion
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»

The CORRECT answer is (c) DDL

Best explanation: DATA Definition Language is USED for the to define the data structure of the Table.
Discussion
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»

Correct option is (b) DESCRIBE [TableName].

To explain I WOULD SAY: DESCRIBE command is used to get the STRUCTURE of the Oracle Table.
Discussion
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»

Correct answer is (a) DCL

Explanation: DCL COMMAND like Grant and Revoke is used for to give ACCESS on the database.
Discussion
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»

Right choice is (a) Committed

The best EXPLANATION: A transaction the COMPLETES its execution is SAID to be Committed.
Discussion
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»

Right answer is (d) GRANT

To ELABORATE: GRANT is the keyword which is USED with Data CONTROL Language statements.
Discussion
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»

Right answer is (c) Authorizing Access And Other CONTROL Over DATABASE

Explanation: DCL is USED to PERFORM the action LIKE authorization, Access and other control over database.
Discussion
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»

The correct choice is (a) Where

The best I can EXPLAIN: In an SQL statement where CLAUSE states the CONDITIONS for rowselection.
Discussion
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»

Right CHOICE is (b) Sub query

The best I can explain: Sub-query that is PLACED WITHIN a WHERE or HAVING CLAUSE of another query.
Discussion
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»

The CORRECT CHOICE is (a) Transaction CONTROL LANGUAGES

Explanation: TCL for Transaction control languages.
Discussion
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»

Right choice is (a) DATA Control LANGUAGE

Easy explanation: DCL stands for Data Control Language.
Discussion
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»

The correct answer is (d) All of the Mentioned

To elaborate: Table that displays DATA REDUNDANCIES YIELDS UPDATE, insertion, DELETION anomalies.
Discussion
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»

The correct CHOICE is (C) First In Last Out (FILO)

To EXPLAIN: Stack works on the First In Last Out.
Discussion
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»

The correct choice is (c) Insert

To ELABORATE: Alter Table will CHANGE the STRUCTURE of the table.
Discussion
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»

Right option is (B) DDL statement

Easiest EXPLANATION: The SQL TRUNCATE TABLE command is used to DELETE COMPLETE data from an existing table.so its a DDL statement.
Discussion
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»

The correct option is (d) CREATE

For EXPLANATION: The CREATE TABLE statement is used to create a table in a database.Tables are organized into rows and columns; and each table MUST have a NAME.
Discussion
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»

The CORRECT choice is (d) Data Communication Language (DCL)

To EXPLAIN: Data Communication Language (DCL) is not a TYPE of SQL statement.
Discussion
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» RIGHT choice is (a) DML

The best explanation: Data Manipulation Language (DML) statements are used for MANAGING data in DATABASE. DML commands are not auto-committed. It means changes made by DML command are not permanent to database, it can be rolled BACK.
Discussion
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»

Correct answer is (B) TRUNCATE

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 WISH you STORE some data.
Discussion
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»

Right answer is (b) Drop table command

For EXPLANATION I WOULD SAY: The DROP INDEX STATEMENT is used to delete an index in a table.
Discussion
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»

Right choice is (a) TRUNCATE command

Easy 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 WISH you store some data.
Discussion
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» CORRECT CHOICE is (a) CREATE command

To elaborate: The CREATE TABLE STATEMENT is used to create a table in a database.Tables are organized into rows and columns.
Discussion
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»

Correct OPTION is (c) 3

Explanation: CREATE, Delete, Alter these are 3 main command.
Discussion
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»

The CORRECT answer is (B) Constraint

Explanation: SQL constraints are USED to specify RULES 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.
Discussion
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»

Right OPTION is (c) Having

Easy EXPLANATION: The HAVING clause was added to SQL because the WHERE keyword could not be USED with aggregate FUNCTIONS.
Discussion
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»

Right ANSWER is (a) RENAME

Explanation: With RENAME statement you can rename a table.RENAME, REVOKE and GRANT are DDL commands and UPDATE is DML COMMAND.
Discussion
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»

Right ANSWER is (a) ALTER TABLE

The EXPLANATION: To change the structure of the table we USE ALTER TABLE SYNTAX:

ALTER TABLE “table_name” ADD “column_name” datatype

OR

ALTER TABLE “table_name” DROP COLUMN “column_name”.
Discussion
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»

Correct option is (d) All of the MENTIONED

To EXPLAIN I would say: All the mentioned commands are the PART of DDL STATEMENTS.
Discussion
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»

The correct option is (a) Data Definition Language(DDL)

The best EXPLANATION: The DDL is used to manage table and index structure.CREATE, ALTER, RENAME, DROP and TRUNCATE STATEMENTS are the names of few data definition elements.
Discussion
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»

Correct OPTION is (a) SELECT DISTINCT

The best explanation: The keyword allows us to grab all information from a column (or columns) on a table. This, of COURSE, necessarily means that there will be REDUNDANCIES. 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;.
Discussion
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» CORRECT answer is (c) SELECT city, temperature FROM WEATHER ORDER BY temperature;

To explain I would say: SELECT column_name, aggregate_function(column_name)

 FROM table_name

 WHERE column_name OPERATOR value

 GROUP BY column_name

 HAVING aggregate_function(column_name) operator value

 ORDER BY ;

So base on [SELECT city, temperature FROM weather ORDER BY temperature;] this will be the correct answer.
Discussion
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»

Right answer is (d) None of the Mentioned

The BEST explanation: SELECT SYSDATE – SYSDATE FROM DUAL; outputs 0 SELECT SYSDATE – (SYSDATE – 2) FROM DUAL; outputs 2

SELECT SYSDATE – (SYSDATE + 2) FROM DUAL; outputs -2.
Discussion
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»

The correct OPTION is (B) Modify

To elaborate: Sometimes we need to CHANGE the data type of a COLUMN. To do this, we use the ALTER TABLE Modify Column ALTER TABLE table_name, MODIFY column_name “NEW Data Type”.
Discussion
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»

Right answer is (B) SELECT Username, Password FROM Users

The best explanation: CORRECT order of SELECT, FROM and WHERE CLAUSE is as FOLLOW:

SELECT column_name1, column_name2 FROM table_name WHERE condition So, only SELECT Username, Password FROM Users follows the above syntax.
Discussion
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»

The correct OPTION is (a) Data Definition Language(DDL)

Explanation: The Data Definition Language is USED to MANAGE table and index structure.CREATE, ALTER, RENAME, DROP and TRUNCATE statements are the NAMES of few data definition elements.
Discussion
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»

The correct answer is (a) Structured Query LANGUAGE

To elaborate: SQL (Structured Query Language) is a special-purpose programming language designed for managing data held in a relational DATABASE MANAGEMENT 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 INSERT, query, update and delete, SCHEMA creation and modification, and data access control.
Discussion