Question is ⇒ What mode of authentication does SQL Server NOT provide?, Options are ⇒ (A) Windows-only security, (B) Both SQL Server and Windows-only security, (C) Mixed security, (D) SQL Server only security, (E) , Leave your comments or Download question paper.

Question is ⇒ What mode of authentication does SQL Server NOT provide?, Options are ⇒ (A) Windows-only security, (B) Both SQL Server and Windows-only security, (C) Mixed security, (D) SQL Server only security, (E) , Leave your comments or Download question paper. Previous question Next question


Q1.	What mode of authentication does SQL Server NOT provide?
A.	Windows-only security [Wrong Answer]
B.	Both SQL Server and Windows-only security [Wrong Answer]
C.	Mixed security [Wrong Answer]
D.	SQL Server only security [Correct Answer]
View Answer 1 -1 Explanation:- Answer : D Discuss it below : !! OOPS Login [Click here] is required to post your answer/result Help other students, write article, leave your comments

Previous question Next question

Also Read Similar Questions Below :

⇒ Which of the following are the five built-in functions provided by SQL?
COUNT, SUM, AVG, MAX, MIN
SUM, AVG, MIN, MAX, MULT
SUM, AVG, MULT, DIV, MIN
SUM, AVG, MIN, MAX, NAME

⇒ Which JDBC driver Types are for use over communications networks?
Type 3 only
Type 4 only
Both Type 3 and Type 4
Neither Type 3 nor Type 4

⇒ What is an advantage of placing computations in SQL views?
To save users from having to write an expression.
To ensure that the results are consistent.
To accomplish both of the above.
None of the above is correct - computations cannot be placed in a view.

⇒ Which of the following do you need to consider when you make a table in SQL?
Data types
Primary keys
Default values
All of the above.

⇒ What is an SQL virtual table that is constructed from other tables?
Just another table
A view
A relation
Query results

⇒ SQL data definition commands make up a(n) ________ .
DDL
DML
HTML
XML

⇒ SQL Server automatically creates an index on:
primary keys only.
foreign key only.
both primary and foreign keys.
SQL Server never automatically creates an index.

⇒ What type of join is needed when you wish to include rows that do not have matching values?
Equi-join
Natural join
Outer join
All of the above.

⇒ To sort the results of a query use:
SORT BY.
GROUP BY.
ORDER BY.
None of the above is correct.

⇒ Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?
#
%
&
@

⇒ How many tables may be included with a join?
One
Two
Three
All of the above.

⇒ With this type of index, the data are stored in the bottom level of the index and in the same order as that index.
Nonclustered
Clustered
Primary
Secondary

⇒ The SQL statement to create a view is:
CREATE VIEW.
MAKE VIEW.
SELECT VIEW.
INSERT VIEW.

⇒ The Microsoft Access wildcards are ____ and ____ .
asterisk (*); percent sign (%)
percent sign (%); underscore (_)
underscore(_); question mark (?)
question mark (?); asterisk (*)

⇒ With which type of SQL Server recovery model are all database changes logged?
Differential recovery
Full recovery
Simple recovery
Bulk-logged recovery

⇒ What MySQL property is used to create a surrogate key in MySQL?
UNIQUE
SEQUENCE
AUTO_INCREMENT
None of the above -- Surrogate keys are not implemented in MySQL.

⇒ The DROP TABLE statement:
deletes the table structure only.
deletes the table structure along with the table data.
works whether or not referential integrity constraints would be violated.
is not an SQL statement.

⇒ The strictest transaction isolation level provided by SQL Server is called:
REPEATABLE READ.
SERIALIZABLE.
READ COMMITTED.
READ UNCOMMITTED.

⇒ What servlet processor was developed by Apache Foundation and Sun?
Apache Tomcat
Apache Web server
Sun servlet processor
None of the above is correct.

⇒ The SQL keyword BETWEEN is used:
for ranges.
to limit the columns displayed.
as a wildcard.
None of the above is correct.

⇒ A ________ is a program that performs some common action on database data and that is stored in the database.
trigger
stored procedure
pseudofile
None of the above is correct.

⇒ A subquery in an SQL SELECT statement is enclosed in:
braces -- {...}.
CAPITAL LETTERS.
parenthesis -- (...) .
brackets -- [...].

⇒ What is the full form of SQL?
Simple Query Language
Structured Query Language
Structured Query List
None of these

⇒ The command to remove rows from a table 'CUSTOMER' is:
REMOVE FROM CUSTOMER ...
DROP FROM CUSTOMER ...
DELETE FROM CUSTOMER WHERE ...
UPDATE FROM CUSTOMER ...

⇒ SQL Server program code that is executed after an SQL command has been processed is called a(n):
INSTEAD OF trigger.
BEFORE trigger.
AFTER trigger.
BEGIN trigger.

⇒ Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');
SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
SELECT NAME IN CUSTOMER WHERE STATE = 'V';
SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

⇒ A CASE SQL statement is which of the following?
A way to establish an IF-THEN-ELSE in SQL.
A way to establish a loop in SQL.
A way to establish a data definition in SQL.
All of the above.

⇒ Which of the three possible types of triggers does SQL Server support?
INSTEAD OF only
AFTER only
BEFORE only
INSTEAD OF and AFTER only

⇒ Which of the following is a way to create and modify tables using SQL Server?
Write SQL code using either CREATE or ALTER SQL statements only.
Use the graphical facilities of SQL Server Enterprise Manager only.
Both of the two methods above will work.
Neither of the two methods above will work.

⇒ What type of join is needed when you wish to return rows that do have matching values?
Equi-join
Natural join
Outer join
All of the above.