Quiz
SQL part2(21-40)
Questions in this quiz (50)
1Policy categories apply
- Ato servers
- Bto databases and servers
- Cto database
- Dto routers
2SQL Server can not notify operators of alerts which of the following
- AInstance messages
- BE-mail
- CPager
- Dnet send
3SQL Server Integration Services Tools
- AExtraction, transformation, loading
- BNone above them
- COnly SSIS designer
- DWizards, SSIS Designer, Command-prompt Utilities
4SQLAgentOperatorRole is
- AThe most privileged of the SQL Server Agent fixed database roles
- BProxy defines the security context for a non-Transact-SQL job
- CImpersonates the credentials defined in the proxy, and then runs the job
- DAutomate common administrative tasks
5SQLAgentUserRole is
- APermissions to view the list of available multi-server jobs, their properties
- BProperties for operators and proxies, and enumerate available proxies and alerts on the server
- CThe least privileged of the SQL Server Agent fixed database roles
- Donly granted access to those subsystems
6Steps to open Activity Monitor
- AIn SQL Server Management Studio Right click the Management then select the Activity Monitor
- BIn SQL Server Management Studio Right click the Server Objects then select the Activity Monitor
- C]In SQL Server Management Studio Right click the server then select the Activity Monitor
- DIn SQL Server Management Studio expand Management click Activity Monitor
7sys.dm_db_partition_stats returns the following
- AReturns information about pending input/output (I/O) requests
- BReturns information about each Service Broker queue monitor in the system
- CReturns page and row count information for each partition in the database
- DReturns information about all the current sessions connected to the server
8The ... database must use the full or bulk-logged recovery model; switching the database to simple recovery will cause log shipping to stop functioning
- APrimary
- BSecondary
- CReserve
- Dcopied
9The advantage of setting up an alerts management server
- ACentralazation
- BIncreased traffic
- CSingle point of failure
- DServer load
10The basic syntax for bulk importing data is
- AINSERT ... SELECT * FROM OPENROWSET(BULK...)
- BINSERT ... SELECT * FROM OPENROWSET
- CSELECT * FROM OPENROWSET
- DSELECT * FROM (BULK...)
11The 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?
- ADirector
- BSpeed Analyzer
- CComputer Manager
- DTask Manager
12The disadvantage of setting up an alerts management server
- AIncreased traffic
- BCentralization
- CScalability
- DEfficiency
13The list of available providers includes the following data sources
- ASQL Server
- BFlat files
- CMicrosoft Office Access(r), Microsoft Office Excel(r)
- DAll of the above
14The 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?
- AActivity Monitor
- BSystem Monitor
- CTask Manager
- DEvent Log Reader
15The number and characteristics of the properties are built into the facet and can be added or removed
- Aby administrator
- BNone above them
- Cby all users
- Dby only the maker of facet
16There are factors affecting availability. Find wrong answer
- ASystem failure
- BSoftware failure
- CNetwork failure
- DHardware component failure
17This is common dynamic management view (DMVs). What information is it return?
- AReturns information about pending input/output (I/O) requests
- BReturns page and row count information for each partition in the database
- CReturns information about all the current sessions connected to the server
- DReturns information about each Service Broker queue monitor in the system
18This is common dynamic management view (DMVs). What information is it return?
- AReturns information about the threads in the system
- BReturns page and row count information for each partition in the database
- CReturns information about all the current sessions connected to the server
- DReturns information about each Service Broker queue monitor in the system
19This is common dynamic management view (DMVs). What information is it return? "sys.dm_db_partition_stats"
- AReturns page and row count information for each partition in the database
- BReturns information about all the current sessions connected to the server
- CReturns information about pending input/output (I/O) requests
- DReturns information about each Service Broker queue monitor in the system
20This is common dynamic management view (DMVs). What information is it return? "sys.dm_broker_queue_monitors"
- AReturns information about each Service Broker queue monitor in the system
- BReturns information about the threads in the system
- CReturns page and row count information for each partition in the database
- DReturns information about all the current sessions connected to the server
21To bulk import data from a data file into a SQL Server table or non-partitioned view, you can use the following
- Abcp utility
- Bbcp tools
- Cbcp all
- Dbcp bulk
22To 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- AI, II, II
- BI and III
- CI and II
- DII and III
23To determine whether SQL Server or another process is cause of excessive paging, monitor the following Process
- APage Faults/sec
- B%Privileged Time
- C%User Time
- D%Disk Time
24To enable and configure Database Mail accounts and profiles, what can you use
- ATools->Configure->Database Mail
- BRight click accounts and profiles then click configure
- CIn the Database Mail Wizard clear check box accounts and profiles
- DDatabase Mail Configuration Wizard
25To install SQL Server to Windows Server 2008 what we installing?
- A.NET FRAMEWORK
- Btransact sql
- Cinstall key
- Dregistre
26To lock or disable access to database or some authorizing elements what is using?
- AKey
- BInsert
- CDuplicate
- Dprotocol
27To modifying elements in database what transact queries we are using?
- Ainsert, update, drop, create
- Block, grand, select, show
- Cuse, work, execute, run
- Dplay, set, ord, record
28To reserve some db firstly we use
- ABackup
- BRecovery
- CRestore
- Dupdate
29To send Database Mail, you must be a member of the
- ADatabaseMailUserRole
- BSysadmin role
- CTargetServerRole
- DSQL Server Agent role
30To work with Server Agent and execute some parametres, what we turn on?
- AConfiguration Manager
- BBussines Development Studio
- CManagement Studio
- DServer services
31Unlike standard triggers they do not execute in response to which of the following statements
- AUPDATE, DELETE, CREATE
- BDROP, INSERT, GRANT
- CREVOKE, ALTER, CREATE
- DUPDATE, INSERT, DELETE
32Was a backup device specified in the restore statement?
- AWhen using this statement, you must specify a snapshot name rather than a backup device.
- BPerform a full database and transaction log backup strategy for frequently modified databases
- CPhases of a restore include the data copy phase, the redo phase and the undo phase
- DThe data copy phase involves copying all data, log and index pages from the backup
33What are Key Areas to Monitor in SQL Server?
- ADisk system, Memory, CPU
- BCPU performance, Memory performance
- CHardware stability, software availability
- DOperability, stability, organization
34What are the primarily uses of the SQL Server Configuration Manager?
- AManaging 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.
- BThe Database Engine Services.
- CThe System Configuration Checker checks for conditions that prevent a successful SQL Server installation and will verify the computer where the installation is running.
- DBussiness Intelegent Studio
35What Backup Job does?
- AIt performs the backup operation, logs history to the local server and the monitor server, and deletes old backup files and history information.
- BThis job restores only the copied backup files to the secondary databases.
- CThis job is shared by the primary and secondary databases of all log shipping configurations using this monitor server instance.
- DThere is no information about this in lectures
36What benefits would that offer?
- AIt could avoid the unnecessary expense and administrative overhead of deploying multiple physical servers
- BEnterprise edition would satisfy the needs of large corporate SQL deployments. Other editions would be appropriate in difference scenarios.
- CA 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.
- DAmount of RAM, number of CPUs, and highly optimized disk storage arrays (in that order) are the most critical items for performance.
37What can indicate that there is an overall shortage of memory on the computer or that an application is not releasing memory?
- ALow values for the Available Bytes
- BHigh values for the Available Bytes
- CLow values for the Busy Bytes
- DHigh values for the Busy Bytes
38What condition is wrong ?
- AThe policy is enabled.
- BThe target belongs to the target set of the policy.
- CThe target or one of the targets ancestors subscribes to the policy group that contains this policy.
- DOnly policies from its subscribed categories can govern a database.
39What is an efficient way to determine CPU usage?
- ATo use the Processor\: %Processor Time counter in System Monitor
- BTo use the Processor\:%Processor Avg. Time counter in Event Log Reader
- CTo use System\:%Total Processor Time
- DTo use the Processor\: %User Time counter in System Monitor
40What counter monitors the percentage of time that the disk is busy with read/write activity?
- A% Disk Time
- BAvg. Disk Queue Length
- CCurrent Queue Length
- D%Busy Time
41What counter shows the number of requests that were outstanding on the disk at the time that the performance data was collected.
- ACurrent Queue Length
- BAvg. Disk Queue Length
- C% Disk Time
- DUniversal Disk Performance Measure
42What counter used to determine how many system requests, on average, are waiting for disk access
- A%Busy Time
- B% Disk Time
- CCurrent Queue Length
- DAvg. Disk Queue Length
43What Distributors do?
- Astore replication-specific data associated with one or more publishers
- Bcreate and modify the data
- CReceive the data. With merge replication, this situation is altered slightly because modifications occur at both the publisher and the subscribers
- DModify data for something
44What does bcp utility do?
- Abulk copies data between an instance of Microsoft SQL Server 2008 and a data file in a user-specified format
- Bloads data from a data file into a table
- Cused to access remote data from OLE DB data sources only when the DisallowAdhocAccess registry option is explicitly set to 0 for the specified provider
- Dmanage existing packages
45What does Dtutil do?
- Arun an existing package at the command prompt
- BAdding event handlers to the package and package objects.
- CConstructing the data flows in a package
- Dmanage existing packages
46What does the Available Bytes counter indicates?
- AHow many bytes of memory are currently available for use by processes
- BThe 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
- CHow many bytes of hard disk are currently available for use by processes
- DAvailable system resources
47What information do Dynamic management views and functions return?
- AServer state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance
- BInformation about user connections to the Database Engine and the locks that they hold
- CServer processing information and use connections report
- DAll the information available about the server
48What is "article"?
- AIt can be a whole table or a database object, or a part of one.
- BIt can only have articles from the same database
- CIt is generally created against a publication
- DThere is no information about this in lectures
49What is a Maintenance Plan:
- Ahelps database administrators schedule core tasks
- BPlan which will tell you how a query will be executed, or how a query was executed.
- CAn ordered set of steps used to access or modify information in a SQL relational database management system
- DTypically diagram or list of steps with timing and resources
50What is a transaction log?
- AThe transaction log is a special DBMS table that contains a description of all the database transactions executed by the DBMS.
- BThe transaction log is the DBMS component that establishes the order in which concurrent database operations are executed.
- CThe transaction log is important because it is the DBMS component that will ensure transaction serializability
- Dfull
Information
- Description
- Quiz on SQL part2(21-40), created by Райхан Абдыжалилова on 20/12/2018.
- Author
- Райхан Абдыжалилова
- Language
- English
- Views
- 204
- Rating
- No ratings yet Rate this quiz