Tag: technology

Quizzes (307) Questions (36705)

Questions Related to technology

Multiple choice technology databases

You want to display the titles of books that meet these criteria: 1. Purchased before January 21,2001 2. Price is less than \$500 and greater than \$900 You want to sort the results by thier date of purchase, starting with the most recently bought book. Which statement should you use?

  1. SELECT book_title FROM books WHERE price between 500 and 900 AND puchase_date < '21-JAN-2001' ORDER BY purchase_date;

  2. SELECT book_title FROM books WHERE price IN (500,900) AND puchase_date < '21-JAN-2001' ORDER BY purchase_date ASC;

  3. SELECT book_title FROM books WHERE price <500 or >900 AND puchase_date < '21-JAN-2001' ORDER BY purchase_date DESC;

  4. SELECT book_title FROM books WHERE (price<500 OR price>900) AND puchase_date < '21-JAN-2001' ORDER BY purchase_date DESC;
Reveal answer Fill a bubble to check yourself
D Correct answer
Full explanation
Multiple choice technology databases

Examine the SQL statements that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN('CREDIT','CASH')), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id,order_date)); For which column would an index be automatically created when you execute the above SQL statement?(Choose two)

  1. SER_NO

  2. ORDER_ID

  3. STATUS

  4. PROD_ID

  5. ORD_TOTAL

  6. Composite index on ORDER_ID and ORDER_DATE
Reveal answer Fill a bubble to check yourself
A,F Correct answer
Full explanation
Multiple choice technology databases

Which two statements accurately describes a role?(Choose two)

  1. A role can be given to a maximum of 1000 users

  2. A user can have access to a maximum of 10 roles

  3. A role can have a maximum of 100 privileges contained in it

  4. Privileges are given to a role by using the CREATE ROLE statement

  5. A role is a named group of related privileges that can be granted to the user

  6. A user can have access to several roles, and several users can be assigned to the same role
Reveal answer Fill a bubble to check yourself
D,F Correct answer