Certiport exam questions with accurate
solutions
How many files does Microsoft SQL Server use to store database - Correct Answers -3
What is the sublanguage that allows the user to insert, delete, and update data in a
database - Correct Answers -DML
Which three are are T-SQL commands to handle privileges - Correct Answers -Grant,
Deny, Revoke
removes a SQL Server login account - Correct Answers -Drop Login
How do you called a stored procedure - Correct Answers -EXEC procedurename ([input
variables])
Join - Correct Answers -returns rows when there is at least one match in both tables
Left Join - Correct Answers -Returns all rows from the left table (table_name1), even if
there are no matches in the right table (table_name2 )
right join - Correct Answers -Returns all rows from the right table (table_name2), even if
there are no matches in the left table (table_name1 )
Full join - Correct Answers -returns rows when there is a match in one of the tables
What does SQL stand for - Correct Answers -Structured Query Language
What is the maximum data value that can be stored in a SMALLDATETIME datatype -
Correct Answers -June 6, 2079
What is a view - Correct Answers -A virtual table created by a query joining one or more
tables
The where clause allows you to - Correct Answers -Obtain a subset of rows
Consider a query of two tables. The result contains only the rows that have a match in
both tables. What kind of join was used - Correct Answers -Inner Join
What statement is used to retrieve data from a database - Correct Answers -Select
, The result of the query:
SELECT COUNT (*) from employees - Correct Answers -The number of rows in the
table employees
What is the result of the following query:
Select MAX(salary) from employee - Correct Answers -The maximum salary of all
employees.
what does the following statement do
SELECT DATEADD (DD, 0, DATEDIFF(DD, 0, GETDATE())); - Correct Answers -
Return just the date part of the current system date removing the time.
How many levels of normal forms are there - Correct Answers -5
what determines a database in the third normal form. - Correct Answers -Every non-
prime attribute is non-transitively dependent on every candidate key in the table
Sql code injection - Correct Answers -A technique that exploits security vulnerabilities in
the db layer of an application
Members of what fixed database role cannot add, modify, or delete any data in the
tables within a database, regardless of other roles. - Correct Answers -
db_denydatawriter
Which of the following fixed server roles can shut down the SQL server - Correct
Answers -Serveradmin
Three types of databases - Correct Answers -Relational, Hierarchical, Flat File
Allows you to use the statements INSERT, UPDATE, DELETE, and MERGE to
manipulate data in any SQL Server tables - Correct Answers -DML
A subset of the Transact-SQL language. - Correct Answers -DDL
Microsoft's proprietary extension to SQL - Correct Answers -T-SQL
The four basic functions of persistent storage - Correct Answers -CRUD
______can create, alter, drop, and restore databases - Correct Answers -Dbcreator
An ____ initiates an action when an event (INSERT, DELETE or UPDATE) occurs -
Correct Answers -Trigger
SQL statements that are grouped, named, and executed together are called a/an -
Correct Answers -Stored procedure
solutions
How many files does Microsoft SQL Server use to store database - Correct Answers -3
What is the sublanguage that allows the user to insert, delete, and update data in a
database - Correct Answers -DML
Which three are are T-SQL commands to handle privileges - Correct Answers -Grant,
Deny, Revoke
removes a SQL Server login account - Correct Answers -Drop Login
How do you called a stored procedure - Correct Answers -EXEC procedurename ([input
variables])
Join - Correct Answers -returns rows when there is at least one match in both tables
Left Join - Correct Answers -Returns all rows from the left table (table_name1), even if
there are no matches in the right table (table_name2 )
right join - Correct Answers -Returns all rows from the right table (table_name2), even if
there are no matches in the left table (table_name1 )
Full join - Correct Answers -returns rows when there is a match in one of the tables
What does SQL stand for - Correct Answers -Structured Query Language
What is the maximum data value that can be stored in a SMALLDATETIME datatype -
Correct Answers -June 6, 2079
What is a view - Correct Answers -A virtual table created by a query joining one or more
tables
The where clause allows you to - Correct Answers -Obtain a subset of rows
Consider a query of two tables. The result contains only the rows that have a match in
both tables. What kind of join was used - Correct Answers -Inner Join
What statement is used to retrieve data from a database - Correct Answers -Select
, The result of the query:
SELECT COUNT (*) from employees - Correct Answers -The number of rows in the
table employees
What is the result of the following query:
Select MAX(salary) from employee - Correct Answers -The maximum salary of all
employees.
what does the following statement do
SELECT DATEADD (DD, 0, DATEDIFF(DD, 0, GETDATE())); - Correct Answers -
Return just the date part of the current system date removing the time.
How many levels of normal forms are there - Correct Answers -5
what determines a database in the third normal form. - Correct Answers -Every non-
prime attribute is non-transitively dependent on every candidate key in the table
Sql code injection - Correct Answers -A technique that exploits security vulnerabilities in
the db layer of an application
Members of what fixed database role cannot add, modify, or delete any data in the
tables within a database, regardless of other roles. - Correct Answers -
db_denydatawriter
Which of the following fixed server roles can shut down the SQL server - Correct
Answers -Serveradmin
Three types of databases - Correct Answers -Relational, Hierarchical, Flat File
Allows you to use the statements INSERT, UPDATE, DELETE, and MERGE to
manipulate data in any SQL Server tables - Correct Answers -DML
A subset of the Transact-SQL language. - Correct Answers -DDL
Microsoft's proprietary extension to SQL - Correct Answers -T-SQL
The four basic functions of persistent storage - Correct Answers -CRUD
______can create, alter, drop, and restore databases - Correct Answers -Dbcreator
An ____ initiates an action when an event (INSERT, DELETE or UPDATE) occurs -
Correct Answers -Trigger
SQL statements that are grouped, named, and executed together are called a/an -
Correct Answers -Stored procedure
