Given the following table definition:STOCK: item VARCHAR(30) status CHAR(1) quantity INT p
Given the following table definition:STOCK: item VARCHAR(30) status CHAR(1) quantity INT price DEC(7,2)If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY and PRICE to zero, which of the following statements would be used to update the STOCK table to indicate that all the items whose description begins with the letter "S" are out of stock?()
A.UPDATE stock SET (status = NULL; quantity, price = 0) WHERE item LIKE S%
B.UPDATE stock SET (status, quantity, price) = (NULL, 0, 0) WHERE item LIKE S%
C.UPDATE stock SET status = NULL, SET quantity = 0, SET price = 0 WHERE item LIKE ‘S%‘
D.UPDATE stock SET (status = NULL), (quantity = 0), (price = 0) WHERE item LIKE S%
时间:2023-06-12 02:09:39
-
Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?()
A . A syntax error will result as you cannot specify more than one partition in the same statement
B . All data in p1 and p3 partitions are removed and the table definition is changed
C . All data in p1 and p3 partitions are removed, but the table definition remains unchanged
D . Only the first partition (p1) will be dropped as only one can be dropped at any time
-
Which of the following commands is used to observe the current state of the routing table?()
A . route
B . lsattr
C . netstat
D . ifconfig
-
Given the following two tables: TAB1 C1 C2 A 11 B 12 C 13 TAB2 CX CY A 21 C 22 D 23 The following results are desired: C1 C2 CX CY A 11 A 21 C 13 C 22 -- --D 23 Which of the following queries will yield the desired results?()
A . SELECT * FROM tab1 INNER JOIN tab2 ON c1=cx
B . SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cx
C . SELECT * FROM tab1 FULL OUTER JOIN tab2 ON c1=cx
D . SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON c1=cx
-
Given the following code fragment: public void create() { Vector myVect; myVect = new Vector(); } Which of the following statements are true?()
A . The declaration on line 2 does not allocate memory space for the variable myVect.
B . The declaration on line 2 allocates memory space for a reference to a Vector object.
C . The statement on line 2 creates an object of class Vector.
D . The statement on line 3 creates an object of class Vector.
E . The statement on line 3 allocates memory space for an object of class Vector.
-
Given the following two tables: TAB1 C1 C2 1 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY 5 Europe 6 North America 7 South America Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1?()
A . INSERT INTO tab1 SELECT cx, cy FROM tab2
B . INSERT INTO tab1 VALUES (tab2.cx, tab2.cy)
C . INSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2)
D . INSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)
-
Why would you use the following FLASHBACK TABLE command?() FLASHBACK TABLE emp TO TIMESTAMP (’11:45’.’hh12:mi’);
A . to undo the changes made to the EMP table since the specified time
B . to restore the EMP table that was wrongly dropped from the database
C . to view the transactions that have modified the EMP table since the specified time
D . to view the changes made to the EMP table for one or more rows since the specified time
-
Why would you use the following FLASHBACK TABLE command?() FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’);
A . to undo the changes made to the EMP table since the specified time
B . to restore the EMP table that was wrongly dropped from the database
C . to view the transactions that have modified the EMP table since the specified time
D . to view the changes made to the EMP table for one or more rows since the specified time
E . to recover the EMP table to a point in time in the past by restoring the most recent backu
-
You are trying to alter the initial segment size given to a table in a dictionary-managed tablespace. Which of the following keywords would be used as part of this process?()
A . DROP TABLE
B . ALTER TABLE
C . RESIZE
D . COALESCE
-
Which of the following will DELETE all of the rows from table T03?()
A . DELETE * FROM TABLE T03
B . DELETE ALL FROM T03
C . DELETE * FROM T03
D . DELETE FROM T03
-
Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 1 4 1 3 1 2 Table T2: C1 C2 1 1 1 2 1 3 Which of the following queries will return only those rows that exist in both T1 and T2?()
A . SELECT * FROM t1 UNION SELECT * FROM t2
B . SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2
C . SELECT * FROM t1 INTERSECT SELECT * FROM t2
D . SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
-
Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?()
A . Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.
B . Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).
C . Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.
D . Define column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.
-
Why would you use the following FLASHBACK TABLE command?() FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’);
A . to undo the changes made to the EMP table since the specified time
B . to restore the EMP table that was wrongly dropped from the database
C . to view the transactions that have modified the EMP table since the specified time
D . to view the changes made to the EMP table for one or more rows since the specified time
E . to recover the EMP table to a point in time in the past by restoring the most recent backu
-
You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?()
A . All data along with the table structure is deleted
B . The pending transaction in the session is committed
C . All indexes on the table will remain but they are invalidated
D . All views and synonyms will remain but they are invalidated
E . All data in the table are deleted but the table structure will remai
-
Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 5 4 5 2 5 5 Table T2: C1 C2 5 1 5 2 5 3 Which of the following queries will return only those rows that exist in T1 and not in T2?()
A . SELECT * FROM T1 MINUS SELECT * FROM T2
B . SELECT * FROM T1 EXCEPT SELECT * FROM T2
C . SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1
D . SELECT * FROM T1 NOT EXISTS SELECT * FROM T2
-
Which one of the following statements is NOT the suggestion given by psychologists?
-
For English names, the family name is put first, followed by the given name.
-
Which of the following shows good table manner
A.Talking with your mouth full.
B.Putting bones on your plate.
C.Putting your elbows on the table.
D.Chewing with your month open.
-
Given the following estimated financial results, value the stock of FishnChips, In
A., using the infinite period dividend discount model (DDM).
· Sales of $1,000,000.
· Earnings of $150,000.
· Total assets of $800,000.
· Equity of $400,000.
· Dividend payout ratio of 60.0%.
· Average shares outstanding of 75,000.
· Real risk free interest rate of 4.0%.
· Expected inflation rate of 3.0%.
· Expected market return of 13.0%.
· Stock Beta at 2.1.
The per share value of FishnChips stock is approximately: (Note: Carry calculations out to at least 3 decimal places.)
B.Unable to calculate stock value because ke
D.$17.91.
E.$26.86.
-
Given the following policy, what happens when the 1.1/17 route is evaluated?()
<img src='https://img2.soutiyun.com/shangxueba/ask/17124001-17127000/17125954/deb7ed68c2d7e927abdb1c3b0d607a7b.jpg' />
<img src='https://img2.soutiyun.com/shangxueba/ask/17124001-17127000/17125954/42e9c457823b57ebe153d61d4f5b09e9.jpg' />
A. The route does not match this policy.
B. The route is accepted.
C. The route is rejected.
D. The route is accepted with a metric of 6.
-
Which of the following statements is FALSE based on the given article?
A.The artificial nose does have a big prospect in the fields of police, state security and food-safety assurance.
B.There will be a threat of lowering down people"s privacy if some day sensors are abused.
C.Things remain even when one of the traditional protectors of American liberty is that it has been impossible to search everyone.
D.It is expected to load a single fingernail-size chip with thousands of odor receptors, enough to create a sensor that"s nearly as sensitive as a dog"s nose.
-
Given $100 000 to invest, what is the expected risk premium in dollars of investing in equities versus risk-free T-bills(U.S. Treasury bills) based on the following table?______.<img src='https://img2.soutiyun.com/ask/uploadfile/2895001-2898000/0c4ba50a8847741f35d6cf01c08de390.jpg' />
A.$20 000
B.$18 000
C.$15 000
D.$13 000
-
6 Part Ⅲ Reading Comprehension Task 4 Directions: The following is a list of public signs. After reading it, you are required to find the items equivalent to those given in Chinese in the table below.
A.当心夹手
B.请勿登踏
C.服务区
D.勿靠车门
E.严禁超速
F.正在检修G. 前方学校H. 靠右站立I. 路面结冰J. 紧急情况击碎玻璃
-
Directions: The following is list of terms. After reading it, you are required to find the items equivalent ....... (相同) those given in Chinese in the table below. Then you should put the corresponding letters in the brackets numbered 26 through 30.
A--legal retirement
H--ensure
B- overlook
I- inspiration
C--boost
J- competition
D--social media
K- dependence
E--benefit
L--balance
F--graduate
M--record
G- conduct
N- career planning
Example: (A)合法退休 (I)灵感;鼓舞
26()改善;促进;增强 ()记录
27()社交媒体 ()利益,好处;优势
28()组织;实施;进行;处理 ()平衡
29()竞争 ()职业规划
30()忽视;忽略,没注意到 ()毕业
-
In the following options, which keyword is used to add records to the table ()
A.ALTER
B.CREATE
C.UPDATE
D.INSERT