Tag: technology

Questions Related to technology

You use the bcp utility to import data during nonworking hours. After importing data into the database, you execute a full backup statement. You need to ensure that the impact on the database during the insert is reduced to a minimum. Which of the following options can help you achieve that?
technology web technology

  1. Set the recovery model to Full

  2. Set the recovery model to Simple

  3. Set the recovery model to Bulk-Logged

  4. Back up the transaction log while performing the inserts

Show answer
Correct Option: C

Which type of index physically orders the rows in a table?

technology web technology

  1. Unique Index

  2. Clustered Index

  3. Non-Clustered Index

  4. Foreign Key

Show answer
Correct Option: B

What does SQL stand for?
technology databases

  1. Structured Query Language

  2. Strong Question Language

  3. Structured Question Language

  4. none of above

Show answer
Correct Option: A

Which SQL statement is used to extract data from a database?
technology databases

  1. OPEN

  2. GET

  3. SELECT

  4. EXTRACT

Show answer
Correct Option: C
  1. Which SQL statement is used to delete data from a database?
technology databases

  1. DELETE

  2. COLLAPSE

  3. REMOVE

  4. None

Show answer
Correct Option: A

Which SQL statement is used to extract data from a database?

technology databases

  1. OPEN

  2. GET

  3. SELECT

  4. EXTRACT

Show answer
Correct Option: C
  1. Which SQL statement is used to update data in a database?
technology databases

  1. SAVE

  2. SAVE AS

  3. MODIFY

  4. UPDATE

Show answer
Correct Option: D
  1. Which SQL statement is used to insert new data in a database?
technology databases

  1. INSERT NEW

  2. ADD RECORD

  3. ADD NEW

  4. INSERT INTO

Show answer
Correct Option: D
  1. With SQL, how do you select all the columns from a table named "Persons"?
technology databases

  1. SELECT Persons

  2. SELECT *.Persons

  3. SELECT * FROM Persons

  4. SELECT [all] FROM Persons

Show answer
Correct Option: C
  1. With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?
technology databases

  1. SELECT * FROM Persons WHERE FirstName<>'Peter'

  2. SELECT [all] FROM Persons WHERE FirstName='Peter'

  3. SELECT * FROM Persons WHERE FirstName='Peter'

  4. SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

Show answer
Correct Option: C