Tag: databases

Questions Related to databases

Multiple choice technology databases

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which Service / Server would be used to host the OLTP data?

SSAS
SSIS
SQL RDBMS
SSRS

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which Service / Server would be used to host the Staging data

SSAS
SSIS
SQL RDBMS
SSRS

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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?

<Deploy_Prod1>.asdatabase
<Deploy_Prod1>.deploymenttargets
<Deploy_Prod1>.configsettings
<Deploy_Prod1>.deploymentoptions

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Limiting the rows in a select statement for a specific condition is done by the clause

Distinct
Projection
Where
All of the above

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

The value returned by the subquery is used by the main query.

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Character values are case insensitive

True
False

Reveal answer Fill a bubble to check yourself

← Previous
1
2
…
158
159
160
161
162
163
164
165
166
…
486
487
Next →