0

databases Online Quiz - 163

Description: databases Online Quiz - 163
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. SELECT DISTINCT position, manager FROM employee;

  2. SELECT position, manager DISTINCT FROM employee;

  3. SELECT position, manager FROM employee;

  4. SELECT position, DISTINCT manager FROM employee;


Correct Option: A
Explanation:

To solve this question, the user needs to know the syntax of the SELECT statement and the purpose of the DISTINCT keyword. The user must retrieve unique combinations of the POSITION and MANAGER values from the EMPLOYEE table.

Option A is the correct answer:

A. SELECT DISTINCT position, manager FROM employee;

This option retrieves unique combinations of the POSITION and MANAGER values from the EMPLOYEE table. The DISTINCT keyword ensures that each combination is unique and not repeated in the result set.

Option B is incorrect:

B. SELECT position, manager DISTINCT FROM employee;

This option is not valid because the keyword DISTINCT is in the wrong position. The correct syntax is SELECT DISTINCT, not SELECT column1, column2 DISTINCT.

Option C is incorrect:

C. SELECT position, manager FROM employee;

This option retrieves all combinations of the POSITION and MANAGER values from the EMPLOYEE table, including duplicates.

Option D is incorrect:

D. SELECT position, DISTINCT manager FROM employee;

This option is not valid because the keyword DISTINCT is in the wrong position. The correct syntax is SELECT DISTINCT, not SELECT column1, DISTINCT column2.

The Answer is: A

  1. /SQL*Plus commands cannot be abbreviated.

  2. /SQL*Plus commands are accesses from a browser.

  3. /SQL*Plus commands are used to manipulate data in tables.

  4. /SQL*Plus commands manipulate table definitions in the database.

  5. /SQL*Plus is the Oracle proprietary interface for executing SQL statements.


Correct Option: C,D
  1. INSERT

  2. UPDATE

  3. SELECT

  4. DESCRIBE

  5. DELETE

  6. RENAME


Correct Option: D

Which two statements are true regarding the ORDER BY clause?

  1. The sort is in ascending by order by default.

  2. The sort is in descending order by default.

  3. The ORDER BY clause must precede the WHERE clause.

  4. The ORDER BY clause is executed on the client side.

  5. The ORDER BY clause comes last in the SELECT statement

  6. The ORDER BY clause is executed first in the query execution.


Correct Option: A,E

What is the correct order of the ">" and the "=" operators, when we want to specify greater or equal search condition?

  1. =>

  2. >=

  3. Neither of the other two.

  4. >>


Correct Option: B
  1. Fields

  2. Attributes

  3. Records

  4. Schema


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

  2. Selects all Customers from the Sales table

  3. Both of them above

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


Correct Option: D
  1. Specifies data retrieved

  2. Specifies the tables to retrieve rows from.

  3. Specifies the columns we are retrieving.

  4. Specifies a search condition.


Correct Option: B
  1. SSAS

  2. SSIS

  3. SQL RDBMS

  4. SSRS


Correct Option: C
Explanation:

To solve this question, the user needs to have an understanding of the different services/servers in Microsoft SQL Server and their purposes.

SSAS (SQL Server Analysis Services) is used for creating and managing OLAP (Online Analytical Processing) databases, which are used for data analysis and business intelligence.

SSIS (SQL Server Integration Services) is used for data integration and migration, including ETL (Extract, Transform, Load) processes.

SSRS (SQL Server Reporting Services) is used for creating and managing reports based on data stored in a SQL Server database.

C. SQL RDBMS (Relational Database Management System) is the correct option for hosting OLTP (Online Transaction Processing) data. OLTP databases are optimized for the rapid processing of transactions, such as inserting, updating, and deleting data. SQL RDBMS is designed to manage relational databases, which are commonly used for OLTP applications.

Therefore, the correct answer is:

The Answer is: C

  1. Slow queries

  2. Disparate Data sources

  3. Invalid / Inconsistent report data

  4. Availability of data to all users


Correct Option: A

SYSDATE is a date function that returns the current database server date and time.

  1. True

  2. False


Correct Option: B

To perform wild card search “Like” is used .

  1. True

  2. False


Correct Option: B
- Hide questions