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
  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 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

Which dbcc command logs records onto dbccdb database

  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

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

What are the different types of synonyms?

  1. Schema synonym

  2. Public synonym

  3. Private synonym

  4. Database synonym

Correct Option: B,C




Correct Option: B

What are the DML statements you can use on a synonym created for a table?

  1. Select

  2. Insert

  3. Update

  4. Delete

Correct Option: A,B,C,D
  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