Exam 19 January 2020, questions and answers PDF

Preview

Summary

Assignment 001Which of the following is the correct example of granting role TEACHER to USER BEN? Select one: a. GRANT ROLE TEACHER TO USER BEN; b. GRANT TEACHER TO BEN IDENTIFIED BY B01; c. GRANT ROLE TEACHER TO USER BEN IDENTIFIED BY B01; d. GRANT TEACHER TO BEN;Which of the following is the corre...

Description

Assignment 001 Which of the following is the correct example of granting role TEACHER to USER BEN? Select one: a. GRANT ROLE TEACHER TO USER BEN; b. GRANT TEACHER TO BEN IDENTIFIED BY B01; c. GRANT ROLE TEACHER TO USER BEN IDENTIFIED BY B01; d. GRANT TEACHER TO BEN; Which of the following is the correct example revoking a priviledge to INSERT, UPDATE and DELETE to USER BEN? Select one: a. REVOKE INSERT, UPDATE, DELETE FROM EMPLOYEES TO USER BEN; b. REVOKE INSERT, UPDATE, DELETE ON EMPLOYEES TO BEN; c. REVOKE INSERT, UPDATE, DELETE TO EMPLOYEES ON USER BEN; d. REVOKE INSERT, UPDATE, DELETE FROM EMPLOYEES ON USER BEN; Which of the following is the correct example of selecting all columns from employees table using the user BEN? Select one: a. SELECT * FROM EMPLOYEES b. SELECT * FROM EMPLOYEES BY USER BEN; c. SELECT * FROM SYSTEM.EMPLOYEES; d. SELECT * FROM SYSTEM.EMPLOYEES BY USER BEN; Which of the following is the correct example of granting INSERT, UPDATE and DELETE to user BEN with an option to pass the privilege to other user? Select one:

a. GRANT INSERT, UPDATE, DELETE TO EMPLOYEES ON BEN WITH GRANT OPTION; b. GRANT INSERT, UPDATE, DELETE ON EMPLOYEES TO BEN WITH GRANT OPTION; c. GRANT INSERT, UPDATE, DELETE FROM EMPLOYEES TO BEN WITH GRANT OPTION; d. GRANT INSERT, UPDATE, DELETE ON EMPLOYEES TO BEN WITH PRIVILEGE GRANT OPTION; Which of the following is the correct example of create a user Ben with password B01; Select one: a. CREATE USER BEN IDENTIFIED BY B01; b. CREATE USER BEN IDENTIFIED BY PASSWORD B01; c. CREATE BEN IDENTIFIED BY B01; d. CREATE USER BEN PASSWORD B01; Which of the following is the correct example of granting create session and create table to user BEN? Select one: a. GRANT CREATE SESSION, TABLE TO BEN; b. GRANT CREATE SESSION, CREATE TABLE TO USER BEN; c. GRANT SESSION,TABLE TO BEN; d. GRANT CREATE SESSION, CREATE TABLE

Which of the following is the correct example of changing a password to user BEN from B01 to B@1? Select one: a. ALTER USER BEN IDENTIFIED BY NEW PASSWORD B@1; b. ALTER USER BEN IDENTIFIED B01 TO B@1; c. ALTER OLD USER BEN IDENTIFIED BY B@1; d. ALTER USER BEN IDENTIFIED BY B@1; Which of the following is the correct example of creating a role TEACHER? Select one: a. CREATE ROLE AS NEW ROLE TEACHER; b. CREATE NEW ROLE AS TEACHER; c. CREATE NEW ROLE TEACHER; d. CREATE ROLE TEACHER; Which of the following is the correct example of granting SELECT and INSERT on table EMPLOYEES to role TEACHER? Select one: a. GRANT SELECT, INSERT TO EMPLOYEES ON TEACHER; b. GRANT SELECT, INSERT ON EMPLOYEES TO TEACHER; c. GRANT SELECT, INSERT ON EMPLOYEES TO USER TEACHER; d. GRANT SELECT, INSERT ON EMPLOYEES TO ROLE TEACHER; Which of the following is the correct example revoking a privilege to INSERT, UPDATE and DELETE to user ANA from user BEN? Select one:

