An atomic literal is which of the following?
Which of the following is the preferred way to recover a database after a system failure?
A star schema has what type of relationship between a dimension and fact table?
The UNION clause is used to combine the output from multiple queries together into a single result table.
Which of the following are integrity controls that a DBMS may support?
An enterprise key is a primary key whose value is unique for a given relation.
Total specialization is represented by double lines between the supertype and subtype on an EER.
Which is not a relevant feature of CASE tools?
Most operational databases can be used for many BI applications.
With SQL Server optimistic locking, an update lock is placed on the row when the row is read.
SERIALIZABLE is the strictest isolation level.
Cascading updates refers to child rows being automatically deleted when a parent row is deleted.
Which one of the following sorts rows in SQL?
An XML component that defines the structure of a document is known as a(n):
To drop a column that is used as a foreign key, first:
If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
When using the SQL INSERT statement:
Consider the join of a relation R with relation S. If R has m tuples and S has n tuples, then the maximum size of join is:
Long form of DBA is ______________.
Prior to 1970, all data was stored in separate files, which were mostly stored on reels of magnetic tape.
Total number of questions : 20
Number of answered questions : 0
Number of unanswered questions : 20
An atomic literal is which of the following?
Your Answer : (Not Answered)
Correct Answer : D
No answer description available for this question.
Which of the following is the preferred way to recover a database after a system failure?
Your Answer : (Not Answered)
Correct Answer : C
No answer description available for this question.
A star schema has what type of relationship between a dimension and fact table?
Your Answer : (Not Answered)
Correct Answer : C
No answer description available for this question.
The UNION clause is used to combine the output from multiple queries together into a single result table.
Your Answer : (Not Answered)
Correct Answer : A
No answer description available for this question.
Which of the following are integrity controls that a DBMS may support?
Your Answer : (Not Answered)
Correct Answer : D
No answer description available for this question.
An enterprise key is a primary key whose value is unique for a given relation.
Your Answer : (Not Answered)
Correct Answer : B
No answer description available for this question.
Total specialization is represented by double lines between the supertype and subtype on an EER.
Your Answer : (Not Answered)
Correct Answer : A
No answer description available for this question.
Which is not a relevant feature of CASE tools?
Your Answer : (Not Answered)
Correct Answer : D
No answer description available for this question.
Most operational databases can be used for many BI applications.
Your Answer : (Not Answered)
Correct Answer : B
No answer description available for this question.
With SQL Server optimistic locking, an update lock is placed on the row when the row is read.
Your Answer : (Not Answered)
Correct Answer : B
No answer description available for this question.
SERIALIZABLE is the strictest isolation level.
Your Answer : (Not Answered)
Correct Answer : A
No answer description available for this question.
Cascading updates refers to child rows being automatically deleted when a parent row is deleted.
Your Answer : (Not Answered)
Correct Answer : B
No answer description available for this question.
Which one of the following sorts rows in SQL?
Your Answer : (Not Answered)
Correct Answer : C
No answer description available for this question.
An XML component that defines the structure of a document is known as a(n):
Your Answer : (Not Answered)
Correct Answer : B
No answer description available for this question.
To drop a column that is used as a foreign key, first:
Your Answer : (Not Answered)
Correct Answer : C
No answer description available for this question.
If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
Your Answer : (Not Answered)
Correct Answer : A
No answer description available for this question.
When using the SQL INSERT statement:
Your Answer : (Not Answered)
Correct Answer : D
No answer description available for this question.
Consider the join of a relation R with relation S. If R has m tuples and S has n tuples, then the maximum size of join is:
Your Answer : (Not Answered)
Correct Answer : A
No answer description available for this question.
Long form of DBA is ______________.
Your Answer : (Not Answered)
Correct Answer : D
No answer description available for this question.
Prior to 1970, all data was stored in separate files, which were mostly stored on reels of magnetic tape.
Your Answer : (Not Answered)
Correct Answer : A
No answer description available for this question.
Total number of questions : 20
Number of answered questions : 0
Number of unanswered questions : 20
We'll write only best content for you