Shared Flashcard Set

Details

DBA Exam 1, Final Review
Name the Primary Database Service
30
Computer Science
Undergraduate 4
04/27/2011

Additional Computer Science Flashcards

 


 

Cards

Term
What service is the primary database Service?
Definition
SQL Server
Term
What service provides connection details?
Definition
SQL Server Browser
Term
What service Provides Message Queuing for asynchronous data transfer?
Definition
Service Broker
Term
what service is for extracting and transforming data?
Definition
SQL Integration Service
Term
What service is for OLAP and datamining?
Definition
SQL Server Analysis Service
Term
what service is for scheduling and alerting?
Definition
SQL Server Agent
Term
A recommended disk configuration for SQL is ________
Definition
disk striping with parity
Term
You need to set up permissions to allow a new administrator to work with a SQL Server DB. Which tool would you use?
Definition
SQL Server Configuration Manager
Term
True or False, log files should be stored in filegroups along with DB data?
Definition
False
Term
The secondary database are stored in a file with an extension of _____
Definition
.ndf
Term
Transaction throughput is limited by the speed that the data can be written into the _____
Definition
the transaction log file
Term
You have written a new SQL command to create a new db structure and filegroups. You specified two filegroups, FG_A and FG_B. No data has been loaded in the DB, but you only want system objects in FG_A. What should you do?
Definition
FG_A is currently marked as the default group, you should change the default group to FG_B when done setting up.
Term
You are configuring a database that is used by a county tax agent to enter payments made by citizens at the county tax office. You want to minimize the amount of data that may be lost if the server experiences a hardware failure. Which recovery model should you select?
Definition
Full
Term
If you define a column with the UNIQUE constant, you must also make this column the primary key?
Definition
False
Term
You are administering a db that is used during the day by company employees. At night a set of batch jobs are run to process data which comes in from branch offices. It is becoming difficult to finish the entire batch processing before employees arrive at 8am. What actions should you take?
Definition
Change the recovery model to bulk-logged after the employees are off-line, then change it back to full when batch jobs are done.
Term
You are administering a database that is used periodically throughout the day, but not heavily. Users complain that when they try to use the DB there is a lengthy delay for the first transaction. It has plenty of memory. What option should you configure to address this problem?
Definition
AUTO_CLOSE FALSE
Term
The manager reports that employees cannot make any updates to data but can still read it. What database option change caused the problem?
Definition
The Database is set to READ_ONLY mode
Term
If you run DBCC CHECKDB and an index has an integrity error, what should you do to correct this?
Definition
Just drop and recreate the index
Term
what kind of index is created by using the WHERE clause on the CREATE INDEX statement
Definition
Filtered Index
Term
What type of index does the leaf level consist of data pages?
Definition
Clustered Index
Term
What type of index does the leaf level consist of pointers to data pages?
Definition
Non-clustered index
Term
what type of index is created on a column that has a data type of geometry or geography?
Definition
Spatial index
Term
what type of index can there only be one of per table?
Definition
Clustered index
Term
When designing a large company db that will store data on all aspects of the company, allowing each department's applications to see and use only the tables and views that are related to that department. Which of the following approaches will require the least effort and will accomplish this goal?
Definition
Create a schema for each department, and add the tables and views required by the department to it.
Term
T or F, Each SQL Server instance contains its own set of databases, security credentials and configuration settings?
Definition
True
Term
You have created two schemas, names schema1 and schema2. You decide to move the Products table from schema 1 to schema 2. Which happens?
Definition
All permissions on the Products table will be dropped, but the owner remains
Term
You are configuring a Database Mail feature of the Accounting DB to alert all DBAs when performance falls below certain thresholds. You want only the DBAs and the database itself to send mail messages through DB Mail, what should you do?
Definition
Create a private profile and assign permissions for the DBAs accounts to this profile
Term
You have a db named Personnel that contains an unindexed table named Category, it never changes. You want to create an index of this table so that the physical order of the rows in the table will be the same as the logical order of the index. What SQL Command should you use?
Definition
CREATE UNIQUE CLUSTERED INDEX idx_Cat
ON Category (Cat_ID)
WITH FILLFACTOR = 100
Term
___ defines the character set supported for this DB.
Definition
Collation Sequence
Term
___ defines the character set supported for this DB.
Definition
Collation Sequence
Supporting users have an ad free experience!