9009483
Reseña de GoConqr
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.
Test por Kelvin Rivas, actualizado hace más de 1 año
|
Creado por Kelvin Rivas
hace alrededor de 7 años
|
|
Pregunta 1
Pregunta
The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?
Respuesta
-
View
-
Functon
-
Index
-
Stored procedure
-
Trigger
Pregunta 2
Pregunta
One reason to add an index is to:
Respuesta
-
Decrease storage space
-
Increase database security.
-
Improve performance of select statements.
-
Improve performance of insert statements.
Pregunta 3
Pregunta
You have a table that contains the following data.
You break the table into the following two tables.
This process is referred to as:
Image:
Question3 1 (image/jpeg)
Respuesta
-
defragmentaton
-
normalizaton
-
fragmentaton
-
denormalizaton
Pregunta 4
Pregunta
You have a table that contains the following data.
Which database term is used to describe the relatonship between ProductID and ProductCategory?
Image:
Question4 1 (image/jpeg)
Respuesta
-
Cohort
-
Relatonally dependent
-
Deterministc
-
Functonally dependent
-
Compositonal
Pregunta 5
Pregunta
Which key uniquely identies a row in a table?
Respuesta
-
foreiqn
-
primary
-
local
-
superkey
Pregunta 6
Respuesta
-
Opton A
-
Opton B
-
Opton C
-
Opton D
Pregunta 7
Pregunta
At 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?
Respuesta
-
The Customer table no longer exists.
-
The Customer table is unafected.
-
The Customer table exists but has no data.
-
The script fails.
Pregunta 8
Pregunta
In which situaton do you need to perform a restore on a database?
Respuesta
-
when data becomes corrupted in the database
-
when you need to roll back a transacton
-
when you encounter an error in your applicaton
-
when data needs to be deleted from the database
Pregunta 9
Pregunta
Which command should you use to give a user permission to read the data in a table?
Respuesta
-
ALLOW SELECT
-
LET READ
-
PERMIT READ
-
GRANT SELECT
Pregunta 10
Pregunta
You need to enable a new employee to authentcate to your database.
Which command should you use?
Respuesta
-
ALLOW USER
-
CREATE USER
-
ADD USER
-
INSERT USER
-
ALTER USER
Pregunta 11
Pregunta
Which keyword can be used in a create table statement?
Respuesta
-
ORDER BY
-
DISTINCT
-
GROUP BY
-
UNIQUE
Pregunta 12
Pregunta
You need to store product quanttes, and you want to minimize the amount of storage space that is used. Which data
type should you use?
Respuesta
-
INTEGER
-
DOUBLE
-
COUNT
-
FLOAT
Pregunta 13
Respuesta
-
Option A
-
Option B
-
Option C
-
Option D
Pregunta 14
Pregunta
You 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?
Image:
Question14 (image/jpeg)
Respuesta
-
an error statng that NULL values are not allowed
-
a new row in the table
-
an error statng that duplicate IDs are not allowed
-
a syntax error
Pregunta 15
Pregunta
You 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?
Respuesta
-
VARCHAR (3, 30)
-
CHAR (3, 30)
-
VARCHAR (30)
-
CHAR (30)
Pregunta 16
Pregunta
One reason to create a stored procedure is to:
Respuesta
-
Improve performance.
-
Minimize storage space.
-
Bypass case sensitvity requirements.
-
Give the user control of the query logic.
Pregunta 17
Pregunta
Which permission does a user need in order to run a stored procedure?
Respuesta
-
EXECUTE
-
ALLOW
-
CALL
-
RUN
Pregunta 18
Pregunta
You 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:
Respuesta
-
Empty
-
Deleted
-
Unchanged
-
Archived
Pregunta 19
Pregunta
In SQL, an insert statement is used to add a:
Respuesta
-
User to a database.
-
Row of data to a table.
-
Table to a database.
-
Column to a table deiniton.
Pregunta 20
Pregunta
You have two tables. Each table has three rows.
How many rows will be included in the Cartesian product of these two tables?
Respuesta
-
0
-
3
-
6
-
9
Pregunta 21
Pregunta
You are writng an SQL statement to retrieve rows from a table.
Which data manipulaton language (DML) command should you use?
Respuesta
-
READ
-
SELECT
-
OUTPUT
-
GET
Pregunta 22
Pregunta
Which constraint ensures a unique value in the ID column for each customer?
Respuesta
-
DISTINCT
-
FOREIGN KEY
-
SEQUENTIAL
-
PRIMARY KEY
Pregunta 23
Pregunta
The component that holds informaton for a single entry in a table is called a:
Respuesta
-
Data type
-
Row
-
Column
-
View
Pregunta 24
Pregunta
You execute the following statement:
SELECT EmployeeID, FirstName, DepartmentName
FROM Employee, Department
This type of operaton is called a/an:
Respuesta
-
Intersection
-
Outer join
-
Equi-join
-
Cartesian product
Pregunta 25
Pregunta
Which command should you use to add a column to an existng table?
Respuesta
-
MODIFY
-
ALTER
-
UPDATE
-
INSERT
-
CHANGE
Pregunta 26
Pregunta
You 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?
Image:
Pregunta26 (image/png)
Respuesta
-
0
-
1
-
2
-
3
-
4
Pregunta 27
Pregunta
You are writng a select statement to ind every product whose name contains a speciic character.
Which keyword should you use in your where clause?
Respuesta
-
FIND
-
BETWEEN
-
INCLUDES
-
LIKE
Pregunta 28
Pregunta
A database contains two tables named Customer and Order.
You execute the following statement:
DELETE FROM Order
WHERE CustomerID = 209
What is the result?
Respuesta
-
The irst order for CustomerID 209 is deleted from the Order table.
-
All orders for CustomerID 209 are deleted from the Order table, and CustomerID 209 is deleted from the Customer table.
-
All orders for CustomerID 209 are deleted from the Order table.
-
CustomerID 209 is deleted from the Customer table.
Pregunta 29
Pregunta
You 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?
Image:
Question29 (image/jpeg)
Respuesta
-
Opton A
-
Opton B
-
Opton C
-
Opton D
Pregunta 30
Pregunta
You 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?
Respuesta
-
UPDATE
-
CHANGE
-
SELECT
-
INSERT
Pregunta 31
Pregunta
You need to populate a table named EmployeeCopy with data from an existng table named Employee.
Which statement should you use?
Image:
Question31 (image/jpeg)
Respuesta
-
Option A
-
Option B
-
Option C
-
Option D
Pregunta 32
Respuesta
-
Subquery
-
Union
-
Outer join
-
Cartesian product
Pregunta 33
Pregunta
Which keyword would you use in a select statement to return rows that meet a speciic conditon?
Respuesta
-
WHERE
-
UNION
-
ORDER BY
-
FROM
Pregunta 34
Pregunta
You 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?
Image:
Question34 (image/jpeg)
Respuesta
-
Option A
-
Option B
-
Option C
-
Option D
Pregunta 35
Pregunta
The 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?
Respuesta
-
1
-
2
-
3
-
4
Pregunta 36
Pregunta
Which command should you use to remove a table from a database?
Respuesta
-
REMOVE TABLE
-
UPDATE TABLE
-
DROP TABLE
-
DELETE TABLE
Pregunta 37
Pregunta
You need to store the contact informaton for each student in your school database.
You should store each student's informaton in a:
Respuesta
-
Stored procedure
-
Function
-
Row
-
Variable
Pregunta 38
Pregunta
Which category of SQL statements is used to add, remove, and modify database structures?
Respuesta
-
Data access language (DAL)
-
Data manipulation language (DML)
-
Data control language (DCL)
-
Data definiton language (DDL)
Pregunta 39
Pregunta
You 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?
Respuesta
-
Complete join
-
Partial join
-
Inner join
-
Outer join
Pregunta 40
Pregunta
Data in a database is stored in:
Respuesta
-
Tables
-
Queries
-
Data types
-
Stored procedures
Pregunta 41
Pregunta
You 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?
Respuesta
-
All rows in the table will be deleted.
-
All rows containing a NULL value in the FirstName column will be deleted.
-
You will receive an error message.
-
All rows and the table deiniton will be deleted.
Pregunta 42
Pregunta
You need to establish a set of permissions that you can routnely assign to new users.
What should you create?
Respuesta
-
Resource
-
Group
-
List
-
Role
Pregunta 43
Pregunta
Which database term is used to describe the process of applying a backup to a damaged or corrupt database?
Respuesta
-
Recover
-
Restore
-
Commit
-
Atach
Pregunta 44
Pregunta
You need to disable User1's access to view the data in the Customer table.
Which statement should you use?
Image:
Question44 (image/jpeg)
Respuesta
-
Option A
-
Option B
-
Option C
-
Option D
Pregunta 45
Pregunta
Denormalizaton is performed in order to:
Respuesta
-
Reduce redundancy.
-
Eliminate repeatng groups.
-
Create smaller tables.
-
Improve query performance.
Pregunta 46
Pregunta
You 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?
Respuesta
-
A cursor
-
A subquery
-
A trigger
-
An index
Pregunta 47
Pregunta
You 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?
Image:
Question47 (image/jpeg)
Respuesta
-
a foreign key constraint violation
-
a syntax error
-
a new row in the Product table
-
a primary key constraint violation
-
a new row in the Category table
Pregunta 48
Pregunta
Which two keys establish a relatonship between two tables? (Choose two.)
Respuesta
-
candidate
-
foreign
-
superkey
-
local
-
primary
Pregunta 49
Pregunta
One diference between a functon and a stored procedure is that a functon:
Respuesta
-
Must be called from a trigger.
-
Must return a value.
-
Cannot contain a transaction.
-
Cannot accept parameters.
Pregunta 50
Pregunta
Which keyword must be included in a create view statement?
Respuesta
-
WHERE
-
ORDER BY
-
UPDATE
-
SELECT
Pregunta 51
Pregunta
You have a table named Customer. You need to add a new column named District.
Which statement should you use?
Image:
Question51 (image/jpeg)
Respuesta
-
Option A
-
Option B
-
Option C
-
Option D
Pregunta 52
Pregunta
You need to remove a view named EmployeeView from your database.
Which statement should you use?
Respuesta
-
DELETE VIEW EmployeeView
-
DELETE EmployeeView
-
DROP EmployeeView
-
DROP VIEW EmployeeView
Pregunta 53
Pregunta
A named group of SQL statements that can be executed in a database is called a:
Respuesta
-
Subroutine
-
Formula
-
Stored procedure
-
Method
Pregunta 54
Pregunta
A view can be used to:
Respuesta
-
Save an extra copy of data stored in a separate table.
-
Limit access to speciic rows or columns of data in a table.
-
Ensure referental integrity.
-
Save historical data before deleting it from the base table.
Pregunta 55
Pregunta
On which database structure does an update statement operate?
Respuesta
-
Table
-
User
-
Trigger
-
Role
Pregunta 56
Pregunta
You need to list the name and price of each product, sorted by price from highest to lowest. Which statement should
you use?
Image:
Question56 (image/jpeg)
Respuesta
-
Option A
-
Option B
-
Option C
-
Option D
Pregunta 57
Pregunta
You 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:
Respuesta
-
Inherited delete
-
Cascade delete
-
Functional delete
-
Waterfall delete
-
Domino delete
Pregunta 58
Pregunta
Which statement deletes the rows where the employee's phone number is not entered
Image:
Question58 (image/jpeg)
Respuesta
-
Option A
-
Option B
-
Option C
-
Option D
Pregunta 59
Pregunta
You 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?
Image:
Question59 (image/jpeg)
Respuesta
-
OptIon A
-
OptIon B
-
OptIon C
-
OptIon D
Pregunta 60
Pregunta
You have a table named Employee that includes four columns.
You execute the following statement:
SELECT *
FROM Employee
Which columns are returned?
Respuesta
-
all columns
-
only the last column
-
only the First column
-
only the First and last columns
Pregunta 61
Pregunta
Which two elements are required to deine a column? (Choose two.)
Respuesta
-
A name
-
A key
-
An index
-
A data type
Pregunta 62
Pregunta
What deines the amount of storage space that is allocated to a value in a column?
Respuesta
-
format
-
key
-
data type
-
validator
Pregunta 63
Pregunta
You 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?
Respuesta
-
CHAR
-
BYTE
-
DOUBLE
-
SMALLINT
Pregunta 64
Pregunta
What is one diference between an update statement and a delete statement?
Respuesta
-
An update statement can change only one row.
-
A delete statement cannot use a where clause.
-
An update statement does not remove rows from a table.
-
A delete statement works only within a stored procedure.
Pregunta 65
Pregunta
You 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?
Respuesta
-
A primary key
-
An index
-
A foreign key
-
A unique constraint
-
A data type
Pregunta 66
Pregunta
You need to store the irst name, last name, and student ID for 100 students.
This informaton will be stored in a table as:
Respuesta
-
100 items and three cells.
-
100 rows and three columns.
-
three rows and 100 columns.
-
three items and 100 cells.
Pregunta 67
Pregunta
What are three valid data manipulaton language (DML) commands? (Choose three.)
Respuesta
-
INSERT
-
COMMIT
-
DELETE
-
OUTPUT
-
UPDATE
Pregunta 68
Pregunta
You assign User1 a set of permissions that include the WITH GRANT OPTION.
The WITH GRANT OPTION enables User1 to:
Respuesta
-
request a log of permission use.
-
delegate permissions to other users.
-
create new database users.
-
view other users' permissions.
Pregunta 69
Pregunta
Which type of index changes the order in which the data is stored in a table?
Respuesta
-
non-sequental
-
sequental
-
non-clustered
-
clustered
Pregunta 70
Pregunta
Which statement should you use to remove a foreign key?
Respuesta
-
ALTER TABLE
-
DELETE TABLE
-
DELETE FOREIGN KEY
-
ALTER FOREIGN KEY
Pregunta 71
Pregunta
First normal form requires that a database excludes:
Respuesta
-
Foreign keys
-
Composite keys
-
Duplicate rows
-
Repeatng groups
Pregunta 72
Pregunta
You 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?
Respuesta
-
The table will be corrupted.
-
Forty (40) rows will be deleted from the table.
-
The transacton will restart.
-
No rows will be deleted from the table.
Pregunta 73
Pregunta
You 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?
Respuesta
-
SET ProduetName = 'glass'
-
LET ProduetName = 'glass'
-
EXEC ProduetName = 'glass'
-
ASSIGN ProduetName = 'glass'
Pregunta 74
Pregunta
Your 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?
Image:
Question74 (image/jpeg)
Respuesta
-
OptIon A
-
OptIon B
-
OptIon C
-
OptIon D
Pregunta 75
Pregunta
On which database structure does an insert statement operate?
Respuesta
-
Role
-
Trigger
-
User
-
Stored procedure
-
Table
Pregunta 76
Pregunta
You 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?
Respuesta
-
THAT
-
WHERE
-
GROUP BY
-
HAVING
Pregunta 77
Pregunta
You 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?
Image:
Question77 (image/jpeg)
Respuesta
-
Option A
-
Option B
-
Option C
-
Option D
Pregunta 78
Pregunta
HOTSPOT
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]
Respuesta
-
Verdadero
-
Falso
-
Verdadero
-
Falso
-
Verdadero
-
Falso
-
Verdadero
-
Falso
Pregunta 79
Pregunta
HOTSPOT
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.
Image:
79 (image/png)
Respuesta
-
client
-
www.contoso.com
-
s01.contoso.com
-
client
-
www.contoso.com
-
s01.contoso.com
Pregunta 80
Respuesta
-
4
-
5
-
6
-
7
Pregunta 81
Pregunta
You 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?
Image:
81 (image/png)
Respuesta
-
Image:81.1 (image/jpeg)
-
Image:81.2 (image/jpeg)
-
Image:81.3 (image/jpeg)
-
Image:81.4 (image/jpeg)
Pregunta 82
Pregunta
You 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:
Image:
82 (image/jpeg)
Respuesta
-
Image:82.1 (image/jpeg)
-
Image:82.2 (image/jpeg)
-
Image:82.3 (image/jpeg)
-
Image:82.4 (image/jpeg)
Pregunta 83
Pregunta
This 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.
Respuesta
-
No change is needed
-
DROP TABLE
-
TRUNCATE TABLE
-
CREATE TABLE
Pregunta 84
Pregunta
You 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?
Respuesta
-
TRUNCATE
-
JOIN
-
EXCEPT
-
UNION
Pregunta 85
Pregunta
This 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
Respuesta
-
No change is needed
-
DROP TABLE
-
TRUNCATE TABLE
-
ALTER TABLE
Pregunta 86
Pregunta
You 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?
Respuesta
-
Primary key
-
Secondary key
-
Foreign key
-
Default Key
Pregunta 87
Pregunta
HOTSPOT
You have the following table:
Adding a [answer choice] on the FlightNumber column physically sorts rows in the by FlightNumber
Image:
Q88 (image/jpeg)
Respuesta
-
foreing key
-
clustered index
-
noclustered index
Pregunta 88
Pregunta
HOTSPOT
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
Image:
Q88 (image/jpeg)
Respuesta
-
foreing key
-
clustered index
-
noclustered index
Pregunta 89
Pregunta
While 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?
Respuesta
-
Foreing Key
-
Index Key
-
Link Key
-
Default Key
Pregunta 90
Pregunta
This 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.
Respuesta
-
No change is needed.
-
Save an extra copy of data stored in a separate table.
-
Limit access to specific rows or columns of data in a table.
-
Save historical data before deleting it from the base table.
Pregunta 91
Pregunta
DRAG 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.
Image:
Q91 (image/jpeg)
Respuesta
-
CREATE VIEW dbo.NorthAmericanMammal_View
-
GENERATE VIEW dbo.NorthAmericanMammal_Vi
-
AS JOIN a.Id , a.Name
-
AS SELECT a.Id, a.Name
-
FROM Animal a
-
JOIN Animal a
Pregunta 92
Pregunta
DRAG 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.
Image:
Q92 (image/jpeg)
Respuesta
-
VARCHAR
-
CHAR
-
INT
-
BIT
-
DECIMAL
-
DATETIME
Pregunta 93
Pregunta
The VARCHAR data type contains only numeric characters.
Respuesta
- True
- False
Pregunta 94
Pregunta
The NUMERIC data type contains only numbers that have decimal places.
Respuesta
- True
- False
Pregunta 95
Pregunta
The INT data type contains only whole numbers.
Respuesta
- True
- False
Pregunta 96
Pregunta
This 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.
Respuesta
-
No change is needed
-
Table
-
Index
-
Row
Pregunta 97
Pregunta
This 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.
Respuesta
-
No change is needed
-
Zero
-
Three
-
Six
Pregunta 98
Pregunta
You 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?
Respuesta
-
Nonclustered index
-
Primary key
-
Foreign key
-
Clustered index
Pregunta 99
Pregunta
DRAG 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.
Image:
Q97 (image/png)
Respuesta
-
INT NOT NULL PRIMARY KEY
-
INT NOT NULL FOREING KEY
-
DATE NULL
-
TIMESTAMP NULL
-
IMAGE NULL
-
XML NULL
Pregunta 100
Pregunta
This 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.
Respuesta
-
No change is needed
-
UPDATE
-
INSERT
-
CREATE
Pregunta 101
Pregunta
You need to rename a column in a database table.
Which data deiniton language (DDL) statement should you use?
Respuesta
-
ALTER
-
INSERT
-
CREATE
-
UPDATE
Pregunta 102
Pregunta
DRAG 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.
Image:
Q100 (image/jpeg)
Respuesta
-
MATH
-
MATH
-
SCIENCE
-
MATH
-
SCIENCE
-
SCIENCE
-
GEOGRAPHY
-
READING
-
HISTORY
-
GEOGRAPHY
-
READING
-
HISTORY
-
GEOGRAPHY
-
READING
-
HISTORY
Pregunta 103
Pregunta
This 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.
Respuesta
-
No change is needed.
-
Data manipulaton language (DML) statements
-
Data deiniton language (DDL) statements
-
A unique constraint
Pregunta 104
Pregunta
You need to add rows to a database table.
Which Structured Query Language (SQL) keyword should you use?
Respuesta
-
JOIN
-
INSERT
-
CREATE
-
UPDATE
Pregunta 105
Pregunta
You 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?
Respuesta
-
INTERSECT
-
UNION
-
JOIN
-
TRUNCATE
Pregunta 106
Pregunta
You have a database table that contains the following columns, Which two Structured Query Language (SQL) statements can you use? (Choose two.)
Image:
104 (image/jpeg)
Respuesta
-
Image:104a (image/png)
-
Image:104b (image/png)
-
Image:104c (image/png)
-
Image:104d (image/png)
Pregunta 107
Pregunta
This 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
Respuesta
-
No change is needed
-
INTERSECT
-
ALL
-
EXCEPT
Pregunta 108
Pregunta
You 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?
Image:
106 (image/png)
Respuesta
-
1
-
2
-
3
-
4
Pregunta 109
Pregunta
You 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.)
Image:
107 (image/png)
Respuesta
-
ChapterId
-
LanguageId
-
Country
-
Region
-
City
-
LanguageName
Pregunta 110
Pregunta
HOT 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.
Respuesta
- True
- False
Pregunta 111
Pregunta
HOT 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
Respuesta
- True
- False
Pregunta 112
Pregunta
HOT 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
Respuesta
- True
- False
Pregunta 113
Pregunta
HOT 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
Respuesta
- True
- False
Pregunta 114
Pregunta
This 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.
Respuesta
-
No change is needed
-
Normalized
-
Truncated
-
Indexed
Pregunta 115
Pregunta
You need to delete a database table.
Which data definition language (DDL) keyword should you use?
Respuesta
-
ALTER
-
DELETE
-
DROP
-
TRUNCATE
Pregunta 116
Pregunta
This 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.
Respuesta
-
No change is needed
-
INSERT
-
REPLACE
-
SELECT
Pregunta 117
Pregunta
Your 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?
Respuesta
-
Create a table that contains columns that are named given name, surname, phone number, and email.
-
Create a table that contains rows that are named given name, surname, phone number, and email.
-
Create a view that contains columns that are named given name surname, phone number, and email.
-
Create a view that contains rows that are named given name surname, phone number, and email
Pregunta 118
Pregunta
This 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.
Respuesta
-
Change is needed
-
Commit
-
Attach
-
Restore
Pregunta 119
Pregunta
This 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
Respuesta
-
No change is needed
-
GRANT SELECT
-
LET HEAD
-
PERMIT READ
Pregunta 120
Pregunta
You have a user that has server roles as deined below:
The user can perfect [answer choice] actions on data that is on the serve
Image:
115 (image/png)
Respuesta
-
no
-
read-only
-
unlimited
Pregunta 121
Pregunta
You have a user that has server roles as deined below:
The user can perfect [answer choice] actions on data that is on the serve
Image:
115 (image/png)
Respuesta
-
no
-
unlimited
-
configuration
Pregunta 122
Pregunta
The 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
Image:
116 (image/png)
Respuesta
-
less
-
more
-
the same
Pregunta 123
Pregunta
The 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
Image:
116 (image/png)
Respuesta
-
less
-
more
-
the same
Pregunta 124
Pregunta
You can delete data by using a stored procedure
Respuesta
- True
- False
Pregunta 125
Pregunta
A function must have a return value
Respuesta
- True
- False
Pregunta 126
Pregunta
A stored procedure must have a return value
Respuesta
- True
- False
Pregunta 127
Pregunta
This 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
Respuesta
-
No change is needed
-
Queries
-
Stored procedures
-
Tables
Pregunta 128
Pregunta
You have two tables named Cars and Color as deined below. The two tables are related by ColorId.
Image:
1 (image/jpeg)
Respuesta
-
0
-
2
-
3
-
6
Pregunta 129
Pregunta
You 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?
Respuesta
-
Image:2 (image/jpeg)
-
Image:3 (image/jpeg)
-
Image:4 (image/jpeg)
-
Image:5 (image/jpeg)
Pregunta 130
Pregunta
This 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.
Respuesta
-
No change is needed
-
DROP TABLE
-
TRUNCATE TABLE
-
CREATE TABLE
Pregunta 131
Pregunta
You 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?
Respuesta
-
Money
-
Bit
-
Varchar
-
Binary
Pregunta 132
Pregunta
This 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
Respuesta
-
No change is needed
-
Column
-
Data type
-
View
Pregunta 133
Pregunta
A SQL Server Login can use Windows Authentication
Respuesta
- True
- False
Pregunta 134
Pregunta
A SQL Server Role provides permissions at the server level
Respuesta
- True
- False
Pregunta 135
Pregunta
A SQL Server Login is granted permissions to database views only
Respuesta
- True
- False
Pregunta 136
Pregunta
This 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.
Respuesta
-
No change is needed
-
1433 and 1434
-
411 and 412
-
67 and 68
Pregunta 137
Pregunta
You are creating a database object named Student to store the following data:
Image:
6 (image/jpeg)
Respuesta
-
Image:7 (image/jpeg)
-
Image:8 (image/jpeg)
-
Image:9 (image/jpeg)
-
Image:11 (image/jpeg)
Pregunta 138
Pregunta
You 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?
Respuesta
-
View
-
Table
-
Function
-
Stored procedure
Pregunta 139
Pregunta
This 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.
Respuesta
-
No change is needed.
-
Composite keys
-
Duplicate rows
-
Foreign keys
Pregunta 140
Pregunta
HOTSPOT
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
Image:
1 (image/png)
Respuesta
-
Index
-
Union
-
Foreing key
-
Primary key
Pregunta 141
Pregunta
HOTSPOT
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
Image:
1 (image/png)
Respuesta
-
Primary Key
-
Foreing Key
-
UNION
-
Index
Pregunta 142
Pregunta
This 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
Respuesta
-
No change is needed
-
ORDER BY
-
UNION
-
WHERE
Pregunta 143
Pregunta
A cluestered Index improves the perfomance of queries that [answer choice]
Image:
Q87 (image/jpeg)
Respuesta
-
return large result set
-
return a range of values by using the = operator
-
do not use ORDER BY or GROUP BY clauses
Pregunta 144
Pregunta
A Clustered index improves the perfomances of queries on column that [answer choice]
Image:
Q87 (image/jpeg)
Respuesta
-
are accessed randomly
-
are accessed sequentially
-
are not unique or contain many common values
Pregunta 145
Pregunta
You 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?
Respuesta
-
Non-null constraint
-
Default constraint
-
Index
-
Foreign key
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.