a. REVOKE INSERT, UPDATE, DELETE FROM EMPLOYEES TO ANNA; b. REVOKE INSERT, UPDATE, DELETE ON SYSTEM.EMPLOYEES TO ANNA; c. REVOKE INSERT, UPDATE, DELETE ON EMPLOYEES TO ANNA; d. REVOKE INSERT, UPDATE, DELETE FROM SYSTEM.EMPLOYEES TO ANNA;

Assignment 002 Supposed that a user performs the query as shown below, what will happen to the data? DELETE * FROM EMPLOYEES; Then close the CMD by clicking the X button Select one: a. All rows in employees table are permanently deleted. b. Automatically save all the data. c. Generate a save point. d. DELETE statement is discarded. Supposed that a user performs the query as shown below, what will happen to the data? UPDATE EMPLOYEES SET JOB_ID = 'IT' WHERE MANAGER_ID IS NULL; SAVEPOINT UPDATE_IT; UPDATE EMPLOYEES SET JOB_ID = 'SECRETARY' WHERE DEPARTMENT IN (50,90); SAVEPOINT UPDATE_IT; ROLLBACK TO UPDATE_IT; Select one: a. The manager_id that is equal to null has been updated to IT. b. The manager_id that is equal to null is now change to IT and the job_id of employees under department_id 50,90 have been updated to secretary.

c. No changes made on employees table. d. Savepoints are discarded. Supposed that a user performs the query as shown below, what will happen to the data? UPDATE EMPLOYEES SET JOB_ID = 'IT' WHERE MANAGER_ID IS NULL; SAVEPOINT UPDATE_IT; UPDATE EMPLOYEES SET JOB_ID = 'SECRETARY' WHERE DEPARTMENT IN (50,90); SAVEPOINT UPDATE_IT; COMMIT; ROLLBACK; Select one: a. The manager_id that is equal to null has been updated to IT. b. Changes are made permanently. c. Savepoints are saved. d. The job_id of employees under department_id 50,90 have been updated to secretary. Which of the following is not a state of data after COMMIT has been issued? Select one: a. Locks are release b. The data is permanently saved. c. Save points are discarded. d. Changes are rolled back Supposed that a user performs the query as shown below, what will happen to the data? UPDATE EMPLOYEES SET JOB_ID = 'IT' WHERE MANAGER_ID IS NULL; SAVEPOINT UPDATE_IT; UPDATE EMPLOYEES SET JOB_ID = 'SECRETARY' WHERE DEPARTMENT IN (50,90); SAVEPOINT UPDATE_SECRETARY; ROLLBACK TO UPDATE_IT; Select one: a. The manager_id that is equal to null is now change to IT and the job_id of employees under department_id 50,90 have been updated to secretary b. No changes made on employees table. c. The manager_id that is equal to null has been updated to IT.

d. Savepoints are discarded. Which of the following is not a state of data after ROLLBACK has been issued? Select one: a. The data is permanently saved. b. Locks are release c. Changes are rolled back d. Save points are discarded. Which of the following is the correct example of saving changes made on the table? Select one: a. Save; b. Type exit c. Commit; d. CTRL + S Supposed that a user performs the query as shown below, what will happen to the data? UPDATE EMPLOYEES SET JOB_ID = 'IT' WHERE MANAGER_ID IS NULL; SAVEPOINT UPDATE_IT; UPDATE EMPLOYEES SET JOB_ID = 'SECRETARY' WHERE DEPARTMENT IN (50,90); SAVEPOINT UPDATE_IT; ROLLBACK; Select one: a. No changes made on employees table. b. The manager_id that is equal to null is now change to IT and the job_id of employees under department_id 50,90 have been updated to secretary. c. Savepoints are saved. d. The manager_id that is equal to null has been updated to IT. Which of the following is state of data is CREATE TABLE has been issued while performing transaction? Select one: a. Save points are restored. b. Changes are rolled back; c. All changes are automatically saved even without issuing commit.

d. Locks are not release.

Supposed that a user performs the query as shown below, what will happen to the data? DELETE * FROM EMPLOYEES; Then close the CMD by typing EXIT Select one: a. Automatically save all the data. b. DELETE statement is discarded. c. Generate a save point. d. All rows in employees table are permanently deleted

Supposed that a user performs the query as shown below, what will happen to the data? DELETE * FROM EMPLOYEES; Then close the CMD by typing EXIT Select one: a. Automatically save all the data. b. DELETE statement is discarded. c. Generate a save point. d. All rows in employees table are permanently deleted

