Database Management System 2 (Oracle 10g Admin) IT-6203 exam answers

This is a kind of mechanism, which liberalizes itself from actual data stored on the disk.

Logical Data Independence Correct

This is a schema that pertains to the actual storage of data and its form of storage like files, indices.

Logical Database Schema Correct

This is a type of attribute that is atomic value, which cannot be divided further.

Simple Attribute Correct

This is a type of attribute that is made of more than one simple attribute.

Composite Attribute Correct

This is a type of schema defines all the logical constraints that need to be applied on the data stored. It defines tables, views, and integrity constraints.

Logical Database Schema Correct

This is a type of schema that has the power to change the physical data without impacting the schema or logical data.

Physical Data Independence Correct

This is acquired automatically as needed to support a transaction based on isolation levels.

Lock Correct

This is also known as unit of work.

Transaction Correct

This is also known collection of objects such as tables, views, and sequences.

Schema Correct

This is the fundamental entity which introduces abstraction in a Database Management System (DBMS).

Entity Relationship Diagram Correct

This is use to connect to the Oracle instance and is started when a user establishes a session

Server process Correct

This is used to deactivate an integrity constraint.

DISABLE CONSTRAINT Correct

This is used to delete a primary key constraint in a parent table and will automatically drop the foreign key constraint in the child table.

DROP CASCADE Correct

This is used to delete child row when a parent key is deleted.

ON DELETE CASCADE Correct

This is used to enable a currently disable constraint in the table definition.

ENABLE CONSTRAINT Correct

This is used to quality ambiguous column when joining two or more tables.

Table Prefixes Correct

This is used to remove a privilege granted to a user.

REVOKE Correct

What are the two forms of key integrity constraint?

Foreign key and Primary Key Correct

Which of the following are mandatory tablespaces that are created at the time of database creation

System and Syshaux Correct

Which of the following follows the correct order of designing, implementing and mainting and Oracle Database.

Evaluating the database server hardwareInstalling the Oracle softwarePlanning the database and security strategyCreating, migrating, and opening the databaseBacking up the databaseEnrolling system users and planning for their Oracle Network access.Implementing the database designRecovering from database failureMonitoring database performance Correct

Which of the following follows the order of designing, implementing and mainting and Oracle Database

Evaluating the database server hardwareInstalling the Oracle softwarePlanning the database and security strategyCreating, migrating, and opening the databaseBacking up the databaseEnrolling system users and planning for their Oracle Network accessImplementing the database designRecovering from database failureMonitoring database performance Correct

Which of the following is not included in the disk requirements of oracle database?

3 GB for the preconfigured database (required) Correct

Which of the following is not included in the memory requirements of oracle database.

3GB for the ASM instance Correct

Which of the following is not included in the optional requirement for operating system of oracle database?

Dba Correct

Which of the following is not included in the oracle environment?

Oracle_instance Correct

Which of the following is not included in the required operating system users and groups?

sysdba Correct

Which of the following is not part of multiple row subqueries?

MAX Correct

Which of the following is not part of single to subqueries?

IN Correct

Which of the following is not part or Oracle Installation System Requirement.

File Manager Correct

Which of the following is not possible causes of lock.

Lost Update Correct

Which of the following is not true about complex view when using DELETE statement?

All of the choices Correct

Which of the following is not true about complex view when using INSERT statement?

All of the choices Correct

Which of the following is not true about complex view when using UPDATE statement?

All of the choices Correct

Which of the following is the correct Disk space requirement when installing Oracle?

3.8 GB Correct

Which of the following is the correct example of adding a check constraint on column BOOK_ID to accept value greater that 10?

CREATE TABLE BOOKS(BOOK_ID NUMBER,TITLE VARCHAR(10),YEAR NUMBER(4),CONSTRAINT BK_ID CHECK (BOOK_ID > 10)); Correct

Which of the following is the correct example of adding a CHECK constraint where CODE should start with the character ‘BS’.

