Test
DATABASE ++++++ +
Este test tiene tipos de pregunta que se abren en el reproductor de siempre.
Preguntas del test (167)
1Data in a database is stored in:
- ATables
- BQueries
- CData types
- DStored procedures
2The component that holds information for a single entry in a table is called a:
- AData type
- BRow
- CColumn
- DAttribute
3This question requires that you evaluate the underlined text to determine if it is correct.
A row holds information for a single record in a table.
Instructions: 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
4This question requires that you evaluate the underlined text to determine if it is correct.
In a database table, each column represents a unique record.
Instructions: 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
5You need to store the contact information for each student in your school database.
You should store each student's information in a:- AStored procedure
- BFunction
- CRow
- DVariable
6You are structuring a table in a relational database.
Instructions: For each of the following statement, select Yes if the statement is true. Otherwise, select No.- AEach value in a field in a table must be unique.
- BEach row in a table must be unique.
- CEach column name in a table must be unique.
7You need to store the first name, last name, and student ID for 100 students.
This information 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.
8Which two elements are required to define a column? (Choose two.)
- AA name
- BA key
- CAn index
- DA data type
9What defines the amount of storage space that is allocated to a value in a column?
- Aformat
- Bkey
- Cdata type
- Dvalidator
10You need to store product quantities, and you want to minimize the amount of storage space that is used. Which
data type should you use?- AINTEGER
- BDOUBLE
- CCOUNT
- DFLOAT
11You 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)
12You create a table that stores product names. You need to record the product names in different language. Which
data type should you use?- ACHAR
- BNCHAR
- CTEXT
- DVARCHAR
13You are creating a table to store customer data. The AccountNumber column uses values that always consist of
one letter and four digits. Which data type should you use for the AccountNumber column?- ACHAR
- BBYTE
- CDOUBLE
- DSMALLINT
14For each of the following statements, select Yes if the statement is true and No if it is not.
- AChar(size) holds a fixed-length string.
- BText holds a fixed-length string.
- CVarchar(size) can hold a string of differing lengths.
15Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each
correct selection is worth one point.- AThe VARCHAR data type contains only numeric characters.
- BThe NUMERIC data type contains only numbers that have decimal places.
- CThe INT data type contains only whole numbers.
16You have a database table that stores information about school attendance.
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.
StudentName [blank_start]1[blank_end]
GradeLevel [blank_start]2[blank_end]
DaysAbesent [blank_start]3[blank_end]- AVARCHAR
- BBIT
- CDATETIME
- DCHAR
- EINT
- FDECIMAL
17You work at a coffee 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 financial functions against the charged amounts.
Which data type should you recommend?- AMoney // Decimal
- BBit
- CVarchar
- DBinary
18Which constraint ensures a unique value in the ID column for each customer?
- ADISTINCT
- BFOREIGN KEY
- CSEQUENTIAL
- DPRIMARY KEY
19Which key uniquely identifies a row in a table?
- Aforeiqn
- Bprimary
- Clocal
- Dsuperkey
20You 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
21You accept an IT internship at a local charity. The charity has two tables in their data model named Chapter and
Language, as defined below:
- AChapterId
- BLanguageId
- CCountry
- DRegion
- ECity
- FLanguageName
22You have a Department table and an Employee table in your database.
You need to ensure that an employee can be assigned to only an existing department.
What should you apply to the Employee table?- AA primary key
- BAn index
- CA foreign key
- DA unique constraint
- EA data type
23You 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
24You have two database tables as defined 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]1[blank_end] in the State table.
StateID is a/an [blank_start]2[blank_end] in the Address table.
- Aindex
- Bunion
- Cforeign key
- Dprimary key
- Eindex
- Funion
- Gforeign key
- Hprimary key
25Which two keys establish a relationship between two tables? (Choose two.)
- Acandidate
- Bforeign
- Csuperkey
- Dlocal
- Eprimary
26Student CourseName
Brad [blank_start]1[blank_end]
Joe [blank_start]2[blank_end]
Susan [blank_start]3[blank_end]
- AReading
- BHistory
- CGeography
- DMath
- EScience
27Among the following, which sets limits or rules placed on a file or a column to ensure that the data is considered
valid for a database?- Achecker
- Bvalidator
- Cscanner
- Dconstraint
28Which feature does a relational database use to ensure that data entered into a column is valid.
- AAn attribute
- BA primary key
- CA constraint
- DAn index
29Which of the following statements is the primary method to program and manage SQL Server?
- ADOS Commands
- BSQLCMD Scripts
- CXQuery
- DT-SQL (Transact-SQL)
30You are writing an SQL statement to retrieve rows from a table.
Which data manipulation language (DML) command should you use?- AREAD
- BSELECT
- COUTPUT
- DGET
31What command do you use to perform a query in SQL?
- AUSE
- BSELECT
- CQUERY
- DCHOSE
32What statement would you use to pull First_Name, Last_Name, and ID_Number from the Users table?
[blank_start]1[blank_end] First_Name, Last_Name, ID_Number
[blank_start]2[blank_end] Users;- ASELECT
- BINSERT INTO
- CUPDATE
- DDELETE
- EWHERE
- FJOIN
- GGROUP BY
- HFROM
33You have a table named Customer that has columns named CustomerID, FirstName, and DataJoined. CustomerID
is a primary key. You execute the following statement:
SELECT CustomerID, FirstName, DataJoined FROM Customer
How are the rows organized in the result set?- AIn no predictable order
- BIn alphabetical order FirstName
- CIn chronological order by DateJoined
- DIn the order in which the rows were inserted
34You 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
35A flower shop wants to see every flower ordered, but each flower should only show once. Which SQL statement
will fulfill that need?- ASELECT UNIQUE flowername FROM flowers
- BSELECT flowername FROM flowers DISTINCT
- CSELECT DISTINCT flowername FROM flowers
- DSELECT TOP 1 flowername FROM flowers
36A stored procedure contains the following query
SELECT 'Greetings' + Prefix + ' ' + FirstName FROM Person;
The stored procedure return all null values. You verify that there is data in the person table
What is likely the cause of the problem- AYou must specify the NULLIF keyword in the query
- BThe plus (+) operator cannot be used to append character data
- CThe Prefix or FirstName columns have null values
- DYou must specify the join keyword in the select statement
37This question requires that you evaluate the underlined text to determine if it is correct.
Use the FROM keyword in a SELECT statement to return rows that meet a specific condition.
Instructions: 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
38Which SQL statement is a data manipulation languange statement?
- AALTER TABLE Employee
ADD EmployeeName Varchar; - BSELECT EmployeeName FROM Employee
WHERE EmployeeName = ‘Jack Smith’; - CSELECT * INTO Employee FROM NewHires
INSERT INTO Employee - DVALUES (‘Jack Smith’);
- AALTER TABLE Employee
39What would you use to combine two parameters in a query in SQL
- APLUS
- BBOTH
- CCOMBINE
- DAND
40You have a database table named SongInformation as defined below:
- ASELECT Name
FROM SongInformation
WHERE CDsSold > - BSELECT Name
FROM CDsSold
WHERE CDsSold > 1000 - CSELECT
FROM SongInformation
WHERE CDsSold > 1000 - DSELECT *
FROM SongInformation
- ASELECT Name
41The following table named Building stores data about building and their most recent inspection dates.
Which query correctly returns a result set for all orders where the ship_state excludes Texas (TX) and Arizona (AZ)?- ASELECT * FROM Orders WHERE NOT Ship_State = ‘TX’ AND NOT Ship_State = ‘AZ’ ;SELECT * FROM Orders WHERE NOT Ship_State = ‘TX’ AND NOT Ship_State = ‘AZ’ ;
- BSELECT * FROM Orders WHERE NOT Ship_State = ‘TX’ OR NOT Ship_State = ‘AZ’;
- CSELECT * FROM Orders WHERE Ship_State NOT = ‘TX’ AND Ship_State NOT = ‘AZ’;
- DSELECT * FROM Orders WHERE Ship_State NOT = ‘TX’ OR Ship_State NOT = ‘AZ’;
42You have the database table named Cars as defined below:
You have the following Structured Query Language (SQL) statement:
SELECT *
FROM Cars c
WHERE c.Origin <> 'USA' AND c.Color<> 'Black'
- A4
- B5
- C6
- D7
43The Product table contains the following data
You execute the following statement:
SELECT Name FROM Product WHERE Quantity IS NOT NULL
How many rows are returned?
- A0
- B1
- C2
- D3
- E4
44A sales manager wants to see all customers with sales of at least 50000 who either reside in Los Angeles,
California, or in the states of Nevada or Arizona. Which SQL statement will satisfy the request?- ASELECT lastname, firstname
FROM customers
WHERE sales >-500ee OR ((city="Los Angeles' AND state='California') OR state IN ('Nevada', 'Arizona')) - BSELECT lastname, firstname
FROM customers
WHERE sales >500ee AND ((city="Los Angeles' AND state='California') OR state IN ('Nevada', 'Arizona')) - CSELECT lastname, firstname
FROM customers
WHERE sales >=50000 AND ((city="Los Angeles' AND state='California') OR state IN ('Nevada',
'Arizona')) - DSELECT lastname, firstname
FROM customers
WHERE sales >50000 OR((city="Los Angeles' AND state='California') AND state IN ('Nevada', 'Arizona'))
- ASELECT lastname, firstname
45What clause would you use with the SELECT command that would pull records based on a range?
- ACOMBO
- BBETWEEN
- COR
- DCOMBINE
46You are writing a select statement to find every product whose name contains a specific character.
Which keyword should you use in your where clause?- AFIND
- BBETWEEN
- CINCLUDES
- DLIKE
47The products table contains the following data
Which query will retrieve ItemName and Price when chocolate appears in the ItemDescription column?
- ASELECT ItemName, Price
FROM Products
Where ItemDescription = ‘chocolate’; - BSELECT ItemName, Price
FROM Products
WHERE ItemDescription LIKE ‘%chocolate%’; - CSELECT ItemName, Price
FROM Products
WHERE ItemDEscription LIKE ‘chocolate’; - DSELECT ItemName, Price
FROM Products
WHERE ItemDescription IN ‘%chocolate%’;
- ASELECT ItemName, Price
48Which query returns a result set of orders placed after January 2017 in all states except California (CA)?
- ASELECT * FROM orders WHERE order_date > ‘2017-01-01’ AND ship_state < > ‘CA’
- BSELECT * FROM orders WHERE order_date > ‘2017-01-01’ OR ship_state < > ‘CA’
- CSELECT * FROM orders WHERE order_date ? ‘2017-01-01’ AND ship_state LIKE ‘CA’
- DSELECT * FROM orders WHERE order_date > ‘2017-01-01’ OR ship_state LIKE ‘CA’
49You need to list the name and price of each product, sorted by price from highest to lowest. Which statement
should you use?- ASELECT Name, Price
FROM Product
ORDER BY Price DESC - BSELECT Name, Price
FROM Product
ORDER BY Price ASC - CSELECT Name, BOTTOM Price
FROM Product - DSELECT Name, TOP Price
FROM Product
- ASELECT Name, Price
50Drag and drop to complete the query to display customers from Utah, sorted by last name.
SELECT lastname, firstname
FROM customers
[blank_start]1[blank_end] state = "UT'
[blank_start]2[blank_end] lastname- ASORT BY
- BWHEN
- CWHERE
- DHAVING
- EORDER BY
51The customers table includes the following data
Create a query to return lastname,
phonenumber, and valid extensions, sorted
by lastname. Complete the code using the
drop-down options.
SELECT Lastname, PhoneNumber, Extension
FROM Customers
WHERE [blank_start]1[blank_end] [blank_start]2[blank_end]
[blank_start]3[blank_end] Lastname
- AExtention
- BPhoneNumber
- CIS VALID
- DSORT BY
- EIS NOT NULL
- FORDER BY
52A table named Flight contains the following fields:
You need to display the flight numbers of all flights that arrive at LaGuardia Airport (LGA) later today. The
results should be sorted by the most recent arrival time.
Which query should you use? Complete the code by selecting the correct option from each drop-down list.
SELECT FlightNumber
FROM Flight
WHERE DestinationAirport = ‘LGA’ [blank_start]1[blank_end]
ArrivalTime [blank_start]2[blank_end]GETDATE()
[blank_start]3[blank_end] [blank_start]4[blank_end]
- AAND
- BOR
- CNOT
- D=
- E<>
- F<
- GHAVING
- HGROUP
- IArrivalTime ASC
- JArrivalTime
- K>
- LORDER BY
- MArrivalTime DESC
53You need to create a report of data in the students table. The report must meet the following requirements:
• Display all student who enrolled on or after June 1, 2020
• Display all student who graduated in 2020
• Return the result set in order of enrollment, with the most recent enrollment date first
Enrollment_Date specifies the enrollment date, Graduation_Date specifies the graduation date.
An Academic_Status Of Graduated indicates that a student has graduated.
Which query should you use ?- ASELECT * FROM student
WHERE enrollment_date >= ‘2020-06-01’ OR academic_status =’graduated’ AND
graduation_date >= ‘2020-01-01’
ORDER BY enrollment_date DESC - BSELECT * FROM student
WHERE enrollment_date >= ‘2020-06-01’ AND academic_status =’graduated’ AND
graduation_date >= ‘2020-01-01’
ORDER BY enrollment_date ASC - CSELECT * FROM student
Where enrollment_date >= ‘2020-06-01’ AND academic_status =’graduated’ OR
graduation_date >= ‘2020-01-01’
ORDER BY enrollment_date - DSELECT * FROM student
WHERE enrollment_date >= ‘2020-06-01’ OR academic_status =’graduated’ OR
graduation_date >= ‘2020-01-01’
ORDER BY enrollment_date DESC
- ASELECT * FROM student
54The following table named Building stores data about building and their most recent inspection dates.
The address field stores the building’s address. The InspectionDate field stores the most recent inspection date. A
value of null in the InspectionDate field means that the building has not yet been inspected.
You need to display the address of the earliest 10 buildings that have been inspected.
Complete the query by moving the appropriate keywords from the list on the left to the correct locations on the
right. You may use each keyword once, more than once, or not at all.
SELECT [blank_start]1[blank_end] Address
FRM Building
WHERE InspectionDate [blank_start]2[blank_end]
[blank_start]3[blank_end] InspectionDate- ATOP 10
- BCOUNT
- CGROUP BY 10
- DIS NULL
- EHAVING
- FIS NOT NULL
- GORDER BY
55You have a table named Employee that includes the following columns: EmployeeID, Emp1oyeeName.
Which statement should you use to return the number of rows in the table?- ASELECT * FROM Employee
- BSELECT SUM(*) FROM Employee
- CSELECT COUNT (rows) FROM Employee
- DSELECT COUNT(*) FROM Employee
56The Product table contains the following data.
You execute the following statement:
SELECT COUNT(*)
FROM Product WHERE Quantity > 18
What is the value returned by this statement?
- A1
- B2
- C3
- D4
57The ItemsOnOrder table contains the following data.
You need to create a query that display the total number of orders, the average line item total, the highest line item
total, and the grand total of all items ordered. LineItemTotal represents the line item total.
Which query should you use?
- ASELECT COUNT (ID), AVG(LineItemTotal), MAX(LineItemTotal),
SUM(LineItemTotal)
FROM ItemsOnOrder
HAVING ItemNumber, Quantity, UnitPrice - BSELECT COUNT (ID), AVG(Unitprice+Quantity), MAX(UnitPrice+Quantity),
SUM(UnitPrice+Quantity)
FROM ItemOnOrder
GROUP By ItemNumber, LineItemTotal - CSELECT SUM(ID), AVG(LineItemTotal), MAX(LineItemTotal), SUM(LineItemTotal)
FROM ItemOnOrder - DSELECT COUNT(ID), AVG(LineItemTotal), MAX(LineItemTotal), SUM(LineItemTotal)
FROM ItemOnOrder
- ASELECT COUNT (ID), AVG(LineItemTotal), MAX(LineItemTotal),
58A table named PlayerStat contain following fields:
You need to display the total number of point per player on the team whose ID is 1.
Move the appropriate code segments from the list on the left to the correct locations on the right. You may use
each code segment once, more than once, or not at all.
Note : you will receive partial credit for each correct selection
SELECT PlayerID, [blank_start]1[blank_end]
FROM PlayerStat
[blank_start]2[blank_end] TeamID = 1
[blank_start]3 4[blank_end]
- ATeamID
- BSUM(Points)
- CCOUNT
- DWHERE
- EHAVING
- FGROUP BY
- GPlayerID
59Which SQL statement will return the country and number of orders in each country where the number of orders is
less than 50?
OrderID represent an individual order, Country represent the country, and Orders represents the number of orders.- ASELECT COUNT (OrderId), Country
FROM Orders
HAVING COUNT(OrderId) < 50;
GROUP BY Country - BSELECT Country, OrderId
FROM Orders
GROUP BY Country
WHERE COUNT(OrderId) < 50; - CSELECT COUNT (OrderId), Country
FROM Orders
GROUP BY Country
HAVING COUNT(OrderId) < 50; - DSELECT Country, OrderId
FROM Orders
WHERE Count(OrderId) < 50;
GROUP BY Country
- ASELECT COUNT (OrderId), Country
60You create the following query to determine whether Sample Movie appears only once in the Movie table.
SELECT Title
FROM Movie
WHERE Title = ‘Sample Movie’
ORDER BY Title
GROUP BY Title
HAVING COUNT(*) = 1
When you run this Query, if return a syntax error
You need to modify the query to run without error and return accurate result
What should you do?- ARemove the group by clause
- BChange the having clause to having count(title) = 1
- CRemove the order by clause
- DChange the having clause to having count(1) = 1
61What would you use to combine columns from two different tables?
- AAND
- BBETWEEN
- CJOIN
- DCOMBINE
62You’re the database admin for a university that stores student information in a table named student. This table has
a foreign key named courseID that links to the primary key in a table named courses.
You need to return the student name and course name using both tables where there is a match on courseID.
You execute the following query:
SELECT students.name, courses.name FROM students
OUTER JOIN courses WHERE student.courseID = courses.courseID
The query returns an error.
How should you correct the query?- ASELECT students.name, courses.name FROM students
INNER JOIN courses WHERE students.courseID = courses.courseID - BSELECT students.name, courses.name FROM students
INNER JOIN courses ON students.courseID = courses.coursesID - CSELECT students.name,courses.name FROM students
INNER JOIN ON students.courseID = courses.coursesID - DSELECT students.name, courses.name FROM students
INNER JOIN On courses
WHERE students.courseID = courses.courseID
- ASELECT students.name, courses.name FROM students
63You are working with three tables: Students, Courses, and Enrollments.
You need to return the student name, course name, and grade for each enrollment. Which SQL query correctly
retrieves this information?
- ASELECT s.FirstName, s.LastName, c.CourseName, e.Grade
FROM Students s
JOIN Enrollments e ON s.StudentID = e.StudentID
JOIN Courses c ON e.CourseID = c.CourseID; - BSELECT FirstName, LastName, CourseName, Grade
FROM Students
JOIN Courses ON Students.StudentID = Courses.CourseID
JOIN Enrollments ON Students.StudentID = Enrollments.CourseID; - CSELECT s.FirstName, s.LastName, c.CourseName, e.Grade
FROM Students s, Courses c, Enrollments e
WHERE s.StudentID = e.StudentID AND e.CourseID = c.CourseID; - DSELECT s.FirstName, c.CourseName, e.Grade
FROM Students s
JOIN Enrollments e ON s.StudentID = c.CourseID
JOIN Courses c ON e.CourseID = c.CourseID;
- ASELECT s.FirstName, s.LastName, c.CourseName, e.Grade
64You have two tables named Cars and Color as defined below. The two tables are related by ColorId.
You run the following SQL statement: select:
SELECT *
FROM Cars
LEFT OUTER JOIN Colors
ON Cars.ColorID = Colors. ColorID
- A0
- B2
- C3
- D6
65You 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 / Full join
66You execute the following statement:
SELECT EmployeeID, FirstName, DepartmentName
FROM Employee, Department;
This type of operation is called a/an:- AIntersection
- BOuter join
- CEqui-join
- DCartesian product
67The ____________ clause allows you to combine the results of any two or more queries into a resulting single set
that will include all the rows belonging to the query.- AUNION
- BINTERSECT
- CGROUP BY
- DWHERE
68Which clause used with the SELECT command will return values that you want to exclude from another query's result set?
- AEXCEPT
- BINTERSECT
- CSEARCH
- DEXCLUDE
69The SQL __________ operator takes the results of two queries and returns only rows that appear in both result sets.
- AUNION
- BINTERSECT
- CEXCEPT
- DJOIN
70You execute the following statement:
SELECT DepartmentName FROM Department
WHERE DepartmentID =
(SELECT DepartmentID
FROM Employee
WHERE EmployeeID = 1234)
This statement is an example of a/an:- ASubquery
- BUnion
- COuter join
- DCartesian product
71You work as a Database Administrator for ManufacturingDB.
The factory uses a system to track which machines are operated by which operators.
Each Machine can be operated by multiple operators across different shifts, and each Operator is qualified to
operate multiple machines depending on their skill set.
You need to model this relationship between Machine and Operator using MachineID and OperatorID.
OperatirID is a/an [blank_start]1[blank_end] in the Operator table.
MachineID is a/an [blank_start]2[blank_end] in the Machine table
OperatirID is a/an [blank_start]3[blank_end] in the Machine_Operator table.
MachineID is a/an [blank_start]4[blank_end] in the Machine_Machine table.
- Aindex
- Bunion
- Cforeign key
- Dprimary key
- Eprimary key
- Findex
- Gunion
- Hforeign key
- Iprimary key
- Jforeign key
- Kunion
- Lindex
- Mforeign key
- Nindex
- Oprimary key
- Punion
72You have a table that contains the following data.
Which database term is used to describe the relationship between ProductID and ProductCategory?
- ACohort
- BRelationally dependent
- CDeterministic
- DFunctionally dependent
- ECompositional
73Which are the reasons for normalizing data within a database? (Choose two)
- AReduce the number of tables in a database.
- BReduces dependencies on data.
- CReduces the size of a database.
- DReduces redundancies of data.
74You have a table that contains the following data.
This process is referred to as:
- Adefragmentation
- Bnormalization
- Cfragmentation
- Ddenormalization
75You need to normalized a database to first normal form.
Which two requirement must you meet? (Choose 2)- AExclude repeating groups
- BExclude foreign key
- CExclude composite key
- DExclude duplicate rows
76You work at a restaurant and they ask you to help them with a data issue.
They provide you with the following recipe data:
You need to normalize the data to third normal form.
How many tables should you create?
- A1
- B2
- C3
- D4
77You create the following table, which displays winners of past pet shows.
Pet Competition Winners
Which column prevents the table from being in third normal form?
- APetID
- BBirthdate
- CID
- DYear
78Denormalization is performed in order to:
- AReduce redundancy
- BEliminate repeating groups.
- CCreate smaller tables.
- DImprove query performance.
79This question requires that you evaluate the underlined text to determine if it is correct.
You combine data from three tables into one table. The new table includes redundancy to optimize read
performance.The data in the new table has been denormalized.
Instructions: 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
- BNormalized
- CTruncated
- DIndexed
80This question 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.
Instructions: 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
81You ate creating a database object named Student to store the following data:
Which syntax should you use to create the object?
- ACREATE TABLE Student (
ID INT,
Name VARCHAR(100),
Age INT ) - BCREATE (
TABLE Student ID INT,
Name VARCHAR(100),
Age INT ) - CCREATE Student ( ID INT,
Name VARCHAR(100),
Age INT ) - DCREATE TABLE ID INT,
Name VARCHAR(100),
Age IN
- ACREATE TABLE Student (
82Your class project involves helping a charity create a website to collect volunteer information. Each volunteer
must have a unique identifier. The stored data includes:
✑ Given name
✑ Surname
✑ Date of birth
✑ Phone number
✑ Photo
You need to design a table to meet these requirements. Match the provided SQL statements to the correct places
in the query. Each correct match earns one point.
CREATE TABLE [dbo].[Volunteer]
(
[Id] [blank_start]1[blank_end]
[GivenName] NCHAR(255) NULL,
[Surname] NCHAR(255) NULL,
[DateOfBirth] [blank_start]2[blank_end]
[PhoneNumber] NCHAR(10) NULL,
[Photo] [blank_start]3[blank_end]
)- AINT NOT NULL PRIMARY KEY,
- BTIME STAMP NULL,
- CXML NULL,
- DINT NOT NULL FOREIGN KEY,
- EDATE NULL,
- FIMAGE NULL,
83Which statement creates a composite key?
- ACREATE TABLE Order
(OrderID INTEGER PRIMARY KEY,
OrderItemID INTEGER PRIMARY KEY) - BCREATE TABLE Order
(OrderID INTEGER,
OrderItemID INTEGER,
PRIMARY KEY OrderID,
PRIMARY KEY OrderItemID) - CCREATE TABLE Order
(OrderID INTEGER,
OrderItemID INTEGER,
PRIMARY KEY) - DCREATE TABLE Order
(OrderID INTEGER,
OrderItemID INTEGER,
PRIMARY KEY(OrderID, OrderItemID))
- ACREATE TABLE Order
84You are developing SQL statement to create a table.
Which two SQL keywords are valid to use in a create table statement? (Choose 2)- AOrder By
- BPrimary Key
- CInsert Into
- DConstraint
85Which keyword can be used in a create table statement?
- AORDER BY
- BDISTINCT
- CGROUP BY
- DUNIQUE
86Which statement should you use to remove a foreign key
- AALTER TABLE
- BDELETE TABLE
- CDELETE FOREIGN KEY
- DALTER FOREIGN KEY
87A developer adds a BirthDate column with NOT NULL but gets an error:
ALTER TABLE Person ADD BirthDate date NOT NULL;
What caused it, and how can it be fixed? Select the correct SQL statement- AALTER TABLE Person
ADD BirthDate varchar(10) NOT NULL; - BALTER TABLE Person
ADD BirthDate date DEFAULT '1900-01-01' NOT NULL; - CALTER TABLE Person
ADD BirthDate int NOT NULL; - DALTER TABLE Person
ADD BirthDate date NULL;
- AALTER TABLE Person
88A developer adds a Prefix column with NOT NULL but encounters an error.
ALTER TABLE Person ADD Prefix varchar(4) NOT NULL;
What is the likely cause?- AThe Person table is empty
- BYou should run the DROP CONSTRAINT query before running the ALTER TABLE query
- CThe varchar(4) data types is invalid for the Person table.
- DThe DEFAULT keyword should be used to specify a default value.
89You have a table named Customer. You need to add a new column named District.
Which statement should you use?- AMODIFY TABLE Customer ADD (District INTEGER)
- BALTER TABLE Customer MODIFY (District INTEGER)
- CMODIFY TABLE Customer (District INTEGER)
- DALTER TABLE Customer ADD (District INTEGER)
90Your company stores customer social security numbers in a column named SSN in a table
named customer. New compliance laws prohibit your companyfrom storing this information.
Running the query below causes an error to occur.
ALTER TABLE Customers
REMOVE SSN;
What changes are needed to the query above so that it removes the SSN column from the customers table ?- AALTER TABLE Customers DELETE SSN;
- BALTER TABLE Customers DELETE COLUMN SSN;
- CALTER TABLE Customers DROP SSN;
- DALTER TABLE Customers DROP COLUMN SSN;
91This question requires that you evaluate the underlined text to determine if it is correct.
The CREATE TABLE command removes one or more table definitions and all data, indexes, triggers,
constraints, and permission specifications for those tables.
Instructions: 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
92What statement would you use to delete the Equipment table?
- ADELETE TABLE Equipment
- BDROP TABLE Equipment
- CREMOVE TABLE Equipment
- DTRUNCATE TABLE Equipment
93This question requires that you evaluate the underlined text to determine if it is correct.
DELETE TABLE removes all rows from a table without logging the individual row deletions.
Instructions: 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
- DREMOVE TABLE
- ECLEAR TABLE
94Which of the following is the language element allowing you to use statements, such as INSERT, UPDATE and
DELETE to manipulate the data in any SQL Server table?- ADML
- BDDE
- CDDL
- DDAT
95What are three valid data manipulation language (DML) commands? (Choose three.)
- AINSERT
- BCOMMIT
- CDELETE
- DOUTPUT
- EUPDATE
96In 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 definition.
97On which database structure does an insert statement operate?
- ARole
- BTrigger
- CUser
- DStored procedure
- ETable
98You need to add rows to a database table.
Which Structured Query Language (SQL) keyword should you use?- AJOIN
- BINSERT
- CCREATE
- DUPDATE
99You have the following table definition:
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 stating that NULL values are not allowed
- Ba new row in the table
- Can error stating that duplicate IDs are not allowed
- Da syntax error
100You have the following table definition:
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?- AINSERT INTO Product
VALUES (ProductID= 12345, Name = 'Plate') - BINSERT NEW ProductID = 12345, Name = 'Plate'
INTO Product - CINSERT 12345, 'Plate'
INTO Product - DINSERT INTO Product (ProductID, Name)
VALUES (12345, 'Plate')
- AINSERT INTO Product
101You need to insert two new products into the Product table. The first 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?- AINSERT INTO Product
VALUES (ID= 125, 126) (Name ='Book', 'Movie') - BINSERT INTO Product (ID, Name)
VALUES (125, 'Book')
INSERT INTO Product (ID, Name)
VALUES (126, 'Movie') - CINSERT 125, 126, 'Book', 'Movie'
INTO Product - DINSERT NEW ID = 125 AND 126, Name = 'Book' AND 'Movie'
INTO Product - EINSERT NEW ID = 125, Name = = 'Book'
INTO Product
INSERT NEW ID = 126, Name = 'Movie'
INTO Product
- AINSERT INTO Product
102You have a database table that contains the following columns:
Which two Structured Query Language (SQL) statements can you use? (Choose two.)
- AINSERT INTO AddressInfo ('1234 Main Street', 'Dallas', 'TX', '75201')
VALUES ([StreetAddress], [City], [State], [PostalCode]) - BINSERT INTO Address Info ([StreetAddress], [City], [State], [PostalCode])
VALUES ('1234 Main Street', 'Dallas', 'TX', '75201') - CINSERT INTO AddressInfo VALUES ('1234 Main Street', 'Dallas', 'TX', '75201')
- DUPDATE Address Info
SET [StreetAddress]='1234 Main Street', [City]='Dallas', [State]='TX', [PostalCode]='75201'
- AINSERT INTO AddressInfo ('1234 Main Street', 'Dallas', 'TX', '75201')
103You 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 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
104You need to populate a table named EmployeeCopy with data from an existing table named Employee.
Which statement should you use?- ASELECT * INTO EmployeeCopy
SELECT * FROM Employ - BINSERT *
FROM Employee
INTO EmployeeCopy - CCOPY INTO Employee
SELECT *
FROM Employee - DINSERT INTO EmployeeCopy
SELECT * FROM Employee
- ASELECT * INTO EmployeeCopy
105On which database structure does an update statement operate?
- ATable
- BUser
- CTrigger
- DRole
106You have a table that contains information about all students in your school.
Which SQL keyword should you use to change a student's first name in the table?- AUPDATE
- BCHANGE
- CSELECT
- DINSERT
107What statement would you use to change data in a table?
- ACHANGE
- BMODIFY
- CINSERT
- DUPDATE
108You have a table that contains product IDs and product names.
You need to write an UPDATE statement to change the name of a specific product to glass.
What should you include in the update statement?- ASET ProduetName = 'glass'
- BLET ProduetName = 'glass'
- CEXEC ProduetName = 'glass'
- DASSIGN ProduetName = 'glass'
109You have a table of products with fields for ProductID, Name, and Price.
You need to write an UPDATE statement that sets the value in the InStock field to Yes for a specific ProductID.
Which clause should you use in your update statement?- ATHAT
- BWHERE
- CGROUP BY
- DHAVING
110You create the following table, which lists how many books you have on loan to your friends.
Harry in San Francisco returns your books. Which statement will update your table correctly?
- AUPDATE LoanedBooks SET Books = 0 WHERE (Name = 'Harry' AND City = 'San Francisco')
- BUPDATE LoanedBooks SET Books = 0 WHERE (Name = 'Harry' OR City = 'San Francisco')
- CUPDATE LoanedBooks SET Books = 0 WHERE (Name in 'Harry', 'San Francisco')
- DINSERT INTO LoanedBooks SET Books = 0 WHERE ID =4
111You have a table named Product. The Product table has columns for ProductDescription and ProductCategory.
You need to change the ProductCategory value for all the spoons in the Product table to 43.
Which statement should you use?- AUPDATE Product
SET ProductCategory = 43
WHERE ProductDescription = 'spoon - BSET Product
WHERE ProductDescription = 'spoon'
TO ProductCategory = 43 - CUPDATE Product
WHERE ProductDescription = 'spoon'
SET ProductCategory = 43 - DSET Product
TO ProductCategory = 43
WHERE Product Description = 'spoon
- AUPDATE Product
112You 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:
When volunteer information changes, you must update the table.
You need to change Tia's name to Kimberly.
Which statement should you choose?
- ASET GivenName = 'Kimberly'
FROM Volunteer
WHERE GivenName = 'Tia' - BSET Volunteer
TO GivenName = 'Kimberly'
WHERE GivenName = 'Tia' - CUPDATE GivenName = 'Kimberly'
FROM Volunteer
WHERE GivenName = 'Tia' - DUPDATE Volunteer
SET GivenName = 'Kimberly'
WHERE GivenName = 'Tia'
- ASET GivenName = 'Kimberly'
113The products table contains the following data.
Which query will increase the price of item 1 by 6 percent ?
- AUSE Products
SET Price = Price * 1.06
WHERE ItemNumber = 1; - BSET Price = Price * 1.06
FROM Products
WHERE ItemNumber = 1; - CALTER Products
SET Price = Price * 1.06
WHERE ItemNumber = 1; - DUPDATE Products
SET Price = Price * 1.06
WHERE ItemNumber = 1;
- AUSE Products
114What statement is used to remove one or more record from a table?
- AREMOVE
- BTRUNCATE
- CDELETE
- DERASE
115What is one difference 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.
116You accept an IT internship at a local charity. The charity ask you to keep a record of its volunteers by using a database table named Volunteer. The table has the following columns and rows:
You must update the table when volunteers ask to be removed from mailing list
You need to delete all records with the GivenName Tia
Which SQL statement should you use ?
- ADELETE FROM Volunteer WHERE GivenName = = ‘Tia’
- BDELETE FROM Volunteer WHERE GivenName = ‘Tia’
- CDELETE FROM Volunteer WHERE GivenName EQUALS ‘Tia’
- DDELETE FROM Volunteer WHERE GivenName IS ‘Tia’
117Your 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?- AUPDATE Customer
DELETE *
WHERE CustomerID = 12345 - BDELETE CustomerID
FROM Customer
WHERE CustomerID = 12345 - CUPDATE CustomerID
FROM Customer
DELETE *
WHERE CustomerID = 12345 - DDELETE FROM Customer
WHERE CustomerID = 12345
- AUPDATE Customer
118Which statement deletes the rows where the employee's phone number is not entered?
- ADELETE FROM Employee
WHERE Phone IS NULL - BDELETE FROM Employee
WHERE Phone IS NOT NULL - CDELETE FROM Employee
WHERE Phone = '%' - DDELETE FROM Employee
WHERE Phone = NULLABLE
- ADELETE FROM Employee
119A database contains two tables named Customer and Order.
You execute the following statement:
DELETE FROM Order
WHERE CustomerID = 209
What is the result?- AThe first 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.
120You 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 definition will be deleted.
121You have a table named Product that contains one million rows. You need to search for product information in the Product table by using the product's unique ID. What will make this type of search more efficient?
- AA cursor
- BA subquery
- CA trigger
- DAn index
122You have a table named Product that contains one million rows. You need to search for product information in the
Product table by using the product's unique ID. What will make this type of search more efficient?- AA cursor
- BA subquery
- CA trigger
- DAn index
123You have the query that takes too much time to return data:
SELECT * FROM dbo.ProAthlete WHERE Salary > 500000
Which item should you add to the Salary column to improve query performance?- ANon-null constraint
- BDefault constraint
- CIndex
- DForeign key
124One reason to add an index is to:
- ADecrease storage space.
- BIncrease database security.
- CImprove performance of select statements.
- DImprove performance of insert statements.
125You create an index on a table that contains data. What is the result in the database?
- AMore rows are added to the indexed table
- BMore columns are added to the indexed table
- CA separate structure is created that contains the data from the indexed table
- DA separate structure is created that does not contain the data from the indexed table
126The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?
- AView
- BFunction
- CIndex
- DStored procedure
- ETrigger
127Use the dropdowns to identify each characteristic of index as clustered or non-clustered.
This type of index sorts data on the column in the table - [blank_start]1[blank_end]
The type of index stored data in a separate structure from the table being indexed. - [blank_start]2[blank_end]- AClustered
- BNon-clustered
128Which type of index changes the order in which the data is stored in a table?
- Anon-sequential
- Bsequential
- Cnon-clustered
- Dclustered
129You have a table product that contains one million row. You need to search for product
information using the following query :
SELECT ProductName, Price FROM Product WHERE Category = ‘ Science Books’
What will make this type of search more efficient?- AA clustered index on the ProductName column
- BA clusterd index on the Price column
- CA non-clustered index on the Category column
- DA non-clustered on the Price column
130You have the following table:
Instructions: Use the drop-down menus to select the answer choice that
completes each statement. Each correct selection is worth one point.
Adding a [blank_start]1[blank_end] on the FlightNumber colimn physically sorts
rows in the table by FlightNumber.
Adding a [blank_start]2[blank_end] on the Airline colimn retrieves data faster, but not
physically sorts rows in the table by Airline.
- Aforeign key
- Bclustered index
- Cnonclustered index
- Dforeign key
- Eclustered index
- Fnonclustered index
131Instructions: Use the drop-down menus to select the answer choice that completes each statement Each correct selection is worth one point.
A clustered index improves the performance of queries that [blank_start]1[blank_end].
A clustered index improves the performance of queries on columns that [blank_start]2[blank_end].- Areturn large result sets
- Breturn a range...by using the=operator
- Cdo not use ORDER BY or GROUP BY clauses
- Dare accessed randomly
- Eare accessed sequentially
- Farenot unique or containmany common valu
132Which statement creates an index?
- ACREATE TABLE Employee (EmployeeID INTEGER PRIMARY KEY)
- BCREATE TABLE Employee (EmployeeID INTEGER DISTINCT)
- CCREATE TABLE Employee (EmployeeID INTEGER NULL)
- DCREATE TABLE Employee (EmployeeID INTEGER INDEX)
133What is a view?
- AA virtual table created by a query joining one or more tables
- BA command to recover the content of a table.
- CA physical copy of a table
- DThe result of the execution of a query
134This question requires that you evaluate the underlined text to determine if it is correct.
A view can be used to ensure referential integrity.
Instructions: 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.
135You 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.
After you execute the statement, the result set of the view is:- AEmpty
- BDeleted
- CUnchanged
- DArchived
136Which keyword must be included in a create view statement?
- AWHERE
- BORDER BY
- CUPDATE
- DSELECT
137You need to set up a database to provide a view of endangered European birds (EndangeredEuropeanBirds_View).
Move the appropriate code segments from the list on the left to the correct locations on the right. You may use
each code segment once, more than once, or not at all.
[blank_start]1[blank_end]
[blank_start]2[blank_end]
[blank_start]3[blank_end]
WHERE b.Region = 'Europe'
AND b.Status = 'Endangered'- ACREATE VIEW [dbo].[EndangeredEuropeanBir
- BADD VIEW [dbo].[EndangeredEuropeanBirds_
- CFROM Birds b
- DJOIN Birds b
- EAS SELECT b.Id, b.Name, b.Status
- FSELECT b.Id, b.Name, b.Status
138You 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 left 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.
Select and Place:
[blank_start]1[blank_end]
[blank_start]2[blank_end]
[blank_start]3[blank_end]
WHERE a.Class = 'Mammals'
AND a.InNorthAmerica = 1- ACREATE VIEW [dbo].[NorthAmericanMammals_
- BGENERATE VIEW [dbo].[NorthAmericanMammal
- CAS JOIN a.Id, a.Name
- DJOIN Animal a
- EAS SELECT a.Id, a.Name
- FFROM Animal a
139What is the correct syntax for deleting a view?
- ADELETE VIEW view_name
- BREMOVE VIEW view_name
- CDROP VIEW view_name
- DALTER VIEW view_name
140You are tasked with creating a view in SQL that retrieves the Name column from the Games table and allows the
results to be ordered by Name.
Which of the following SQL statements accomplish this correctly?- ACREATE VIEW vw_Mygames As
SELECT Name From Games
ORDER BY Name - BCREATE VIEW vw_Mygames As
SELECT * FROM Games - CCREATE VIEW vw_Mygames As
SELECT TOP 100 PERCENT Name FROM Games
ORDER BY Name - DCREATE VIEW vw_Mygames As
SELECT * From Games
Where Name BETWEEN ‘A’ AND ‘Z’ - ECREATE VIEW vw_Mygames As SELECT Name FROM Games
SELECT Name FROM vw_Mygames ORDER BY Name;
- ACREATE VIEW vw_Mygames As
141You 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
142A named group of SQL statements that can be executed in a database is called a:
- ASubroutine
- BFormula
- CStored procedure
- DMethod
143One reason to create a stored procedure is to:
- AImprove performance.
- BMinimize storage space.
- CBypass case sensitivity requirements
- DGive the user control of the query logic.
144You develop a database to store data about textbooks. The data must be stored to process at a later time.
Which database object should you use to store the data?- AView
- BTable
- CFunction
- DStored procedure
145You write a series of SQL statements that perform a long, complex query. The statements then send the result in
an email. You want to be able to manually call the code any time you need to.
Which database object can you use to store the code ?- AStored procedure
- BFunction
- CTrigger
- DView
146Which permission does a user need in order to run a stored procedure?
- AEXECUTE
- BALLOW
- CCALL
- DRUN
147One difference between a function and a stored procedure is that a function:
- AMust be called from a trigger.
- BMust return a value.
- CCannot contain a transaction.
- DCannot accept parameters.
148Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each
correct selection is worth one point.- AYou can delete data by using a stored procedure. – YES / NO
- BA function must have a return value. – YES / NO
- CA stored procedure must have a return value. – YES / NO
149Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.
- AA SQL Server Login can use Windows Authentication.
- BA SQL Server Role provides permissions at the server level.
- CA SQL Server Login is granted permissions to database views only.
150You need to establish a set of permissions that you can routinely assign to new users. What should you create?
- AResource
- BGroup
- CList
- DRole
151You have a user that has server roles as defined below:
Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct
selection is worth one point.
The user can perform [blank_start]1[blank_end] actions on data that is on the server.
The user can perform [blank_start]2[blank_end] actions on database objects that are on the server.- Ano
- Bread-only
- Cunlimited
- Dno
- Eunlimited
- Fconfiguration
152What role gives full access to an individual database?
- Adb_owner
- Bdb_accessadmin
- Cdb_securityadmin
- Ddb_ddladmin
153You need to enable a new employee to authenticate to your database.
Which command should you use?- AALLOW USER
- BCREATE USER
- CADD USER
- DINSERT USER
- EALTER USER
154Use the __________ command to allow users to access objects within the database.
- AGRANT
- BDENY
- CPERMIT
- DALTER
155This question 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.
Instructions: 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
156You 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.
157You need to disable User1's access to view the data in the Customer table.
Which statement should you use?- AREMOVE User1 FROM Customer
- BREMOVE SELECT ON Customer FROM User1
- CREVOKE SELECT ON Customer FROM User1
- DREVOKE User1 FROM Customer
158In which situation do you need to perform a restore on a database?
- Awhen data becomes corrupted in the database
- Bwhen you need to roll back a transaction
- Cwhen you encounter an error in your application
- Dwhen data needs to be deleted from the database
159You have a database that contains 10 terabytes of data. You need to back up the database every two hours.
Which type of backup should you use?- Aarchive
- Bincremental
- Cpartial
- Dfull
160At 3:00 P.M. (15:00 hours), you create a backup of your database. At 4:00 P.M. (16:00 hours), you create a table
named Customer and import data into the table.
At 5:00 P.M. (17:00 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 unaffected.
- CThe Customer table exists but has no data.
- DThe script fails.
161Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each
correct selection is worth one point.
Description of Behavior:- AA full database backup is a copy of all of the data in the entire database.
- BA transaction log backup backs up all the data in the database
- CA differential backup copies only data that was changed before the last full backup.
- DA file or filegroup restore specifies a portion of the database to recover.
162The following graphic shows the components of a SQL Server application. You access the SQL Server
application through Internet Explorer.
Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct
selection is worth one point.
The [blank_start][answer choice][blank_end] computer is the first line of defense
against SQL injections and weak input validation.
The [blank_start][answer choice][blank_end] computer should be formatted with
NTFS to protect program, database, and log files from
unauthorized access.
- Aclient
- Bwww.contoso.com
- Cs01.contoso.com
- Dclient
- Ewww.contoso.com
- Fs01.contoso.com
163You delete rows in a table named Order. The corresponding rows in the OrderItem table are automatically
deleted. This process is an example of a/an:- AInherited delete
- BCascade delete
- CFunctional delete
- DWaterfall delete
- EDomino delete
164You work for a small auto trading company. You need to remove a car from the company database.
Information about the car is stored in the following tables.
All of the car’s parts are custom made, so they each have a row in every table. Cascading deletes are not enabled
but referential integrity is.
From which table must you first make your deletion?
- AMake
- BModel
- CEngine
- DModelEngine
165You 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 transaction to ensure that the database has data integrity and referential integrity.
Which statement should you use?- ABEGIN TRANSACTION VolunteerDelete;
DELETE FROM Volunteer WHERE Id = 13;
COMMIT TRANSACTION VolunteerDelete; - BWHILE TRANSACTION VolunteerDelete;
DELETE FROM Volunteer WHERE Id = 13;
CATCH TRANSACTION VolunteerDelete; - COPEN TRANSACTION VolunteerDelete;
DELETE FROM Volunteer WHERE Id = 13;
CLOSE TRANSACTION VolunteerDelete; - DBEGIN TRANSACTION VolunteerDelete;
DELETE FROM Volunteer WHERE Id = 13;
END TRANSACTION VolunteerDelete;
- ABEGIN TRANSACTION VolunteerDelete;
166You execute a statement inside a transaction to delete 100 rows from a table. The transaction fails after 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 transaction will restart.
- DNo rows will be deleted from the table.
167The following illustration shows backup strategies that use the simple recovery model and the full recovery model:
Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.
Using the simple recovery model for database backups provides [blank_start]1[blank_end] work-loss exposure than the full recovery model.
Using the simple recovery model for database backups provides [blank_start]2[blank_end] log file backups than the full
recovery model.
- Aless
- Bmore
- Cthe same
- Dless
- Emore
- Fthe same
Información
- Descripción
- Test sobre DATABASE ++++++ +, creado por taksist . el 25/07/2026.
- Autor
- taksist .
- Idioma
- English
- Visitas
- 997
- Valoración
- 5,0 de 5 · 3 valoraciones Valora este test