Tag: databases

Questions Related to databases

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?
technology databases

  1. It will give an error

  2. PMON

  3. Default listener is started but the instance wont be registered.

  4. CJQn

Show answer
Correct Option: B

what happens if the listener currently running for prod database is terminated due to some reason?
technology databases

  1. The currently connected users will be disconnected.

  2. There will be no effect on users.

  3. remote users will not be allowed to spawn sessions.

  4. None of the above

Show answer
Correct Option: C

Is it possible to resize the size of redo logs while the database is running?
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Code Name of SQL Server 2005?
technology databases

  1. Aegan

  2. Yukon

  3. Kilimanjaro

  4. MSSQL

Show answer
Correct Option: B

Which recovery model doesn't allow Log backups?
technology databases

  1. Full

  2. Simple

  3. Bulk-Logged

  4. None of the above

Show answer
Correct Option: B

This database will be flushed when SQL Server restarts
technology databases

  1. model

  2. msdb

  3. tempdb

  4. MSSQLSystemResource

Show answer
Correct Option: C

Which table has all the users of a server?
technology databases

  1. sysusers

  2. syslogins

  3. sysserverusers

  4. None of the above

Show answer
Correct Option: B

Which of the following option helps to execute a stored procedure when the server instance starts?
technology databases

  1. sp_procoption

  2. sp_serverstartup

  3. sp_autoexecute

  4. None of the above

Show answer
Correct Option: A

Which database holds the information of all the jobs in a server?
technology databases

  1. master

  2. model

  3. sysjobs

  4. msdb

Show answer
Correct Option: D

If a sysadmin is granted with "db_denydatareader" role for a database he will not be able to access the data from that database.
technology databases

  1. True

  2. False

Show answer
Correct Option: A