Tag: databases

Questions Related to databases

NOARCHIVELOG mode does have the advantage of not having to write transactions to an archive log and thus increases the performance of the database slightly.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

The ANALYZE command is used to gather statistics on a table
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Before making a tablespace read only, which of the following conditions must be met
technology databases

  1. The tablespace must be online

  2. The tablespace must not contain any active rollback segments

  3. he tablespace must not be involved in an open backup

  4. All of the above

Show answer
Correct Option: D

Select correct type of parameter mode used in oracle
technology databases

  1. IN

  2. OUT

  3. IN OUT

  4. All of the above

Show answer
Correct Option: D

You need to remove the database trigger T1. Which command do you use to remove the trigger in the SQL *Plus environment?
technology databases

  1. DROP TRIGGER T1

  2. DELETE TRIGGER T1

  3. ALTER TRIGGER T1 DISABLE

  4. None of the above

Show answer
Correct Option: A

A cold backup is taking a backup of the database while it is shut down and does not require being in archive log mode.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

What tablespace is automatically created when we create a database
technology databases

  1. The Default tablespace

  2. The temp tablespace

  3. The SYSTEM tablespace

  4. None of the above

Show answer
Correct Option: C

In which four clauses can a subquery be used?
technology databases

  1. in the INTO clause of an INSERT statement

  2. in the GROUP BY clause of a SELECT statement

  3. in the VALUES clause of an INSERT statement

  4. in the ORDER BY clause of a SELECT statement

Show answer
Correct Option: A

Uses of SSIS
technology databases

  1. to move data from one data source to another

  2. powerful ETL tool

  3. To design various kind of reports

  4. to provide business information to a wider audience within an organization

Show answer
Correct Option: A,B,D

What does the following SQL statement do: SELECT Customer, COUNT(Order) FROM Sales GROUP BY Customer HAVING COUNT(Order) >5
technology databases

  1. Selects the total number of orders from the Sales table, if this number is greater than 5

  2. Selects all customers from table Sales that have made more than 5 orders.

  3. Selects all Customers from the Sales table

  4. None of the above

Show answer
Correct Option: B
Explanation:

To understand this SQL statement, the user needs to know the basic structure of SQL queries. In this case, the statement selects two fields, Customer and COUNT(Order), from the Sales table. It then groups these fields by Customer and applies a filter using the HAVING clause to only return rows where the count of orders for that customer is greater than 5.

A. This option is incorrect because the statement is not selecting the total number of orders, but rather the count of orders for each customer.

B. This option is correct. The statement is selecting all customers from the Sales table that have made more than 5 orders.

C. This option is incorrect because the statement is not selecting all customers, but rather only those who have made more than 5 orders.

D. This option is incorrect because option B is correct.

Therefore, the answer is: B. Selects all customers from table Sales that have made more than 5 orders.