Tag: technology

Quizzes (307) Questions (36705)

Questions Related to technology

Multiple choice technology databases
  1. Evalute the CREAT TABLE Statement: CREATE TABLE products (prod_id NUMBER(6) CONSTRAINT PROD_ID_PK PRIMARY KEY, product_name VARCHAR2(10)) ; Which statement is true regarding the PROD_ID_PK constraint?

  1. It would be created only if a unique index is manually created first.

  2. It would be created and would ues an automatically created no unique index

  3. It would be created and would use an automatically created unique index

  4. It would be created and reamins in a disabled state because no index is specified in the command
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation
Multiple choice technology databases

OE and SCOTT are the users in the DB.the ORDERS tables is owned by OE.Evalute the statements by the DBA in the following sequence: CREATE ROLE r1; GRANT SELECT ,INSERT ON OE.ORDERS TO r1; GRANT r1 TO SCOTT; GRANT SELECT ON OE.ORDERS TO SCOTT; REVOKE SELECT ON OE.ORDERS FROM SCOTT; what is the output after executing the statements?

  1. SCOTT would be not able to query the OE.ORDERS tables

  2. SCOTT would be able to query the OE.ORDERS tables

  3. The revoke statment would remove the SELECT privilege from SCOTT as well as from the role r1

  4. The revoke statment would give an error because the select privilege has been granted to the role r1
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation
Multiple choice technology databases

Evalute the follwing SQL statements? ALTER TABLE HR.EMP SET UNUSED ( MGR_ID ); which statements is true ?

  1. Any constraints defined on the MGR_ID column would be removed by the above command

  2. Any views created on the EMP table that include the MGR_ID column would have to bve dropped and re-created

  3. Any index created on the MGR_ID column would continue to exists until the DROP UNUSED COLUMNS command is executed.

  4. Any synonym existing on the EMP table would have to be re-created
Reveal answer Fill a bubble to check yourself
D Correct answer
Multiple choice technology databases

In which sceneria would you use the ROLLUP operator for expresiion or column with in a GROUPBY clause?

  1. To find the groups forming the subtotal in a row

  2. To create group-wise totals for the groups specified within a GROUPBY clause

  3. To create grouping for expressions or columns specified within a GROUPBY clause in one direction,from right to left for calculating the subtotals.

  4. To create grouping for expressions or columns specified within a GROUPBY clause in all possible direction,which is cross-tabular report for calculating the subtotals
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation