Tag: databases

Questions Related to databases

The process to assemble and link edit the macro instructions that specify an application programs view of one or more databases is called.
technology databases

  1. PCBGEN

  2. PSBGEN

  3. DBDGEN

  4. ACBGEN

Show answer
Correct Option: B

What tool should you recommend for a junior DBA to use to create a simple backup strategy for a SQL Server database?
technology databases

  1. Database Engine Tuning Advisor

  2. SQL Server Configuration Manager

  3. Database Maintenance Plan Wizard

  4. Database Maintenance design surface

Show answer
Correct Option: C

You have a 1TB SalesDB database running on SQL Server 2003 Enterprise Edition. You have noticed that the nightly DBCC CHECKDB ('SalesDB') job is starting to take too long, and you want to reduce the amount of time that the check will take. What command should you schedule to run nightly instead?
technology databases

  1. DBCC CHECKDB ('SalesDB', REPAIR_ALLOW_DATA_LOSS)

  2. DBCC CHECKDB ('SalesDB', REPAIR_REBUILD)

  3. DBCC CHECKDB ('SalesDB') WITH PHYSICAL_ONLY

  4. DBCC CHECKDB ('SalesDB') WITH DATA_PURITY

Show answer
Correct Option: C

You want to create a replication strategy that will allow users in four branch offices to have a fresh copy of data from the database in the central office every day at 5 a.m. for their daily reports. Although there are many changes to the data during the course of a day, the entire publication is not that large. Which replication strategy should you use in SQL Server?
technology databases

  1. Transactional replication

  2. Peer-to-peer replication

  3. Merge replication

  4. Snapshot replication

Show answer
Correct Option: D

You write a SQL Server stored procedure that will return data for a report. The accuracy of the data is not so important; however, you want to avoid dirty reads. Which isolation level should you avoid?
technology databases

  1. Read Committed

  2. Read Uncommitted

  3. Repeatable Read

  4. Serializable

Show answer
Correct Option: B

You want to identify the top 10 queries in SQL Server that have been recompiled the most times on your server. What can you do?
technology databases

  1. Use the sys.dm_exec_requests dynamic management view.

  2. Use the sys.dm_exec_sessions dynamic management view

  3. Use the sys.dm_exec_query_stats dynamic management view

  4. Use the sys.dm_exec_query_optimizer_info dynamic management view

Show answer
Correct Option: C

When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?
technology databases

  1. System tablespace

  2. Users tablespace

  3. Default tablespace for the user

  4. Default tablespace for system

Show answer
Correct Option: C

Assuming today is Monday, 10 July 2000, what is returned by this statement: SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual;
technology databases

  1. 36724

  2. 36717

  3. 36719

  4. 36718

Show answer
Correct Option: A

What does PCB stands for in IMS?
technology databases

  1. Process control Block

  2. Program Control Block

  3. Program Communication Block

  4. Process Communication Block

Show answer
Correct Option: C

If any higher-level segements is retrieved during IMS seqential retrieval it is indicated by which one of the following status code

technology databases

  1. GA

  2. GD

  3. GK

  4. GB

Show answer
Correct Option: A