০০। Oracle 9i can scale tens of thousands of concurrent users support upto _________ petabytes data.
ক) 124
খ) 256
গ) 512
ঘ) 624
০১। Oracle 9i Reports gives us _______options for building a Web report.
ক) two
খ) three
গ) four
ঘ) five
০২। Oracle 9i Reports is the solution of _______
ক) Paper publishing
খ) Web publishing
গ) Both paper and web publishing
ঘ) None of these
০৩। The ______ process is used for inter-instance locking in Real Application Clusters.
ক) Front Manager Server
খ) Back Manager Server
গ) Lock Manager Server
ঘ) None of the above
০৪। The ________ performs process recovery when a user process fails.
ক) Log Writer(LGWR)
খ) Checkpoint(CKPT)
গ) System Monitor(SMON)
ঘ) Process Monitor(PMON)
০৫। The ________ performs recovery when a failed instance starts up again.
ক) Log Writer(LGWR)
খ) Checkpoint(CKPT)
গ) System Monitor(SMON)
ঘ) Process Monitor(PMON)
০৬। What is the default return value of a function?
ক) int
খ) char
গ) string
ঘ) None of the above
০৭। What is the maximum number of triggers, can apply to a single table?
ক) 8
খ) 10
গ) 12
ঘ) 14
০৮। What is the output after compile and run the following code ? int Output = 10;
boolean b = false;
if((b == true) && ((Output += 10) == 20))
{
System.out.println("We are equal " + Output);
}
else
{
System.out.println("Not equal! " + Output);
}
ক) Compilation and output of "We are equal 10"
খ) Compilation and output of "Not equal! 10"
গ) Compilation error, attempting to perform binary comparison on logical data type
ঘ) Compilation and output of "Not equal! 20"
০৯। Which among the following keys are used to identify each row of the table uniquely?
ক) Primary key
খ) Unique key
গ) Partial key
ঘ) None of the above
১০। Which command is used to return maximum value from result set?
ক) MAX
খ) MIN
গ) MAXIMUM
ঘ) MAXI
১১। Which of the following is an example for Embedded SQL Statement?
ক) ROLLBACK
খ) SETROLE
গ) ALTER SYSTEM
ঘ) FETCH
১২। Which of the following is/are feature(s) of Oracle 9i?
ক) Scalability
খ) Reliablity
গ) One Development model
ঘ) All of the above
১৩। ________ is a tool for entering and running ad-hoc based database statements.
ক) MySQL
খ) PL/SQL
গ) SQL*PLUS
ঘ) None of the above
১৪। ___________ Database is the only database specifically designed as an Internet development and deployment platform