Райхан Абдыжалилова
Quiz by , created more than 1 year ago

Quiz on SQL part2(21-40), created by Райхан Абдыжалилова on 20/12/2018.

192
2
0
No tags specified
Райхан Абдыжалилова
Created by Райхан Абдыжалилова almost 6 years ago
Close

SQL part2(21-40)

Question 1 of 50

1

Policy categories apply

Select one of the following:

  • to servers

  • to databases and servers

  • to database

  • to routers

Explanation

Question 2 of 50

1

SQL Server can not notify operators of alerts which of the following

Select one of the following:

  • Instance messages

  • E-mail

  • Pager

  • net send

Explanation

Question 3 of 50

1

SQL Server Integration Services Tools

Select one of the following:

  • Extraction, transformation, loading

  • None above them

  • Only SSIS designer

  • Wizards, SSIS Designer, Command-prompt Utilities

Explanation

Question 4 of 50

1

SQLAgentOperatorRole is

Select one of the following:

  • The most privileged of the SQL Server Agent fixed database roles

  • Proxy defines the security context for a non-Transact-SQL job

  • Impersonates the credentials defined in the proxy, and then runs the job

  • Automate common administrative tasks

Explanation

Question 5 of 50

1

SQLAgentUserRole is

Select one of the following:

  • Permissions to view the list of available multi-server jobs, their properties

  • Properties for operators and proxies, and enumerate available proxies and alerts on the server

  • The least privileged of the SQL Server Agent fixed database roles

  • only granted access to those subsystems

Explanation

Question 6 of 50

1

Steps to open Activity Monitor

Select one of the following:

  • In SQL Server Management Studio Right click the Management then select the Activity Monitor

  • In SQL Server Management Studio Right click the Server Objects then select the Activity Monitor

  • ]In SQL Server Management Studio Right click the server then select the Activity Monitor

  • In SQL Server Management Studio expand Management click Activity Monitor

Explanation

Question 7 of 50

1

sys.dm_db_partition_stats returns the following

Select one of the following:

  • Returns information about pending input/output (I/O) requests

  • Returns information about each Service Broker queue monitor in the system

  • Returns page and row count information for each partition in the database

  • Returns information about all the current sessions connected to the server

Explanation

Question 8 of 50

1

The ... database must use the full or bulk-logged recovery model; switching the database to simple recovery will cause log shipping to stop functioning

Select one of the following:

  • Primary

  • Secondary

  • Reserve

  • copied

Explanation

Question 9 of 50

1

The advantage of setting up an alerts management server

Select one of the following:

  • Centralazation

  • Increased traffic

  • Single point of failure

  • Server load

Explanation

Question 10 of 50

1

The basic syntax for bulk importing data is

Select one of the following:

  • INSERT ... SELECT * FROM OPENROWSET(BULK...)

  • INSERT ... SELECT * FROM OPENROWSET

  • SELECT * FROM OPENROWSET

  • SELECT * FROM (BULK...)

Explanation

Question 11 of 50

1

The CFO calls you in because he is running a large spreadsheet on his system and it is running unusually slowly. He wants you to try to get his system moving faster again. Which Windows XP utility will give you a quick look at the performance of this system?

Select one of the following:

  • Director

  • Speed Analyzer

  • Computer Manager

  • Task Manager

Explanation

Question 12 of 50

1

The disadvantage of setting up an alerts management server

Select one of the following:

  • Increased traffic

  • Centralization

  • Scalability

  • Efficiency

Explanation

Question 13 of 50

1

The list of available providers includes the following data sources

Select one of the following:

  • SQL Server

  • Flat files

  • Microsoft Office Access(r), Microsoft Office Excel(r)

  • All of the above

Explanation

Question 14 of 50

1

The name of component of Microsoft SQL Server Management Studio used to get information about user connections to the Database Engine and the locks that they hold?

Select one of the following:

  • Activity Monitor

  • System Monitor

  • Task Manager

  • Event Log Reader

Explanation

Question 15 of 50

1

The number and characteristics of the properties are built into the facet and can be added or removed

Select one of the following:

  • by administrator

  • None above them

  • by all users

  • by only the maker of facet

Explanation

Question 16 of 50

1

There are factors affecting availability. Find wrong answer

Select one of the following:

  • System failure

  • Software failure

  • Network failure

  • Hardware component failure

Explanation

Question 17 of 50

1

This is common dynamic management view (DMVs). What information is it return?

Select one of the following:

  • Returns information about pending input/output (I/O) requests

  • Returns page and row count information for each partition in the database

  • Returns information about all the current sessions connected to the server

  • Returns information about each Service Broker queue monitor in the system

Explanation

Question 18 of 50

1

This is common dynamic management view (DMVs). What information is it return?

