Which statement accomplish this? ()
A . CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);
B . CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);
C . CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);
D . CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);
E . CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);
F . CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE)
-
An operator is asked to rewind and eject a tape from a system. Which command will accomplish this without touching the tape drive?()
A . tctl reset
B . tctl rewind
C . tctl return
D . tctl rewoffl
-
You want to limit access to a method of a public class to members of the same class. Which access modifier accomplishes this objective?()
A . Public
B . Private
C . Protected
D . Transient
E . No access modifier is required
-
A WebSphere Commerce administrator is attempting to invalidate a cached servlet. Which course of action would NOT accomplish this goal?()
A . Manually Invalidate the servlet cache through the Cache Monitor
B . Configure a Time Based invalidation for the servlet
C . Call the dynamic cache invalidation API to invalidate the servlet
D . Manually invalidate the servlet through the Configuration Manager
E . Use the Commerce Accelerator to remove the invalid servlet
-
You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty.Which statement accomplishes this task?()
A . ALTER TABLE students ADD PRIMARY KEY student_id;
B . ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student _ id);
C . ALTER TABLE students ADD CONSTRAINT stud _ id _pk PRIMARY KEY (student _ id);
D . ALTER TABLE students MODIFY CONSTRAINT stud _ id _pk PRIMARY KEY (student _ id)
-
The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? ()
A . GRANT select ON dept TO ALL_ USER;
B . GRANT select ON dept TO ALL;
C . GRANT QUERY ON dept TO ALL_USERS
D . GRANT select ON dept TO PUBLIC
-
You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others. Which statement accomplishes this? ()
A . GRANT select, insert, update ON student_grades TO manager
B . GRANT select, insert, update ON student_grades TO ROLE manager
C . GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;
D . GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;
E . GRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;
F . GRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION
-
kristin wants to build an action which exits the video form. the action will be avaiable only when the user is reading the document ,which one of the following accomplish this ? ()
A . @ command([back])
B . @ command([fileexit])
C . @ command([gotoview])
D . @ command([fileclosewindow])
-
A network administrator is configuring ACLs on a cisco router,to allow traffic from hosts on networks 192.168.146.0,192.168.147.0,192.168.148.0and192.168.149.0 only.Which two ACL statements when combined are the best for accomplishing the task?()
A . access-list 10 permit ip 192.168.147.0 0.0.0.255.255
B . access-list 10 permit ip 192.168.149.0 0.0.0.255.255
C . access-list 10 permit ip 192.168.146.0 0.0.0.0.255
D . access-list 10 permit ip 192.168.146.0 0.0.0.1.255
E . access-list 10 permit ip 192.168.148.0 0.0.0.1.255
F . access-list 10 permit ip 192.168.146.0 255.255.255.0
-
An integrated, converged network enables customers to accomplish which three actions?()
A . simplify communications
B . eliminate network security threats
C . reduce total cost of ownership
D . reduce headcount
E . enable collaboration
F . increase bandwidth
-
You want a class to have access to members of another class in the same package. Which is the most restrictive access modifier that will accomplish that will accomplish this objective?()
A . Public
B . Private
C . Protected
D . Transient
E . No access modifier is required.
-
The Company network needs to pass traffic between VLANs. Which device should be used to accomplish this? ()
A . Hub
B . Switch
C . Router
D . Bridge
E . None of the other alternatives apply
-
You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table. Which set of statements accomplishes this? ()
A . CREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3
B . CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3
C . CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3
D . CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3;
E . CREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar
-
Which tasks can be accomplished using the DBMS_LOB. SETOPTIONS procedure?()
A . only encryption and compression settings for all SecureFile LOBs
B . only encryption and deduplication settings for only SecureFile CLOBs
C . deduplication,encryption,and compression settings for all SecureFile LOBs
D . deduplication,encryption,and compression settings only for SecureFile CLOB
-
A system administrator would like to verify the user definitions in the /etc/passwd file. Which of the following commands will accomplish this?()
A . usrck
B . sysck
C . lssec
D . lsuser
-
An operator needs to change from the /usr/bin to the /var/spool directory. Which of the following commands will accomplish this?()
A . cd /var/spool
B . lcd /var/spool
C . cd /usr/bin /var/spool
D . lcd /usr/bin /var/spool
-
A network administrator is configuring ACLs on a cisco router, to allow affic from hosts on networks 192.168.146.0,192.168.147.0,192.168.148.0 and 192.168.149.0 only.Which two ACL statements when combined are the best for accomplishing the task?()
A . access-list 10 permit ip 192.168.147.0 0.0.0.255.255
B . access-list 10 permit ip 192.168.149.0 0.0.0.255.255
C . access-list 10 permit ip 192.168.146.0 0.0.0.0.255
D . access-list 10 permit ip 192.168.146.0 0.0.1.255
E . access-list 10 permit ip 192.168.148.0 0.0.1.255
F . access-list 10 permit ip 192.168.146.0 255.255.255.0
-
Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g?()
A . Generate reports on data failure such as data file failures.
B . You can track the Service Request (SR) and implement repairs.
C . You can package and upload diagnostic data to Oracle Support.
D . You can manually run health checks to gather diagnostic data for a problem.
-
Which tasks can be accomplished using the DBMS_LOB. SETOPTIONS procedure?()
A . only encryption and compression settings for all SecureFile LOBs
B . only encryption and deduplication settings for only SecureFile CLOBs
C . deduplication, encryption, and compression settings for all SecureFile LOBs
D . deduplication, encryption, and compression settings only for SecureFile CLOB
-
You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?()
A . ALTER TABLE students ADD PRIMARY KEY _ id;
B . ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);
C . ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;
D . ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
E . ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id)
-
●A(n) _____ is defined as a specified accomplishment in a particular instant in time which
● A(n) _____ is defined as a specified accomplishment in a particular instant in time which does not consume time or resources.
A Activity
B Event.
C Correlation
D Constant
E Event constrained within planned effort.
-
Examine the structure of the STUDENTS table:You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999.Which SQL statement accomplishes this task?()
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/7fe8306013ab0f36b81d7271dc0c8478.jpg' />
A.<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/cfff1591b450909431e9f7ae7dc05f14.jpg' />
B.<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/c75e1c68e2e140258467ca466b7e474d.jpg' />
C.<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/c87a2c32bbbd462ee3f4b85cd7438fec.jpg' />
D.<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/659c7750c67c9d05542c4c9f4dd01ed9.jpg' />
-
The STUDENT_GRADES table has these columns:The register has requested a report listing the students‘ grade point averages (GPA), sorted from highest grade point average to lowest within each semester, starting from the earliest date. Which statement accomplishes this?()
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/96672f85a7852424612e04353e00d7a4.jpg' />
A. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end DESC, gpa DESC;
B. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end ASC, gpa ASC;
C. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end, gpa DESC;
D. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC, semester_end DESC;
E. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC, semester_end ASC;
-
You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11.You executed the following commands:Which two statements are true regarding the tasks accomplished with these commands?()
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/fe48cb3c0725d56bce44108ab4437e61.jpg' />
A. They import all metadata from the RCAT10 catalog.
B. They unregister the database from the RCAT10 catalog.
C. They do not register the databases registered in the RCAT10 catalog.
D. They register all databases registered in the RCAT10 catalog.