> > Database MCQs > SQL Server Database MCQs

SQL Server Database MCQ

A subquery can be coded in a where, from, select, or ______________ clause.

Join

Expansion

Fork

Select

Answer

Correct Answer: Select

Note: This Question is unanswered, help us to find answer for this one

A subquery is a/an ______________ statement thats coded within another sql statement.

Join

Expansion

Fork

SELECT

Answer

Correct Answer: SELECT

Note: This Question is unanswered, help us to find answer for this one

A subquery must include a(n) ____ clause.

SELECT

WHERE

FROM

Both a and b

Answer

Correct Answer: SELECT

Note: This Question is unanswered, help us to find answer for this one

In sql server, you can use the ____ function to obtain today?s date.

SYSDATE

GETDATE()

TODAYS_DATE

CURRENTDATE().

Answer

Correct Answer: GETDATE()

Note: This Question is unanswered, help us to find answer for this one

Only one ____ constraint can exist for each table.

PRIMARY KEY

FOREIGN KEY

USER_CONSTRAINTS

CONSTRAINT

Answer

Correct Answer: PRIMARY KEY

Note: This Question is unanswered, help us to find answer for this one

The ____ function is used to create a constant.

Define()

Min()

Abs()

Sqrt()

Answer

Correct Answer: Define()

Note: This Question is unanswered, help us to find answer for this one

The ____ data type stores only the actual character string.

CHAR

VARCHAR

TEXT

From

Answer

Correct Answer: VARCHAR

Note: This Question is unanswered, help us to find answer for this one

The ____ command is permanent.

SELECT

COMMIT

SAVE

UPDATE

Answer

Correct Answer: COMMIT

Note: This Question is unanswered, help us to find answer for this one

The ____ data type is used to store integers.

DISTINCT

DROP

INT

INSERT

Answer

Correct Answer: INT

Note: This Question is unanswered, help us to find answer for this one

When a script file contains more than one command, each command must end with a(n) ____.

Question mark.

Colon.

Period.

Semicolon

Answer

Correct Answer: Semicolon

Note: This Question is unanswered, help us to find answer for this one

A ____ procedure returns a single value to the calling procedure.

Function

Event handling

Property

Operator

Answer

Correct Answer: Function

Note: This Question is unanswered, help us to find answer for this one

In sql, table names cannot exceed ____ characters.

Answer

Correct Answer: 30

Note: This Question is unanswered, help us to find answer for this one

The privilege ____ can be granted to change the table structure.

WRITE

UPDATE

ALTER

MODIFY

Answer

Correct Answer: ALTER

Note: This Question is unanswered, help us to find answer for this one

The ____ is responsible for ensuring database security and integrity.

Database programmer

Systems analyst

Database security officer

Data administrator

Answer

Correct Answer: Database programmer

Note: This Question is unanswered, help us to find answer for this one

The sql command that lets you select attributes from rows in one or more tables is ____.

INSERT

SELECT

COMMIT

UPDATE

Answer

Correct Answer: SELECT

Note: This Question is unanswered, help us to find answer for this one

The sql command that lets you insert rows into a table is ____.

INSERT

SELECT

COMMIT

UPDATE

Answer

Correct Answer: INSERT

Note: This Question is unanswered, help us to find answer for this one

The sql command that allows a user to list the contents of a table is _____.

INSERT

SELECT

COMMIT

UPDATE

Answer

Correct Answer: SELECT

Note: This Question is unanswered, help us to find answer for this one

The sql character data format(s) is(are) ____.

CHAR and VARCHAR2.

VARCHAR2 only.

Alphanumeric.

CHAR only

Answer

Correct Answer: CHAR and VARCHAR2.

Note: This Question is unanswered, help us to find answer for this one

Any create command may be reversed by using a(n) ________ command.

Undo

Drop

Delete

Unpack

Answer

Correct Answer: Drop

Note: This Question is unanswered, help us to find answer for this one

An example of a command you would use when making changes to a product table is ____.

SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE, FROM PRODUCT, WHERE V_CODE <> 21344;

DELETE FROM PRODUCT, WHERE P_CODE = 'BRT-345';,

UPDATE PRODUCT, SET P_INDATE = '18-JAN-2004', WHERE P_CODE = '13-Q2/P2';

SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE, FROM PRODUCT, WHERE V_CODE = 21344

Answer

Correct Answer: UPDATE PRODUCT, SET P_INDATE = '18-JAN-2004', WHERE P_CODE = '13-Q2/P2';

Note: This Question is unanswered, help us to find answer for this one

