228

Report as inappropriate Your report has been received

Shared by: huanghengdong

Tags

Stats

views:: 2
posted:: 12/1/2011
language:: English
pages:: 13

Public Domain

Document Sample

install
A. Install SQL Server 2000 as a named instance. bce
A. Install a larger hard disk. b
configure
A. Configure the services to run under the local system account c
a
A. Configure the database on the two servers as a SQL Server 2000 cluster.
A. Configure SQLAgentMail to use a valid MAPI profile a
A. Configure the hard disks as two mirrored NTFS volumes. ce
A. Configure the IIS virtual directory to allow URL queries. be
A. Configure Windows authentication. bc
A. Configure Mixed Mode authentication. bdef
A. Configure DataSvr for Mixed Mode authentication. b
A. Configure Windows Authentication. bce
b
A. Configure the database permissions to deny Maria access to the database.
B
A. Configure the SQL Server Agent service to start by using the local system account.
A
A. Configure systems monitor to log an alert if the hard disk database contains less than 600MB
A. Configure System Monitor to log disk space utilization A
C
A. Configure System Monitor to collect data and store it in a SQL Server table
REVOKE
A. Revoke Log on interactivity rights for the HQMAIN\sqladmin user Daccount.
A. REVOKE ALL TO SalesData FROM 'Julia' C
UNISTALL
A. Uninstall SQL Server 7.0, and then rerun the SQL Server upgrade Dwizard.
SET
B
A. Set up SQL server replication to replicate the data from the oracle server to the SQL server
A. Set the security permissions on your e-mail CE
BE
A. Set the database load state for each destination server to No recovery mode.
A. Set the c2 audit mode option to 1. AF
A. Set the SQLServerAgent service’s startup method to Disabled. D
USE
A. Use the ALTER DATABASE statement to change the collation of the Cdatabases on SQL1.
B
A. Use the rebuildm utility to rebuild the system database on an existing SQL server computer.
A. Use the Full Recovery model for the staging database. bd
A. Use the spid 52 icon in the Current Activity window to discover Awhich SQL
A. Use the ALTER COLUMN clause of the ALTER TABLE B
A. Use the simple recovery model and the FOR LOAD A
D
A. Use the bcp utility to export data from each table to a separate text file.
A. Use a Bulk Insert Task to read the data into a temporary table.B
A. Use SQL Server Enterprise Manager to create a new job A
A. USE Marketing
GO
EXEC sp_grantdbaccess 'CORP\Maria' B
EXEC sp_grantdbaccess 'CORP\Bruno'
EXEC sp_grantdbaccess 'CORP\Stefan'
A. USE finance
GO
EXEC sp_revokedbaccess Sophie
A
USE sales
GO
EXEC sp_revokedbaccess Sophie
A. Use SQL Profiler to capture security events and audit events. D
A. Use SQL Profiler to capture security events and audit events. A
A. Use SQL Enterprise manager to manage the alert responses on all Bcompany servers.
A
A. Use the current Activity window to discover who is holding locks in the database
A. Use SAL Profiler …. BG
CREATE
A. Create a parameterised stored procedure to retrieve the data. D
A. Create a 60-MB data file named geography.ndf BF
A. Create a filegroup named LOOKUP. Move the lookup tables to this Afilegroup.
D
A. Create a new DBCC SHRINKFILE job to shrink the inventory_data file. Schedule the new job to r
A. Create an UPDATE trigger that sends an e-mail message. A
A
A. Create an INSTEAD OF trigger on the view to update the composite tables.
A. Create a Data Transformation Services (DTS) C
A
A. Create a constraint that compares the start date to the end date.
A. Create a SQL Server Agent job to execute the UPDATE STATISTICS B
A. CREATE UNIQUE INDEX IX_UPC On Parts(UPC) AE
A. Create a new full-text catalog for the Articles database D
A. Create indexes B. Create a view that returns D
C
A. Create additional nonclustered indexes on the CustomerInformation table.
A. Create a non-normalized TestKingConsolidated table and populate Cthe table with data
A. Create indexes B. Create a view to provide A
A. Create one publication for each Subscriber. BCE
A. Create a database for each department. ACF
A. Create a database user account for each assistant. C
A. Create a new database user in the CorpSales database. A
A. Create a trigger on the Salary column of the Employees table. D
A. CREATE VIEW TotalTreatments AS
SELECT COUNT(PatientID) AS Total FROM dbo.Patients
C
GO
GRANT ALL ON TotalTreatments TO AccountUser
A
A. Create a stored procedure and require users to enter information by means
Leading the way in IT testing and certification tools,
www.testking.com BDE
A. CREATE VIEW TotalTreatments AS
A. Create a domain user group for all users.
Add a login for the domain user group. C
Add the login to the sysadmin server role.
A. Create a stored procedure that uses sp_start_job D
Compress
A. Compress drive E. B
Place
A. Place the transaction log on physical disk 0 and the data file
D
on the RAID-5 disk array.
A. Place primary keys and foreign key indexes on the table. A
ON
A. On drive C, create a transaction log.
AE
On drive D, create a data file in the PRIMARY filegroup.
A. On a new hard disk, create a new filegroup. A
A. On the New York City server, defect all 11 target servers. A
A. On SQL2000, enable the multiprotocol net library. AE
ensure
A. Ensure that the SQLServerAgent service is running c
C
A. Ensure that the file copy procedures are in an ActiveX Scripting job step.
Detach
A
A. Detach the database from the original server by using the sp_detach_db stored procedure
A. Detach the msdb database from the first server. C
Back
A. Back up the existing objects on the PRIMARY D
A. Backup the transaction log by using the NO_LOG option. BCDG
A. Back up the transaction log. A
A. BACKUP LOG Contracts WITH no_log CF
ALTER
A. ALTER TABLE [dbo].[StorageLocations]
A
ALTER COLUMN [UnitsStored] [int] NOT NULL
A. ALTER TABLE dbo.storagelocations ADD CONSTRAINTS A
A
A. Alter the table to allow null values in the CustomerAddress2 column.
A. Alter the data type of the description field to varchar(50). A
Rerun
C
A. Rerun the SQL Server Setup and specify the SQL_Latin1_General_CP437_BIN collation.
ADD
D
A. Add a 2-GB transaction log to drive D, a 3-GB data file to drive E, and a 3-GB data file to d
A. Add an ON UPDATE CASCADE constraint to the CustomerID A
A. Add triggers to the PartsShipped and the PartsReceived tables A
A. Add triggers to the PartsShipped and the PartsReceived tables
that update the InStock field in the A
Parts table.
A
A. Add another data file on drive E, and then add the file to the PRIMARY filegroup.
A. Add Lilly to the Managers database role. BC
B
A. Add a SQL server login for the unauthorized users, and then deny access to the login.
A
A. Add Pierre’s login to the db_ddladmin role in the Sales database.
A. Add Bruno to the Managers database role. AE
A. Add indexes to the fields that are used in the joins D
DROP
A. Drop the FOREIGN KEY constraints. CF
A. Drop IX_Customers_FK and IX_SalesPerson_FK. A
A. Drop the indexes for the customers table before the data load, B
EXECUTE
A. Execute sp_recompile on the stored procedure. A
A. Execute the DBCC CHECKDB statement, D
A. Execute the stored procedure, D
A. Execute the sp_releaseapplock stored procedure D
UPDATE
A. Update the database statistics. B
RE-CREATE
A. Re-create the PK_PartsLocations index as a clustered index. A
A. Re-create the PK_Invoices index as a nonclustered index AB
A. Re-create the Notes table on the SECONDARY filegroup. B
NORMALIZE
A. Normalize the data structure of the table. AB
DBCC
A. DBCC UPDATEUSEAGE ('Sales','Invoices','PK_Invoices') BCD
Recompile
A. Recompile the stored procedure. A
INCREASE
A. Increase the maximum file size of Sales_Data to 1,500MB. A
A. Increase the amount of RAM. D
A. Increase the physical RAM on the computer to 2GB. C
SHRINK
A. Shrink the empty data file on drive E. B
DISCONNECT
A. Disconnect users from the Sales database. A
ENABLE
C
A. Enable the torn page detection database option for each database.
A. Enable the Always read properties from UDL AE
EXPORT
A. Export all records from the Sales table to a temporary table. C
Reorganize
A. Reorganize the data files into two groups. BD
Perform
A. Perform a combination of full database and filegroup backups. CE
CHANGE
A. Change the isolation level of the database connection. AC
A. Change the connection properties in the DTS C
EXTEND
A. Extend the BULK INSERT statement with the BATCHSIZE F
SELECT
A. Select the DTS packages log package execution B
A. Select the commit on successful completion A
APPLY
A. Apply a bulk update lock to the table. ABE
Save
A. Save AC
Implement
A. Implement merge replication. BE
A. Implement merge replication. Use the DATETIME B
Store
CD
A. Store the snapshot in the default folder on the Publisher/Distributor.

