1Z0-042章節(jié)練習(xí)(2018.11.02)

Consider the following scenario： 
You have a directory， data， under the disk group tdgroup 
A. You want to create an alias for one of the data files and you execute the following command：
ALTER DISKGROUP tdgroupA 
ADD ALIAS ’+tdgroupA/data/datafile.dbf’ 
FOR ’+tdgroupA. 231.45678’； 
Which task would be accomplished by the command？（）

You work as a database administrator for Certkiller .com. You decided to manage client and server connections using Local Naming method in Certkiller .com. When you try to connect to the database you get the following error： ERROR： 
ORA-12154：TNS：couldnot resolve service name 
Which network configuration files would you look into to resolve this error？（）

While setting up the database for your production environment， you want to create a user with following requirements. 
1.The objects created by the user must be stored in a tablespace， TBS1， if the TABLESPACE option is not defined during the object creation. 
2.The user should be able to use 10MB of space in the tablespace TBS1. 
3.The user must change the password immediately after logging in for the first time. Which three options of the CREATE USER command would you use to achieve this objective？（）

You are connecting to an Oracle database server from a client by using the following connect string： 
SQL> CONNECT hr/hr@pdserver.us.oracle.com：1521/proddb 
Which naming method is being used in this case？（）