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