Practice 1000 Oracle Database Multiple Choice Questions with Answers Quiz-2

Q.1.

Which of the following is not included in DML (Data Manipulation Language)?

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

Explanation

Q.2.

Which of the following keyword is used with Data Control Language (DCL) statements?

a) INSERT
b) SELECT
c) GRANT
d) DELETE

Explanation

Q.3.

Which of the following command is used to obtain the structure of an Oracle table?

a) DESC TABLE [TableName].
b) STRUCTURE [TableName].
c) DESCRIBE [TableName].
d) DESCRIBE STRUCTURE [TableName].

Explanation

Q.4.

Which of the following is not a type of SQL statement?

a) Data Definition Language (DDL)
b) Data Control Language (DCL)
c) Data Communication Language (DCL)
d) Data Manipulation Language (DML)

Explanation

Q.5.

command to use iscommand is used for removing a table and all its data from the database?

a) Alter table command
b) Create command
c) Drop table command
d) All of the Mentioned

Explanation

Q.6.

The SQL statement

a) 2345
b) 456789
c) 6789
d) 1234

Explanation

Q.7.

Which of the following command is used to SELECT only one copy of each set of duplicable rows in SQL?

a) SELECT UNIQUE
b) SELECT DIFFERENT
c) SELECT DISTINCT
d) All of the Mentioned

Explanation

Q.8.

Which of the following is record based logical model?

a) E-R Model
b) Network Model
c) Object oriented model
d) None of the Mentioned

Explanation

Q.9.

Which of the following is not a Key in SQL Server?

a) Alternate
b) Secondary
c) Foreign
d) Primary

Explanation

Q.10.

Which of the following is not a component of a data warehouse?

a) Data metadata
b) Data extraction/cleaning/preparation programs
c) Data warehouse data
d) None of the Mentioned

Explanation

Q.11.

Which of the following is the oldest database model?

a) Deductive
b) Physical
c) Network
d) Relational

Explanation

Q.12.

Which of the following object types below cannot be replicated?

a) Sequence
b) Data
c) Trigger
d) View

Explanation

Q.13.

What is the result of the following ‘ORA’NULL’CLE’?

a) ORA CLE
b) Error
c) NULL
d) ORACLE

Explanation

Q.14.

The redo log buffer and Shared pool are elements of?

a) SGA
b) PGA and Buffer cache
c) Buffer cache
d) PGA

Explanation

Q.15.

Which processes is an instance made of Oracle?

a) Data processes
b) Oracle background processes
c) Memory processes
d) All of the Mentioned

Explanation

Support mcqgeeks.com by disabling your adblocker.