Short Quiz 001 Also known as Oracle Database backup and restore operations Select one: a. Data Buffer Cache b. Java Pool c. Redo Log Buffer d. Large Pool It holds information about changes made to the database

Select one: a. Data Buffer Cache b. Redo Log Buffer c. Large Pool d. Java Pool

It is a collection of data treated as a unit with the main purpose of storing and retrieving related information in the database. Select one: a. Databank b. Database Server c. Oracle Database d. Oracle Storage It is a communication between a user process and an instance Select one: a. isqlPlus* b. Session c. Database Instance d. Connection

It is a type of process structure that automatically connects to other databases involved in indoubt distributed transactions Select one: a. Checkpoint Process (CKPT) b. Log Writer Process (LGWR) c. Archiver Processes (ARCn) d. Recoverer Process

It is a type of process structure that can collect transaction, redo data and transmit that data to standby destinations Select one:

a. Archiver Processes (ARCn) b. Checkpoint Process (CKPT) c. Log Writer Process (LGWR) d. Recoverer Process

It is a type of process structure that cleans up the database buffer cache Select one: a. Database Writer Process (DBWn) b. Checkpoint Process (CKPT) c. Log Writer Process (LGWR) d. Process Monitor Process (PMON)

It is a type of process structure that records checkpoint information in Control file on each data file header Select one: a. Checkpoint Process (CKPT) b. Database Writer Process (DBWn) c. Process Monitor Process (PMON) d. Log Writer Process (LGWR)

It is a type of process structure that writes modified (dirty) buffers in the database buffer cache asynchronously while performing other processing to advance the checkpoint Select one: a. Process Monitor Process (PMON) b. Checkpoint Process (CKPT) c. Database Writer Process (DBWn) d. Log Writer Process (LGWR)

It is a type of process structure that writes the redo log buffer to a redo log file on disk Select one: a. Checkpoint Process (CKPT)

b. Database Writer Process (DBWn) c. Log Writer Process (LGWR) d. Process Monitor Process (PMON) It is also known as specific connection of a user to an instance through a user process Select one: a. Session b. Database Instance c. Connection d. isqlPlus* It is part of the System Global Area (SGA) that hold copies of data blocks that are read from data files Select one: a. Large Pool b. Data Buffer Cache c. Java Pool d. Redo Log Buffer It is part of the System Global Area which is used to provide memory for Oracle Streams processes Select one: a. Java Pool b. Data Buffer Cache c. Redo Log Buffer d. Large Pool It is the key in solving the problems of information management. Select one: a. Database Server b. Oracle Database c. Oracle Storage d. Database

Which of the following are mandatory tablespaces that are created at the time of database creation Select one: a. Sysman and Sysdba b. System and Syshaux c. System and SysDba d. Sysman and System

Short Quiz 002 In planning to install Oracle which of the following is not important to consider. Select one: a. Type of Oracle software . b. Are there prerequisite steps that must be performed by someone other than the DBA? c. Any Oracle version will do even when multiple products are involved. d. Does the hardware involved meet the minimum required specifications? Which of the following is the correct Disk space requirement when installing Oracle? Select one: a. 3.4 GB b. 3.8 GB c. 1GB d. 3 GB It is a type a Oracle environment where Oracle Products run. Select one: a. ORACLE_BASE b. ORACLE_WAREHOUSE c. ORACLE_SID d. ORACLE_HOME

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

Select one: a. Evaluating the database server hardware Installing the Oracle software Planning the database and security strategy Creating, migrating, and opening the database Backing up the database Enrolling system users and planning for their Oracle Network access. Implementing the database design Recovering from database failure Monitoring database performance b. Backing up the database Recovering from database failure Evaluating the database server hardware Installing the Oracle software Creating, migrating, and opening the database Enrolling system users and planning for their Oracle Network access. Implementing the database design Monitoring database performance Planning the database and security strategy c. Recovering from database failure Evaluating the database server hardware Installing the Oracle software Creating, migrating, and opening the database Enrolling system users and planning for their Oracle Network access. Implementing the database design Monitoring database performance Planning the database and security strategy Backing up the database Which of the following is not part or Oracle Installation System Requirement. Select one: a. Operating System b. Memory c. File Manager d. Disk Space