A. Assign the guest login a blank password. D
EXEC
A. EXEC sp_revokelogin ‘guest’ C
A. EXEC sp_grantdbaccess ‘FinanceData’, ‘Andrew’ C
A. EXEC sp_grant login BUILTIN\Local Techs D
A. EXEC sp_grantlogin Franz D
A. EXEC sp_addlogin 'CORPHQ\Receptionists' C
A. EXEC sp_grantlogin TESTKINGSRV\Tess A
A. EXEC sp_addlogin 'TESTKING\Employees' AG
A. EXEC sp_addrolemember ‘SalesManagers’, ‘Corporate\Paulo’ D
A. EXEC sp_droprolemember 'Accountants', 'Stefan' A
Remove
A. Remove the Csapp1 domain user account B

A. First AE

A. GRANT ALL ON ResearchData TO 'Peter' D
A. GRANT PRIVILEGES ON Accounting TO Bruno D

A
A. Modify SQL Server Agent properties and specify a smaller idle time.
A. Modify the applications so that they use views to query data. B

A. Restore the msdb database from a backup D

A. Stop B

A. Run SQL Profiler, and create one trace to monitor both servers. B
A. Run SQL Profiler on a client computer. A

A. Double B
p5-1
p223-2

p7-2
p8-3
p14-1
p17-1
p122-1
p157-3
p160-6
p162-7
p163-8
p187-1
p213-6T
P216-2T
P220-2
P224-1

