Tag: technology

Questions Related to technology

What is true about Drive duplexing
technology storage

  1. Two controllers used to write data and faster than disk mirroring

  2. Spread data between multiple drives

  3. The process of reading and writing data on two drives simultaneously

  4. Disk striping with parity

Show answer
Correct Option: A

This array contains query parameters.
technology web technology

  1. $_GET

  2. $_POSTS

  3. $_GETS

  4. All the above

Show answer
Correct Option: A

What is the first P in PHP stands for?
technology web technology

  1. PHP

  2. PEAR

  3. PECL

  4. ProC

Show answer
Correct Option: A

Which of the in PHP denote FALSE statement about variables?
technology web technology

  1. $$name denote variable variable

  2. $name denote variable variable

  3. $name denote variable

  4. None of the Above

Show answer
Correct Option: B

What is the function to start the session?
technology web technology

  1. session_start()

  2. session_init()

  3. session_boot()

  4. None of the Above

Show answer
Correct Option: A

If you want to find out whether a cookie has been already set which of the following is used
technology web technology

  1. setcookie()

  2. isset()

  3. iscookie()

  4. None of the Above

Show answer
Correct Option: B

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