Select one of the following:

  • Returns information about the threads in the system

  • Returns page and row count information for each partition in the database

  • Returns information about all the current sessions connected to the server

  • Returns information about each Service Broker queue monitor in the system

Explanation

Question 19 of 50

1

This is common dynamic management view (DMVs). What information is it return? "sys.dm_db_partition_stats"

Select one of the following:

  • Returns page and row count information for each partition in the database

  • Returns information about all the current sessions connected to the server

  • Returns information about pending input/output (I/O) requests

  • Returns information about each Service Broker queue monitor in the system

Explanation

Question 20 of 50

1

This is common dynamic management view (DMVs). What information is it return? "sys.dm_broker_queue_monitors"

Select one of the following:

  • Returns information about each Service Broker queue monitor in the system

  • Returns information about the threads in the system

  • Returns page and row count information for each partition in the database

  • Returns information about all the current sessions connected to the server

Explanation

Question 21 of 50

1

To bulk import data from a data file into a SQL Server table or non-partitioned view, you can use the following

Select one of the following:

  • bcp utility

  • bcp tools

  • bcp all

  • bcp bulk

Explanation

Question 22 of 50

1

To design an event notification, you must determine the following\:
I.The scope of the notification.
II.The Transact-SQL statement, or group of statements, that raises the event notification.
III.Server-scoped DDL triggers

Select one of the following:

  • I, II, II

  • I and III

  • I and II

  • II and III

Explanation

Question 23 of 50

1

To determine whether SQL Server or another process is cause of excessive paging, monitor the following Process

Select one of the following:

  • Page Faults/sec

  • %Privileged Time

  • %User Time

  • %Disk Time

Explanation

Question 24 of 50

1

To enable and configure Database Mail accounts and profiles, what can you use

Select one of the following:

  • Tools->Configure->Database Mail

  • Right click accounts and profiles then click configure

  • In the Database Mail Wizard clear check box accounts and profiles

  • Database Mail Configuration Wizard

Explanation

Question 25 of 50

1

To install SQL Server to Windows Server 2008 what we installing?

Select one of the following:

  • .NET FRAMEWORK

  • transact sql

  • install key

  • registre

Explanation

Question 26 of 50

1

To lock or disable access to database or some authorizing elements what is using?

Select one of the following:

  • Key

  • Insert

  • Duplicate

  • protocol

Explanation

Question 27 of 50

1

To modifying elements in database what transact queries we are using?

Select one of the following:

  • insert, update, drop, create

  • lock, grand, select, show

  • use, work, execute, run

  • play, set, ord, record

Explanation

Question 28 of 50

1

To reserve some db firstly we use

Select one of the following:

  • Backup

  • Recovery

  • Restore

  • update

Explanation

Question 29 of 50

1

To send Database Mail, you must be a member of the

Select one of the following:

  • DatabaseMailUserRole

  • Sysadmin role

  • TargetServerRole

  • SQL Server Agent role

Explanation

Question 30 of 50

1

To work with Server Agent and execute some parametres, what we turn on?

Select one of the following:

  • Configuration Manager

  • Bussines Development Studio

  • Management Studio

  • Server services

Explanation

Question 31 of 50

1

Unlike standard triggers they do not execute in response to which of the following statements

Select one of the following:

  • UPDATE, DELETE, CREATE

  • DROP, INSERT, GRANT

  • REVOKE, ALTER, CREATE

  • UPDATE, INSERT, DELETE

Explanation

Question 32 of 50

1

Was a backup device specified in the restore statement?

Select one of the following:

  • When using this statement, you must specify a snapshot name rather than a backup device.

  • Perform a full database and transaction log backup strategy for frequently modified databases

  • Phases of a restore include the data copy phase, the redo phase and the undo phase

  • The data copy phase involves copying all data, log and index pages from the backup

Explanation

Question 33 of 50

1

What are Key Areas to Monitor in SQL Server?

Select one of the following:

  • Disk system, Memory, CPU

  • CPU performance, Memory performance

  • Hardware stability, software availability

  • Operability, stability, organization

Explanation

Question 34 of 50

1

What are the primarily uses of the SQL Server Configuration Manager?

Select one of the following:

  • Managing SQL Server Services, Changing the Accounts Used by the Services, Manage Server and Client Network Protocols, Configure Server Startup Options, and Manage Instances of SQL Server.

  • The Database Engine Services.

  • The System Configuration Checker checks for conditions that prevent a successful SQL Server installation and will verify the computer where the installation is running.

  • Bussiness Intelegent Studio

Explanation

Question 35 of 50

1

What Backup Job does?

