Tag: databases

Questions Related to databases

mod(-15, 4)would return ?
technology databases

  1. 15

  2. -15

  3. -3

  4. 3

Show answer
Correct Option: C

instr(Tech on the net, e, -3, 2) would retrun
technology databases

  1. 10

  2. 8

  3. 6

  4. 2

Show answer
Correct Option: D

power(-5, 3) would return ?
technology databases

  1. -15

  2. -125

  3. 125

  4. 15

Show answer
Correct Option: B

TRUNC(44.647, -1) would retrun ?
technology databases

  1. 44.6

  2. 44

  3. 40

  4. 43

Show answer
Correct Option: C

Your company has created a custom application that will require the use of several stored procedures. The lifetime of this application is relatively short and you wish to create the stored procedures such that they can all be dropped with a single DROP PROCEDURE statement command at the end of the application's lifetime. How can you group the procedures together such that they can all be dropped with a single DROP PROCEDURE statement?
technology databases

  1. Create each procedure with a distinct name followed by a semi-colon and a group name.

  2. Create each procedure with a distinct name followed by a semi-colon and a group number.

  3. Create each procedure with the same name followed by a semi-colon and a group name.

  4. Create each procedure with the same name followed by a semi-colon and a distinct number.

Show answer
Correct Option: D

You have a mission critical database named MCDB1 that you want to configure for automatic failover. You have decided to utilize database mirroring. Which database mirroring operating mode should you use?

technology databases

  1. High safety mode

  2. Asynchronously

  3. High performance mode

  4. Synchronously

Show answer
Correct Option: A

You have been assigned the task of designing a relational database for a client. The database will be used to store an exact copy of specific XML documents that the client needs to retrieve on a regular basis. The client wants to be able to use an application that they created to enter the documents into the database as well as retrieve them. You are in the process of designing a table for the database. What should you do?
technology databases

  1. Convert the XML documents to relational data and then store them within the database

  2. Create a table that uses XML as the data type for the column that will store the XML documents.

  3. Nothing. You can not store XML documents within a SQL Server 2005 database

  4. Create a table that uses nvarchar(max) as the data type for the column that will store the XML documents

Show answer
Correct Option: D

EasyYatra is a travel booking company that has a web site available for customers to view and book their vacations online. You have been hired to look after the back-end SQL Server that is used to store customer and booking information. You are creating a table called Booking to keep track of vacations booked by customers. This table will contain a computed column called Total that is derived from other columns in the table. You want to be able to create an index on this Total column to increase performance when any queries are executed using this column. To do this, you want to physically store the computed column in the table. How can this be done?

technology databases

  1. Mark the computed column as PERSISTED.

  2. Define the computed column as NULL.

  3. Specify the collation for the column using COLLATE Physical.

  4. Do nothing. Computed columns are stored in the table by default.

Show answer
Correct Option: A

You are gathering performance and optimization data for your SQL Server 2005 database. Your company has three custom applications that routinely make use of the database. Each application accesses the database using separate login credentials. You wish to gather information concerning the queries executed by each custom application. To gather this data you decide to create a trace using the SQL Server Profiler. You decide to use one of the predefined SQL Server Profiler templates to define what data should be gathered. Which predefined SQL Server Profiler template would best suit your requirements?

technology databases

  1. TSQL_Duration

  2. TSQL_Grouped

  3. TSQL_Replay

  4. TSQL_SPs

Show answer
Correct Option: B

NA
technology databases

  1. Na

  2. An

  3. fe

  4. fef

Show answer
Correct Option: A