In ODL, you specify an operation using parentheses after its name.
Synchronization for pull replication is less disruptive and occurs only when needed by each site, not when a central master site thinks it is best to update.
Which of the following is not one of the stages in the evolution of distributed DBMS?
Information repositories are replacing data dictionaries in many organizations.
Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.
Data transformation includes which of the following?
The UNION clause is used to combine the output from multiple queries together into a single result table.
A supertype can only have only one subtype.
A database application can perform which of the following activities?
The basic data type char(n) is a _____ length character string and varchar(n) is _____ length character.
Which one of the following is used to define the structure of the relation ,deleting relations and relating schemas ?
Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.
A updatable view has its own data.
In a 1:1 relationship, the primary key placement is arbitrary.
To define what columns should be displayed in an SQL SELECT statement:
In OLE DB, a service provider:
Which of the following is not true about indexes?
Which SQL-92 standard SQL command can be used to change a table name?
SQL query and modification commands make up a(n) ________ .
The command to eliminate a table from a database is:
Total number of questions : 20
Number of answered questions : 0
Number of unanswered questions : 20
In ODL, you specify an operation using parentheses after its name.
Your Answer : (Not Answered)
Correct Answer : A
No answer description available for this question.
Synchronization for pull replication is less disruptive and occurs only when needed by each site, not when a central master site thinks it is best to update.
Your Answer : (Not Answered)
Correct Answer : A
No answer description available for this question.
Which of the following is not one of the stages in the evolution of distributed DBMS?
Your Answer : (Not Answered)
Correct Answer : A
No answer description available for this question.
Information repositories are replacing data dictionaries in many organizations.
Your Answer : (Not Answered)
Correct Answer : A
No answer description available for this question.
Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.
Your Answer : (Not Answered)
Correct Answer : B
No answer description available for this question.
Data transformation includes which of the following?
Your Answer : (Not Answered)
Correct Answer : A
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.
A supertype can only have only one subtype.
Your Answer : (Not Answered)
Correct Answer : B
No answer description available for this question.
A database application can perform which of the following activities?
Your Answer : (Not Answered)
Correct Answer : D
No answer description available for this question.
The basic data type char(n) is a _____ length character string and varchar(n) is _____ length character.
Your Answer : (Not Answered)
Correct Answer : C
Varchar changes its length accordingly whereas char has a specific length which has to be filled by either letters or spaces .
Which one of the following is used to define the structure of the relation ,deleting relations and relating schemas ?
Your Answer : (Not Answered)
Correct Answer : B
Data Definition language is the language which performs all the operation in defining structure of relation.
Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.
Your Answer : (Not Answered)
Correct Answer : B
No answer description available for this question.
A updatable view has its own data.
Your Answer : (Not Answered)
Correct Answer : B
No answer description available for this question.
In a 1:1 relationship, the primary key placement is arbitrary.
Your Answer : (Not Answered)
Correct Answer : A
No answer description available for this question.
To define what columns should be displayed in an SQL SELECT statement:
Your Answer : (Not Answered)
Correct Answer : A
No answer description available for this question.
In OLE DB, a service provider:
Your Answer : (Not Answered)
Correct Answer : D
No answer description available for this question.
Which of the following is not true about indexes?
Your Answer : (Not Answered)
Correct Answer : D
No answer description available for this question.
Which SQL-92 standard SQL command can be used to change a table name?
Your Answer : (Not Answered)
Correct Answer : D
No answer description available for this question.
SQL query and modification commands make up a(n) ________ .
Your Answer : (Not Answered)
Correct Answer : B
No answer description available for this question.
The command to eliminate a table from a database is:
Your Answer : (Not Answered)
Correct Answer : B
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