QUIZ. DATABASE ADMINISTRATOR. LESS 3 LESS 5 LESS 6 LESS 7. Less 3.
As this is a production database, you want to accomplish this task with no impact on the users' connections. What activity must you have completed before accomplishing this task?
Instance name : test
Host name : tech1.us.oracle.com
IP address : 220.127.116.11
Enterprise Manager Console HTTP Port number : 5500
You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser.
Which two URLs would you use to access the Database Control? (Choose two.)
ALTER DATABASE OPEN;
What actions are performed as a result of this command?
CREATE TABLESPACE sales_tbs DATAFILE ‘D:/oracle/oradata/sales_tbs.dbf' SIZE 50M EXTENT MANAGEMENT LOCAL;
The hr_tbs tablespace created in the HR database is as follows:
CREATE TABLESPACE hr_tbs DATAFILE ‘D:/oracle/oradata/hr_tbs.dbf' SIZE 50M;
View the Exhibit to see the properties of the HR database.
Which two statements are correct in the scenario? (Choose two)
You want to add a new tablespace to your database. Which three statements regarding a new tablespaces are true? (Choose three)
ORA-01653: unable to extend table HR.EMPLOYEES by 8 in tablespace USERS
Which tasks would you perform to load the data successfully affecting the users who are accessing the table?
User A wants to insert rows from EMPLOYEES and DEPARTEMENTS table into EMP_DEP table by using following insert command.
INSERT INTO EMP_DEP (emp_id, name, salary, dep_name, mgr_id) SELECT e.employee_id,
e.first_name || ' ' ||
e.manager_id FROM employees e,
departments d WHERE e.department_id = d.department_id;
While user A executes the command, it errors out, displaying the following error message:
INSERT INTO EMP_DEP (emp_id, salary, dep_name, mgr_id) *
ERROR at line 1:
ORA-01653: unable to allocate extent table A.EMP_DEP by 8 in tablespace USERS
What would have caused the error?
a) connect to the database when the database is in restricted mode, and
b) query the tables created by any other users.
Which minimal set of privileges and roles would you select from the following list to grant to the user?
1. RESTRICTED SESSION privilege
2. SELECT ANY TABLE privilege
3. RESOURCE role
4. SYSOPER privilege
5. EXEMPT ACCESS POLICY privilege
6. SELECT_CATALOG_ROLE privilege
What is CREATE USER command would you use to achieve this objective?
Which option would you use to achieve this objective?