1D0-541 試験問題を無料オンラインアクセス

Consider the relations shown in the exhibit. Due to restructuring, the sales department has been eliminated and the employees working in that department have been dismissed. All ID information is stored as integers. Which SQL statement would be used to return a relation with all information for the employees who have been dismissed?

• A.SELECT *
  FROM Employee
  WHERE Dept_ID = 022;
• B.SELECT *
  FROM Employee;
• C.SELECT ID,Last_Name
  FROM Employee;
  WHERE ID = 0004;
• D.SELECT *
  FROM Employee
  WHERE Dept_ID = 022;

You enterprise must decide whether to use a database management system. Which of the following lists four advantages of using a DBMS?

• A.Increased datasecriry, increased data integrity, increased data independence, and decreased data separation.
• B.Increased data access, increased data backup and recovery, data sharing, and consistency of data.
• C.Management of data redundancy, increased data integrity, increased data dependence, and increased application program flexibility.
• D.Consistency of data, adherence to standards, managed concurrency, and increased software complexity.

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

• A.CREATE
• B.CREATE SCHEMA
• C.CREATE TABLE
• D.CREATE DOMAIN

Consider the relation shown in the exhibit. Which of the following SQL statements would properly remove all tuples for New York customers?

• A.DELETE FROM Customers WHERESales_Office = ew York?WHERE Sales_Office = ?ew York?
• B.DELETE * FROM Customers WHERESales_Office = ew York?WHERE Sales_Office = ?ew York?
• C.DELETE FROM Customers WHERESales_Office NOT LIKE ew York? WHERE Sales_Office NOT LIKE ?ew York?
• D.DELETE * FROM Customers
  WHERE Sales_Office = New York;

Which mechanism provides database users with controlled access to the database through the use of virtual tables?

• A.Database control language
• B.Data dictionary
• C.Database management system
• D.View