-
The best method for tying two lines of the same size together is by using a().
A . becket bend
B . two bowlines
C . single carrick bend
D . square knot
-
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.
-
You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server. Which two changes would ensure that the temporary table does not propagate to the slave?()
A . Use the – replicate-do-db, — replicate-do-table, or – replicate-wild-do-table option with the value equal to OLD_INVENTORY
B . Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table
C . Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table
D . Set binlog_format=MIXED with the – replicate-ignore-temp-table option
E . Use the – replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table
-
The RECYCLEBIN parameter is set to ON for your database. You drop a table,PRODUCTS,from the SCOTT schema. Which two statements are true regarding the outcome of this action?()
A . All the related indexes and views are automatically dropped
B . The flashback drop feature can recover only the table structure
C . Only the related indexes are dropped whereas views are invalidated
D . The flashback drop feature can recover both the table structure and its data
-
Which statement describes the effect on an index, when the indexed column for the rows is updatedin the base table()
A . An update in a leaf row takes place.
B . The index becomes invalid after the update.
C . The leaf block containing the row to be updated is marked as invalid.
D . A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted
-
The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? ()(Choose two)
A . All the related indexes and views are automatically dropped
B . The flashback drop feature can recover only the table structure
C . Only the related indexes are dropped whereas views are invalidated
D . The flashback drop feature can recover both the table structure and its data
-
The CUSTOMERS table has these columns:
https://assets.asklib.com/images/image2/2018080116294948484.jpg
The CUSTOMER_ID column is the primary key for the table.Which two statements find the number of customers? ()
A . SELECT TOTAL(*) FROM customers;
B . SELECT COUNT(*) FROM customers;
C . SELECT TOTAL(customer_id) FROM customers;
D . SELECT COUNT(customer_id) FROM customers;
E . SELECT COUNT(customers) FROM customers;
F . SELECT TOTAL(customer_name) FROM customer
-
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
-
When a database administrator chooses the dimensions for an MDC table, which two characteristics should beconsidered?()
A . the query transaction rate
B . numeric data versus character data
C . extent size
D . the cardinality of the candidate columns
E . prefetch size&e
-
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.
-
For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state?()
A . UPDATE TABLE
B . CREATE CLUSTER
C . TRUNCATE TABLE
D . ALTER TABLE MOVE
E . INSERT INTO···VALUES
F . ALTER TABLE···DROP COLUMN
G . ALTER TABLE···DROP PARTITION
-
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.
-
The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action?()
A . All the related indexes and views are automatically dropped
B . The flashback drop feature can recover only the table structure
C . Only the related indexes are dropped whereas views are invalidated
D . The flashback drop feature can recover both the table structure and its data
-
Which statement is true about the PCTFREE setting for the table()https://assets.asklib.com/images/image2/2018080117092455693.jpg
A . It sets the minimum percentage of a data block to be reserved to contain chained rows from other blocks.
B . It sets the minimum percentage of a data block to be reserved as free space before the server prevents inserts into the block.
C . It sets the minimum percentage of a data block to be reserved to contain the bitmap used to maintain the free block information.
D . It sets the minimum percentage of a block that can be used for row data plus overhead before new rows are added to the block.
-
Is there a table for , please? () please. Is the one near the backdoor OK?
A . Take your time
B . This way
C . You are welcome
D . After you
-
You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table?()
A . You must enable the block change tracking feature.
B . You must have enable the flashback feature.
C . You must use the OMF in your database.
D . You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
-
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.
-
The contract is _____ for two years.
-
Writing a descriptive title for each table and figure is for the reader to know exactly what they are looking at without referring to the text.
-
For the left hand of the two hand model, which lifestyle factor is NOT in the model?
-
Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:Which two statements are true about redefining the table?()
<img src='https://img2.soutiyun.com/shangxueba/ask/64224001-64227000/64224740/398a37009eba261eceebfd5a001edaba.png' />
<img src='https://img2.soutiyun.com/shangxueba/ask/64224001-64227000/64224740/a5add098aa6143b225044036df53c199.png' />
A. All the triggers for the table are disabled without changing any of the column names or column types in the table.
B. The primary key constraint on the EMPLOYEES table is disabled during redefinition.
C. VPD policies are copied from the original table to the new table during online redefinition.
D. You must copy the VPD policies manually from the original table to the new table during online redefinition.
-
Examine the description of the MARKS table:SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects.Examine this SELECT statement based on the MARKS table:What is the result of the SELECT statement?()
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/1179420481e271350f195c64f9e527b9.jpg' />
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/a88968eec9764c2a8638e3aee2b1e23d.jpg' />
A. The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.
B. The statement returns an error at the SELECT clause.
C. The statement returns an error at the WHERE clause.
D. The statement returns an error at the ORDER BY clause.
-
You are the network administrator for TestKing. All network servers run Windows Server 2003.A member server named TestKingSrv is configured to run shadow copies without a storage limit. TestKingSrv has the disk configuration shown in the following table.You need to create additional free space on TESTKINGDATA1. You also need to improve the performance of TestKingSrv and ensure it has sufficient space for shadow copies in the future.Which two actions should you perform? ()(Each correct answer presents part of the solution. Choose two)
<img src='https://img2.soutiyun.com/shangxueba/ask/17127001-17130000/17128961/71325333bc54d713a67fe575c85cd7af.jpg' />
A. Delete the shadow copies on TESTKINGDATA1.
B. Delete Backup.bkf on TESTKINGDATA3.
C. In the properties of TESTKINGDATA1, relocate the shadow copies to TESTKINGDATA2.
D. In the properties of TESTKINGDATA1, relocate the shadow copies to TESTKINGDATA3.
E. Delete TESTKINGDATA3 and extend the TESTKINGDATA1 partition to include the space on TESTKINGDATA3.
-
Read the following statements and then decide whether each of them is true or false based on the information in the text. Write T for True and F for False in the black before each statement.2. () Peop
是
否