For relation R where primary key contains multiple attributes,no non-key attribute should be functionally dependent on a part of the primary key. This relation R is at least inA． 1NFB．2NFC．3NFD．BCNF
题目
For relation R where primary key contains multiple attributes,no non-key attribute should be functionally dependent on a part of the primary key. This relation R is at least in
A． 1NF
B．2NF
C．3NF
D．BCNF
相似考题
更多“For relation R where primary key contains multiple attributes,no non-key attribute should be functionally dependent on a part of the primary key. This relation R is at least inA． 1NFB．2NFC．3NFD．BCNF”相关问题
-
第1题：
Which of the following conditions will make a relation that is in first normal form. to be in second normal form?
Ⅰ.every non-key attribute is functionally dependent on the full set of primary key attributes.
Ⅱ.no non-key attributes exist in the relation.
Ⅲ.the primary key consists of only one attribute.
A．Ⅰ only
B．Ⅰ and Ⅱ only
C．Ⅰ and Ⅲ only
D．any of them
正确答案：D
-
第2题：
Let R and S be the relation respectively: Relation R: A B C Relation S: B C D 1 2 3 2 3 4 6 7 8 2 3 5 The number of tuplesthat the result of the expression R ∞ S (Here is the natural join of relations R and S) is
A．3
B．4
C．6
D．9
正确答案：B
-
第3题：
Let R and S be the relation respectively: Relation R:A B C Relation S:B C D 1 2 3 2 3 4 6 7 8 2 3 5 9 7 8 7 8 1 The number of tuples that the result of the expression R ∞ S( Here is the natural join of relations R and S)is(69).
A．1
B．4
C．7
D．10
正确答案：B
解析：译文：关系R和S分别是R：ABC，关系S：BCD。表达式R∞S(这里是R、S的自然连接)的结果的元组个数为4。 -
第4题：
Acandidate key is().A.an attribute or a set of attributes with a unique value for each tuple of a relation
B.a set of attributes referring to another relation in the database
C.an attribute or a set of attributes that is potentially the primary key of a relation
D.an attribute or a set of attributes that is potentially(有潜力地)the super key(超键)of a relation
答案C -
第5题：
Which values are NOT permitted to be part of the primary key?
A．alpha-numeric characters
B．punctuation
C．special characters
D．NULL
正确答案：D
-
第6题：
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named named Dworks in the instance. The Dworks table has a table named BillDetails which has a clustered primary key named BillId on the BillId column. The BillDetails table has a single XML column named GoodsDetails. The XML column has an XML index and XML data are stored in this XML column. A new column named GoodsID is added to the BillDetails table. GoodsID must be included in the primary key. So what action should you perform to achieve this goal？（）
- A、You should drop the XML index on the table. Modify the primary key. Recreate the XML index
- B、You should alter the XML index and set the ALLOW_ROW_LOCKS = OFF option. Alter the primary key and set the ALLOW_ROW_LOCKS = ON option.
- C、You should move the XML data to a temporary table. Clear the XML data from the original table by setting the GoodsDetails column to NULL. Modify the primary key. Repopulate the ProductSpecs column.
- D、You should disable the XML index on the GoodsDetails column. Modify the primary key.Enable the XML index on the ProductSpecs column.
正确答案:A -
第7题：
Which two statements are true about the primary key constraint in a table？ （）
- A、It is not possible to disable the primary key constraint.
- B、It is possible to have more than one primary key constraint in a single table.
- C、The primary key constraint can be referred by only one foreign key constraint.
- D、The primary key constraint can be imposed by combining more than one column.
- E、The non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.
正确答案:D,E -
第8题：
Where can you add your own PL/SQL code in relation-handling triggers?（）
- A、Before the "End default relation program section" comment.
- B、After the "Begin default relation program section" comment.
- C、Before the "Begin default relation program section" comment.
- D、It is not possible to modify the relation-handling code that Forms automatically creates for relations.
正确答案:C -
第9题：
Which statements are correct regarding indexes？ （）
- A、 When a table is dropped， the corresponding indexes are automatically dropped.
- B、 For each DML operation performed， the corresponding indexes are automatically updated.
- C、 Indexes should be created on columns that are frequently referenced as part of an expression.
- D、 A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a uniqueindex.
正确答案:A,B,D -
第10题：
单选题You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?（）AALTER TABLE students ADD PRIMARY KEY _ id;
BALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);
CALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;
DALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
EALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
正确答案： D解析： 暂无解析 -
第11题：
多选题Which two statements are true about the primary key constraint in a table？ （）AIt is not possible to disable the primary key constraint.
BIt is possible to have more than one primary key constraint in a single table.
CThe primary key constraint can be referred by only one foreign key constraint.
DThe primary key constraint can be imposed by combining more than one column.
EThe non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.
正确答案： D,B解析： 暂无解析 -
第12题：
单选题When defining a referential constraint between the parent table T2 and the dependent table T1, which of the following is true?（）AThe list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.
BThe list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.
CThe list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.
DThe list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.
正确答案： A解析： 暂无解析 -
第13题：
5 (a) Compare and contrast the responsibilities of management, and of auditors, in relation to the assessment of
going concern. You should include a description of the procedures used in this assessment where relevant.
(7 marks)
正确答案：
5 Dexter Co
(a) Responsibilities of management and auditors
Responsibilities
ISA 570 Going Concern provides a clear framework for the assessment of the going concern status of an entity, and
differentiates between the responsibilities of management and of auditors. Management should assess going concern in order
to decide on the most appropriate basis for the preparation of the financial statements. IAS 1 Presentation of Financial
Statements (revised) requires that where there is significant doubt over an entity’s ability to continue as a going concern, the
uncertainties should be disclosed in a note to the financial statements. Where the directors intend to cease trading, or have
no realistic alternative but to do so, the financial statements should be prepared on a ‘break up’ basis.
Thus the main focus of the management’s assessment of going concern is to ensure that relevant disclosures are made where
necessary, and that the correct basis of preparation is used.
The auditor’s responsibility is to consider the appropriateness of the management’s use of the going concern assumption in
the preparation of the financial statements and to consider whether there are material uncertainties about the entity’s ability
to continue as a going concern that need to be disclosed in a note.
The auditor should also consider the length of the time period that management have looked at in their assessment of going
concern.
The auditor will therefore need to come to an opinion as to the going concern status of an entity but the focus of the auditor’s
evaluation of going concern is to see whether they agree with the assessment made by the management. Therefore whether
they agree with the basis of preparation of the financial statements, or the inclusion in a note to the financial statements, as
required by IAS 1, of any material uncertainty.
Evaluation techniques
In carrying out the going concern assessment, management will evaluate a wide variety of indicators, including operational
and financial. An entity employing good principles of corporate governance should be carrying out such an assessment as
part of the on-going management of the business.
Auditors will use a similar assessment technique in order to come to their own opinion as to the going concern status of an
entity. They will carry out an operational review of the business in order to confirm business understanding, and will conduct
a financial review as part of analytical procedures. Thus both management and auditors will use similar business risk
assessment techniques to discover any threats to the going concern status of the business.
Auditors should not see going concern as a ‘completion issue’, but be alert to issues affecting going concern throughout the
audit. In the same way that management should continually be managing risk (therefore minimising going concern risk),
auditors should be continually be alert to going concern problems throughout the duration of the audit.
However, one difference is that when going concern problems are discovered, the auditor is required by IAS 570 to carry out
additional procedures. Examples of such procedures would include:
– Analysing and discussing cash flow, profit and other relevant forecasts with management
– Analysing and discussing the entity’s latest available interim financial statements
– Reviewing events after the period end to identify those that either mitigate or otherwise affect the entity’s ability to
continue as a going concern, and
– Reading minutes of meetings of shareholders, those charged with governance and relevant committees for reference to
financing difficulties.
Management are not explicitly required to gather specific evidence about going concern, but as part of good governance would
be likely to investigate and react to problems discovered. -
第14题：
Suppose we have the relation schema R(A,B,C,D)with functional dependencies;F{A→B,B→C,C→D,D→A},then R(A,B,C,D)at least is in
A．1NF
B．2NF
C．3NF
D．BCNF
正确答案：D
-
第15题：
For relation where primary key contains multiple attributes, no non-key attribute should be functionally dependent on a part of primary key. This relation R is at least in(66).
A．3NF
B．2NF
C．INF
D．BCNF
正确答案：A
解析：译文：对于主键包含多个属性的关系，没有非主属性函数依赖于部分主键。这样的关系R至少是3NF。 -
第16题：
What operation on relations R and S produces the relation shown below?
A．Union
B．Difference
C．Intersection
D．Division
正确答案：A
-
第17题：
为表TEST中ID列添加主键约束的语法是（）
- A、ALTER TABLE TEST CHANGE（ ID INT PRIMARY KEY）
- B、ALTER TABLE TEST ADD（ ID INT PRIMARY KEY）
- C、ALTER TABLE TEST MODIFY（ ID INT PRIMARY KEY）
- D、ALTER TABLE TEST ADD CONSTRAINT PK PRIMARY KEY （ID）
正确答案:D -
第18题：
When defining a referential constraint between the parent table T2 and the dependent table T1, which of the following is true?（）
- A、The list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.
- B、The list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.
- C、The list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.
- D、The list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.
正确答案:C -
第19题：
he data blocks in your form module are based on object tables. How would you create a master-detail relationship between two of these blocks?（）
- A、Use the Data Block Wizard and base the relation on a REF pointer.
- B、In the Object Navigator, select the Relation node under the master block and click the Create icon. Build the relation manually and coordinate the blocks using triggers.
- C、Use the Data Block Wizard, and base the relation on the primary key-foreign key relationship in the database.
- D、This task is not possible because master-detail relations can be implemented only for blocks based on relational tables.
正确答案:A -
第20题：
You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty.Which statement accomplishes this task?（）
- A、ALTER TABLE students ADD PRIMARY KEY student_id;
- B、ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student _ id);
- C、ALTER TABLE students ADD CONSTRAINT stud _ id _pk PRIMARY KEY (student _ id);
- D、ALTER TABLE students MODIFY CONSTRAINT stud _ id _pk PRIMARY KEY (student _ id);
正确答案:C -
第21题：
In the COURSE_ENROLLMENT form module, you define a master-detail relation between the COURSES_OFFERED data block and the STUDENT data block, respectively. To implement block coordination, which statement must be true?（）
- A、 The Enforce Primary Key property on the STUDENT block is set to Yes.
- B、 The Alias property on the COURSES_OFFERED block is set to Student.
- C、 The Copy Value from item property on the foreign key item in the STUDENT blocks is set to the primary key item of the COURSES_OFFERED block.
- D、 The Synchronize with item property on the foreign key item in the STUDENT block is set to the primary key item of the COURSES_OFFERED block.
正确答案:C -
第22题：
单选题he data blocks in your form module are based on object tables. How would you create a master-detail relationship between two of these blocks?（）AUse the Data Block Wizard and base the relation on a REF pointer.
BIn the Object Navigator, select the Relation node under the master block and click the Create icon. Build the relation manually and coordinate the blocks using triggers.
CUse the Data Block Wizard, and base the relation on the primary key-foreign key relationship in the database.
DThis task is not possible because master-detail relations can be implemented only for blocks based on relational tables.
正确答案： D解析： 暂无解析 -
第23题：
单选题In the COURSE_ENROLLMENT form module, you define a master-detail relation between the COURSES_OFFERED data block and the STUDENT data block, respectively. To implement block coordination, which statement must be true?（）AThe Enforce Primary Key property on the STUDENT block is set to Yes.
BThe Alias property on the COURSES_OFFERED block is set to Student.
CThe Copy Value from item property on the foreign key item in the STUDENT blocks is set to the primary key item of the COURSES_OFFERED block.
DThe Synchronize with item property on the foreign key item in the STUDENT block is set to the primary key item of the COURSES_OFFERED block.
正确答案： C解析： 暂无解析