The correct answers are: CREATE TABLE COURSE(CODE CHAR(4) PRIMARY KEY,TITLE VARCHAR(20),CONSTRAINT CODE_ck CHECK (CODE LIKE ‘BS%’));b, ‘BS’)); Correct

Which of the following is the correct example of adding primary key constraint?

ALTER TABLE AUTHORSADD CONSTRAINT AUTHOR_ID PRIMARY KEY(NUMBER); Correct

Which of the following is the correct example of an attribute?

USN_ID Correct

Which of the following is the correct example of an attributes?

USN_ID Correct

Which of the following is the correct example of an entity.

Workers Correct

Which of the following is the correct example of changing a password to user ANNA from ANNA01 to AN01?

ALTER USER ANNAIDENTIFIED BY AN01; Correct

Which of the following is the correct example of create a default constraint.

CREATE TABLE COURSE(CODE CHAR(4) PRIMARY KEY,TITLE VARCHAR(20),CONSTRAINT CODE_df DEFAULT(CODE 'BSIT')); Correct

Which of the following is the correct example of creating a role STUDENT?

CREATE ROLE STUDENT; Correct

Which of the following is the correct example of creating a subquery that copy the values from employees table to workers table?

INSERT INTO WORKERS(ID, NAME, POSITION)SELECT (ID, NAME, POSITIONFROM EMPLOYEES); Correct

Which of the following is the correct example of creating a subquery that will copy all values from employees table to workers where job_id is equal to ST_CLERK;

INSERT INTO WORKERS(SELECT * FROM EMPLOYEES WHERE JOB_ID = ‘ST_CLERK’); Correct

Which of the following is the correct example of creating a user ANNA with password ANN01?

CREATE USER ANNAIDENTIFIED BY ANN01; Correct

Which of the following is the correct example of creating a view where LASTNAME ends with letter S rename LASTNAME to SURNAME?

CREATE VIEW WORKERS (EMPLOYEE_ID, SURNAME, FIRSTNAME)AS (EMPLOYEE_ID, LASTNAME, FIRSTNAMEFROM EMPLOYEES WHERE SALARY LASTNAME LIKE '%S'); Correct

Which of the following is the correct example of derived attribute?

The correct answer is: Correct

Which of the following is the correct example of disabling an integrity constraint?

ALTER TABLE STUDENTS DISABLE CONSTRAINT usn_pk; Correct

Which of the following is the correct example of dropping on delete cascade?

ALTER TABLE AUTHORSDROP PRIMARY KEY CASCADE; Correct

Which of the following is the correct example of enabling constraint?

ALTER TABLE BOOKSENABLE CONSTRAINT STUD_ID; Correct

Which of the following is the correct example of granting create session and create table to user ANNA?

GRANT CREATE SESSION, CREATE TABLETO ANNA; Correct

Which of the following is the correct example of granting INSERT, UPDATE and DELETE to user ANNA with an option to pass the privilege to other user?

GRANT INSERT, UPDATE, DELETEON EMPLOYEESTO ANNAWITH GRANT OPTION; Correct

Which of the following is the correct example of granting role STUDENT to USER ANNA?

GRANT STUDENT TO ANNA; Correct

Which of the following is the correct example of granting SELECT and INSERT on table EMPLOYEES to roleSTUDENT?

GRANT SELECT, INSERTON EMPLOYEESTO STUDENT; Correct

Which of the following is the correct example of modifying a view where salary manager_id is null?

CREATE OR REPLACE VIEW WORKERS (EMPLOYEE_ID, SURNAME, FIRSTNAME, MANAGER_ID)AS (EMPLOYEE_ID, LASTNAME, FIRSTNAME, MANAGER_ID)FROM EMPLOYEES WHERE MANAGER_ID IS NULL); Correct

Which of the following is the correct example of multiple row subquery?

