Data-Management-Foundations 무료 덤프문제 온라인 액세스

Which clause is used to specify the join columns when performing a join in MySQL?

• A.ON
• B.AS
• C.JOIN
• D.AND

Which SQL command uses the correct syntax to add a new employee "John Doe" to the Employee table?

• A.INSERT INTO Employee (Name) VALUES ("John Doe");
• B.INSERT Employee (Name) Values ("John Doe");
• C.INSERT Employee { "John Doe" };
• D.INSERT INTO Employee ("John Doe");

What is the first step of the analysis phase for designing a database?

• A.Draw an entity-relationship (ER) diagram
• B.Determine cardinality
• C.Implement attributes
• D.Identify entities

Which database operation locates the needed table blocks?

• A.Fan-out
• B.Index scan
• C.Binary search
• D.Table scan

Which type of entity only exists in a logical sense?

• A.Physical entity
• B.Concrete entity
• C.Tangible entity
• D.Intangible entity