There is no entry in the file listener.ora. You issue the command "lsnrctl start". Which process will register the running instance with the listener?
It will give an error
PMON
Default listener is started but the instance wont be registered.
CJQn
what happens if the listener currently running for prod database is terminated due to some reason?
The currently connected users will be disconnected.
There will be no effect on users.
remote users will not be allowed to spawn sessions.
None of the above
Is it possible to resize the size of redo logs while the database is running?
True
False
Code Name of SQL Server 2005?
Aegan
Yukon
Kilimanjaro
MSSQL
Which recovery model doesn't allow Log backups?
Full
Simple
Bulk-Logged
This database will be flushed when SQL Server restarts
model
msdb
tempdb
MSSQLSystemResource
Which table has all the users of a server?
sysusers
syslogins
sysserverusers
Which of the following option helps to execute a stored procedure when the server instance starts?
sp_procoption
sp_serverstartup
sp_autoexecute
Which database holds the information of all the jobs in a server?
master
sysjobs
If a sysadmin is granted with "db_denydatareader" role for a database he will not be able to access the data from that database.