0

databases Online Quiz - 129

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

Which of the following is a prerequisite for Database Mail?

  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

  1. DBINFO

  2. DES

  3. IDES

  4. DBTABLE


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

What are the different types of synonyms?

  1. Schema synonym

  2. Public synonym

  3. Private synonym

  4. Database synonym


Correct Option: B,C
  1. CREATE SYNONYM

  2. CREATE ANY SYNONYM

  3. CREATE PUBLIC SYNONYM

  4. CREATE OTHER SYNONYM


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

Which are not an advantages of a synonym?

  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