P9-4
P193-4

P11-1

P12-1
P15-2
P107-1T
P204-3
P211-5

P13-2
P91-3
P98-1T
P109-1
P123-1
P128-4T
P132-6T
P136-8T
P139-2

P173-7T
P189-1

P202-1
P203-2
P218-4
P232-2T
P233-3T

P19-2T
P31-1
P32-2
P35-2
P41-2
P45-4
P49-7
P51-8T
P61-4T
P65-6T
P68-8
P78-13
P113-4T
P120-8
P134-7T
P145-1
P176-1
P178-2T
P179-1
P190-2

P192-3

P195-5

P197-6T

P199-2

P209-3

P21-3T
P22-4T
P55-1

P24-5
P83-2
P152-5
P154-1

p26-1
p208-2T

P27-2
P214-1

P29-1
P92-4T
P96-7T
P103-3

P33-1
P46-5
P112-3
P144-1

P36-1

P38-1
P40-1
P43-3

P53-9

P79-1
P167-2
P169-4
P183-2
P185-4
P230-1

P48-6
P75-11
P130-5

P57-2
P88-1
P115-5
P117-6

P59-3

P64-5
P71-9
P85-3

P67-7

P72-10

P76-12

P82-1
P219-1
P221-1

P86-4

P89-2

P94-5
P140-1

P95-6

P101-2

P105-4

P110-2
P142-2

P119-7

P125-2
P126-3

P137-9

P138-1

P147-2
P150-4
P149-3

P155-2

P158-4
P165-1
P168-3
P170-5
P171-6
P174-8
P175-9
P181-1
P200-3

P159-5

P165-9

P183-3
P198-1

P206-1
P225-2

P210-4

P217-3

P226-3
P229-5

