Tag: SQL
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!
Which of the command below undo the current transaction
ROLLBACK
Correct Answer!
COMMIT
SAVEPOINT
UNDO
Show Answer!
SQL is a language for
Relational database management system
Correct Answer!
Developing system programs
Business applications only
None of these
Show Answer!
DML stands for
Data Manipulation Language
Correct Answer!
Digital Manipulation Language
Discrete Manipulation Language
Data Modifying Language
Show Answer!
A database is said to be in 2nd Normal Form if:
It is in 1st normal form and each attribute that is not a primary key is dependent on the primary key
Correct Answer!
It...
Which of the following is not a valid aggregate function
COMPUTE
Correct Answer!
COUNT
SUM
MIN
Show Answer!