Bissoy.com
Doctors Medicines MCQs Q&A

Before a block of data in main memory can be output to the database, all log records pertaining to data in that block must have been output to stable storage. This is

Before a block of data in main memory can be output to the database, all log records pertaining to data in that block must have been output to stable storage. This is Correct Answer Write-ahead logging

The WAL rule requires only that the undo information in the log has been output to stable storage, and it permits the redo information to be written later.

Related Questions

The conditions regarding selection from a list of suitable candidates to be called for interview after a written examination for appointment of management-level persons to a multi-national company providing accounting services and sales are mentioned below. Candidates: a) Must have a Bachelor's degree in Basic Science with 65% or more marks or BE with 55% or more marks. b) Must have passed the examination with 70% or more marks. c) Age must be between 25 to 30 years as of 1/4/18. d) Must have 3 years of experience in an Accounting Institution and must have a Diploma in Accounting with 60% or more marks. e) Must be currently getting CTC of Rs. 6 lakh or more per annum. If the candidate: 1) If he fulfills all the other conditions other than A above, he will be designated as Junior Accountant. 2) If he fulfills all the other conditions other than (d) and (e) above, he can be designated as Trainee-Accountant. If he fulfills all the above conditions including 5 years of experience, he can be designated as a Senior Accountant. He can be designated as Manager (Accounts) if he fulfills all the above criteria including educational qualifications of CA/ ICWA/ MBA (Finance). Study all the above information and answer the following question. Varun has passed the CA exam and has a bachelor's degree in basic science and a diploma in accountancy, having scored 75% or more in the written examination during his entire career and also in the written examination. His age is 27 years and with 4 years of experience in Accountancy, he has a CTC salary of 18 lakhs per annum. To which of the following positions can he be referred? Select from the given options.
With regard to computer memory, which of the following statement(s) is/are TRUE?  (A) Cache memory is 'volatile' memory. (B) Magnetic memory is 'volatile' memory.  (C) Flash memory is 'volatile' memory. (D) RAM is 'volatile' memory. Choose the correct answer from the option given below:
Which of the following are true? (i) A programming language option does not permit global variables of any king and has no nesting of procedures/functions, but permits recursion can be implemented with static storage allocation (ii) Multi-level access link (or display) arrangement is needed to arrange activation records-only if the programming language being implemented has nesting of procedures/function (iii) Recursion in programming languages cannot be implemented with dynamic storage allocation (iv) Nesting of procedures/functions and recursion require a dynamic heap allocation scheme and cannot be implemented with a stack-based allocation scheme for activation records (v) Languages which permit a function to return a function as its result cannot be implemented with a stack-based storage allocation scheme for activation records.
To constitute a matter of res judicata which of the following conditions must concur?
1. The matter directly and substantially in issue in the subsequent suit or issue must be the same matter which was directly and substantially in issue either actually (section 11, explanation III) or constructively (section 11, explanation IV) in the former suit
2. The former suit must have been a suit between the same parties under whom they or any of them claim. Explanation VI of Section 11 must be read with this condition
3. The parties as aforesaid must have litigated under the same title in the former suit
4. The court which decided the former suit must have been a court competent to try the subsequent suit of the suit in which such issue has been subsequently raised. Explanation II of section 11 is to be read with condition
5. The matter directly and substantially in issue in the subsequent suit must have been heard and finally decided by the court in the first suit. Explanation V of section 11 is to be read with this condition
Consider the following two C code segment. Y and X are one- and two-dimensional arrays of size n and n × n respectively, where 2 ≤ n ≤ 10. Assume that in both code segments, elements of y are initialized to 0 and each element X[i] [j] of array X is initialized to i + j. Further assume that when stored in main memory all elements of x are in same main memory page frame. Code segment 1:                 //initialize elements of y to 0                 //initialize elements X[i] [j] of X to i+j                       for (i = 0; i < n; i++)                                 Y[i] += X[0] [i]; Code Segment 2:                 //initialize elements of Y to 0                 //initialize elements X[i] [j] of X to i+j                        for (i = 0; i < n; i++)                                 Y[i] += X[i] [0]; Which of the following statements is/are correct? S1: Final contents of array Y will be same in both code segments S2: Elements of array X accessed inside the for loop shown in code segment 1 are contiguous in main memory S3: Elements of array X accessed inside the for loop shown in code segment 2 are contiguous in main memory
log 3 + log 9 + log 27 + ……………i. ধারার পরবর্তী পদ log 81 ii. একটি সমান্তর ধারা iii. এর সাধারণ অন্তর log 6 নিচের কোনটি সঠিক?
log 3 + log 9+log 27+...... i. ধারাটির সাধারণ অনুপাত log 3 ii. ধারাটির প্রথম দশটি পদের সমষ্টি 55 log 3 iii. ধারাটি একটি গুণোত্তর ধারা নিচের কোনটি সঠিক?
Which of the following statement about computer memory are true?  A. Secondary storage is non-volatile storage.  B. Video memory found in graphics cards is volatile memory.  C. Primary memory (RAM) is the fastest form of memory in a computer.  Choose the correct answer from the options given below:
Which of the following are true statements? I: Primary storage units have faster access time and less storage capacity as compared to the secondary storage units. II: Primary storage units have sequential access. III: Secondary storage units are non-volatile storage.
You are the administrator of a SQL Server 2000 computer. The server contains a database named FinanceData that is used by a client/server application. Each employee has a SQL Server login that the application uses to access the server.Your company hires a new employee named Andrew. You create a SQL Server login named Andrew. You also create a database user named Andrew in the database and grant the database user full permissions in the database.Whenever Andrew runs the client/server application, he receives the following error message: "Invalid object name." Andrew also reports that he cannot access the database by using the application.You need to ensure that Andrew can use the application. Which Transact-SQL statement should you execute?