Engineering Questions with Answers - Multiple Choice Questions
Oracle Database MCQs
1 - Question
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
View Answer
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 - Question
2. In SQL, which of the following is not a data Manipulation Language Commands?
a) Delete
b) Truncate
c) Update
d) Create
View Answer
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 - Question
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)
View Answer
Answer: d
Explanation: Data Communication Language (DCL) is not a type of SQL statement.
4 - Question
4. Which of the following is not included in DML (Data Manipulation Language)
a) INSERT
b) UPDATE
c) DELETE
d) CREATE
View Answer
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 - Question
5. TRUNCATE statement in SQL is a –
a) DML statement
b) DDL statement
c) DCL statement
d) TCL statement
View Answer
Answer: b
Explanation: The SQL TRUNCATE TABLE command is used to delete complete data from an existing table.so its a DDL statement.
6 - Question
6. In SQL, which command is used to add new rows to a table?
a) Alter Table
b) Add row
c) Insert
d) Append
View Answer
Answer: c
Explanation: Alter Table will change the structure of the table.
7 - Question
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)
View Answer
Answer: c
Explanation: Stack works on the First In Last Out.
8 - Question
8. A table that displays data redundancies yields ____________ anomalies.
a) Update
b) Insertion
c) Deletion
d) All of the Mentioned
View Answer
Answer: d
Explanation: Table that displays data redundancies yields update, insertion, deletion anomalies.
9 - Question
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
View Answer
Answer: b
Explanation: Sub-query that is placed within a WHERE or HAVING clause of another query.
10 - Question
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
View Answer
Answer: b
Explanation: The users and practitioners are concerned with only Data manipulation language component of DBMS.