Which SELECT statement should you use if you want to display unique combinations of the POSITION and MANAGER values from the EMPLOYEE table?
SELECT DISTINCT position, manager FROM employee;
SELECT position, manager DISTINCT FROM employee;
SELECT position, manager FROM employee;
SELECT position, DISTINCT manager FROM employee;
Which two are attributes of /SQL*Plus? (Choose two)
/SQL*Plus commands cannot be abbreviated.
/SQL*Plus commands are accesses from a browser.
/SQL*Plus commands are used to manipulate data in tables.
/SQL*Plus commands manipulate table definitions in the database.
/SQL*Plus is the Oracle proprietary interface for executing SQL statements.
Which is an /SQL*Plus command?
INSERT
UPDATE
SELECT
DESCRIBE
DELETE
RENAME
Which two statements are true regarding the ORDER BY clause?
The sort is in ascending by order by default.
The sort is in descending order by default.
The ORDER BY clause must precede the WHERE clause.
The ORDER BY clause is executed on the client side.
The ORDER BY clause comes last in the SELECT statement
The ORDER BY clause is executed first in the query execution.
The size of a table does NOT need to be specified.
True
False
Can you use both HAVING and WHERE SQL clauses in one SQL statement?
Yes
No
Sometimes possible
Can't Say
What is the correct order of the ">" and the "=" operators, when we want to specify greater or equal search condition?
=>
>=
Neither of the other two.
>>
The table columns are also known as...
Fields
Attributes
Records
Schema
What does the following SQL statement do: SELECT Customer, COUNT(Order) FROM Sales GROUP BY Customer HAVING COUNT(Order) >5
Selects the total number of orders from the Sales table, if this number is greater than 5
Selects all Customers from the Sales table
Both of them above
Selects all customers from table Sales that have made more than 5 orders
What does the SQL FROM clause do?
Specifies data retrieved
Specifies the tables to retrieve rows from.
Specifies the columns we are retrieving.
Specifies a search condition.
Which Service / Server would be used to host the OLTP data?
SSAS
SSIS
SQL RDBMS
SSRS
Which Service / Server would be used to host the Staging data
What are the reasons for switching to a solution using Business Intelligence? Select all the options that are applicable.
Slow queries
Disparate Data sources
Invalid / Inconsistent report data
Availability of data to all users
You are in the process of deploying Analysis Services Database in the production environment. You are using the Analysis Services Deployment Wizard to perform this deployment. The project will be named Deploy_Prod1.During the deployment process, you want to retain the existing roles and role members on the destination server.Which input file should you modify to accomplish the objective?
.asdatabase
.deploymenttargets
.configsettings
.deploymentoptions
Limiting the rows in a select statement for a specific condition is done by the clause
Distinct
Projection
Where
All of the above
SYSDATE is a date function that returns the current database server date and time.
The value returned by the subquery is used by the main query.
Character values are case insensitive
To perform wild card search “Like” is used .
What is the output of the following? SELECT ROUND(1111.93412,3) FROM DUAL;
1112
1111.93
1111.93412
1111.934
