Tag: databases

Quizzes (243) Questions (4862)

Questions Related to databases

Multiple choice technology databases

Within the application MY_APP the following PREVIOUS VALUE expression references the sequence MY_SEQ: PREVIOUS VALUE FOR my_seq After which of the following events will the most recently generated value of MY_SEQ persist so that it can be returned to the active MY_APP application?

  1. After a ROLLBACK is issued

  2. .After the sequence is altered

  3. After the sequence is dropped

  4. After the current session ends
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation
Multiple choice technology databases

In which of the following scenarios would a stored procedure be beneficial?

  1. An application running on a remote client needs to be able to convert degrees Celsius to degrees Fahrenheit and vice versa

  2. An application running on a remote client needs to collect three input values, perform a calculation using the values provided, and store the input data, along with the results of the calculation in two different base tables

  3. An application running on a remote client needs to track every modification made to a table that contains sensitive data

  4. An application running on a remote client needs to ensure that every new employee that joins the company is assigned a unique, sequential employee number
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation
Multiple choice technology databases

Given the following DDL for the PARTS table: CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9)); All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever the table is queried. Which of the following create index statements will meet this criteria and require the least amount of storage for the index object?

  1. CREATE UNIQUE INDEX idx_partno ON parts(part_no)

  2. CREATE UNIQUE INDEX idx_partno ON parts(part_name ASC)

  3. CREATE UNIQUE INDEX idx_partno ON parts(part_name, part_no ASC)

  4. CREATE UNIQUE INDEX idx_partno ON parts(part_no, part_name ASC)
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation