Eminem’s 8 Mile is named after a road in which city?
Detroit
Correct Answer!
Manhattan
New York
Michigan
Show Answer!
Where is OnePlus Nizam Palace located?
Hyderabad
Correct Answer!
Bangalore
Delhi
Mumbai
Show Answer!
Which of the following is the correct SQL statement to use to remove rows from a table?
DELETE
Correct Answer!
DROP
REMOVE
All of the options
Show Answer!
What will be the output of the following statement? SELECT ROUND(123.89, -1)
120.00
Correct Answer!
123.00
124.00
123.90
Show Answer!
With _ locking a user may have to redo their work when a conflict occurs
optimistic
Correct Answer!
deterministic
pessimistic
Show Answer!
Which of the following commands denote DML commands
INSERT
Correct Answer!
CREATE
ALTER
All of these
Show Answer!
What is the different between Truncate and Delete ?
Truncate deletes all items and delete only deletes each row
Correct Answer!
Truncate resizes the data page of a table and delete performs operations...
To remove duplicate rows from the result set of a select use the following keyword(s):
DISTINCT
Correct Answer!
NO DUPLICATES
UNIQUE
None of these
Show Answer!
Which is not included in an ACID model of a Database
Consistency
Connectivity
Correct Answer!
Atomicity
Isolation
Durability
Show Answer!
Which one of the following trigger is run before the DML ?
INSTEADOF
Correct Answer!
INSERT
UPDATE
AFTER
Show Answer!
View text definitions are stored in which system table?
syscomments
Correct Answer!
sysobjects
syscolumns
sysviews
Show Answer!
Which of the following cannot be done by a SQL profiler?
Users monitoring
Batch Execution
Correct Answer!
To find the Stored procedures triggered
Error tracking
Performance monitoring
Show Answer!