1D0-541無料問題集「CIW v5 Database Design Specialist」

質問 1

Consider the following SQL statement and the Orders relation shown in the exhibit:

What is the output of this SQL statement?

（A）B.

（B）D.

正解：B 解答を投票する

質問 2

Which statement is used to define a named group of related tables, views, domains and other database objects?

（A）CREATE SCHEMA

（B）CREATE DOMAIN

（C）CREATE TABLE

（D）CREATE

正解：A 解答を投票する

質問 3

Consider the Project relation shown in the exhibit as well as the following SQL statement: DELETE FROM Project WHERE Cust_Name = Acme; Which of the following tables shows the Project relation after execution of this SQL statement?

（A）D

（B）B

（C）C

（D）A

正解：D 解答を投票する

質問 4

In a relational database, which term describes a single table consisting of rows and columns?

（A）Relation

（B）Entity

（C）Data dictionary

（D）Matrix

正解：A 解答を投票する

質問 5

Consider the Registration relation shown in the exhibit. Which of the following SQL statements would return the Registration2 relation from the Registration relation?

（A）SELECT * FROM Registration WHERE Registration_ID = 1003 AND Registration_ID = 1005;

（B）SELECT * FROM Registration WHERE Course_Code = 'A4343';

（C）SELECTRegistration_ID, Student_ID, First_Name, Last_Name

（D）SELECTCourse_Code FROM Registration;

正解：B 解答を投票する

質問 6

Consider the Information Engineering diagram in the exhibit showing the relations BUILDING and RESIDENT. What is the relationship between BUILDING and RESIDENT?

A 1:1

（A）1:N

（B）M:N

（C）N:1

正解：C 解答を投票する

質問 7

Which term best defines a database system in which data records are stored in one or more files with no structured relationship?

（A）Object-oriented database

（B）Flat-file database

（C）Relational database

（D）Distributed database

正解：B 解答を投票する

質問 8

Your enterprise must decide whether to use a database management system. Which of the following best describes the functionality of a DBMS?

（A）A DBMS allows users to access the database while allowing the database administrator to define views particular to individual sets of users.

（B）A DBMS provides the ability to define, create and maintain databases while providing controlled access to databases.

（C）A DBMS provides the ability to maintain databases while providing increased security for the database.

（D）A DBMS provides the ability to control data access and limit the number of users at one time.

正解：B 解答を投票する

質問 9

The exhibit shows a table called Student Relation that tracks all information related to a students courses, professors and sites. What would be the consequence of removing all records for a student with the ID 1311?

（A）A deletion anomaly would occur.

（B）An insertion anomaly would occur.

（C）Only an update anomaly would occur.

（D）An update anomaly and a deletion anomaly would occur.

正解：A 解答を投票する

質問 10

Consider the Recreation relation in the exhibit. A data operation that changes one of the tuples for Student_ID 1003 must be performed. It is necessary to change one of the activities from swimming to tennis. The Student_ID and Activity attributes make up the primary key for the Recreation relation. All related information must be altered, as well. Which SQL statement or statements would best accomplish this?

（A）UPDATE Recreation SET Activity, Activity_Fee ('Tennis',100) WHERE Student_ID = 1003;

（B）UPDATE TABLE Recreation ALTER COLUMN ACTIVITY SET ACTIVITY = 'Tennis', Activity_Fee = 100 WHERE Student__ID = 1003 AND Activity = wimming?AND Activity = ?wimming?

（C）UPDATE Recreation SET Activity = 'Tennis', Activity_Fee = 100 WHERE Student_ID = 1003 AND Activity = 'Swimming';

（D）DELETE Activity FROM Recreation WHERE Student_ID = 1003; INSERT INTO Recreation VALUES (1003, 'Tennis', 100);

正解：C 解答を投票する

1D0-541 無料問題集「CIW v5 Database Design Specialist」

弊社を連絡する

関連リンク

トップ試験