- 博客(380)
- 资源 (7)
- 收藏
- 关注
RSS订阅原创 java获取前台参数的几种方式
一、第一种@RequestMapping("/updateHumanInfo")public void updateHumanInfo(HttpServletRequest request) { StringBuffer sb = new StringBuffer(""); BufferedReader reader = null; try { reader = new BufferedReader(new InputStreamReader(request.
2020-08-04 10:27:02
1155
原创 integer数据比较
public class Test { public static void main(String[] args) { Integer i = 50; Integer j = 50; System.out.println(i==j); Integer a = 500; Integer b = 500; System.out.println(a==b); }}...
2018-12-20 08:51:57
450
原创 long自动转为float类型
long占用8个字节，float占用4个字节，但是在运算中long可以自动转为float1、long的取值范围没有float大，因为他们存储方式不同2、因为存储方式的不同，因此发生转换时可能会丢失精度public class Convert{ public static void main(String[] args){ long b = 1234567890123L;...
2018-11-29 10:15:32
4553
原创 类型自动转换问题
public class Convert{ public static void main(String[] args){ byte b = 5; b = b + 5; System.out.println(b); }}这里报错这是由于java的整型默认为int类型，因此这里5是int，byte和int进行运算，byte自动转化为int，因此b...
2018-11-29 10:00:43
428
原创 1.What are the prerequisites for performing flashback transactions? (Choose all that apply)
1.What are the prerequisites for performing flashback transactions? (Choose all that apply)
2016-08-22 11:02:00
1511
原创 188.You receive complaints from users regarding the high waiting time for their transactions. On inv
188.You receive complaints from users regarding the high waiting time for their transactions. Oninvestigation, you find that some users are not committing their transactions though they are notperforming any activity for a long time. As a result, SQL sta
2016-08-16 11:57:39
913
原创 187.Which two statements describe good practices for an application developer to reduce locking conf
187.Which two statements describe good practices for an application developer to reduce lockingconflicts in Oracle database? (Choose two.)
2016-08-16 11:56:47
814
原创 186.User A executes the following command to drop a large table in your database: SQL> DROP TABLE tr
186.User A executes the following command to drop a large table in your database:SQL> DROP TABLE trans;While the drop table operation is in progress, user B executes the following command on the same table:SQL> DELETE FROM trans WHERE tr_type='SL';Whic
2016-08-16 11:56:12
1275
原创 185.User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK,
185.User SCOTT executes the following command on the EMP table but has not issued COMMIT,ROLLBACK, or any data definition language (DDL) command:SQL> SELECT ename FROM emp WHERE job='CLERK' FOR UPDATE OF empno;SCOTT has opened another session to work wi
2016-08-16 11:54:31
744
原创 184.You suspect unauthorized data manipulation language (DML) operations on a particular table. You
184.You suspect unauthorized data manipulation language (DML) operations on a particular table. Youwant to track users who are performing the transactions and the values used in the transactions. You alsoplan to transfer these values to another table for
2016-08-16 11:54:04
602
原创 183.The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the p
183.The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on theprocedure to many database users:
2016-08-16 11:53:35
1158
原创 182.Which two statements are true regarding a PL/SQL package body? (Choose two.)
182.Which two statements are true regarding a PL/SQL package body? (Choose two.)
2016-08-16 11:53:08
1607
原创 181.View the Exhibit and examine the PL/SQL package and procedure.
181.View the Exhibit and examine the PL/SQL package and procedure.
2016-08-16 11:52:36
784
原创 180.User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives the fol
180.User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives thefollowing error after the INSERT statement is issued and few rows are inserted:INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id)*ERROR at line 1:ORA
2016-08-09 05:50:17
1025
原创 179.The TRANS_SUMMARY table contains product-wise transaction details that get updated with every tr
179.The TRANS_SUMMARY table contains product-wise transaction details that get updated with everytransaction in the system. Each row has cumulative transaction details of a single product and everyproduct is identified by a product code, which is the pri
2016-08-08 23:21:16
1367
原创 178.All the database users are presently connected to the database instance and working. The HR user
178.All the database users are presently connected to the database instance and working. The HR userhas opened three database sessions and executed the following command in one of his sessions:SQL> UPDATE persons SET ccode='U031' WHERE ccode='U029';123
2016-08-08 23:07:52
934
原创 177.Which three statements are correct about temporary tables? (Choose three.)
177.Which three statements are correct about temporary tables? (Choose three.)
2016-08-08 23:06:43
1755
原创 176.You executed this command to create a temporary table: SQL> CREATE GLOBAL TEMPORARY TABLE report
176.You executed this command to create a temporary table:SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area ( startdate DATE, enddate DATE, class CHAR(20)) ON COMMIT PRESERVE ROWS;Which statement is true about the rows inserted into the REPORT
2016-08-08 22:43:20
1412
原创 175.What can you achieve by implementing reverse key index?
175.What can you achieve by implementing reverse key index?
2016-08-08 22:37:58
1140
原创 174.Which two statements are true regarding B-tree index? (Choose two.)
174.Which two statements are true regarding B-tree index? (Choose two.)
2016-08-08 22:37:31
983
原创 173.Which statement describes the effect on an index, when the indexed column for the rows is update
173.Which statement describes the effect on an index, when the indexed column for the rows is updatedin the base table?
2016-08-08 22:36:30
706
原创 172.The session of user SCOTT receives the following error after executing an UPDATE command on the
172.The session of user SCOTT receives the following error after executing an UPDATE command onthe EMP table:ERROR at line 1:ORA-00060: deadlock detected while waiting for resourceOn investigation, you find that a session opened by user JIM has a trans
2016-08-08 22:36:03
765
原创 171.View the Exhibit and examine the command used to create the ZONEDATA table.
171.View the Exhibit and examine the command used to create the ZONEDATA table.
2016-08-08 22:35:14
919
原创 170.A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER T
170.A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTERTABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled.What are the two effects of this command? (Choose two.)
2016-08-08 22:03:32
1342
原创 169.You have two tables with referential integrity enforced between them. You need to insert data to
169.You have two tables with referential integrity enforced between them. You need to insert data to thechild table first because it is going to be a long transaction and data for the parent table will be available ina later stage, which can be inserted
2016-08-08 22:02:56
722
原创 168.You execute this command to drop the ITEM table, which has the primary key referred in the ORDER
168.You execute this command to drop the ITEM table, which has the primary key referred in the ORDERtable:SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE;Which two statements are true about the effect of the command? (Choose two.)
2016-08-07 18:19:57
1297
5
原创 167.Which three descriptions are correct about the effects of the TRUNCATE command on a table? (Choo
167.Which three descriptions are correct about the effects of the TRUNCATE command on a table?(Choose three.)
2016-08-07 18:08:43
795
6
原创 166.View the Exhibit and examine the setting for a table. Which statement is true about the PCTFR
166.View the Exhibit and examine the setting for a table.Which statement is true about the PCTFREE setting for the table?
2016-08-07 18:03:53
878
2
原创 165.You have an ORDERS table with the following structure:
165.You have an ORDERS table with the following structure:Name Null? Type----------- -------- ----------OID NUMBER(6)ODATE DATE CCODE NUMBER(6) OAMT NUMBER(10,2)The table has d
2016-08-07 17:55:15
1183
4
原创 164.Examine the command that is used to create a table: SQL> CREATE TABLE orders( oid NUMBER(6) PRI
164.Examine the command that is used to create a table:SQL> CREATE TABLE orders( oid NUMBER(6) PRIMARY KEY, odate DATE, ccode NUMBER(6), oamt NUMBER(10,2)) TABLESPACE users;Which two statements are true about the effect of the above command? (Cho
2016-08-07 17:45:53
1389
6
原创 163.You want to access employee details contained in flat files as part of the EMPLOYEE table. You p
163.You want to access employee details contained in flat files as part of the EMPLOYEE table. You planto add a new column to the EMPLOYEE table to achieve this.Which data type would you use for the new column?
2016-08-07 17:18:49
1655
原创 162.You created a profile APP_USER and assigned it to the users. After a month, you decide to drop t
162.You created a profile APP_USER and assigned it to the users. After a month, you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile
2016-08-07 17:10:52
974
原创 161.In your database instance, the user sessions are connected to the database server from the remot
161.In your database instance, the user sessions are connected to the database server from the remotemachines. You want to achieve the following for these users:1: The user account must be locked after four unsuccessful login attempts.2: The user must b
2016-08-07 16:57:46
1167
原创 160.View the Exhibit to observe the roles assigned to the SLP_REP user. Which statement is true a
160.View the Exhibit to observe the roles assigned to the SLP_REP user.Which statement is true about the assignment of the SELECT_CATALOG_ROLE role to the SLP_REPuser?
2016-08-07 16:22:15
759
原创 159.View the Exhibit and examine the user information.
159.View the Exhibit and examine the user information.The user has been granted CONNECT and RESOURCE roles and no individual system privileges. TheSL_REP user executes this command to create a table:SQL> CREATE TABLE orders( oid number(6), oda
2016-08-07 16:12:32
767
原创 158.You want to create a role to meet these requirements: 1: The role is to be protected from unauth
158.You want to create a role to meet these requirements:1: The role is to be protected from unauthorized usage.2: The password of the role is not to be embedded in the application source code or stored in a table.Which method would you use to restrict
2016-08-07 15:18:14
1493
1
原创 157.Examine the commands executed in the following sequence: 1: SQL> CREATE ROLE mgrrole; 2: SQL> G
157.Examine the commands executed in the following sequence:1: SQL> CREATE ROLE mgrrole;2: SQL> GRANT create user,select any table,connect,resource TO mgrrole;3: SQL> GRANT select,update ON sh.sales TO mgrrole;4: SQL> CREATE ROLE ceo IDENTIFIED BY bos
2016-08-07 13:23:55
646
原创 156.Examine the following steps performed on a database instance: 1: The DBA grants the CREATE TABL
156.Examine the following steps performed on a database instance:1: The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION.2: The SKD user creates a table.3: The SKD user grants the CREATE TABLE system privilege to the HR us
2016-08-07 13:11:13
1032
原创 155.The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this co
155.The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using thiscommand:SQL> GRANT SELECT,INSERT,UPDATE ON emp TO scott WITH GRANT OPTION;The user SCOTT executes this command to grant privileges to the user JIM:SQL> GRA
2016-08-07 07:16:47
1154
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人