Dear Aspirants,
Welcome to the Professional Knowledge Section in Affairscloud.com. Here we are providing sample questions in DBMS. It will be useful for the IBPS SO IT officer. We have also included some important questions that are repeatedly asked in previous exams.
- Which of the following is/are feature(s) of Oracle 9i?
A. Scalability
B. Reliablity
C. One Development model
D. All of the aboveD. All of the above - Which of the following is an example for Embedded SQL Statement?
A. ROLLBACK
B. SETROLE
C. ALTER SYSTEM
D. FETCHD. FETCH - ________ is a tool for entering and running ad-hoc based database statements.
A. MySQL
B. PL/SQL
C. SQL*PLUS
D. None of the aboveC. SQL*PLUS - ___________ Database is the only database specifically designed as an Internet development and deployment platform
A. Oracle 6i
B. Oracle 7i
C. Oracle 8i
D. Oracle 9iD. Oracle 9i - Oracle 9i can scale tens of thousands of concurrent users support upto _________ petabytes data.
A. 124
B. 256
C. 512
D. 624C. 512 - Oracle 9i Reports gives us _______options for building a Web report.
A. two
B. three
C. four
D. fiveA. two - Oracle 9i Reports is the solution of _______
A. Paper publishing
B. Web publishing
C. Both (A) and (B)
D. None of the aboveC. Both (A) and (B) - The ______ process is used for inter-instance locking in Real Application Clusters.
A. Front Manager Server
B. Back Manager Server
C. Lock Manager Server
D. None of the aboveC. Lock Manager Server - The ________ performs recovery when a failed instance starts up again.
A. Log Writer(LGWR)
B. Checkpoint(CKPT)
C. System Monitor(SMON)
D. Process Monitor(PMON)C. System Monitor(SMON) - The ________ performs process recovery when a user process fails.
A. Log Writer(LGWR)
B. Checkpoint(CKPT)
C. System Monitor(SMON)
D. Process Monitor(PMON)D. Process Monitor(PMON)
AffairsCloud Recommends Oliveboard Mock Test
AffairsCloud Ebook - Support Us to Grow
Govt Jobs by Category
Bank Jobs Notification
