Your browser does not support JavaScript!
TypicalSparrow just signed up and they study Information Technology πŸ‘©β€πŸ’»
MaleSalmon just signed up and they study Real Estate Management 🏘️
LightSilverfish just signed up and they study Information Technology πŸ‘©β€πŸ’»
ConceptualSpider just signed up and they study Hotel Management 🏨
RationalCamel just signed up and they study Psychology 😌
LooseReptile just signed up and they study Real Estate Management 🏘️
MarginalTapir just signed up and they study Information Technology πŸ‘©β€πŸ’»
CautiousOwl just signed up and they study Economics πŸ’΅

Database Management System 2 (Oracle 10g Admin)

Showing 1-75 of 190 answers

A transaction ends when either of the following occurs. (Choose 5)
  • The correct answers are: CREATE TABLE is issued, The user closes the isqlplus, The user type in Commit, The user encounter system failure, The user type in Rollback Correct
An automatic commit is issued by the Oracle Server under the following circumstances. (Choose 2)
  • The correct answers are: CREATE TABLE is issued, Closes the sqlplus normally by typing exit Correct
An automatic rollback is issued by the oracle under the following circumstances. (Choose 2)
  • The correct answers are: The user encounter system failure, Closes the sqlplus normally by closing he isqlplus using x button Correct
If WITH CHECK OPTION is added on the view (see sample code below) what is/are the restriction?
  • It restricts the users to add a value where course is equal to BSCS onlyCorrec Correct
In planning to install Oracle which of the following is not important to consider.
  • Any Oracle version will do even when multiple products are involved. Correct
In the given complex view example what will be the possible output if this code is run?
  • Cause an error because the JOIN condition is omitted. Correct
Supposed that a user performs the query as shown below, what will happen to the data?
  • The manager_id that is equal to null is now change to IT and the job_id of employees under department_id 50,90 or salary greater that 500 have been updated to secretary. Correct
Supposed that table: Workers and Employees is consists of the following values.
  • INSERT INTO EMPLOYEES(ID, LASTNAME, DEPARTMENT)SELECT ID, LASTNAME, DEPARTMENTFROM WORKERSWHERE STATUS = β€˜Regular’; Correct
Search
All courses