CS8492 - DATABASE MANAGEMENT SYSTEMS (UNIT 5)

UNIT 5 - ADVANCED TOPICS

15 flashcards · Computer Science · by Poongothai K

What is the purpose of the index in SQL server? A) To enhance the query B) To provide an index to a record C) To perform fast searches D) All of the mentioned
D) All of the mentioned
How many types of indexes are there in SQL server? A) 1 B) 2 C) 3 D) 4
B) 2
Which one of the following is the oldest database model? A) Relational B) Deductive C) Physical D) Network
D) Network
A __________ is a query that retrieves rows from more than one table or view.
Join
How many join types in join condition? A) 2 B) 3 C) 4 D) 5
D) 5
Which of the following is/are false for RAW mode of FOR XML? A) XMLSCHEMA option does not returns an in-line XSD schema B) BINARY BASE32 returns the binary data in base32-encoded format C) Each row in the query result is transformed into an XML element D) None of the mentioned
B) BINARY BASE32 returns the binary data in base32-encoded format
By default SQL server has _____________ isolation level.
READ COMMITTED
Which statement is used to define a cursor? A) OPEN B) FETCH C) DECLARE CURSOR D) @@ FETCH_STATUS
C) DECLARE CURSOR
A line of PL/SQL text contains groups of characters known as ___________
Lexical units
The storage structure which do not survive system crashes are _______________
Volatile storage
The process of saving information onto secondary storage devices is referred to as _______________
Writing
Which is essential a business problem not a data problem? A) Data B) Database C) Database design D) All of the mentioned
C) Database design
How many types of insertion anomalies? A) 1 B) 2 C) 3 D) 4
B) 2
___________ refers to a stalemate situation due to which no further progress is possible as computer await response of each other.
Deadlock
What are the ways of dealing with deadlock? A) Deadlock prevention B) Deadlock recovery C) Deadlock Detection D) All of the mentioned
D) All of the mentioned