SELECT EMPLOYEE_ID, SALARY FROM EMPLOYEES WHERE SALARY =(SELECT MIN(SALARY) FROM EMPLOYEES; Correct

Which of the following is the correct example of passing a privilege (INSERT and UPDATE) to user HR coming from a SYSTEM?

GRANT INSERT, UPDATEON EMPLOYEESTO HRWITH GRANT OPTION; Correct

Which of the following is the correct example of passing a privilege (INSERT and UPDATE) to user HR coming from a user scott?

GRANT INSERT, UPDATEON SYSTEM.EMPLOYEESTO HR; Correct

Which of the following is the correct example of referencing the BOOKS table to AUTHORS?

CREATE TABLE BOOKS(BOOK_ID NUMBER PRIMARY KEY NOT NULL,TITLE VARCHAR(10),YEAR NUMBER(4),CONSTRAINT BK_ID FOREIGN KEY(BOOK_ID)REFERENCES AUTHORS (BOOK_ID)); Correct

Which of the following is the correct example of saving changes made on the table?

Commit; Correct

Which of the following is the correct example of selecting all columns from employees table using the user BEN?

SELECT * FROM SYSTEM.STUDENT; Correct

Which of the following is the correct example revoking a priviledge to INSERT, UPDATE and DELETE to USER ANNA?

REVOKE INSERT, UPDATE, DELETEON EMPLOYEESTO ANNA; Correct

Which of the following is the correct example revoking a privilege to INSERT, UPDATE and DELETE to user ANNA from user BEN?

REVOKE INSERT, UPDATE, DELETEON SYSTEM.EMPLOYEESTO ANNA; Correct

Which of the following is the correct query that will create a report that will display the following: FIRTSNAME, SALARY with additional 1000 in employees salary, rename this column as BONUS, then get the DEPARTMENT_NAME and DEPARTMENT_ID. Join the table using ON condition.

SELECT FIRSTNAME, SALARY + 1000 AS BONUS, DEPARTMENT_NAME, D.DEPARTMENT_IDFROM EMPLOYEES E JOIN DEPARTMENTS DON E.DEPARTMENT_ID = D.DEPARTMENT_ID; Correct

Which of the following is the correct query that will create a report that will display the following: STREET_ADDRESS, CITY, DEPARTMENT_NAME and LOATION_ID? Use using clause to get the data from two tables.

SELECT STREET_ADDRESS, CITY, DEPARTMENT_NAME, LOCATION_ID FROM DEPARTMENTS JOIN LOCATIONS USING (LOCATION_ID); Correct

Which of the following is the correct representation of many-to-many relation?

The correct answer is: Correct

Which of the following is the correct representation of one-to-many relation?

The correct answer is: Correct

Which of the following is the correct representation of one-to-one relation?

The correct answer is: Correct

Which of the following is the correct syntax for creating a new user?

CREATE USER hrIDENTIFIED BY hr; Correct

Which of the following is the Disk space requirement when installing Oracle?

8 GB Correct

Which of the following is the example of adding a check constraint on column BOOK_ID to accept value greater that 10?

CREATE TABLE BOOKS(BOOK_ID NUMBER,TITLE VARCHAR(10),YEAR NUMBER(4),CONSTRAINT BK_ID CHECK (BOOK_ID > 10)); Correct

Which of the following is the example of adding a CHECK constraint where CODE should start with the character ‘BS’

The answers are: CREATE TABLE COURSE(CODE CHAR(4) PRIMARY KEY,TITLE VARCHAR(20),CONSTRAINT CODE_ck CHECK (CODE LIKE ‘BS%’));b, ‘BS’)); Correct

Which of the following is the example of adding primary key constraint?

ALTER TABLE AUTHORSADD CONSTRAINT AUTHOR_ID PRIMARY KEY(NUMBER); Correct

Which of the following is the example of an attribute?

USN_ID Correct

Database Management System 2 (Oracle 10g Admin)

Showing 76-150 of 187 answers