The ………………… is essentially used to search for patterns in target string.

The ………………… is essentially used to search for patterns in target string.
Like Predicate
Well Done. Your Answer is Correct Keep it Up!
Null Predicate
In Predicate
Out Predicate

…………… joins are SQL server default

…………… joins are SQL server default
Inner
Well Done. Your Answer is Correct Keep it Up!
Outer
Equi
None of the Option is Correct

Drop Table cannot be used to drop a table referenced by a …………… constraint.

Drop Table cannot be used to drop a table referenced by a …………… constraint.
Foreign Key
Well Done. Your Answer is Correct Keep it Up!
Composite Key
Primary Key
Local Key

To delete a database ………………. command is used

To delete a database ………………. command is used
drop database database_name
Well Done. Your Answer is Correct Keep it Up!
Delete database_name
delete database database_name
drop database_name

HSAM stands for ……….

HSAM stands for ……….
Hierarchic Sequential Access Method
Well Done. Your Answer is Correct Keep it Up!
Hierarchic Standard Access Method
Hierarchic Sequential and Method
Hierarchic Standard and Method

Is a utility to capture a continuous record of server activity and provide auditing capability.

Is a utility to capture a continuous record of server activity and provide auditing capability.
SQL server service manager
Well Done. Your Answer is Correct Keep it Up!
SQL server Profile
SQL server setup
SQL server wizard

Approach reduces time and effort required for design and lesser risk in database management.

Approach reduces time and effort required for design and lesser risk in database management.
Multiple databases
Well Done. Your Answer is Correct Keep it Up!
Top-down approach
Single global database
None of the Option is Correct

Contains data assisting day to day activities of the organization.

Contains data assisting day to day activities of the organization.
Operational database
Well Done. Your Answer is Correct Keep it Up!
Control database
Strategic database
Sequential database

SQL server stores index information in the ………… system table

SQL server stores index information in the ………… system table
sys indexes
Well Done. Your Answer is Correct Keep it Up!
sysind
system indexes
syst indexes

…………………….. are designed to overcome any limitations placed on the warehouse by the nature of the relational data model.

…………………….. are designed to overcome any limitations placed on the warehouse by the nature of the relational data model.
operational database
Well Done. Your Answer is Correct Keep it Up!
relational database
multidimensional database
None of the Option is Correct
Page 1 of 22
1 2 3 22