MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Information Science
1000 Oracle Database
Quiz 2
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Q.1
Which of the following is not included in DML (Data Manipulation Language)?
a) UPDATE
b) CREATE
c) INSERT
d) DELETE
Q.2
Which of the following keyword is used with Data Control Language (DCL) statements?
a) INSERT
b) SELECT
c) GRANT
d) DELETE
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].
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)
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
Q.6
The SQL statement
a) 2345
b) 456789
c) 6789
d) 1234
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
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
Q.9
Which of the following is not a Key in SQL Server?
a) Alternate
b) Secondary
c) Foreign
d) Primary
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
Q.11
Which of the following is the oldest database model?
a) Deductive
b) Physical
c) Network
d) Relational
Q.12
Which of the following object types below cannot be replicated?
a) Sequence
b) Data
c) Trigger
d) View
Q.13
What is the result of the following ‘ORA’NULL’CLE’?
a) ORA CLE
b) Error
c) NULL
d) ORACLE
Q.14
The redo log buffer and Shared pool are elements of?
a) SGA
b) PGA and Buffer cache
c) Buffer cache
d) PGA
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
0 h : 0 m : 1 s
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page