A support engineer reports that inserting new sales transactions in a SQL Server 2005 database results in an error. You investigate the error. You discover that in one of the databases, a developer has accidentally deleted some data in a table that is critical for transaction processing. The database uses the full recovery model. You need to restore the table. You need to achieve this goal without affecting the availability of other data in the database. What should you do?
Back up the current transaction log. Restore the database with a different name and stop at
Back up the current transaction log. Restore the database to the point just before the data loss.
Restore the database from the existing backup files to a time just before the data loss.
Restore the database to the point of the last full backup.
A power failure occurs on the storage area network (SAN) where your SQL Server 2005 database server is located. You need to check the allocation as well as the structural and logical integrity of all databases, including their system catalogs. What should you do?
Execute DBCC CHECKFILEGROUP for each filegroup.
Execute DBCC CHECKCATALOG.
Execute DBCC CHECKDB.
Execute DBCC CHECKTABLE for each table.
AppDomains are usually created by hosts
True
False
Which tool is used to generate PE files from MSIl code?
ildasm
ilasm
capol
resgen
Placing web service files in one of these folders, generates a proxy class(out of .wsdl) and a typed dataset (out of .xsd). What is the name of the folder?
App_Data
App_Resources
App_Code
App_WebReferences
Which of the page directive defines the class or virtual path used to type the Master property of a page?
@MasterType
@MasterPage
@Master
@MasterPath
What is called as a collection of CSS files and images?
Skin
Themes
CSS_folder
None
which technigue is best to hack email passwords or bank accounts?
remote keylogging
phishing
guessing
using password recovery tools
what is ment by Brute force attack?
finding users in data base
to attck viruses
to get user ans password from servers
none of above
I am working on manager number field on some table. which is correct usage of nvl function usage....?
nvl(mgrno,0)
nvl(mgrno,'none')
nvl('mgrno',0)
nvl(mgrno,'0')