Prepare
Practice
Interview
Aptitude
Reasoning
English
GD
Placement papers
HR
Current affairs
Engineering
MCA
MBA
Online test
Login
Online Practice Test
>
Database 1
« Previous
Next »
Which is true regarding indexing operation?
Options
- Sorts a file using a single key.
- Sorts a file using two keys
- Established an index for a file
- Both B and C
CORRECT ANSWER : Established an index for a file
Discussion Board
Established an index for a file
When using indexes in an application, you might need to request that the DBA grant privileges or make changes to initialization parameters. To create a new index, you must own, or have the INDEX object privilege for, the corresponding table. The schema that contains the index must also have a quota for the tablespace intended to contain the index, or the UNLIMITED TABLESPACE system privilege. To create an index in another user's schema, you must have the CREATE ANY INDEX system privilege. You can create indexes on columns to speed up queries. Indexes provide faster access to data for operations that return a small portion of a table's rows.
Prajakta Pandit 03-14-2017 07:07 AM
« Previous
Next »
Write your comments
*
*
Email must be in the form someone@domain.com
*
*
Enter the code shown above:
Please enter the code shown above
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
Related Content
SQL Server (40)
SQL Server (28)
SQL Server (25)
Data Warehousing (10)
Biztalk (15)
SQL Server DBA (15)
Database (30)
Database (28)
DBMS (20)
Advertisement
▲