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
Tag: Computer Science MCQs
…………… 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