in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
1076you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
954if no size is defined while creating the database, what size will the database have? : Sql server administration
1019you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
986how you can move data or databases between servers and databases in sql server? : Sql server administration
982you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
1262You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
1016You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
1000You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
958How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
1039
Can we install Oracle database in VT100 Server?
Is there anyway to automatically update the Datasource name in Database Checkpoints object when we migrate tests to a new release?
How to connect to a remote database using Applet?
How database connectivity in XML is achieved?
How data can be inserted into long row column of database?
How to know howmuch data is truncated?
What are the parameters available in user exit for enhancing master data?
What are the data target administration tasks?
Where the data is extracted during init of delta and during delta updates?
How do you transform OH data?
How will you do data driven testing using Robot?
Where the datapool values are stored?
What is datapool cursor?
What is standard data type and what is user defined data type?
What information is contained in the Datapool_config section?