Oracle SQL Multiple Choice Questions and Answers on DML Commands for Freshers

1. 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 Mentioned
Answer: a

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.
2. In SQL, which of the following is not a data Manipulation Language Commands?

a) Delete
b) Truncate
c) Update
d) Create
Answer: b

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.
3. 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)
Answer: d

Explanation: Data Communication Language (DCL) is not a type of SQL statement.
4. Which of the following is not included in DML (Data Manipulation Language)

a) INSERT
b) UPDATE
c) DELETE
d) CREATE
Answer: d

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.
5. TRUNCATE statement in SQL is a –

a) DML statement
b) DDL statement
c) DCL statement
d) TCL statement
Answer: b

Explanation: The SQL TRUNCATE TABLE command is used to delete complete data from an existing table.so its a DDL statement.
6. In SQL, which command is used to add new rows to a table?

a) Alter Table
b) Add row
c) Insert
d) Append
Answer: c

Explanation: Alter Table will change the structure of the table.
7. 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)
Answer: c

Explanation: Stack works on the First In Last Out.
8. A table that displays data redundancies yields ____________ anomalies.

a) Update
b) Insertion
c) Deletion
d) All of the Mentioned
Answer: d

Explanation: Table that displays data redundancies yields update, insertion, deletion anomalies.
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-query
Answer: b

Explanation: Sub-query that is placed within a WHERE or HAVING clause of another query.
10. The three language components of a database management system (DBMS) like DDL, DCL, DML.
Two different types of people (users and practitioners) are concerned with them. Which of them do users of a DBMS usually deal with?

a) DDL
b) DML
c) DDL and DCL
d) DCL and DML
Answer: b

Explanation: The users and practitioners are concerned with only Data manipulation language component of DBMS.

Related

Data Structures Multiple Choice Questions and Answers on Binary Search Tree

1. Which of the following is false about a binary search tree? a) The left child is always lesser than its parentb) The right child is always greater than its parentc) The left and right sub-trees ...

Data Structures Multiple Choice Questions and Answers on AVL Tree

1. What is an AVL tree? a) a tree which is balanced and is a height balanced treeb) a tree which is unbalanced and is a height balanced treec) a tree with three childrend) a tree with atmost 3 chil...

Data Structures Multiple Choice Questions and Answers on Heap

1. In a max-heap, element with the greatest key is always in the which node? a) Leaf nodeb) First node of left sub treec) root noded) First node of right sub tree Answer: c Explanation: This is o...

Post a Comment

emo-but-icon
:noprob:
:smile:
:shy:
:trope:
:sneered:
:happy:
:escort:
:rapt:
:love:
:heart:
:angry:
:hate:
:sad:
:sigh:
:disappointed:
:cry:
:fear:
:surprise:
:unbelieve:
:shit:
:like:
:dislike:
:clap:
:cuff:
:fist:
:ok:
:file:
:link:
:place:
:contact:

item