pl-sql – programming-sql – কুইজ মডেল টেস্ট অনুশীলন – 12

pl-sql – programming-sql – কুইজ মডেল টেস্ট অনুশীলন – 12

8736. What will be the output of the following code : if salary < 1000 then end if;

1. Is valid
2. Generates object not found error
3. Generates SQL error
4. Is invalid

8737. What is an valid statement

1. Both of the above
2. count := count + 1;
3. count : = count + 1;
4. None of the above

8738. Select the type of loop appropriate to meet the following requirement: To set the status of each company whose company IDs are stored in a PL/SQL table to closed.

1. FOR numeric loop
2. DO-WHILE loop
3. Cursor FOR loop
4. Loop

8739. Which procedure will never be executed in this IF statement? IF (submit_date > SYSDATE) AND order_total >= min_order_total THEN fill_order (order_id, ‘HIGH PRIORITY’); ELSIF (submit_date < SYSDATE) OR (submit_date = SYSDATE) THEN fill_order (order_id, ‘LOW PRIORITY’); ELSIF submit_date <= SYSDATE AND order_total < min_order_total THEN queue_order_for_addtl_parts (order_id); ELSIF order_total = 0 THEN disp_message (‘ No items have been placed in this order!’); END IF;

1. disp_message
2. queue_order_for_addtl_parts
3. None is executed
4. fill_order

8740. What will the value of X_STATUS be when the following code is executed : DECLARE X_BONUS BOOLEAN; X_COMMISSION BOOLEAN := FALSE; X_STATUS BOOLEAN; BEGIN X_STATUS := X_BONUS AND X_COMMISSION; END;

1. UNDEFINED
2. TRUE
3. FALSE
4. NULL

8741. Choose the true answer: A variable is defined as %TYPE.

1. If the underlying table column data type changes
2. the PL/SQL code needs to be changed.Only character variables can be defined using %TYPE.
3. You do not have to know the data type or the precision of that column.
4. None of the above

8742. Select the type of loop appropriate to meet the following requirement: For each of twenty years in the loan processing cycle, calculate the outstanding loan balance for the specified customer. If the customer is a preferred vendor, stop the calculations after twelve years.

1. FOR numeric loop
2. DO-WHILE loop
3. Cursor FOR loop
4. While loop

8743. What is the maximum size of a CHAR value in bytes

1. 65536
2. 65535
3. 32767
4. 32768

8744. What is the default size for NCHAR datatype

1. 1
2. 0
3. NULL
4. 32767

8745. What is the limit for levels of block nesting

1. 256
2. 255
3. 128
4. 127

আমাদের কাছে থাকা লক্ষ লক্ষ মডেল টেস্ট থেকে প্রাকটিজের জন্য কিছু এখানে তুলে ধরা হল। প্রতিটি অধ্যায়ের উপরে ইশিখন.কম কুইজ চ্যালেঞ্জ এ আছে শত শত মডেল টেস্ট বার বার মডেল টেস্ট দিয়ে নিজেকে যাচাই কর এবং পুরো বাংলাদেশের সকল শিক্ষার্থীর সাথে আপনার মেধা তালিকা দেখুন। প্রশ্নে কোন প্রকার ভুল থাকলে সঠিক উত্তরসহ নিচে কমেন্ট করে জানাবেন, আমরা ঠিক করে দেবো।