The table below shows the minimum age requirement for obtaining a driver’s license. In what percent of the states can a person obtain a driver's license before the age of 16?
You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?()
Which two statements regarding the Flashback Table feature are correct?()
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) DEFAULT 'SA_REP' SAL NUMBER COMM_PCT NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below: JOB_ID: Default value specified for this column definition. SAL: Maximum salary earned for the job ID SA_REP. COMM_PCT: Default value specified for this commission percentage column, if any. If no default value is specified for the column, the value should be NULL. DEPARTMENT_ID: Supplied by the user during run time through substitution variable. Which UPDATE statement meets the requirements?()
The table below shows the enrollment in various classes at a certain college.
Although no student is enrolled in all three classes, 15 are enrolled in both Biology and Physics, 10 are enrolled in both Biology and Calculus and 12 are enrolled in both Physics and Calculus. How many different students are in the three classes?
When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?()
Which two operations can be performed on an external table()
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()
OF PUFF-X CEREAL
The table above gives the number of calories from the three different sources of calories in Puff-X cereal, and the energy yield in calories per gram for each of those sources. If one serving of Puff-X contains 110 calories, then grams of fat make up what percent of the total mass, in grams, of a serving of Puff-X?
Before a Flashback Table operation,you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?()