oracle certification questions

is not possible to log in with Sysoper, which requires us to create this ora_oper group ourselves, and then add administrator users to the Ora_oper group.By default, only ora_dba this groupThe steps are as follows:1, right button "computer"-"management"-"Local Users and Groups"-"group".2. Right button "group"-"new group ...".3. Enter the group name "Ora_oper" and add the members. Then select "Advanced" below the "Select User" pop-up box.4, then select "Find Now", select Administrator This membe

In recent projects, the results of the completion of Hadoop operations (which exist on HDFs) need to be imported into Oracle, but when you import the Date field ' 2016-03-01 ' in HDFs with Sqoop, the Sqoop error says that the date type must be ' yyyy-mm-dd HH:MM:SS.ffffffff .Does Sqoop not support the custom to_date function, so I started looking for answers online, but I could hardly find the relevant information until I saw the following information

, PDB1)Extract E1 successfully registered with database at SCN 2664333.Sql> select Capture_name,capture_user,status,start_scn,purpose from Dba_capture;Capture_name capture_user STATUS START_SCN PURPOSE----------------- ------------------ -------- ---------- -------------------Ogg$cap_e1 C # #GGADMIN ENABLED 2664333 GoldenGate Capture(3) testSql> Connect Pdb1_u1/[email protected]Connected.1) DMLsql> INSERT into S1 values (+);1 row created.Sql> commit;Commit complete.2) DDLsql> Create sequence SS1

Label:Select To_char (0.1) nums from dual;It is observed that if the integer digits of the decimal are 0, the converted string does not have the preceding 0, and if the preceding 0 is required, a certain rule is required to format it, as shown belowSelect To_char (0.1, ' 0.9 ') nums from dual;We change the decimal number to an integer and then we look.Select To_char (1, ' 0.9 ') nums from dual;Integers can also be programmed with double typesThere are many rules about To_char (x, y) and Y, here

statements are incorrect. The following statement about notification is correct ():A. Notificationmanager man = new Notificationmanager ();B. Pendingintent contentintent= New Pendingintent ();C. remoteviews Contentview = new Remoteviews ();D. Notification Notification = new Notification (); The right thing about the Contenvalues class is ()A, he and Hashtable more similar, is also responsible for storing some name value pairs, but he stored the name value of theB, he and Hashtable more si

job information for all employees. [] (http://i2.51cto.com/images/blog/201807/03/0c3c32fbe18d0dab3f74c70fcf61142a.png?x-oss-process=image/ watermark,size_16,text_qduxq1rp5y2a5a6i,color_ffffff,t_100,g_se,x_10,y_10,shadow_90,type_zmfuz3pozw5nagvpdgk=) In the diagram, we will find that many people work together, so now if you do not want duplicate content in it, then you can use distinct in the SELECT clause to eliminate duplicate content. Syntax format: SELECT DISTINCT Job from EMP; results! [] (

ProceduresCreate or Replace procedure DEPT_EMP6 iscursor db_cursor is select * from Deptframwork ORDER by Deptid;cursor Db_cursor_e is select * FROM deptemployee;whole_name varchar (+), Emps varchar ($): =null;flag Boolean:=true;begin for R in Db_cursor Loop if R.upperid=0 then update deptframwork set wholename=r.deptname where Deptid=r.deptid;Dept_emp4(R.deptid,r.deptname); End If; For re in db_cursor_e Loop if Re.deptno=r.deptid then if flag then emps:=re.emname; Flag:=false; else Emps

1. After installing the database server, there is aClicking on a button after opening will call you to log in, the username is system, the password is the password set at the time of installation (the password I set is root).。2. On the operating system "run" enter Sqlplus then enter the user name password, the user name is system, the password is installed when the password is set (I set the password is root), and then can execute the SQL statement.3.Oracle