MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Sql Server
Sqlserver Assessment
Quiz 1
1
2
3
4
5
6
7
8
9
10
Q.1
A _________ report solution includes a main report that displays summary information with hyperlinks to one or more reports that display detailed information.
a) Main
b) Detail
c) Drillthrough
d) All of the mentioned
Q.2
Point out the correct statement.
a) A published report is a report definition (.rdl) file
b) A saved report is a published report definition that is converted to a newer schema when a report server is upgraded
c) Report history is a collection of report snapshots
d) All of the mentioned
Q.3
An ___________ report is a fully paged report saved in a specific file format.
a) exported
b) fully processed
c) compiled
d) all of the mentioned
Q.4
Which of the following is a list type in RDL with baseencoded value?
a) Boolean
b) Binary
c) Enum
d) Name
Q.5
Point out the wrong statement.
a) A report snapshot is a report that contains layout information and query results that were retrieved at a specific point in time. Unlike on-demand reports
b) A detailed report is a saved copy of a compiled report and report data
c) A report model is a user-friendly description of an underlying database, with pre-established data relationships and auto-generated queries
d) All of the mentioned
Q.6
You can use Report Manager in ________ mode and SharePoint site administration pages in ________ mode.
a) Native, Sharepoint
b) Sharepoint, Native
c) Native, Native
d) Sharepoint, Sharepoint
Q.7
__________ are portable, multipurpose items that contain ready-to-use schedule information.
a) Report-specific schedule
b) Shared schedules
c) File schedules
d) None of the mentioned
Q.8
The Schedule and Delivery Processing feature must be enabled through the ____________ property.
a) ScheduleEventsDeliveryEnabled
b) ScheduleEventsAndReportDeliveryEnabled
c) ScheduleEventsAndReportDelivery
d) All of the mentioned
Q.9
The functionality that SQL Server Agent provides to Reporting Services can be replaced with custom code that uses the _________ method to add schedule events to the queue.
a) FireEvent
b) FireEventdata
c) Eventdata
d) None of the mentioned
Q.10
Which of the following statement is used to retrieve rows from the view ExecutionLog3?
a) select * from ExecutionLog3 order by TimeStart DESC
b) select * from ExecLog3 order by TimeStart DESC
c) select * from ExecutionLog4 order by TimeStart DESC
d) none of the mentioned
0 h : 0 m : 1 s
1
2
3
4
5
6
7
8
9
10
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page