-
You create a data block based on a relation table containing a REF column. You select the REF column for your form module. Which statement about the REF column is true?()
A . It is created as a nondisplay item.
B . The Lock Record property is set to Yes.
C . It cannot be referenced in item level triggers.
D . It is placed on the canvas with the highest sequence number.
-
You work as a database administrator for Certkiller .com. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go? ()
A . 3 hours
B . 6 months
C . until last year
D . until last commit
E . until the point when the undotablespacewas refreshed
F . until the database is shut down and the memory erased
-
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? ()
A . Verify that trunked links are configured to allow the VLAN traffic.
B . Verify that the switch is configured to allow for trunking on the switch ports.
C . Verify that each switch port has the correct IP address space assigned to it for the new VLAN.
D . Verify that different native VLANs exist between two switches for security purposes.
-
Which are SRW package procedure or function could you use to create and then drop a temporary table in the sales report?()
A . SRW.BREAK
B . SRW.SET_ALTER
C . SRW.REFERENCE
D . SRW.DO_SQL
E . SRW.RUN_REPORT
F . SRW.SET_FIELD
-
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) ()
A . A CHECK constraint is created on the OID column.
B . A NOT NULL constraint is created on the OID column.
C . The ORDERS table is the only object created in the USERS tablespace.
D . The ORDERS table and a unique index are created in the USERS tablespace.
E . The ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.
-
On Monday, you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday, you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct?()
A . You can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use the RENAME TO clause.
B . You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.
C . You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.
D . You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
-
In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.() Mysql> SELECT * INTO OUTFILE '/tmp/t1.sql' from t1; mysql> TRUNCATE t1;
A . $ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql
B . Mysql> INSERT INTO t1 VALUES FROM '/tmp/t1.sql'
C . $ mysql – u root – p – h localhost test < /tmp/t1.sql
D . Mysql> LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1
E . $ mysqlinport – u root – p – h localhost test /tmp/t1.sql
-
A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?()
A . REFERENCES
B . SELECT
C . UPDATE
D . ALTER
-
You want to create a temporary table while executing a procedure in a form. Which statement is true?()
A . You cannot create a table form within Forms.
B . You must use the FORMS_DDL built-in to create the table.
C . You must use the DBMS_DYNAMIC_DDL package to create the table.
D . You can write the CREATE TABLE statement directly into the trigger.
-
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? ()
A . Verify that different native VLANs exist between two switches for security purposes.
B . Verify that the VLAN was added on all switches with the use of the show vlan command.
C . Verify that the switch is configured to allow for trunking on the switch ports.
D . Verify that each switch port has the correct IP address space assigned to it for the new VLAN.
-
Examine the command that is used to create a table: SQL> CREATE TABLE orders(oid NUMBER(6) PRIMARY KEY, odate DATE, ccode NUMBER (6), oamtNUMBER(10,2)) TABLESPACE users; Which two statements are true about the effect of the above command()
A . A CHECK constraint is created on the OID column.
B . A NOT NULL constraint is created on the OID column.
C . The ORDERS table is the only object created in the USERS tablespace.
D . The ORDERS table and a unique index are created in the USERS tablespace.
E . The ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.
-
Which is a valid CREATE TABLE statement? ()
A . CREATE TABLE EMP9$# AS (empid number(2));
B . CREATE TABLE EMP*123 AS (empid number(2));
C . CREATE TABLE PACKAGE AS (packid number(2));
D . CREATE TABLE 1EMP_TEST AS (empid number(2))
-
A new Company switch was just configured using the "switchport trunk native vlan 7" command. What does this interface command accomplish?()
A . Causes the interface to apply ISL framing for traffic on VLAN 7
B . Configures the trunking interface to forward traffic from VLAN 7
C . Configures the interface to be a trunking port and causes traffic on VLAN 7 to be 802.1q tagged
D . Configures the trunking interface to send traffic from VLAN 7 untagged
E . None of the other alternatives apply
-
I just managed to()a quick breath before I was pulled under the water by the passing boats.
A . load
B . gain
C . take
D . escape
-
You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results? ()
A . CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;
B . CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;
C . GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
-
He was the Beatles' most versatile singer and not just as a __________.
-
The artwork Uncle Sam was created in 1917 as a recruiting poster for the US Army.
-
The ghostly presence was just a (n)_________ sensation of some people.
-
George:I have just gotten a pair of movie tickets and was thinking of inviting you.Are you interested?
Heather:Yeah,definitely!__________
George:No problem.
A.Thanks for inviting me!
B.Any Problem?
C.Of course!
D.When and where?
-
Mary:I have just gotten a pair of concert tickets and was thinking of inviting you.
Are you interested?
John:Yeah,definitely!__________
A.Thanks for inviting me.
B.Any problem?
C.of Course.
D.when and where?
-
根据所给字母补充词语
The children in a Shenzhen middle school were waiting in the playground for the (e ) moment.They were going to have a football match (a ) a team that was from a middle school in a small village.(E) player was (s) they would (b) the children just because the (o) team was from a village.It began at four in the afternoon.The whole school watched the match.The city children played (c).At first the village children wew (n) and they lost the first half.To their surprise,the village children had (t) at the second half.They (k) goals and won the match.
-
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?()
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135882/b1559080aa448ecf1a5fe7380a121c8c.jpg' />
A. You obtain the results retrieved from the public synonym HR created by the database administrator.
B. You obtain the results retrieved from the HR table that belongs to your schema.
C. You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
D. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
E. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.
-
- Hello, Chris? This is Lee.()- Oh, that's OK.I was just setting the table.
A.What are we going to have for dinner?
B.I hope I'm not calling at dinner time.
C.Jane invites us over for dinner tonight.
-
The world's smallest baby, a __________ girl weighed just 24 grams when she was born .
A、three months
B、three-month-old
C、three months old
D、three-months-old