Tag Archives: Databases

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.Segment creation is not deferred.You execute this command:Which three statements must be true so that the SALES user can create tables in SALES_Q1?(Choose three.) A. The sales user must have been granted the CREATE SESSION privilege B. The sales user must have… Read More »

In one of your databases, you create a user, HR, and then execute this command: GRANT CREATE SESSION

In one of your databases, you create a user, HR, and then execute this command:GRANT CREATE SESSION TO hr WITH ADMIN OPTION;Which three actions can HR perform? (Choose three.) A. Revoke the CREATE SESSION privilege from other users B. Revoke the CREATE SESSION privilege from user HR C. Log in to the database instance D. Grant the CREATE… Read More »

In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance

In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance whose listener listens on port 1531 by using this statement:CONNECT HR/[email protected]No name server is used.Which statement is true about ORCL? A. It must be the value of the SERVICE_NAMES parameter on the client side B. It must be… Read More »

In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespaces are smallfile

In your data center, Oracle Managed Files (OMF) is used for all databases.All tablespaces are smallfile tablespaces.SALES_Q1 is a permanent user-defined tablespace in the SALES database.Examine this command which is about to be issued by a DBA logged in to the SALES database:ALTER TABLESPACE sales_q1 ADD DATAFILE;Which are two actions, either one of which you could take to… Read More »

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.Segment creation is not deferred.You execute this command:Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.) A. The sales user must have their quota on the users tablespace removed B. The sales user… Read More »

The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations. Each

The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.Each database has a tnsnames.ora file defining DALLAS_DB as a service name.Examine this command:CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING ‘dallas_db’; How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB? A.… Read More »

Which two tasks can you perform using DBCA for databases? (Choose two.)

Which two tasks can you perform using DBCA for databases? (Choose two.) A. Configure a nonstandard block size for a new database B. Register a new database with an available Enterprise Manager Management server C. Configure incremental backups for a new database D. Enable flashback database for an existing database E. Change the standard block size of an… Read More »

In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance

In one of your databases, the user HR has the password HRMGR.You want to connect to a database instance whose listener listens on port 1531 by using this statement:CONNECT HR/[email protected]No name server is used.Which statement is true about ORCL? A. It must resolve to a valid connect descriptor in the server’s tnsnames.ora file B. It must resolve to… Read More »

You want to apply the principle of Least Privilege in all your live databases. One of your requirements

You want to apply the principle of Least Privilege in all your live databases.One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three.) A. analysis of all privileges used by all users including administrative users in the… Read More »

In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance

In one of your databases, the user HR has the password HRMGR.You want to connect to a database instance whose listener listens on port 1531 by using this statement:CONNECT HR/[email protected]No name server is used.Which statement is true about ORCL? A. It must resolve to a valid connect descriptor in the client’s tnsnames.ora file B. It must be the… Read More »