Question - 1
Abbreviate the term DBCA?
- Database Control Assistant
- Database Control Application
- Database Configuration Assistant
- Data Control Assistant
Solutions
Answer- C
Question - 2
What is not a constraints used in Oracle?
- NULL
- NOT NULL
- CHECK
- NOT CHECK
Solutions
Answer- D
Question - 3
Which method is used by the clients to connect to the oracle database server?
- TCP/IP
- DECNET
- Both A &B
- None of the above
Solutions
Answer- C
Question - 4
which is the extension of an Oracle SQL*Plus file ?
Answer- B
Question - 5
Which of the following is a collection of one or more replicated objects that are administrated together.
- Replica group
- Replication group
- Replication
- Replica
Solutions
Answer- B
Question - 6
What is the use of Library cache?
- Used to store shared SQL
- Used to do Oracle background processes
- Log of changes made to the database
- None of the above
Solutions
Answer- A
Question - 7
Which is not a module in Oracle forms?
- Form module
- Menu module
- Nav module
- Object Library module
Solutions
Answer- C
Question - 8
What is the data type of DUAL table?
- VARCHAR2(1)
- INT(1)
- BLOB
- ENUM
Solutions
Answer- A
Question - 9
Whic is a database objects in Oracle?
- Tables
- Tablespaces
- Views
- All the above
Solutions
Answer- D
Question - 10
Select the number of bytes that can be stored by the varchar2.
- Upto 1000 bytes
- Upto 2000 bytes
- Upto 4000 bytes
- Upto 5000 bytes
Solutions
Answer- C
Question - 11
What is COALESCE function?
- COALESCE function is used to return the value which is set to be not null in the list
- COALESCE function is used to return the value which is set to be is null in the list
- COALESCE function result sets for VARCHAR2
- None of the above
Solutions
Answer- A
Question - 12
Which of the following segment is destroyed when the SQL statement is finished?
- Data Segment
- Temporary Segment
- Object Segment
- Memory Segment
Solutions
Answer- B
Question - 13
You can create any cluster and associated cluster index in any tablespace that is
- CURRENTLY ONLINE
- OFFLINE
- OPEN
- CLOSED
Solutions
Answer- A
Question - 14
When you drop a single table from a cluster, the database deletes which row of the table?
- Column data
- Row data
- Each row
- None of the above
Solutions
Answer- C
Question - 15
What is the component of logical database structure in Oracle database?
- Tablespaces
- Database schema objects
- Both A & B
- None of the above
Solutions
Answer- C
Question - 16
Which of the following components comprise an Oracle architecture?
- Database related background processes
- Tablespaces
- Datafiles
- All the above
Solutions
Answer- D
Question - 17
Which Shutdown Mode in the ASM instance immediately shuts down without the orderly dismount of disk groups
- ABORT
- NORMAL
- IMMEDIATE
- TRANSACTIONAL
Solutions
Answer- A
Question - 18
Which processes is an instance made of Oracle?
- Oracle background processes
- Data processes
- Memory processes
- All of the above
Solutions
Answer- A
Question - 19
How many types of database links does the oracle database lets you create?
Answer- B
Question - 20
How many partitioning keys columns are specified for range-and-hash-partitioning tables?
Answer- B
Practice more set questions