What is the maximum number of primary partitions that can be created in a basic disk. ()
A log logical volume is created as indicated below: root@host1:/# mklv -a c -t jfs2log -b y datavg 1 loglv00 root@host1:/# lsvg -l datavg datavg: LV NAMETYPELPsPPsPVsLV STATEMOUNT POINT loglv00jfs2log111closed/syncdN/A A new filesytem is then created using the new log logical volume.When the administrator attempts to mount the filesytem, the following error occurs: root@host1:/# mount /newfs mount: 0506-324 Cannot mount /dev/lv00 on /newfs: A system call received a parameter that is not valid. Which of the following actions will resolve this error?()
The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR; ()
Your developers have created table to store some of their program's data. After examining the slow Query Log, you see that they are using the LIKE operator and SUBSTER ( ) functions against a VARCHAR (10000) column quite often. An example of the start of one row of data: 'GREEN01020495888331993-12-10/2…' What should you do to improve the overall performance?()
You have created a JSP that includes instance variables and a great deal of scriptlet code. Unfortunately,after extensive load testing, you have discovered several race conditions in your JSP scriptlet code. To fixthese problems would require significant recoding, but you are already behind schedule. Which JSP codesnippet can you use to resolve these concurrency problems?()
You have just created a new VLAN on your network. What is one step that you should include in your VLAN based implementation and verification plan? ()
Which of the following are examples of traffic that can be created as part of an IP Service -Level Agreement operation?()
You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables: EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME. The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMENT_ID column of the DEPARTMENTS table. You want to modify the view by adding a fourth column, MANAGER_ID of NUMBER data type from the EMPLOYEES tables. How can you accomplish this task?()
Which is the memory area that is created when a dedicated server process is started, and contains data and control information for that server process?()
You have created a resource plan, DAY. You execute the following code: SQL> BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE ( PLAN => ’DAY’, COMMENT => ’DEPARTMENTS PLAN’, GROUP_OR_SUBPLAN => ’DEPARTMENTS’, CPU_P1=0); END; Then, you issue the following code: SQL> BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE ( PLAN => ’DAY’, COMMENT => ’DEPARTMENTS PLAN’, GROUP_OR_SUBPLAN => ’DEVELOPERS’, CPU_P2=100); END; What will be the impact of executing the above code?()