Explore topic-wise MCQs in Cadence.

This section includes 32 Mcqs, each offering curated multiple-choice questions to sharpen your Cadence knowledge and support exam preparation. Choose a topic below to get started.

1.

Difference between UNION and UNION ALL.

A. Both are similar
B. UNION ALL is no longer supported in sql server 2000 onward
C. UNION returns only unique records from both tables. UNION ALL returns all records from both tables
Answer» D.
Discussion
2.

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

A. System for managing the instances of SQL Server 2008
B. SQL Server does not enforce to define the policies by using Management Studio
C. Both b and d
D. A policy can be designed for allowing the usage of unauthorized applications
Answer» D. A policy can be designed for allowing the usage of unauthorized applications
Discussion
3.

______________ helps to restore the database to the point where it failed.

A. File backup
B. Differential Backups
C. File log
D. Transaction log
Answer» E.
Discussion
4.

Embedded spaces or special characters are not allowed in SQL server identifiers

A. True
B. False
Answer» B. False
Discussion
5.

 Which statement should you execute when you do not want to rollback your data?

A. Delete
B. Truncate
Answer» C.
Discussion
6.

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

A. DBCC SHOW_STATISTICS
B. DBCC SHOWCONFIG
C. DBCC DBREINDEX
Answer» B. DBCC SHOWCONFIG
Discussion
7.

Which of the following connection type supports application role permissions and password encryption?

A. OLE DB
B. DBLib
C. ODBC
D. OLE DB and ODBC
Answer» E.
Discussion
8.

Which of the following below are Compound Operators in sql server 2008

A. +=
B. %=
C. *=
D. all of above
Answer» E.
Discussion
9.

_____________ Allows you to provide the full path to a template.

A. Trace file name
B. Trace file path
C. Template name
D. Trace name
Answer» B. Trace file path
Discussion
10.

Which of the following commands below are used to run a stored procedure?

A. EXEC MyStoredProcedure
B. EXECUTE MyStoredProcedure
C. RUN MyStoredProcedure
D. Both a and b above
Answer» E.
Discussion
11.

Which of the below is the correct syntax for a VIEW?

A. Both b and d below
B. CREATE VIEW ViewName AS INSERT ...
C. CREATE VIEW ViewName AS UPDATE ...
D. CREATE VIEW ViewName AS SELECT ...
Answer» E.
Discussion
12.

The SQL Query Analyzer is the main interface for running SQL queries against your database

A. True
B. False
Answer» B. False
Discussion
13.

By default "FILLFACTOR" value is

A. Zero
B. One
C. Two
D. Five
Answer» B. One
Discussion
14.

Choose the incorrect option about the sql server index

A. Two types of indexes - clustered indexes and non-clustered indexes
B. Both types use B-TREE for searching data
C. Only one clustered index on a table
D. More than one clustered index on a table
Answer» E.
Discussion
15.

Which of the following is not correct for DELETE and TRUNCATE?

A. DELETE table can be rolled back
B. TRUNCATE table cannot have triggers
C. TRUNCATE table can have criteria
D. DELETE table can have criteria
Answer» D. DELETE table can have criteria
Discussion
16.

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

A. Ascending
B. Descending
Answer» B. Descending
Discussion
17.

How inserting data through stored procedure do reduces network traffic and increase database performance?

A. Stored procedure can accept parameter
B. Permission check is not required
C. The execution plan is stored in the cache after it was executed the first time.
Answer» D.
Discussion
18.

Which utilities can we used to export data from sql server to a text file?

A. DTS export wizard
B. BCP
C. ISQL
D. and b
Answer» E.
Discussion
19.

Which statement is correct from partitioned view?

A. We cannot create an indexed view on a partitioned view
B. We can create an indexed view on a partitioned view as long as the index is clustered
C. We can create an indexed view on a partitioned view
Answer» D.
Discussion
20.

Which of the following statement is used to make sql server resize the database file to its smallest possible size?

A. DBCC SHRINKFILE
B. DBCC SHRINKDB
C. DBCC SQLPERF SHRINKDB
Answer» B. DBCC SHRINKDB
Discussion
21.

Dynamic Page Repair is a type of database mirroring.

A. False
B. True
Answer» B. True
Discussion
22.

____________ helps to restore the database to the point where it failed.

A. File backup
B. Differential Backups
C. File log
D. Transaction log
Answer» E.
Discussion
23.

 Embedded spaces or special characters are not allowed in SQL server identifiers

A. True
B. False
Answer» B. False
Discussion
24.

The identifers in SQL can have a character range from?

A. 1 to 100
B. 1 to 128
C. 1 to 64
D. 1 to 132
Answer» C. 1 to 64
Discussion
25.

Which join combines all rows from both tables?

A. Inner Join
B. Left Outer Join
C. Right Outer Join
D. Cross Join
Answer» E.
Discussion
26.

Which of the following prevent "Dirty Reads"?

A. Read commited
B. Read Uncommitted
C. Repeatable Read
D. Serializable
Answer» D. Serializable
Discussion
27.

Which of the following is the default isolation level in SQL Server?

A. Read Committed
B. Read Uncommitted
C. Repeatable Read
D. Serializable
Answer» B. Read Uncommitted
Discussion
28.

Which statement should you execute when you do not want to rollback your data?

A. Delete
B. Truncate
Answer» C.
Discussion
29.

When SET SHOWPLAN_ALL is ON, SQL Server returns execution information for each statement without executing it.

A. True
B. False
Answer» B. False
Discussion
30.

__________________repeatedly sent from the client each time they run are compiled and optimized every time they are executed by SQL Server.

A. Transact-SQL statements
B. Stored Procedures
Answer» B. Stored Procedures
Discussion
31.

Which one of the following can not have error-handling (e.g. RAISERROR)?

A. User-Defined Functions
B. Stored Procedures
C. Trigger
Answer» B. Stored Procedures
Discussion
32.

Default is a type of constraint although it does not really enforce anything

A. Yes
B. No
Answer» B. No
Discussion