Loading...

SQL Server

Which is a duplicate copy of a file program that is stored on a different storage media than the original location
  1. Concurrency
  2. Deadlock
  3. Backup
  4. Recovery
_______________ joins are SQL server default
  1. Outer
  2. Inner
  3. Equi
  4. None of the Mentioned
To alter a database ___________ command is used
  1. ALTER database database_name
  2. ALTER database_name
  3. ALTER database database_name
  4. ALTER database_name
The EXISTS keyword will be true if
  1. Any row in the subquery meets the condition only
  2. All rows in the subquery fail the condition only
  3. Both of these two conditions are met
  4. Neither of these two conditions is met
Which of the following is a aggregate function
  1. Average
  2. Sum
  3. With
  4. Minimum
The command ________________ such tables are available only within the transaction executing the query, and are dropped when the transaction finishes
  1. Create table
  2. Create temporary table
  3. Create view
  4. Create label view
Aggregate functions can be used in the select list or the_______clause of a select statement or subquery. They cannot be used in a ______ clause
  1. Where, having
  2. Having, where
  3. Group by, having
  4. Group by, where
Which is duplication of computer operations and routine backups to combat any unforeseen problems
  1. Concurrency
  2. Deadlock
  3. Backup
  4. Recovery
The UNION SQL clause can be used with
  1. SELECT clause only
  2. DELETE and UPDATE clauses
  3. UPDATE clause only
  4. All of the mentioned
Which of the following statement is true
  1. DELETE does not free the space containing the table and TRUNCATE free the space containing the table
  2. Both DELETE and TRUNCATE free the space containing the table
  3. Both DELETE and TRUNCATE does not free the space containing the table
  4. DELETE free the space containing the table and TRUNCATE does not free the space containing the table