Bissoy.com
Doctors Medicines MCQs Q&A

__________ is a database object that defines how the rows of a table or index are mapped to a set of partitions based on the values of certain column.

__________ is a database object that defines how the rows of a table or index are mapped to a set of partitions based on the values of certain column. Correct Answer Partition function

Partition function defines the number of partitions that the table will have and how the boundaries of the partitions are defined.

Related Questions

Consider the following Column A and Column B in which the names of microorganisms are given in Column A and the groups to which they belong are given in Column B: Column A Column B (a) Aspergillus (i) Algae (b) Lactobacillus (ii) Bacteria (c) Paramecium (iii) Fungi (d) Spirogyra (iv) Protozoa   (v) Virus The correct match of the items of Column A with that of Column B is
Consider a database table T containing two columns X and Y each of type integers. After the creation of the table, one record (X= 1, Y=l) is inserted in the table. Let MX and MY denote the respective maximum values of X and Y among all records in the table at any point in time. Using M X and MY, new records are inserted in the table 128 times with X and Y values being MX + 1, 2*MY + 1 respectively. It may be noted that each time after the insertion, values of MX and MY change. What will be the output of the following SQL query after the steps mentioned above are carried out? SELECT Y FROM T WHERE X=7;
In the following question, two columns are given containing three phrases each. In the first column, phrases are A, B, and C and in the second column, the phrases are D, E and F. A phrase from the first column may or may not connect with a phrase from the second column to make a grammatically and contextually correct sentence. There are five options, four of which display the sequence(s) in which the phrases can be joined to form a grammatically and contextually correct sentence. If, none of the options given forms a correct sentence after combination, select 'None of these' as your answer. Column(1) Column(2) (A) Digital photographs are typically created solely by  (D) a certain type of behavioural restraint that has resulted in the establishment of regional peace or economic. (B)Throughout history leaders have used diplomacy to establish  (E) stimulate the economy. (C) Several academics have favoured more public spending on social welfare and infrastructure to  (F) computer-based photoelectric and mechanical techniques, without wet bath chemical processing.
Consider the following statements for Euler’s equation to find the critical load of a column : 1. Critical load of a column is proportional to the flexural rigidity. 2. Critical load of a column depends upon yield stress. 3. Critical load of a column is inversely proportional to the length of the column. 4. Critical load of a column is inversely proportional to the square of the length of the column. Which of the above statements are correct?
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?
In the following question, two columns are given containing three phrases each. In the first column, phrases are A, B, and C and in the second column, the phrases are D, E and F. A phrase from the first column may or may not connect with a phrase from the second column to make a grammatically and contextually correct sentence. There are five options, four of which display the sequence(s) in which the phrases can be joined to form a grammatically and contextually correct sentence. If, none of the options given forms a correct sentence after combination, select 'None of these' as your answer. Column (1) Column(2) (A) Every culture has its own stories or narratives, which are shared as (D) social researchers draw upon a variety of qualitative and quantitative techniques. (B)The range of social scientific methods has also expanded, as  (E) in varying ways, according to the purposes of the speaker or author, and the characteristics of the situation they are concerned with. (C) Public policy can be conceptualized  (F) a means of entertainment, education, cultural preservation or instilling moral values.
In the following question, two columns are given containing three phrases each. In the first column, phrases are A, B, and C and in the second column, the phrases are D, E and F. A phrase from the first column may or may not connect with a phrase from the second column to make a grammatically and contextually correct sentence. There are five options, four of which display the sequence(s) in which the phrases can be joined to form a grammatically and contextually correct sentence. If, none of the options given forms a correct sentence after combination, select 'None of these' as your answer. Column (1) Column (2) (A) An important point that the Survey makes is that of the Indian economy (D) based on naturally occurring biological processes. (B) Tree Plantation drives combat many environmental issues like deforestation, erosion of soil, desertification in semi-arid areas, global warming and hence (E)recovering during the second half of this year. (C) Organic farming methods combine scientific knowledge of ecology and some modern technology with traditional farming practices (F) enhancing the balance of the environment.
In the following question, 2 columns are given containing three phrases/ sentence each. In the first column sentences A, B, C and in the second column D, E, F are given. A sentence from the first column may or may not connect with another sentence/ phrase from the second column to make a grammatically and contextually correct sentence. Each question has five options, four of which display the sequences of the sentences. If none of the above is the answer, then mark option (e) as the answer. Column 1  Column 2  A. The coming wave of space tourism    D. is teamed up with the designers  B. NASA is set to launch a satellite equipped with  E. the most advanced laser instrument of its kind  C. The target audience is not astronauts    F. for an essential purpose                                                       
A linear Hamming code is used to map 4-bit messages to 7-bit codewords. The encoder mapping is linear. If the message 0001 is mapped to the codeword 0000111, and the message 0011 is mapped to the codeword 1100110, then the message 0010 is mapped to
Consider six memory partitions of sizes 200 KB, 400 KB, 600 KB, 500 KB, 300 KB and 250 KB, where KB refers to kilobyte. These partitions need to be allotted to four processes of sizes 357 KB, 210 KB, 468 KB and 491 KB in that order. If the best fit algorithm is used, which partitions are NOT allotted to any process?