Database Management System 2 (Oracle 10g Admin)

Showing 151-187 of 187 answers

Which of the following is the example of an attributes?

USN_ID Correct

Which of the following is the example of an entity

Workers Correct

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

ALTER USER ANNAIDENTIFIED BY AN01; Correct

Which of the following is the 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 example of creating a role STUDENT?

CREATE ROLE STUDENT; Correct

Which of the following is the 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 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 example of creating a user ANNA with password ANN01?

CREATE USER ANNAIDENTIFIED BY ANN01; Correct

Which of the following is the 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 example of derived attribute?

The answer is: Correct

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

ALTER TABLE STUDENTS DISABLE CONSTRAINT usn_pk; Correct

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

ALTER TABLE AUTHORSDROP PRIMARY KEY CASCADE; Correct

Which of the following is the example of enabling constraint?

ALTER TABLE BOOKSENABLE CONSTRAINT STUD_ID; Correct

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

GRANT CREATE SESSION, CREATE TABLETO ANNA; Correct

Which of the following is the 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 example of granting role STUDENT to USER ANNA?

GRANT STUDENT TO ANNA; Correct

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

GRANT SELECT, INSERTON EMPLOYEESTO STUDENT; Correct

Which of the following is the 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 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 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 example of passing a privilege (INSERT and UPDATE) to user HR coming from a user scott?

GRANT INSERT, UPDATEON SYSTEMEMPLOYEESTO HR; Correct

Which of the following is the 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 example of saving changes made on the table?

Commit; Correct

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

SELECT * FROM SYSTEMSTUDENT; Correct

Which of the following is the 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 example revoking a privilege to INSERT, UPDATE and DELETE to user ANNA from user BEN?

REVOKE INSERT, UPDATE, DELETEON SYSTEMEMPLOYEESTO ANNA; Correct

Which of the following is the 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, DDEPARTMENT_IDFROM EMPLOYEES E JOIN DEPARTMENTS DON EDEPARTMENT_ID = DDEPARTMENT_ID; Correct

Which of the following is the 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 syntax for creating a new user?

CREATE USER hrIDENTIFIED BY hr; Correct

Which of the following joins are mutually exclusive.

Natural Join and Using clause Correct

Which of the following statement is not true about Foreign Key constraint?

A foreign key in one table points to a foreign key in another table. Correct

Which of the following System Privileges is not part of SYSTEM privilege?

CREATE INDEX Correct

Which of the following system privileges is not part of the task by the database admin.?

Managing user environment Correct

Which of the following transaction rules is not included in the group?

Redundancy Correct

Which one (1) Data Definition Language is considered as part of Database Transaction.

CREATE TABLE Correct

Which one (1) DCL (Data Control Langauge) is considered as part of Database Transaction

COMMIT Correct

Which three (3) of thefollowing is the three Data Manipulation Langauge that is considered as part of database transaction.

The correct answers are: INSERT, UPDATE, DELETE Correct