Tag: databases

Questions Related to databases

Choose the data type not supported by SQL Server
technology databases

  1. varchar

  2. int

  3. text

  4. binary

  5. Image

Show answer
Correct Option: C,E

Tool(s) used for Sybase to oracle migration is/are:

technology databases

  1. SQL Developer

  2. SQLWays

  3. Both a and b

  4. Only a

Show answer
Correct Option: C

Sybase exodus is migration of Sybase to which of the following databases

technology databases

  1. MYSQL

  2. SQL Server

  3. DB2

  4. Oracle

  5. All of the above/ Any database suggested by client

Show answer
Correct Option: B,D

What is a child stored procedure?

technology databases

  1. A procedure that is very small

  2. A procedure being invoked by another procedure

  3. A procedure that is not used by application

  4. System stored procedures

Show answer
Correct Option: B

Choose the datatypes not supported by Oracle

technology databases

  1. timestamp

  2. varchar

  3. datetime

  4. number

  5. raw

Show answer
Correct Option: C

In Sybase what returns the number of row affected by the preceding query

technology databases

  1. @@trancount

  2. @@rowcount

  3. @@sqlstatus

  4. @@rescount

Show answer
Correct Option: B

Magic tables in Sybase are

technology databases

  1. inserted

  2. updated

  3. deleted

  4. created

Show answer
Correct Option: A,C

Identify the background process which, is responsible for writing data from buffer cache to the datafiles to make changes permanent

technology databases

  1. Checkpoint (CKPT)

  2. Database Writer (DBWR)

  3. Process Monitor (PMON)

  4. Log Writer (LGWR)

Show answer
Correct Option: B

Identify the parts of System Global Area. Choose all that apply.

technology databases

  1. Database Buffer Cache

  2. Shared Pool

  3. Data Dictionary

  4. Redolog Group

  5. Redolog Buffer

Show answer
Correct Option: A,B,E

Identify the physical components of the database. Choose all that apply
technology databases

  1. Database

  2. Controlfile

  3. Table

  4. Datafile

  5. Index

  6. Redolog Group

Show answer
Correct Option: B,D,F