Tag: databases

Questions Related to databases

Two Oraganization has been defined. For both the organization to use same set of books, they have to share atleast
technology databases

  1. Currency

  2. Calender

  3. Accounting Field Structure and Calender

  4. Currency, Calender and Accounting Field Structure

Show answer
Correct Option: D

Below entity has been used to partition data into logical units
technology databases

  1. Application

  2. Set of Books

  3. Organization

  4. Set Of Books

Show answer
Correct Option: B

What are the situations when an index might not be picked up?
technology databases

  1. Leading column in the index is not part of the search arguments

  2. Data types are not matching while doing a join

  3. Optimizer decides that table scan is better

  4. Index name is improper

Show answer
Correct Option: A,B,C

Microsoft recommends a clustered index in every SQL Server table
technology databases

  1. True

  2. False

Show answer
Correct Option: A

A column in a table, having millions of rows, contains the name of States in India. It is defined as CHAR(50). What performance improvements can be made with respect to the data type?
technology databases

  1. Change it to CHAR(10)

  2. Change it to VARCHAR(50)

  3. Change it to NVARCHAR(50)

  4. Change it to CHAR(100)

Show answer
Correct Option: B

ABC Corp is an organization, where company raises purchase orders, process payments, captures transaction and reconciles the information. The products involved in this are (choose all applicable)

technology databases

  1. Istore

  2. GL

  3. Cash Management

  4. Purchasing

  5. Inventory

  6. Order Management

Show answer
Correct Option: B,C,D,E

Numeric columns are best suited to define an index (for faster access)

technology databases

  1. True

  2. False

Show answer
Correct Option: A

In a SQL Server 2005 query plan, the presence of which of the below items are indicators of potential performance issues?
technology databases

  1. Index scan

  2. Table scan

  3. Bookmark lookup

  4. Index seek

Show answer
Correct Option: A,B,C

During performance tuning, it is imperative that we have data regarding the pain points (slow performing queries, high CPU utilizing queries, etc.). What tools are useful in getting these info?

technology databases

  1. Dynamic Management Views (DMV)

  2. DBCC commands

  3. Query plans

  4. BCP

Show answer
Correct Option: A,B,C

In a query, Table_A is joined with Table_B based on the join criteria (Table_A.Column_1 = Table_B.Column_1). The SME in the team mentions that Table_B is the child of Table_A based on Column_1 (one-to-many relationship) and should always have value. Given these considerations, which of the following doesn't apply to this situation?
technology databases

  1. There needs to be a Foreign Key relationship between the two tables.

  2. Table_B.Column_1 shouldn't have NULL values.

  3. There should be a clustered index on Table_A.Column_1 and a non-clustered index on Table_B.Column_1.

  4. Table_B.Column_1 should be unqiue.

Show answer
Correct Option: D