Tag: databases

Quizzes (243) Questions (4862)

Questions Related to databases

Multiple choice technology databases

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?

  1. ALTER TABLE students ADD PRIMARY KEY student_id;

  2. ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student _ id);

  3. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student _ id);

  4. ALTER TABLE students ADD CONSTRAINT stud _ id _pk PRIMARY KEY (student _ id);

  5. ALTER TABLE students MODIFY CONSTRAINT stud _ id _pk PRIMARY KEY (student _ id);
Reveal answer Fill a bubble to check yourself
D Correct answer
Full explanation
Multiple choice technology databases

Which one is correct for the following example shows how a stored procedure would be used with output parameters?

  1. <procedure id="swapEmailAddresses" parameterName="swapParameters" > {call swap_email_address (?, ?)} </procedure>

  2. <procedure id="swapEmailAddresses" parameterMap="swapParameters" > {call swap_email_address (?, ?)} </procedure>

  3. <procedure name="swapEmailAddresses" parameterMap="swapParameters" > {call swap_email_address (?, ?)} </procedure>

  4. <procedure propertyName="swapEmailAddresses" parameterMap="swapParameters" > {call swap_email_address (?, ?)} </procedure>
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation
Multiple choice technology databases

What is iBATIS?

  1. iBATIS is a O/R Mapping tool.

  2. iBATIS is a first class persistence framework with support for custom SQL, stored procedures and advanced mappings.

  3. iBATIS is a java development tool.

  4. iBATIS is a first class persistence framework, and will not support for custom SQL, but will support stored procedures.
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation