Interested to Buy Any Domain ? << Click Here >> for more details...
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
- 0 Answers
- 1011 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How do you use a subquery to find records that exist in one table and do not exist in another?
What is the difference between varchar and nvarchar types?
What is sql injection? How to protect against sql injection attack?
What is the difference between Stored Procedures and triggers?
What are the different sql server versions?
What is difference between delete and truncate commands?
default databases available in sql server and there uses ?
What are 3 ways to get a count of the number of records in a table?
Explain logical operators in sql server?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
Can an automatic recovery be initiated by a user?
Can a table have 2 foreign keys?
-
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)
