Quiz
SQL Server MTA 98-364
This quiz has a time limit, so it opens in the usual player.
Questions in this quiz (145)
1The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?
- AView
- BFuncton
- CIndex
- DStored procedure
- ETrigger
2One reason to add an index is to:
- ADecrease storage space
- BIncrease database security.
- CImprove performance of select statements.
- DImprove performance of insert statements.
3You have a table that contains the following data.
You break the table into the following two tables.
This process is referred to as:
- Adefragmentaton
- Bnormalizaton
- Cfragmentaton
- Ddenormalizaton
4You have a table that contains the following data.
Which database term is used to describe the relatonship between ProductID and ProductCategory?
- ACohort
- BRelatonally dependent
- CDeterministc
- DFunctonally dependent
- ECompositonal
5Which key uniquely identies a row in a table?
- Aforeiqn
- Bprimary
- Clocal
- Dsuperkey
6Which statement creates a composite key?
- AOpton A
- BOpton B
- COpton C
- DOpton D
7At 3:00 P.M. (1500 hours), you create a backup of your database. At 4:00 P.M. (1600 hours), you create a table named
Customer and import data into the table. At 5:00 P.M. (1700 hours), your server fails.
You run a script to apply only the 3:00 P.M. backup to your database. What is the result of the script?- AThe Customer table no longer exists.
- BThe Customer table is unafected.
- CThe Customer table exists but has no data.
- DThe script fails.
8In which situaton do you need to perform a restore on a database?
- Awhen data becomes corrupted in the database
- Bwhen you need to roll back a transacton
- Cwhen you encounter an error in your applicaton
- Dwhen data needs to be deleted from the database
9Which command should you use to give a user permission to read the data in a table?
- AALLOW SELECT
- BLET READ
- CPERMIT READ
- DGRANT SELECT
10You need to enable a new employee to authentcate to your database.
Which command should you use?- AALLOW USER
- BCREATE USER
- CADD USER
- DINSERT USER
- EALTER USER
11Which keyword can be used in a create table statement?
- AORDER BY
- BDISTINCT
- CGROUP BY
- DUNIQUE
12You need to store product quanttes, and you want to minimize the amount of storage space that is used. Which data
type should you use?- AINTEGER
- BDOUBLE
- CCOUNT
- DFLOAT
13Which statement will result in the creaton of an index?
- AOption A
- BOption B
- COption C
- DOption D
14You have the following table deiniton:
CREATE TABLE Road
(RoadID INTEGER NOT NULL,
Distance INTEGER NOT NULL)
The Road table contains the following data:
You execute the following statement:
INSERT INTO Road VALUES (1234, 36)
What is the result?
- Aan error statng that NULL values are not allowed
- Ba new row in the table
- Can error statng that duplicate IDs are not allowed
- Da syntax error
15You need to store product names that vary from three to 30 characters. You also need to minimize the amount of
storage space that is used.
Which data type should you use?- AVARCHAR (3, 30)
- BCHAR (3, 30)
- CVARCHAR (30)
- DCHAR (30)
16One reason to create a stored procedure is to:
- AImprove performance.
- BMinimize storage space.
- CBypass case sensitvity requirements.
- DGive the user control of the query logic.
17Which permission does a user need in order to run a stored procedure?
- AEXECUTE
- BALLOW
- CCALL
- DRUN
18You have a table named Product. You create a view that includes all the products from the Product table that are in
the Furniture category.
You execute a statement on the Product table that deletes all the products in the Furniture category.
Afer you execute the statement, the result set of the view is:- AEmpty
- BDeleted
- CUnchanged
- DArchived
19In SQL, an insert statement is used to add a:
- AUser to a database.
- BRow of data to a table.
- CTable to a database.
- DColumn to a table deiniton.
20You have two tables. Each table has three rows.
How many rows will be included in the Cartesian product of these two tables?- A0
- B3
- C6
- D9
21You are writng an SQL statement to retrieve rows from a table.
Which data manipulaton language (DML) command should you use?- AREAD
- BSELECT
- COUTPUT
- DGET
22Which constraint ensures a unique value in the ID column for each customer?
- ADISTINCT
- BFOREIGN KEY
- CSEQUENTIAL
- DPRIMARY KEY
23The component that holds informaton for a single entry in a table is called a:
- AData type
- BRow
- CColumn
- DView
24You execute the following statement:
SELECT EmployeeID, FirstName, DepartmentName
FROM Employee, Department
This type of operaton is called a/an:- AIntersection
- BOuter join
- CEqui-join
- DCartesian product
25Which command should you use to add a column to an existng table?
- AMODIFY
- BALTER
- CUPDATE
- DINSERT
- ECHANGE
26You have the following table deiniton:
CREATE TABLE Product
(ID INTEGER PRIMARY KEY,
Name VARCHAR(20),
Quantty INTEGER)
The Product table contains the following data.
You execute the following statement:
SELECT Name FROM Product WHERE Quantty IS NOT NULL
How many rows are returned?
- A0
- B1
- C2
- D3
- E4
27You are writng a select statement to ind every product whose name contains a speciic character.
Which keyword should you use in your where clause?- AFIND
- BBETWEEN
- CINCLUDES
- DLIKE
28A database contains two tables named Customer and Order.
You execute the following statement:
DELETE FROM Order
WHERE CustomerID = 209
What is the result?- AThe irst order for CustomerID 209 is deleted from the Order table.
- BAll orders for CustomerID 209 are deleted from the Order table, and CustomerID 209 is deleted from the Customer
table. - CAll orders for CustomerID 209 are deleted from the Order table.
- DCustomerID 209 is deleted from the Customer table.
29You have a table named Product. The Product table has columns for ProductDescripton and ProductCategory.
You need to change the ProductCategory value for all the spoons in the Product table to 43.
Which statement should you use?
- AOpton A
- BOpton B
- COpton C
- DOpton D
30You have a table that contains informaton about all students in your school.
Which SQL keyword should you use to change a student's irst name in the table?- AUPDATE
- BCHANGE
- CSELECT
- DINSERT
31You need to populate a table named EmployeeCopy with data from an existng table named Employee.
Which statement should you use?
- AOption A
- BOption B
- COption C
- DOption D
32You execute the following statement:
- ASubquery
- BUnion
- COuter join
- DCartesian product
33Which keyword would you use in a select statement to return rows that meet a speciic conditon?
- AWHERE
- BUNION
- CORDER BY
- DFROM
34You have a table named Employee that includes the following columns:
EmployeeID
Smp1oyeeName
Which statement should you use to return the number of rows in the table?
- AOption A
- BOption B
- COption C
- DOption D
35The Product table contains the following data.
You execute the following statement:
SELECT COUNT(*)
FROM Product WHERE Quantty > 18
What is the value returned by this statement?- A1
- B2
- C3
- D4
36Which command should you use to remove a table from a database?
- AREMOVE TABLE
- BUPDATE TABLE
- CDROP TABLE
- DDELETE TABLE
37You need to store the contact informaton for each student in your school database.
You should store each student's informaton in a:- AStored procedure
- BFunction
- CRow
- DVariable
38Which category of SQL statements is used to add, remove, and modify database structures?
- AData access language (DAL)
- BData manipulation language (DML)
- CData control language (DCL)
- DData definiton language (DDL)
39You have a Customer table and an Order table. You join the Customer table with the Order table by using the
CusromerID column.
The results include:
• All customers and their orders
• Customers who have no orders
Which type of join do these results represent?- AComplete join
- BPartial join
- CInner join
- DOuter join
40Data in a database is stored in:
- ATables
- BQueries
- CData types
- DStored procedures
41You have a table named Student that contains 100 rows. Some of the rows have a NULL value in the FirstName
column.
You execute the following statement:
DELETE FROM Student
What is the result?- AAll rows in the table will be deleted.
- BAll rows containing a NULL value in the FirstName column will be deleted.
- CYou will receive an error message.
- DAll rows and the table deiniton will be deleted.
42You need to establish a set of permissions that you can routnely assign to new users.
What should you create?- AResource
- BGroup
- CList
- DRole
43Which database term is used to describe the process of applying a backup to a damaged or corrupt database?
- ARecover
- BRestore
- CCommit
- DAtach
44You need to disable User1's access to view the data in the Customer table.
Which statement should you use?
- AOption A
- BOption B
- COption C
- DOption D
45Denormalizaton is performed in order to:
- AReduce redundancy.
- BEliminate repeatng groups.
- CCreate smaller tables.
- DImprove query performance.
46You have a table named Product that contains one million rows.
You need to search for product informaton in the Product table by using the product's unique ID.
What will make this type of search more efcient?- AA cursor
- BA subquery
- CA trigger
- DAn index
47You have a table named Product that contains the following data.
The PrcducrID column is the primary key. The CategoryID column is a foreign key to a separate table named Category.
You execute the following statement:
INSERT INTO Product
VALUES (3296, 'Table', 4444)
What is the result?
- Aa foreign key constraint violation
- Ba syntax error
- Ca new row in the Product table
- Da primary key constraint violation
- Ea new row in the Category table
48Which two keys establish a relatonship between two tables? (Choose two.)
- Acandidate
- Bforeign
- Csuperkey
- Dlocal
- Eprimary
49One diference between a functon and a stored procedure is that a functon:
- AMust be called from a trigger.
- BMust return a value.
- CCannot contain a transaction.
- DCannot accept parameters.
50Which keyword must be included in a create view statement?
- AWHERE
- BORDER BY
- CUPDATE
- DSELECT
51You have a table named Customer. You need to add a new column named District.
Which statement should you use?
- AOption A
- BOption B
- COption C
- DOption D
52You need to remove a view named EmployeeView from your database.
Which statement should you use?- ADELETE VIEW EmployeeView
- BDELETE EmployeeView
- CDROP EmployeeView
- DDROP VIEW EmployeeView
53A named group of SQL statements that can be executed in a database is called a:
- ASubroutine
- BFormula
- CStored procedure
- DMethod
54A view can be used to:
- ASave an extra copy of data stored in a separate table.
- BLimit access to speciic rows or columns of data in a table.
- CEnsure referental integrity.
- DSave historical data before deleting it from the base table.
55On which database structure does an update statement operate?
- ATable
- BUser
- CTrigger
- DRole
56You need to list the name and price of each product, sorted by price from highest to lowest. Which statement should
you use?
- AOption A
- BOption B
- COption C
- DOption D
57You delete rows in a table named Order. The corresponding rows in the OrderItem table are automatcally deleted.
This process is an example of a/an:- AInherited delete
- BCascade delete
- CFunctional delete
- DWaterfall delete
- EDomino delete
58Which statement deletes the rows where the employee's phone number is not entered
- AOption A
- BOption B
- COption C
- DOption D
59You need to insert two new products into the Product table. The irst product is named Book and has an ID of 125. The
second product is named Movie and has an ID of 126.
Which statement should you use?
- AOptIon A
- BOptIon B
- COptIon C
- DOptIon D
60You have a table named Employee that includes four columns.
You execute the following statement:
SELECT *
FROM Employee
Which columns are returned?- Aall columns
- Bonly the last column
- Conly the First column
- Donly the First and last columns
61Which two elements are required to deine a column? (Choose two.)
- AA name
- BA key
- CAn index
- DA data type
62What deines the amount of storage space that is allocated to a value in a column?
- Aformat
- Bkey
- Cdata type
- Dvalidator
63You are creatng a table to store customer dat
a. The AccountNumber column uses values that always consist of one leter and four digits. Which data type should
you use for the AccountNumber column?- ACHAR
- BBYTE
- CDOUBLE
- DSMALLINT
64What is one diference between an update statement and a delete statement?
- AAn update statement can change only one row.
- BA delete statement cannot use a where clause.
- CAn update statement does not remove rows from a table.
- DA delete statement works only within a stored procedure.
65You have a Department table and an Employee table in your database.
You need to ensure that an employee can be assigned to only an existng department.
What should you apply to the Employee table?- AA primary key
- BAn index
- CA foreign key
- DA unique constraint
- EA data type
66You need to store the irst name, last name, and student ID for 100 students.
This informaton will be stored in a table as:- A100 items and three cells.
- B100 rows and three columns.
- Cthree rows and 100 columns.
- Dthree items and 100 cells.
67What are three valid data manipulaton language (DML) commands? (Choose three.)
- AINSERT
- BCOMMIT
- CDELETE
- DOUTPUT
- EUPDATE
68You assign User1 a set of permissions that include the WITH GRANT OPTION.
The WITH GRANT OPTION enables User1 to:- Arequest a log of permission use.
- Bdelegate permissions to other users.
- Ccreate new database users.
- Dview other users' permissions.
69Which type of index changes the order in which the data is stored in a table?
- Anon-sequental
- Bsequental
- Cnon-clustered
- Dclustered
70Which statement should you use to remove a foreign key?
- AALTER TABLE
- BDELETE TABLE
- CDELETE FOREIGN KEY
- DALTER FOREIGN KEY
71First normal form requires that a database excludes:
- AForeign keys
- BComposite keys
- CDuplicate rows
- DRepeatng groups
72You execute a statement inside a transacton to delete 100 rows from a table. The transacton fails afer only 40 rows
are deleted.
What is the result in the database?- AThe table will be corrupted.
- BForty (40) rows will be deleted from the table.
- CThe transacton will restart.
- DNo rows will be deleted from the table.
73You have a table that contains product IDs and product names.
You need to write an UPDATE statement to change the name of a speciic product to glass.
What should you include in the update statement?- ASET ProduetName = 'glass'
- BLET ProduetName = 'glass'
- CEXEC ProduetName = 'glass'
- DASSIGN ProduetName = 'glass'
74Your database contains a table named Customer.
You need to delete the record from the Customer table that has a CusromerID of 12345.
Which statement should you use?
- AOptIon A
- BOptIon B
- COptIon C
- DOptIon D
75On which database structure does an insert statement operate?
- ARole
- BTrigger
- CUser
- DStored procedure
- ETable
76You have a table of products with ields for ProductID, Name, and Price.
You need to write an UPDATE statement that sets the value in the InStock ield to Yes for a speciic ProductID.
Which clause should you use in your update statement?- ATHAT
- BWHERE
- CGROUP BY
- DHAVING
77You have the following table deiniton:
CREATE TABLE Product
(ProductID INTEGER,
Name VARCHAR(20))
You need to insert a new product. The product's name is Plate and the product's ID is 12345.
Which statement should you use?
- AOption A
- BOption B
- COption C
- DOption D
78HOTSPOT
Instructons: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each
correct selecton is worth one point.
A full database backup is a copy of all of the data in the entire database [blank_start]R[blank_end]
A transaction log backup baciks up all the data in the database [blank_start]R[blank_end]
A differential backup copies only data that was changed before tje last full backup [blank_start]R[blank_end]
A file or filegroup restore specifies a portion of the database to recover [blank_start]R[blank_end]- AVerdadero
- BFalso
- CVerdadero
- DFalso
- EVerdadero
- FFalso
- GVerdadero
- HFalso
79HOTSPOT
The following graphic shows the components of a SQL Server applicaton. You access the SQL Server applicaton
through Internet Explorer.
The [[blank_start]Answer Choice[blank_end]] computer is the first line of defense againts SQL injections and weak
input validation.
The [[blank_start]Answer Choice[blank_end]] computer should be formatted with NTFS to protec program, database, and log
files from unauthorized access.
- Aclient
- Bwww.contoso.com
- Cs01.contoso.com
- Dclient
- Ewww.contoso.com
- Fs01.contoso.com
80You have the database table named Cars as deined below:
- A4
- B5
- C6
- D7
81You have a database table named SongInformaton as deined below:
You need to create a Structured Query Language (SQL) query to retrieve only the names of songs that sold more than
1000 compact discs (CDs).
Which query should you use?
- A
- B
- C
- D
- A
82You accept an IT internship at a local charity. The charity asks you to keep a record of its volunteers by using a
database table named Volunteer.
The table has the following columns and rows:
- A
- B
- C
- D
- A
83This queston requires that you evaluate the underlined text to determine if it is correct.
ALTER TABLE removes all rows from a table without logging the individual row deletons.
Instructons: Review the underlined text. If it makes the statement correct, select "No change is needed." If the
statement is incorrect, select the answer choice that makes the statement correct.- ANo change is needed
- BDROP TABLE
- CTRUNCATE TABLE
- DCREATE TABLE
84You need to combine the results of two queries into a single result that contains all of the rows from both queries.
Which Structured Query Language (SQL) statement should you use?- ATRUNCATE
- BJOIN
- CEXCEPT
- DUNION
85This queston requires that you evaluate the underlined text to determine if it is correct.
[blank_start]The CREATE TABLE[blank_end] command removes one or more table deinitons and all data, indexes, triggers, constraints, and
permission speciicatons for those tables.
Instructons: Review the underlined text. If it makes the statement correct, select "No change is needed." If the
statement is incorrect, select the answer choice that makes the statement correct- ANo change is needed
- BDROP TABLE
- CTRUNCATE TABLE
- DALTER TABLE
86You accept an IT internship at a local charity. The charity wants you to help them with compliance and auditing
requirements.
You need to ensure that a column or combination of columns uniquely identifies each row of a table.
Which constraint should you define?- APrimary key
- BSecondary key
- CForeign key
- DDefault Key
87HOTSPOT
You have the following table:
Adding a [answer choice] on the FlightNumber column physically sorts rows in the by FlightNumber
- Aforeing key
- Bclustered index
- Cnoclustered index
88HOTSPOT
You have the following table:
Adding a [answer choice] on the Airline column retrieves data faster, but will not physically sort rows in the table by Airline- Aforeing key
- Bclustered index
- Cnoclustered index
89While atending college, you accept an IT internship at a local charity. The charity needs to report on data that is
related and exists in two tables.
You need to establish a relationship between the data that is in the two tables.
Which constraint should you define?- AForeing Key
- BIndex Key
- CLink Key
- DDefault Key
90This question requires that you evaluate the underlined text to determine if it is correct.
A view [can be used to ensure referental integrity].
Instructons: Review the underlined text. If it makes the statement correct, select "No change is needed." If the
statement is incorrect, select the answer choice that makes the statement correct.- ANo change is needed.
- BSave an extra copy of data stored in a separate table.
- CLimit access to specific rows or columns of data in a table.
- DSave historical data before deleting it from the base table.
91DRAG DROP
You need to set up a database to provide a view of North American mammals.
Match the Structured Query Language (SQL) statements to the SQL query.
Instructions: To answer, drag the appropriate SQL statement from the column on the lef to its place in the SQL query
on the right Each SQL statement may be used once, more than once, or not at all. Each correct match is worth one
point.
- ACREATE VIEW dbo.NorthAmericanMammal_View
- BGENERATE VIEW dbo.NorthAmericanMammal_Vi
- CAS JOIN a.Id , a.Name
- DAS SELECT a.Id, a.Name
- EFROM Animal a
- FJOIN Animal a
92DRAG DROP
You have a database table that stores information about school atendance.
You have a data set that is defined as follows:
You have the following requirements:
StudentName must consist of a string of characters.
GradeLevel must be only a whole number.
DaysAbsent can have one number after the decimal.
Match the data types to the column names.
- AVARCHAR
- BCHAR
- CINT
- DBIT
- EDECIMAL
- FDATETIME
93The VARCHAR data type contains only numeric characters.
- ATrue
- BFalse
94The NUMERIC data type contains only numbers that have decimal places.
- ATrue
- BFalse
95The INT data type contains only whole numbers.
- ATrue
- BFalse
96This question requires that you evaluate the underlined text to determine if it is correct.
In a database table, each [column] represents a unique record.
Instructons: Review the underlined text. If it makes the statement correct, select "No change is needed." If the
statement is incorrect, select the answer choice that makes the statement correct.- ANo change is needed
- BTable
- CIndex
- DRow
97This question requires that you evaluate the underlined text to determine if it is correct.
You have two tables. Each table has three rows.
[Nine] rows will be included in the Cartesian product of these two tables.
Instructons: Review the underlined text. If it makes the statement correct, select "No change is needed." If the
statement is incorrect, select the answer choice that makes the statement corrector.- ANo change is needed
- BZero
- CThree
- DSix
98You have two tables named Salesperson and Sales.
You need to ensure that each record in the Sales table has a valid associated salesperson record in the Salesperson
table.
Which database object should you add to the Sales table?- ANonclustered index
- BPrimary key
- CForeign key
- DClustered index
99DRAG DROP
Your class project requires that you help a charity set up a website.
The website collects informaton about volunteers. Each volunteer record must be uniquely identied.
The following informaton is stored for each volunteer:
Given name
Surname
Date of birth
Phone number
Photo
You need to create a table to meet the requirements.
Match the Structured Query Language SQL statements to the SQL query.
Instructons: To answer, drag the appropriate SQL statement from the column on the lef to its place in the SQL query
on the right. Each SQL statement may be used once, more than once, or not at all. Each correct match is worth one
point.
- AINT NOT NULL PRIMARY KEY
- BINT NOT NULL FOREING KEY
- CDATE NULL
- DTIMESTAMP NULL
- EIMAGE NULL
- FXML NULL
100This queston requires that you evaluate the underlined text to determine if it is correct.
Use the [ALTER] statement to add a new table in a database.
Instructons: Review the underlined text. If it makes the statement correct, select "No change is needed." If the
statement is incorrect, select the answer choice that makes the statement correct.- ANo change is needed
- BUPDATE
- CINSERT
- DCREATE
101You need to rename a column in a database table.
Which data deiniton language (DDL) statement should you use?- AALTER
- BINSERT
- CCREATE
- DUPDATE
102DRAG DROP
You have two database tables as deined below. The First table contains informaton about students. The second table
contains informaton about courses. The two tables are related by CourseID.
Match the CourseName to the StudentName.
Instructons: To answer, drag the appropriate CourseName from the column on the lef to its StudentName on the
right. Each CourseName may be used once, more than once, or not at all. Each correct match is worth one point.
- AMATH
- BMATH
- CSCIENCE
- DMATH
- ESCIENCE
- FSCIENCE
- GGEOGRAPHY
- HREADING
- IHISTORY
- JGEOGRAPHY
- KREADING
- LHISTORY
- MGEOGRAPHY
- NREADING
- OHISTORY
103This question requires that you evaluate the underlined text to determine if it is correct.
Use [indexing] to create, remove, or change database objects.
Instructons: Review the underlined text. If it makes the statement correct, select "No change is needed." If the
statement is incorrect, select the answer choice that makes the statement correct.- ANo change is needed.
- BData manipulaton language (DML) statements
- CData deiniton language (DDL) statements
- DA unique constraint
104You need to add rows to a database table.
Which Structured Query Language (SQL) keyword should you use?- AJOIN
- BINSERT
- CCREATE
- DUPDATE
105You need to retrieve data from two related database tables based on a column that exists in both tables.
Which command should you use in a query?- AINTERSECT
- BUNION
- CJOIN
- DTRUNCATE
106You have a database table that contains the following columns, Which two Structured Query Language (SQL) statements can you use? (Choose two.)
- A
- B
- C
- D
- A
107This queston requires that you evaluate the underlined text to determine if it is correct.
The UNION keyword combines the results of two queries and returns only rows that appear in both result sets.
Instructons: Review the underlined text. If it makes the statement correct, select "No change is needed." If the
statement is incorrect, select the answer choice that makes the statement correct- ANo change is needed
- BINTERSECT
- CALL
- DEXCEPT
108You work at a restaurant and they ask you to help them with a data issue.
They provide you with the following recipe data: (imag)
You need to normalize the data to third normal form.
How many tables should you create?
- A1
- B2
- C3
- D4
109You accept an IT internship at a local charity. The charity has two tables in their data model named Chapter and
Language, as deined below: (img)
You create a third table named ChapterLanguage to relate the Chapter table and the Language table.
You need to select columns from the Chapter and Language tables to create a composite primary key for the
ChapterLanguage table.
Which two columns should you select? (Choose two.)
- AChapterId
- BLanguageId
- CCountry
- DRegion
- ECity
- FLanguageName
110HOT SPOT Instructons: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selecton is worth one point.
A clustered index sorts and stores the data columns of a table or view in order, based on the clustered index hey.- ATrue
- BFalse
111HOT SPOT Instructons: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selecton is worth one point.
A non-clustered index is defined on a table or view by using a clustered index or heap- ATrue
- BFalse
112HOT SPOT Instructons: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selecton is worth one point.
A unique index ensures that the index key contains no duplicate values and that every row in the table or view in unique- ATrue
- BFalse
113HOT SPOT Instructons: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selecton is worth one point.
A filtered index is a clustered index that is optimized for queries that select a small percentage of rows from a table- ATrue
- BFalse
114This queston requires that you evaluate theu nderlined text todetermine if it is correct.
You combine data from three tables into one table. The new table includes redundancy to optmize read performance. The data in the new table has been denormalized.
Instructons: Review the under lined text. If it makes the statement correct, select "Nochangeisneeded." If the statementisincorrect, select the answer choice that makes the statement correct.- ANo change is needed
- BNormalized
- CTruncated
- DIndexed
115You need to delete a database table.
Which data definition language (DDL) keyword should you use?- AALTER
- BDELETE
- CDROP
- DTRUNCATE
116This question requires that you evaluate the underlined text to determine if it is correct.
[Create a query that returns a set of table data by using the UPDATE statement.]
Instructons: Review the underlined text. If it makes the statement correct, select "No change is needed." If the
statement is incorrect, select the answer choice that makes the statement correct.- ANo change is needed
- BINSERT
- CREPLACE
- DSELECT
117Your class project requires that you help a charity to create a website that registers volunteers.
The website must store the following data about the volunteers:
• Given name
• Surname
• Telephone number
• Email address
You need to recommend a correct way to store the data.
What do you recommend?- ACreate a table that contains columns that are named given name, surname, phone number, and email.
- BCreate a table that contains rows that are named given name, surname, phone number, and email.
- CCreate a view that contains columns that are named given name surname, phone number, and email.
- DCreate a view that contains rows that are named given name surname, phone number, and email
118This queston requires that you evaluate the underlined text to determine if it is correct.
[Truncate] is a database term used to describe the process of applying a backup to a damaged or corrupt database.
Instructons: Review the underlined text. If it makes the statement correct, select "No change is needed." If the
statement is incorrect, select the answer choice that makes the statement corrector.- AChange is needed
- BCommit
- CAttach
- DRestore
119This queston requires that you evaluate the underlined text to determine if it is correct.
Use the [ALLOW SELECT] command to give a user permission to read the data in a table.
Instructons: Review the underlined text. If it makes the statement correct, select "No change is needed." If the
statement is incorrect, select the answer choice that makes the statement correct- ANo change is needed
- BGRANT SELECT
- CLET HEAD
- DPERMIT READ
120You have a user that has server roles as deined below:
The user can perfect [answer choice] actions on data that is on the serve
- Ano
- Bread-only
- Cunlimited
121You have a user that has server roles as deined below:
The user can perfect [answer choice] actions on data that is on the serve
- Ano
- Bunlimited
- Cconfiguration
122The following illustraton shows backup strategies that use the simple recovery model and the full recovery model:
Using the simple recovery model for database backups provides [answer choice] works-loss exposure than the full recovery model
- Aless
- Bmore
- Cthe same
123The following illustraton shows backup strategies that use the simple recovery model and the full recovery model:
Using the simple recovery model for database backups provides [answer choice] log file backups than the full recovery model
- Aless
- Bmore
- Cthe same
124You can delete data by using a stored procedure
- ATrue
- BFalse
125A function must have a return value
- ATrue
- BFalse
126A stored procedure must have a return value
- ATrue
- BFalse
127This queston requires that you evaluate the underlined text to determine if it is correct.
[Views] are database objects that contain all of the data in a database.
Instructons: Review the underlined text. If it makes the statement correct, select "No change is needed." If the
statement is incorrect, select the answer choice that makes the statement correct- ANo change is needed
- BQueries
- CStored procedures
- DTables
128You have two tables named Cars and Color as deined below. The two tables are related by ColorId.
- A0
- B2
- C3
- D6
129You accept an IT internship at a local charity. The charity asks you to keep a record of its volunteers by using a
database table named Volunteer.
When volunteers ask to be removed from mailing lists, the table must be updated.
You need to use a transacton to ensure that the database has data integrity and referental integrity.
Which statement should you use?- A
- B
- C
- D
- A
130This queston requires that you evaluate the underlined text to determine if it is correct.
[ALTER TABLE] removes all rows from a table without logging the individual row deletons.
Instructons: Review the underlined text. If it makes the statement correct, select "No change is needed." If the
statement is incorrect, select the answer choice that makes the statement correct.- ANo change is needed
- BDROP TABLE
- CTRUNCATE TABLE
- DCREATE TABLE
131You work at a cofee shop. They ask you to set up a website that stores charges on purchases.
You need to recommend a data type in a database table to run inancial functons against the charged amounts.
Which data type should you recommend?- AMoney
- BBit
- CVarchar
- DBinary
132This queston requires that you evaluate the underlined text to determine if it is correct.
[ A row holds informaton for a single record in a table.]
Instructons: Review the underlined text. If it makes the statement correct, select "No change is needed." If the
statement is incorrect, select the answer choice that makes the statement correct- ANo change is needed
- BColumn
- CData type
- DView
133A SQL Server Login can use Windows Authentication
- ATrue
- BFalse
134A SQL Server Role provides permissions at the server level
- ATrue
- BFalse
135A SQL Server Login is granted permissions to database views only
- ATrue
- BFalse
136This queston requires that you evaluate the underlined text to determine if it is correct.
[ Ports 20 and 21 are the default ports to secure a SQL Server.]
Instructons: Review the underlined text. If it makes the statement correct, select "No change is needed." If the
statement is incorrect, select the answer choice that makes the statement correct.- ANo change is needed
- B1433 and 1434
- C411 and 412
- D67 and 68
137You are creating a database object named Student to store the following data:
- A
- B
- C
- D
- A
138You develop a database to store data about textbooks. The data must be stored to process at a later tme.
Which database object should you use to store the data?- AView
- BTable
- CFunction
- DStored procedure
139This question requires that you evaluate the underlined text to determine if it is correct.
[First normal form requires that a database excludes repeatng groups]
Instructons: Review the underlined text. If it makes the statement correct, select "No change is needed." If the
statement is incorrect, select the answer choice that makes the statement correct.- ANo change is needed.
- BComposite keys
- CDuplicate rows
- DForeign keys
140HOTSPOT
You have two database tables as deined below. The StateID column is unique in the State table. The AddressID
column is unique in the Address table. The two tables are related by the StateID column.
StateID is a /an [blank_start][answer choice][blank_end] in the State table
- AIndex
- BUnion
- CForeing key
- DPrimary key
141HOTSPOT
You have two database tables as deined below. The StateID column is unique in the State table. The AddressID
column is unique in the Address table. The two tables are related by the StateID column.
StateID is a /an [blank_start][answer choice][blank_end] in the Address table
- APrimary Key
- BForeing Key
- CUNION
- DIndex
142This queston requires that you evaluate the underlined text to determine if it is correct.
Use the [blank_start]FROM keyword in a SELECT[blank_end] statement to return rows that meet a speciic conditon.
Instructons: Review the underlined text. If it makes the statement correct, select "No change is needed." If the
statement is incorrect, select the answer choice that makes the statement correct- ANo change is needed
- BORDER BY
- CUNION
- DWHERE
143A cluestered Index improves the perfomance of queries that [answer choice]
- Areturn large result set
- Breturn a range of values by using the = operator
- Cdo not use ORDER BY or GROUP BY clauses
144A Clustered index improves the perfomances of queries on column that [answer choice]
- Aare accessed randomly
- Bare accessed sequentially
- Care not unique or contain many common values
145You have the following SQL query
SELECT * FROM dbo.ProAthlete WHERE Salary > 500000
The query takes too much tme to return data.
You need to improve the performance of the query.
Which item should you add to the Salary column?- ANon-null constraint
- BDefault constraint
- CIndex
- DForeign key
Information
- Description
- Quiz on SQL Server MTA 98-364, created by Kelvin Rivas on 19/05/2017.
- GoConqr review
- Pon a prueba todo lo que sabes sobre SQL server MTA 98-364 y prepárate para obtener tu certificación, con este genial test. Al finalizar recuerda corroborar tus respuestas.
- Author
- Kelvin Rivas
- Language
- Español
- Views
- 1,068
- Tags
- Rating
- 5.0 out of 5 · 1 rating Rate this quiz