P228
ALTER A
ADD A
A. Add a 2-GB D
A. Add indexes D
A. Add Lilly BC
A. Add Bruno to AE
A. Add a SQL B
APPLY ABE
Assign D
Back A. Back up the existing D
A. Backup the transaction log by using BCDG
A. Back up the transaction log. A
A. BACKUP LOG Contracts WITH no_log CF
CHANGE A. Change the isolation AC
A. Change the connection C
Compress A. Compress drive E. B
CREATE A. Create a parameterised D
A. Create a 60-MB BF
A. Create a filegroup A
A. Create a new DBCC D
A. Create an UPDATE A
A. Create an INSTEAD A
A. Create a Data Transformation C
A. Create a constraint A
A. Create a SQL B
A. CREATE UNIQUE AE
A. Create a new full-text D
A. Create indexes B. Create a view that returns D
A. Create additional C
A. Create a non-normalized C
A. Create indexes B. Create a view to provide A
A. Create one publication for each Subscriber. BCE
A. Create a database for each department. ACF
A. Create a database user C
A. Create a new database A
A. Create a trigger D
A. CREATE VIEW TotalTreatments AS C
A. Create a stored procedure and require A
A. CREATE VIEW TotalTreatments AS BDE
A. Create a domain user C
A. Create a stored procedure that uses D
configure A. Configure the services c
A. Configure the database on a
A. Configure SQLAgentMail a
A. Configure the hard ce
A. Configure the IIS virtual be
A. Configure Windows authentication. bc
A. Configure Mixed Mode authentication. bdef
A. Configure DataSvr b
A. Configure Windows Authentication. bce
A. Configure the database permissions b
A. Configure the SQL B
A. Configure systems monitor to log an alert A
A. Configure System Monitor to log disk A
A. Configure System Monitor to collect C
DOUBLE A. Double B
DISCONNECTA. Disconnect users from the Sales database. A
DBCC A. DBCC BCD
DROP A. Drop the FOREIGN KEY constraints. CF
A. Drop IX_Customers_ A
A. Drop the indexes B
Detach A. Detach the database A
A. Detach the msdb C
ensure A. Ensure that the SQLServerAgent c
A. Ensure that the file C
EXECUTE A. Execute sp_recompile A
A. Execute the D
ENABLE A. Enable the torn page detection database option Cfor each database.
A. Enable the Always read properties from UDL AE
EXPORT C
EXTEND F
EXEC A. EXEC sp_revokelogin ‘guest’ C
A. EXEC sp_grantdbaccess ‘FinanceData’, ‘Andrew’ C
A. EXEC sp_grant login BUILTIN\Local Techs D
A. EXEC sp_grantlogin Franz D
A. EXEC sp_addlogin 'CORPHQ\Receptionists' C
A. EXEC sp_grantlogin TESTKINGSRV\Tess A
A. EXEC sp_addlogin 'TESTKING\Employees' AG
A. D
EXEC sp_addrolemember ‘SalesManagers’, ‘Corporate\Paulo’
A. EXEC sp_droprolemember 'Accountants', 'Stefan' A
First AE
Grant D
Install A. Install SQL Server 2000 as a named instance. bce
A. Install a larger hard disk. b
INCREASE A. Increase the maximum A
A. Increase the amount of RAM. D
A. Increase the physical C
Implement A. Implement merge replication. BE
A. Implement merge replication. Use the DATETIME B
Modify A. Modify SQL A
A. Modify the B
NORMALIZE AB
ON A. On drive C, AE
A. On a new hard disk, A
A. On the New York City server, A
A. On SQL2000, AE
Perform CE
Place A. Place the D
A. Place primary keys A
REVOKE A. Revoke Log D
A. REVOKE ALL C
Rerun C
RE-CREATE A. Re-create the PK_PartsLocations A
A. Re-create the PK_Invoices AB
A. Re-create the Notes B
Recompile A
Reorganize BD
Remove B
Restore D
RUN A. Run SQL Profiler, and create B
A. Run SQL Profiler on a client computer. A
SET A. Set up B
A. Set the security CE
A. Set the database BE
A. Set the c2 AF
A. Set the SQLServerAgent D
SELECT A. Select the DTS B
A. Select the commit A
SHRINK B
Save AC
Store CD
Stop B
UNISTALL D
USE A. Use the ALTER DATABASE C
A. Use the rebuildm B
A. Use the Full bd
A. Use the spid A
A. Use the ALTER COLUMN B
A. Use the simple A
A. Use the bcp u D
A. Use a Bulk Insert B
A. Use SQL Server A
A. USE Marketing B
A. USE finance A
A. Use SQL Profiler Make sure D
A. Use SQL Profiler A
A. Use SQL Enterprise B
A. Use the current A
A. Use SAL Profiler …. BG
UPDATE B