-
Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?（）
A . ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;
B . ALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;
C . ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn NOT NULL;
D . ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn IS NOT NULL;
E . ALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL;
F . ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name NOT NULL
-
Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue regarding the above command（）
A . The constraint remains valid.
B . The index on the constraint is dropped.
C . It allows the loading of data into the table using SQL *Loader.
D . New data conforms to the constraint， but existing data is not checked.
E . It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
-
You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）
A . The online redo log files and archived redo log files are required to accomplish the recovery.
B . The uncommitted transaction will be committed at the next startup of the database instance.
C . The uncommitted transaction is rolled back automatically at the next opening of the database.
D . The DBA has to perform the recovery on the database to recover the uncommitted transactio
-
Which SQL statement defines a FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）
A . CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);
B . CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));
C . CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));
D . CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp_deptno_fk REFERENCES dept (deptno))
-
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.
-
Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）
A . The constraint remains valid.
B . The index on the constraint is dropped.
C . It allows the loading of data into the table using SQL*Loader.
D . New data conforms to the constraint， but existing data is not checked
E . It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
-
ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure. Which statement is true in this situation（）
A . The online redo log files and archived redo log files are required to accomplish the recovery.
B . The uncommitted transaction will be committed at the next startup of the database instance.
C . The uncommitted transaction is rolled back automatically at the next opening of the database.
D . The DBA has to perform the recovery on the database to recover the uncommitted transaction.
-
Which of the following is true of an index used to support a UNIQUE constraint?（）
A . It must have the UNIQUE attribute.
B . It cannot be created explicitly by the user.
C . It must have the UNIQUE and CLUSTER attributes.
D . It must have the UNIQUE WHERE NOT NULL attribute.
-
What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）
A . A check constraint on the EMPLOYEE table
B . A unique constraint on the EMPLOYEE table WORKDEPT column
C . A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE table
D . A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table
-
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 cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.
B . You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.
C . 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.
D . 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.
-
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.
-
Which two statements are true about the primary key constraint in a table？ （）
A . It is not possible to disable the primary key constraint.
B . It is possible to have more than one primary key constraint in a single table.
C . The primary key constraint can be referred by only one foreign key constraint.
D . The primary key constraint can be imposed by combining more than one column.
E . The non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.
-
Two database users， Jack and Bill， are accessing the Certkiller STAFF table of the Certkiller DB database. When Jack modifies a value in the table， the new value is invisible to Bill. Which is the modified value invisible to Bill？（）
A . The modified data are not available on disk.
B . The modified data have been flushed out from memory.
C . The modified rows of the Certkiller STAFF table have been locked.
D . Jack has not committed the changes after modifying the value.
E . Both users are accessing the database from two different machines.
-
Evaluate the CREATE TABLE statement： CREATE TABLE products （product_id NUMBER （6） CONSTRAINT prod_id_pk PRIMARY KEY， product_name VARCHAR2 （15））； Which statement is true regarding the PROD_ID_PK constraint？（）
A . It would be created only if a unique index is manually created first.
B . It would be created and would use an automatically created unique index.
C . It would be created and would use an automatically created nonunique index.
D . It would be created and remains in a disabled state because no index is specified in the command.
-
If a switch is working in the fail-open mode， what will happen when the switch’s CAM table fills to capacityand a new frame arrives？（）
A . A copy of the frame is forwarded out all switch ports other than the port the frame was received on.
B . The frame is transmitted on the native VLAN.
C . The switch sends a NACK segment to the frame’s source MAC address.
D . The frame is dropped.
-
Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS which statement is true？（）
A . You cannot perform the TSPITR with the constraints enabled.
B . You must perform the TSPITR recovery of both tablespaces for it to be successful.
C . You can perform TSPITR only on the USERS tablespace.
D . RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it automatically.
E . The TSPITR will only be successful if the constraint is enabled.
-
A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled. What are the two effects of this command？（）
A . It fails if any existing row violates the constraint.
B . It does not validate the existing data in the table.
C . It enables the constraint to be enforced at the end of each transaction.
D . It prevents insert， update， and delete operations on the table while the constraint is in the process of being enabled.
-
A SQL Azure database generates an error when a row is inserted into any table in the database. No error is generated when a row is deleted. You need to recommend an approach for locating the source of the errors. What should you recommend？（）
A . Use a Dynamic Management View to check for locks.
B . Use a Dynamic Management View to check for blocked queries.
C . Use a Dynamic Management View to check for long-running queries.
D . Use a Dynamic Management View to check the size and maximum size of the database.
-
Visual devices such as graphs and tables are a convenient way of displaying large quantities of information in a form that is easy to understand.
-
This is a room in Joan's house. There is a bed, a table and some chairs in it. There's a glass and some books on the table. Joan is in the room. Her father and mother are at the school. They all work hard.
What's on the table？
A．A glass.
B．Some books.
C．A glass and some books.
-
Which size tablecloth would you buy for a circular table which is 30 inches hish and 45 inches in diameter？
A.45-inch round．
B.50-inch round
C.70-inch round
D.120-inch round
-
Below is a table showing the killers in every l00 deaths in a city during the last three decades．Look at the graph and write an essay of about l20 words making reference to the following points：
1） the distribution of killers in different decades and the general bend in these decades
2） the possible reasons for the distribution of these killers in the city
<img src='https://img2.soutiyun.com/ask/uploadfile/10842001-10845000/a4b73cacf6714c8a87917976df08a7d0.gif' />
-
<table><tbody><tr><td>Teaching English as a foreign language is very popular for many travellers. In March I started teaching English in Thailand.
I really love teaching. I knew it could be a lot of fun, especially with my students who are 3-5 years old. But I had no idea just how much I would actually enjoy it. The only reason I started was simple - it was an easy way to make money.
I had no idea Thai children could speak English so well at such a young age. My children could describe colours, shapes, body parts, days of the week and classroom objects!
Two things changed after working. The first one was in the first weeks of teaching, I liked to have my lessons planned out, but things didn't go as expected. Now I am happy to walk into a classroom with whatever I need for the subject.
I guess the other thing would be how much the children trust me. 18 weeks ago these children were<u>unconfident</u>and pretty shy, but now they can't wait to get involved.
In 6 months I have no idea where I will be, but right now I love teaching and enjoy working with the kids every day. Will I teach again - I'd like to think so!
小题1:Where is the writer most probably from？<table><tr><td>A．Korea.</td><td>B．England.</td></tr><tr><td>C．China.</td><td>D．Japan.</td></tr></table>小题2:Which of the following is NOT the writer's student？<table><tr><td>A．May, 4 and a half, who can tell different shapes.</td></tr><tr><td>B．Wilton, 3, who can tell different colors.</td></tr><tr><td>C．Nick, 5, who can count from one to one hundred.</td></tr><tr><td>D．Leonie, 6, who is good at English grammar.</td></tr></table>小题3:Which of the following is TRUE？<table><tr><td>A．The writer might be short of money when he traveled in Thailand.</td></tr><tr><td>B．All the children in the writer's class are very naughty.</td></tr><tr><td>C．The writer will never be a teacher again.</td></tr><tr><td>D．The writer never has classes in the classroom.</td></tr></table>小题4: What is the meaning of the underlined word "unconfident" in Chinese？<table><tr><td>A．粗心大意的</td><td>B．缺乏信心的</td></tr><tr><td>C．不切实际的</td><td>D．骄傲自满的</td></tr></table>小题5:What is best title for the passage？<table><tr><td>A．Teaching is a good job.</td></tr><tr><td>B．How clever the Thailand children are!</td></tr><tr><td>C．My travel experience in Thailand.</td></tr><tr><td>D．First time as an English teacher in Thailand.</td></tr></table></td></tr></tbody></table>
-
The lighting in Jake’s Steak Restaurant is dim. The chairs are covered in leather and each table is covered with a white linen cloth. The colors are limited to earth tones with an occasional splash of
A．promotions
B．target
C．atmosphere
D．product assortment
