1z0-071 試験問題 26

このビジネス ルールを調べてください。
各学生は複数のプロジェクトに取り組むことができ、各プロジェクトには複数の学生が所属できます。_ 最適なデータ ストレージのためにエンティティ関係 (ER) モデルを設計し、次の形式でレポートを生成できるようにする必要があります。
STUDEN_ID FIRST_NAMK LASTNAME PROJECT_ID PROJECT_NAME PROJECT_TASK
正しい 2 つの記述はどれですか?
  • 1z0-071 試験問題 27

    View the Exhibit and examine the structure of the EMPLOYEES and JOB_HISTORY tables. (Choose all that apply.)

    Examine this query which must select the employee IDs of all the employees who have held the job SA_MAN at any time during their employment.
    SELECT EMPLOYEE_ID
    FROM EMPLOYEES
    WHERE JOB_ID = 'SA_MAN'
    -------------------------------------
    SELECT EMPLOYEE_ID
    FROM JOB_HISTORY
    WHERE JOB_ID = 'SA_MAN';
    Choose two correct SET operators which would cause the query to return the desired result.
  • 1z0-071 試験問題 28

    View and Exhibit and examine the structure and data in the INVOICE table. (Choose two.) Which two statements are true regarding data type conversion in query expressions?
  • 1z0-071 試験問題 29

    Examine the structure of the BOOKS_TRANSACTIONStable:

    You want to display the member IDs, due date, and late fee as $2 for all transactions.
    Which SQL statement must you execute?
  • 1z0-071 試験問題 30

    Which three statements are true about inner and outer joins? (Choose three.)