更多"Given the following stored procedur"的相关试题:
[单项选择]Which of the following procedure should be performed prior to delivery and generally involves running a suite of operations so as to verify that the solution is applicable for production?（）
A. Security Check
B. Acceptance Testing
C. Project Close Out
D. Systems Integration
[单项选择] Given the following function: CREATE FUNCTION emplist （ ） RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN ('A00', 'B00'); END How can this function be used in an SQL statement?
A. SELECT TABLE(EMPLIST()) FROM EMPLOYEE
B. SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEE
C. SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEE
D. SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t
[单项选择]Given the following requirements:Create a table named TESTTAB, which has an identity column named ACTIVITYNO. Define the identity column to generate the values for the column by default. Start the values at 10 and increment by 10. Make the identity column unique. Which of the following CREATE statements will successfully create this table?（）
A. CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 10 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))
B. CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTNO))
C. CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 10 INCREMENT BY 1), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))
D. CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 10 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))
[单项选择] Given the following requirements: Create a table to contain employee data, with a unique numeric identifier automatically assigned when a row is added, has an EDLEVEL column that permits only the values 'C', 'H' and 'N', and permits inserts only when a corresponding value for the employee's department exists in the DEPARTMENT table. Which of the following CREATE statements will successfully create this table?（）
A. CREATE TABLE emp ( empno SMALLINT NEXTVAL GENERATED ALWAYS AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3) NOT NULL, edlevel CHAR(1), PRIMARY KEY emp_pk (empno), FOREIGN KEY emp_workdept_fk ON (workdept) REFERENCES department (deptno), CHECK edlevel_ck VALUES (edlevel IN ('C','H','N')), );
B. CREATE TABLE emp ( empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3), edlevel CHAR(1), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department (deptno), CONSTRAINT edlevel_ck CHECK edlevel VALUES ('C','H','N') );
C. CREATE TABLE emp ( empno SMALLINT NEXTVAL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3) NOT NULL, edlevel CHAR(1) CHECK IN ('C','H','N')), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY department (deptno) REFERENCES (workdept) );
D. CREATE TABLE emp ( empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3), edlevel CHAR(1), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department (deptno), CONSTRAINT edlevel_ck CHECK (edlevel IN ('C','H','N')) );
[单项选择] Given the following statements: CREATE TABLE tab1 (col1 INT); CREATE TABLE tab2 (col1 INT); CREATE TRIGGER trig1 AFTER UPDATE ON tab1 REFERENCING NEW AS new1 FOR EACH ROW MODE DB2SQL INSERT INTO tab2 VALUES(new1.col1); INSERT INTO tab1 VALUES(2),(3); What is the result of the following query? SELECT count(*) FROM tab2;（）
A. 3
B. 2
C. 1
D. 0
[单项选择]Given the following DDL for the PARTS table:CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9));All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever the table is queried. Which of the following create index statements will meet this criteria and require the least amount of storage for the index object?（）
A. CREATE UNIQUE INDEX idx_partno ON parts(part_no)
B. CREATE UNIQUE INDEX idx_partno ON parts(part_name ASC)
C. CREATE UNIQUE INDEX idx_partno ON parts(part_name, part_no ASC)
D. CREATE UNIQUE INDEX idx_partno ON parts(part_no, part_name ASC)
[单项选择] Given the script create script db_backup_datafile_script {backup datafile and 1， and2 plus archivelog delete input；} Run {execute script db_backup_datafile_script using 2；} What is the result of running this command？（）
A. The script will fail since you instructed RMAN to back up only one datafile rather than two
B. The script will successfully back up datafile 3 without error
C. The script will fail since it uses a substitution variable which is not supported
D. The execute script command will prompt for the value of and2 since it’s not included in the command
E. The script will fail because you cannot use the plus archivelog command when backing up
[单项选择]The software ______ and simplifies business procedures such as budgeting.
A. puts on
B. puts forward
C. takes after
D. speeds up
[单项选择]What is the correct procedure for adding an access point in WCS？（）
A. Choose Configure >Access_Point， then enter the AP MAC address
B. Choose Configure >Access_Point， then enter the IP address of the AP
C. Wait until the WLC downloads its code from the WCS and choose the access point from the list under the WLC option of the Configure menu
D. Wait until the AP downloads its code from the WCS and choose the access point from the list under the Access_Point option of the Configure menu
[单项选择]You create a Web Form that allows users to create a new account. You add a CreateUserWizard control by using the following code segment. You need to ensure that the wizard automatically sends an e-mail message to users when they finish creating their accounts. You add a valid element to the Web.config file. Which code segment should you add to the Page_Load event? （）
A. Wizard1.RequireEmail = True
B. Wizard1.Email = "user@address.com"
C. Wizard1.MailDefinition.From = "registration@mysite.com"
D. SmtpMail.SmtpServer = "mail.contoso.com"
[单项选择]In what location are EIGRP successor routes stored?（）
A. In the routing table only.
B. In the neighbor table only.
C. In the topology table only.
D. In the routing table and neighbor table.
E. In the routing table and topology table.
F. In the topology table and neighbor table.
[多项选择] You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure. In which three ways can you re-create the lost disk group and restore the data?（）
A. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.
B. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.
C. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.
D. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.
E. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
F. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.
[单项选择]Which statement about using RMAN stored scripts is true?（）
A. To create and execute an RMAN stored script, you must use a recovery catalog.
B. When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.
C. RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.
D. When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.
[单项选择]This energy comes from substances stored in the cells of the body. These substances ______ energy by combining with oxygen.
A. disperse
B. release
C. develop
D. transmit
