Question is ⇒ With which type of SQL Server recovery model are all database changes logged?, Options are ⇒ (A) Differential recovery, (B) Full recovery, (C) Simple recovery, (D) Bulk-logged recovery, (E) , Leave your comments or Download question paper.

Question is ⇒ With which type of SQL Server recovery model are all database changes logged?, Options are ⇒ (A) Differential recovery, (B) Full recovery, (C) Simple recovery, (D) Bulk-logged recovery, (E) , Leave your comments or Download question paper. Previous question Next question


Q1.	With which type of SQL Server recovery model are all database changes logged?
A.	Differential recovery [Wrong Answer]
B.	Full recovery [Correct Answer]
C.	Simple recovery [Wrong Answer]
D.	Bulk-logged recovery [Wrong Answer]
View Answer 1 -1 Explanation:- Answer : B 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 :

⇒ ________ is an open source DBMS product that runs on UNIX, Linux and Windows.
MySQL
JSP/SQL
JDBC/SQL
Sun ACCESS

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

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

⇒ A reason for using an SQL view to hide columns is:
to simplify a result only.
to prevent the display of sensitive data only.
to accomplish both of the above.
None of the above are reasons for using an SQL view.

⇒ JDBC stands for:
Java Database Connectivity
Java Database Components
Java Database Control
None of the above is correct.

⇒ What is not an advantage of stored procedures?
Greater security
SQL can be optimized
Code sharing
Increased network traffic

⇒ Which of the following is valid SQL for an Index?
CREATE INDEX ID;
CHANGE INDEX ID;
ADD INDEX ID;
REMOVE INDEX ID;

⇒ What is bytecode?
Machine-specific code
Java code
Machine-independent code
None of the above is correct.

⇒ SQL query and modification commands make up a(n) ________ .
DDL
DML
HTML
XML

⇒ Which of the following statements is true concerning routines and triggers?
Both consist of procedural code.
Both have to be called to operate.
Both run automatically.
Both are stored in the database.

⇒ SQL can be used to:
create database structures only.
query database data only.
modify database data only.
All of the above can be done by SQL.

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

⇒ The SQL WHERE clause:
limits the column data that are returned.
limits the row data are returned.
Both A and B are correct.
Neither A nor B are correct.

⇒ Which one of the following sorts rows in SQL?
SORT BY
ALIGN BY
ORDER BY
GROUP BY

⇒ An SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called:
COBOL.
VB.NET.
TRANSACT SQL.
Visual Basic.

⇒ The SQL command to create a table is:
MAKE TABLE.
ALTER TABLE.
DEFINE TABLE.
CREATE TABLE.

⇒ A ________ is a stored program that is attached to a table or a view.
pseudofile
embedded SELECT statement
trigger
None of the above is correct.

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

⇒ The SQL ALTER statement can be used to:
change the table structure.
change the table data.
add rows to the table.
delete rows from the table.

⇒ 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

⇒ ON UPDATE CASCADE ensures which of the following?
Normalization
Data Integrity
Materialized Views
All of the above.

⇒ The benefits of a standard relational language include which of the following?
Reduced training costs
Increased dependence on a single vendor
Applications are not needed.
All of the above.

⇒ Which of the following is not a factor in determining the concurrency control behavior of SQL Server?
Lock level
Transaction isolation level
Cursor concurrency setting
Locking hints

⇒ The SQL statement that queries or reads data from a table is ________ .
SELECT
READ
QUERY
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.

⇒ With which type of SQL Server recovery model, is no logging done?
Differential recovery
Full recovery
Bulk-logged recovery
Simple recovery

⇒ A view is which of the following?
A virtual table that can be accessed via SQL commands
A virtual table that cannot be accessed via SQL commands
A base table that can be accessed via SQL commands
A base table that cannot be accessed via SQL commands

⇒ 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 automatically creates an index on:
primary keys only.
foreign key only.
both primary and foreign keys.
SQL Server never automatically creates an index.

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