Short Quiz 003 It is a named group of related privileges that can be granted to the user. This method makes it easier to revoke and maintain privileges.

Select one: a. Role b. Character c. Operator d. User It is a type of privilege that gain access to the database Select one: a. Object b. Table / View c. Schema d. System It is a type of privilege that is used to manipulating the content of the database objects. Select one: a. Table / View b. Schema c. Object d. System This is also known collection of objects such as tables, views, and sequences. Select one: a. Schema b. Table / View c. Object d. System This is used to remove a privilege granted to a user. Select one: a. CANCEL b. REVOKE c. DELETE d. REMOVE

Which of the following is the correct example of passing a privilege (INSERT and UPDATE) to user HR coming from a user scott? Select one: a. GRANT ROLE INSERT, UPDATE ON SYSTEM.EMPLOYEES TO USER HR; b. GRANT INSERT, UPDATE ON SYSTEM.EMPLOYEES TO HR; c. GRANT INSERT, UPDATE ON EMPLOYEES TO USER HR; d. GRANT INSERT, UPDATE ON EMPLOYEES TO HR; Which of the following is the correct example of passing a privilege (INSERT and UPDATE) to user HR coming from a SYSTEM? Select one: a. GRANT ROLE INSERT, UPDATE ON SYSTEM.EMPLOYEES TO USER HR WITH GRANT OPTION; b. GRANT INSERT, UPDATE ON EMPLOYEES TO HR WITH GRANT OPTION; c. GRANT INSERT, UPDATE ON SYSTEM.EMPLOYEES TO HR WITH GRANT OPTION; d. GRANT INSERT, UPDATE ON EMPLOYEES TO USER HR WITH GRANT OPTION; Which of the following is the correct syntax for creating a new user? Select one:

a. CREATE ROLE hr IDENTIFIED BY USER hr; b. CREATE ROLE hr IDENTIFIED BY hr; c. CREATE USER hr IDENTIFIED BY hr; d. CREATE hr IDENTIFIED BY hr; Which of the following System Privileges is not part of SYSTEM privilege? Select one: a. CREATE SESSION b. CREAT VIEW c. CREATE TABLE d. CREATE INDEX Which of the following system privileges is not part of the task by the database admin.? Select one: a. Managing user environment b. Creating new user c. Removing tables d. Backing up tables

Long Quiz 001 43% It is a type process structure that cleans up the database buffer cache Select one: a. Log Writer Process (LGWR) b. Process Monitor Process (PMON) c. Checkpoint Process (CKPT) d. Database Writer Process (DBWn) Which of the following is the correct example of granting SELECT and INSERT on table EMPLOYEES to roleSTUDENT?

Select one: a. GRANT SELECT, INSERT ON EMPLOYEES TO USER STUDENT; b. GRANT SELECT, INSERT ON EMPLOYEES TO ROLE STUDENT; c. GRANT SELECT, INSERT ON EMPLOYEES TO STUDENT; d. GRANT SELECT, INSERT TO EMPLOYEES ON STUDENT; It is the key to solving the problems of information management. Select one: a. Oracle server b. Storage server c. SQL server d. Database server Which of the following is the correct example of creating a user ANNA with password ANN01? Select one: a. CREATE USER ANNA IDENTIFIED BY ANN01; b. CREATE USER ANNA PASSWORD ANN01; c. CREATE ANNA IDENTIFIED BY ANN01; d. CREATE USER ANNA IDENTIFIED BY PASSWORD ANN01; Holds information about changes made to the database Select one: a. Java Pool b. Data Buffer Cache c. Large Pool d. Redo Log Buffer

Which of the following is not included in the optional requirement for operating system of oracle database? Select one: a. Dba b. asmadmin c. Asmdba d. Asmoper Which of the following is the correct example revoking a priviledge to INSERT, UPDATE and DELETE to USER ANNA? Select one: a. REVOKE INSERT, UPDATE, DELETE TO EMPLOYEES ON USER ANNA; b. REVOKE INSERT, UPDATE, DELETE FROM EMPLOYEES ON USER ANNA; c. REVOKE INSERT, UPDATE, DELETE ON EMPLOYEES TO ANNA; d. REVOKE INSERT, UPDATE, DELETE FROM EMPLOYEES TO USER ANNA; 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? Select one: a. GRANT INSERT, UPDATE, DELETE TO EMPLOYEES ON ANNA WITH GRANT OPTION; b. GRANT INSERT, UPDATE, DELETE ON EMPLOYEES TO ANNA WITH GRANT OPTION; c. GRANT INSERT, UPDATE, DELETE ON EMPLOYEES TO ANNA WITH PRIVILEGE GRANT OPTION;

