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

AI Explanation

To answer this question, we need to understand how Oracle manages the storage of segments.

When a user creates an object (such as a table or index) without specifying a TABLESPACE clause, Oracle will store the segment in the default tablespace for the user.

Option A) System tablespace - This option is incorrect because the system tablespace is used to store the data dictionary and other system-related objects, not user-created segments.

Option B) Users tablespace - This option is incorrect because there is no specific "users" tablespace in Oracle. Each user has their own default tablespace, which is where the segment would be stored.

Option C) Default tablespace for the user - This option is correct because Oracle will store the segment in the default tablespace for the user who created the object.

Option D) Default tablespace for system - This option is incorrect because there is no specific "default tablespace for system" in Oracle. The default tablespace is specific to each user.

The correct answer is Option C) Default tablespace for the user. This option is correct because Oracle will store the segment in the default tablespace for the user who created the object.

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