Tag: databases

Questions Related to databases

A support engineer reports that inserting new sales transactions in a SQL Server 2005 database results in an error. You investigate the error. You discover that in one of the databases, a developer has accidentally deleted some data in a table that is critical for transaction processing. The database uses the full recovery model. You need to restore the table. You need to achieve this goal without affecting the availability of other data in the database. What should you do?
technology databases

  1. Back up the current transaction log. Restore the database with a different name and stop at

  2. Back up the current transaction log. Restore the database to the point just before the data loss.

  3. Restore the database from the existing backup files to a time just before the data loss.

  4. Restore the database to the point of the last full backup.

Show answer
Correct Option: A

A power failure occurs on the storage area network (SAN) where your SQL Server 2005 database server is located. You need to check the allocation as well as the structural and logical integrity of all databases, including their system catalogs. What should you do?
technology databases

  1. Execute DBCC CHECKFILEGROUP for each filegroup.

  2. Execute DBCC CHECKCATALOG.

  3. Execute DBCC CHECKDB.

  4. Execute DBCC CHECKTABLE for each table.

Show answer
Correct Option: C

I am working on manager number field on some table. which is correct usage of nvl function usage....?
technology databases

  1. nvl(mgrno,0)

  2. nvl(mgrno,'none')

  3. nvl('mgrno',0)

  4. nvl(mgrno,'0')

Show answer
Correct Option: A

Where do I need to configure to tell how oracle operates while it is running...?
technology databases

  1. control files

  2. password files

  3. parameter files

  4. redo logs

Show answer
Correct Option: C

find the SGA components
technology databases

  1. buffer cache

  2. large pool

  3. java pool

  4. all the above

Show answer
Correct Option: D

Distinct keyword must appear directly after the select keyword in SQL Query....
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Which statements excute without error(select all)
technology databases

  1. select ename||',is the'||job from emp

  2. select ename,||'is the||job from emp

  3. select 'ename'||'is the'||'job' from from emp

  4. select ename||concat('is the',job) from emp

Show answer
Correct Option: A,C

An Element can be
technology databases

  1. Source file

  2. Directories

  3. Binary files

  4. All the above

Show answer
Correct Option: D

What is a Configuration Specification
technology databases

  1. It is a dynamic view.

  2. It is a rule determine which versions of an element are visible in the new view

  3. None of the above.

  4. All of the above.

Show answer
Correct Option: B

What is the operation to get a file from ClearCase
technology databases

  1. Check-In

  2. Check-Out

  3. Deliver

  4. Retrieve

Show answer
Correct Option: B