Database Entrance Exams Online Exam Quiz
Database Entrance Exams GK Quiz. Question and Answers related to Database Entrance Exams. MCQ (Multiple Choice Questions with answers about Database Entrance Exams
Which of the following pair of regular expression are not equivalent?
Options
A : 1(01)* and (10)*1
B : x(xx)* and (xx)*x
C : (ab)* and a*b*
D : x+ and x*x+
Which utilities can we use to export data from sql server to a text file?
Options
A : DTS export wizard
B : BCP
C : ISQL
D : DTS export wizard and BCP
___________ refers to the ability of the system to recover committed transaction updates if either the system or the storage media fails.
Options
A : Isolation
B : Atomicity
C : Consistency
D : Durability
You have a column that will only contain values from 0 to 256. What is the most economical data type to use for the column?
Options
A : TINYINT
B : SMALLINT
C : INT
D : DECIMAL(1)
Which of the following is/are false for RAW mode of FOR XML?
Options
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
Chemical Engineering Basics - Part 1 more Online Exam Quiz
Cpp Programming Uncaught Exceptions