d. GRANT INSERT, UPDATE, DELETE FROM EMPLOYEES TO ANNA WITH GRANT OPTION; Which of the following is the correct example of granting role STUDENT to USER ANNA? Select one: a. GRANT ROLE STUDENT TO USER ANNA IDENTIFIED BY B01; b. GRANT ROLE STUDENT TO USER ANNA; c. GRANT STUDENT TO ANNA; d. GRANT STUDENT TO ANNA IDENTIFIED BY B01; It is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. Select one: a. Database management System b. Oracle database c. Relational database management system d. Oracle database management system Which of the following is the correct example revoking a privilege to INSERT, UPDATE and DELETE to user ANNA from user BEN? Select one: a. REVOKE INSERT, UPDATE, DELETE FROM SYSTEM.EMPLOYEES TO ANNA; b. REVOKE INSERT, UPDATE, DELETE FROM EMPLOYEES TO ANNA; c. REVOKE INSERT, UPDATE, DELETE ON EMPLOYEES TO ANNA; d. REVOKE INSERT, UPDATE, DELETE ON SYSTEM.EMPLOYEES TO ANNA;

Which of the following is the correct example of creating a role STUDENT? Select one: a. CREATE NEW ROLE STUDENT; b. CREATE NEW ROLE AS STUDENT; c. CREATE ROLE STUDENT; d. CREATE ROLE AS NEW ROLE STUDENT; Which of the following is not included in the oracle environment? Select one: a. NSL_LANG b. oracle_base c. Oracle_instance d. oracle_sid This is use to connect to the Oracle instance and is started when a user establishes a session Select one: a. User process b. Communication c. Connection d. Server process It is a type process structure that records checkpoint information in Control file on each data file header. Select one: a. Checkpoint Process (CKPT) b. Database Writer Process (DBWn) c. Process Monitor Process (PMON) d. Log Writer Process (LGWR) It is part of the System Global Area (SGA) that hold copies of data blocks that are read from data files. Select one: a. Redo Log Buffer b. Data Buffer Cache c. Large Pool

d. Java Pool Which of the following is not included in the disk requirements of oracle database? Select one: a. 3.8 GB for the Oracle Database software b. 1 GB of disk space in the /tmp directory c. 4.5 GB for the Grid Infrastructure software d. 3 GB for the preconfigured database (required) Which of the following is not included in the required operating system users and groups? Select one: a. Dba b. sysdba c. Groups d. Oinstall

It is a type process structure that automatically connects to other databases involved in in- doubt distributed transactions. Select one: a. Checkpoint Process (CKPT) b. Archiver Processes (ARCn) c. Recoverer Process d. Log Writer Process (LGWR)

Also known as the application or tool that connects to the Oracle Database Processes Select one: a. session b. User process c. Connection d. Communication It represents the state of a current user login to the database instance. Select one:

a. User process b. Communication c. Connection d. session It is a communication pathway between a user process and an Oracle Database instance. Select one: a. User process b. session c. Connection d. Communication It is part of the System Global Area which is used to provide memory for Oracle Streams processes Select one: a. Data Buffer Cache b. Large Pool c. Redo Log Buffer d. Java Pool It is a type of privilege that gain access to the database Select one: a. Table / View b. System c. Schema d. Object Which of the following is the correct example of changing a password to user ANNA from ANNA01 to AN01? Select one: a. ALTER USER ANNA IDENTIFIED BY NEW PASSWORD B@1; b. ALTER USER ANNA IDENTIFIED B01 TO AN01; c. ALTER OLD USER ANNA IDENTIFIED BY AN01;

d. ALTER USER ANNA IDENTIFIED BY AN01; Which of the following is the correct example of granting create session and create table to user ANNA? Select one: a. GRANT SESSION,TABLE TO ANNA; b. GRANT CREATE SESSION, CREATE TABLE TO ANNA; c. GRANT CREATE SESSION, CREATE TABLE TO USER ANNA; d. GRANT CREATE SESSION, TABLE TO ANNA; Which of the following system p...