Select one of the following:

  • It performs the backup operation, logs history to the local server and the monitor server, and deletes old backup files and history information.

  • This job restores only the copied backup files to the secondary databases.

  • This job is shared by the primary and secondary databases of all log shipping configurations using this monitor server instance.

  • There is no information about this in lectures

Explanation

Question 36 of 50

1

What benefits would that offer?

Select one of the following:

  • It could avoid the unnecessary expense and administrative overhead of deploying multiple physical servers

  • Enterprise edition would satisfy the needs of large corporate SQL deployments. Other editions would be appropriate in difference scenarios.

  • A fast, multi-core CPU, with lots of RAM (at least 2 Gigs, 8 Gigs or more for an enterprise server), and a redundant disk array.

  • Amount of RAM, number of CPUs, and highly optimized disk storage arrays (in that order) are the most critical items for performance.

Explanation

Question 37 of 50

1

What can indicate that there is an overall shortage of memory on the computer or that an application is not releasing memory?

Select one of the following:

  • Low values for the Available Bytes

  • High values for the Available Bytes

  • Low values for the Busy Bytes

  • High values for the Busy Bytes

Explanation

Question 38 of 50

1

What condition is wrong ?

Select one of the following:

  • The policy is enabled.

  • The target belongs to the target set of the policy.

  • The target or one of the targets ancestors subscribes to the policy group that contains this policy.

  • Only policies from its subscribed categories can govern a database.

Explanation

Question 39 of 50

1

What is an efficient way to determine CPU usage?

Select one of the following:

  • To use the Processor\: %Processor Time counter in System Monitor

  • To use the Processor\:%Processor Avg. Time counter in Event Log Reader

  • To use System\:%Total Processor Time

  • To use the Processor\: %User Time counter in System Monitor

Explanation

Question 40 of 50

1

What counter monitors the percentage of time that the disk is busy with read/write activity?

Select one of the following:

  • % Disk Time

  • Avg. Disk Queue Length

  • Current Queue Length

  • %Busy Time

Explanation

Question 41 of 50

1

What counter shows the number of requests that were outstanding on the disk at the time that the performance data was collected.

Select one of the following:

  • Current Queue Length

  • Avg. Disk Queue Length

  • % Disk Time

  • Universal Disk Performance Measure

Explanation

Question 42 of 50

1

What counter used to determine how many system requests, on average, are waiting for disk access

Select one of the following:

  • %Busy Time

  • % Disk Time

  • Current Queue Length

  • Avg. Disk Queue Length

Explanation

Question 43 of 50

1

What Distributors do?

Select one of the following:

  • store replication-specific data associated with one or more publishers

  • create and modify the data

  • Receive the data. With merge replication, this situation is altered slightly because modifications occur at both the publisher and the subscribers

  • Modify data for something

Explanation

Question 44 of 50

1

What does bcp utility do?

Select one of the following:

  • bulk copies data between an instance of Microsoft SQL Server 2008 and a data file in a user-specified format

  • loads data from a data file into a table

  • used to access remote data from OLE DB data sources only when the DisallowAdhocAccess registry option is explicitly set to 0 for the specified provider

  • manage existing packages

Explanation

Question 45 of 50

1

What does Dtutil do?

Select one of the following:

  • run an existing package at the command prompt

  • Adding event handlers to the package and package objects.

  • Constructing the data flows in a package

  • manage existing packages

Explanation

Question 46 of 50

1

What does the Available Bytes counter indicates?

Select one of the following:

  • How many bytes of memory are currently available for use by processes

  • The number of bytes that either retrieved from disk due to hard page faults or written to disk due to free space in the working set due to page faults

  • How many bytes of hard disk are currently available for use by processes

  • Available system resources

Explanation

Question 47 of 50

1

What information do Dynamic management views and functions return?

Select one of the following:

  • Server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance

  • Information about user connections to the Database Engine and the locks that they hold

  • Server processing information and use connections report

  • All the information available about the server

Explanation

Question 48 of 50

1

What is "article"?

Select one of the following:

  • It can be a whole table or a database object, or a part of one.

  • It can only have articles from the same database

  • It is generally created against a publication

  • There is no information about this in lectures

Explanation

Question 49 of 50

1

What is a Maintenance Plan:

Select one of the following:

  • helps database administrators schedule core tasks

  • Plan which will tell you how a query will be executed, or how a query was executed.

  • An ordered set of steps used to access or modify information in a SQL relational database management system

  • Typically diagram or list of steps with timing and resources

Explanation

Question 50 of 50

1

What is a transaction log?

Select one of the following:

  • The transaction log is a special DBMS table that contains a description of all the database transactions executed by the DBMS.

  • The transaction log is the DBMS component that establishes the order in which concurrent database operations are executed.

  • The transaction log is important because it is the DBMS component that will ensure transaction serializability

  • full

Explanation

Previous
Check answer
Next