Interested to Buy Any Domain ? << Click Here >> for more details...
What is Index Segmentation ?
- 1 Answers
- 7353 Views
- TCS, I also Faced
- E-Mail Answers
A segment is a part of relational data base and consists of
one or more extents. Each extent is further divided into
blocks. Every segment has an index for holding all of its
data for quick data retrieval. Index segments can be created
explicitly by using the CREATE INDEX command. Storage
parameters for the extents of the index segment can be
specified along with this command.
| Is This Answer Correct ? | 4 Yes | 1 No |
What is the difference between mysql and sql server?
What is the contrast amongst drop and truncate?
1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?
How do you run a trace?
How to find the service pack installed? : sql server database administration
What are the benefits of using stored procedures over sql statements?
I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?
What do you understand by triggers and mention the different types of it?
What is global temp table?
Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.
Can sql servers link to other servers like oracle?
What is shrink log file?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
