databases Online Quiz - 129

Description: databases Online Quiz - 129
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. Service Broker

  2. Database Mirroring

  3. Extended MAPI Profile

  4. Microsoft Exchange Server

Correct Option: A

Which of the following sentences is true for recovery models?

  1. In the Simple recovery model, all transactions are logged.

  2. In the Bulk-Logged recovery model, all transactions are logged.

  3. In the Full recovery model, most transactions are minimally logged.

  4. In the Simple recovery model, most transactions are minimally logged.

Correct Option: D

Which option can be used to generate a new password for an sso login from RUN_SERVER file

  1. -c

  2. -E

  3. -u

  4. -p

Correct Option: D

Which trace is useful for checking index selection by Sybase Optimiser

  1. 3604

  2. 2512

  3. 302

  4. 310

Correct Option: C

Which parameter tells us about current memory used by Sybase ASE

  1. max memory

  2. physical memory

  3. logical memory

  4. network memory

Correct Option: C

Which metadata cache descriptor is used for holding database structure


  2. DES

  3. IDES


Correct Option: D
  1. dbcc checkdb

  2. dbcc checkverify

  3. dbcc checkstorage

  4. dbcc checkalloc

Correct Option: C
  1. auto identity

  2. identity in nonunique index

  3. unique auto_identity index

  4. async log service

Correct Option: B

What clause can be used to check if a dump is valid or not along with load database statement

  1. with header

  2. with headerofdump

  3. with dumpstatus

  4. with listonly

Correct Option: D

if you need to preserve some user defined datatypes in tempdb which database should you add them to

  1. sybmgmtdb

  2. sybsystemprocs

  3. model

  4. master

Correct Option: C

Which @@ gobal variable can tell you the tranasction mode of a session

  1. is_chained

  2. tran_chained

  3. chained

  4. tranchained

Correct Option: D

Which isolation level prevents phantom reads

  1. 0

  2. 3

  3. 2

  4. 1

Correct Option: B
  1. Schema synonym

  2. Public synonym

  3. Private synonym

  4. Database synonym

Correct Option: B,C




Correct Option: B
  1. Table

  2. View

  3. Procedure

  4. Package

  5. Another Synonym

  6. Sequence

Correct Option: A,B,C,D,E,F
  1. Alias for a schema object

  2. Provide security by hiding the name of the object

  3. Provide security by hiding the schema owner of the object

  4. Reduce complexity in SQLs by creating short synonyms names for objects with long names

  5. By granting privilege to synonym, granting privilege to the underlying object can be avoided

Correct Option: E
- Hide questions