A ________ is an in-memory copy of data read from database tables.

Data control

Dataset

Connection

Data adapter

Answer

Correct Answer: Dataset

Note: This Question is unanswered, help us to find answer for this one

________ is a set of commands used to update and query a database.

DML

DDL

DCL

DPL

Answer

Correct Answer: DML

Note: This Question is unanswered, help us to find answer for this one

________ is a set of commands used to control a database, which includes security.

DML

DDL

DCL

DPL

Answer

Correct Answer: DCL

Note: This Question is unanswered, help us to find answer for this one

__________ is a feature that is used for tracking the changes on a table.

Change Data Capture

Change table Capture

Change database Capture

Change schema Capture

Answer

Correct Answer: Change Data Capture

Note: This Question is unanswered, help us to find answer for this one

Which of the following statements is/are true for Plan freezing?

IntelliSense of SQL Server 2008 is ON by default

DML statements can also be used with IntelliSense

IntelliSense of SQL Server 2008 is OFF by default

IntelliSense of SQL Server 2008 is ON by default and DML statements can also be used with IntelliSense

Answer

Correct Answer: IntelliSense of SQL Server 2008 is ON by default and DML statements can also be used with IntelliSense

Note: This Question is unanswered, help us to find answer for this one

SQL Server 2000 always returns the result of a FOR XML query directly to the client in XML form.

False

True

Answer

Correct Answer: False

Note: This Question is unanswered, help us to find answer for this one

Which of the following statements is/are false for Plan freezing?

Helps to monitor schemas

Allows the DBAs to persist plan guides which helps when a query fails

None

Monitoring features for checking when the query is succeeded or failed

Answer

Correct Answer: Helps to monitor schemas

Note: This Question is unanswered, help us to find answer for this one

By default "FILLFACTOR" value is __________.

One

Zero

Five

Two

Answer

Correct Answer: Zero

Note: This Question is unanswered, help us to find answer for this one

Which join combines all rows from both tables?

Left Outer Join

Right Outer Join

Inner Join

Cross Join

Answer

Correct Answer: Cross Join

Note: This Question is unanswered, help us to find answer for this one

By default sql server has ___________ isolation level.

SERIALIZABLE

READ COMMITTED

REPEATABLE READ

READ UNCOMMITTED

Answer

Correct Answer: READ COMMITTED

Note: This Question is unanswered, help us to find answer for this one

Which of the following statements is/are false for Extended events in sql server 2008?

An architecture that is not very scalable, highly configurable.

None

Used for problem identification or problem trouble shooting.

Enhanced event handling system in SQL Server.

Answer

Correct Answer: An architecture that is not very scalable, highly configurable.

Note: This Question is unanswered, help us to find answer for this one

What is the default "SORT" order for a SQL?

Descending

Ascending

Answer

Correct Answer: Ascending

Note: This Question is unanswered, help us to find answer for this one

Which of the following DBCC command is used to see when was the last time the index rebuild?

DBCC SHOWCONFIG

DBCC SHOW_STATISTICS

DBCC DBREINDEX

Answer

Correct Answer: DBCC SHOW_STATISTICS

Note: This Question is unanswered, help us to find answer for this one

Difference between UNION and UNION ALL:

UNION returns only unique records from both tables. UNION ALL returns all records from both tables.

UNION ALL is no longer supported in sql server 2000 onward.

Both are similar

Answer

Correct Answer: UNION returns only unique records from both tables. UNION ALL returns all records from both tables.

Note: This Question is unanswered, help us to find answer for this one

Which statement is used to delete all rows in a table without having the action logged?

Drop table statement

Truncate table statement

Delete table statement

None

Answer

Correct Answer: Truncate table statement

Note: This Question is unanswered, help us to find answer for this one

Which of the following prevent "Dirty Reads"?

READ UNCOMMITTED

SERIALIZABLE

REPEATABLE READ

Read commited

Answer

Correct Answer: REPEATABLE READ

Note: This Question is unanswered, help us to find answer for this one

Which of the following statements is/are false for Declarative Management Framework (DMF) in sql server 2008?

A policy can be designed for allowing the usage of unauthorized applications.

SQL Server does not enforce to define the policies by using Management Studio.

SQL Server does not enforce to define the policies by using Management Studio and a policy can be designed for allowing the usage of unauthorized applications.

System for managing the instances of SQL Server 2008.

Answer

Correct Answer: SQL Server does not enforce to define the policies by using Management Studio and a policy can be designed for allowing the usage of unauthorized applications.

Note: This Question is unanswered, help us to find answer for this one