0

databases Online Quiz - 185

Description: databases Online Quiz - 185
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Which constraint can be defined only at column level?

  1. unique

  2. not null

  3. check

  4. primary key


Correct Option: B

Which SELECT statement will get the result 'elloworld' from the string 'HelloWorld'?

  1. SELECT SUBSTR ('HelloWorld',1) FROM dual;

  2. SELECT LOWER (TRIM ('H' FROM 'Hello World')) FROM dual

  3. SELECT LOWER (SUBSTR('HellowWorld', 2,1) FROM dual

  4. SELECT INITCAP(TRIM('HellowWorld', 1,1) FROM dual


Correct Option: B

Which substitution variable would you use if you want to reuse the variable without prompting the user each time

  1. &

  2. accept

  3. prompt

  4. &&


Correct Option: D

CREATE USER sh IDENTIFIED BY sh; GRANT CREATE ANY MATERIALIZED VIEW CREATE ANY DIMENSION , DROP ANY DIMENSION , QUERY REWRITE , GLOBAL QUERY REWRITE TO dw_manager WITH ADMIN OPTION; GRANT dw_manager TO sh WITH ADMIN OPTION; Which action the user SH cannot perform?

  1. Create and drop a materialized view

  2. Grant and revoke the role to and from other users

  3. Enable the role and exercise any privileges in the role's privilege domain

  4. Select from a table


Correct Option: D

Which type of index does this syntax create? CREATE INDEX hr.employees_last_name_idx ON hr.employees(last_name) PCTFREE 30 STORAGE(INITIAL 200K NEXT 200K PCTINCREASE 0 MAXEXTENTS 50) TABLESPACE indx;

  1. Bitmap

  2. B-Tree

  3. Partitioned

  4. Reverse key


Correct Option: B

You need to create an index on the PASSPORT_RECORDS table. It contains 10 million rows of data. The key columns have low cardinality. The queries generated against this table use a combination of multiple WHERE conditions involving the OR operator. Which type of index would be best for this type of table?

  1. Bitmap

  2. Btree

  3. Unique

  4. partitioned


Correct Option: A

Which statement about the shared pool is true?

  1. The shared pool CANNOT be dynamically resized.

  2. The shared pool contains only fixed structures

  3. The shared pool consists of the library cache and buffer cache.

  4. The shared pool stores the most recently executed SQL statements and the most recently


Correct Option: D

Which action will cause a log switch?

  1. A transaction completes.

  2. The instance is started.

  3. The instance is shut down

  4. The current online redo log group is filled


Correct Option: D

Which is a valid CREATE TABLE statement?

  1. CREATE TABLE EMP9$# AS (empid number(2));

  2. CREATE TABLE EMP*123 AS (empid number(2));

  3. CREATE TABLE PACKAGE AS (packid number(2));

  4. CREATE TABLE 1EMP_TEST AS (empid number(2));


Correct Option: C

A SELECT statement can be to perform these three functions: -Choose rows from a table -Choose columns from a table -Bring together data that is stored in different tables by creating a link between them. Which set of keywords describe these capabilities?

  1. difference,projection,join

  2. selection.projection,join

  3. selection,intersection,join

  4. intersection,projection,join

  5. difference,projection,product


Correct Option: B

Which four are types of functions available in SQL?

  1. string

  2. character

  3. integer

  4. numeric

  5. date

  6. conversion


Correct Option: B,D,E,F
  1. DELETE,INSERT,SELECT

  2. ALTER,DELETE,INSERT,SELECT

  3. DELETE,INSERT,SELECT,UPDATE

  4. none


Correct Option: C
  1. Substitution variables

  2. Replacement variables

  3. Prompt variables

  4. Instead-of variables

  5. This feature cannot be implemented through iSQL*PLUS


Correct Option: A
  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;


Correct Option: D

In a SELECT statement that includes a WHERE clause, where is teh GROUP BY clause placed in the SELECT statement?

  1. Immediately after the SELECT clause

  2. Before the WHERE clause

  3. Before the FROM clause

  4. After the ORDER BY clause

  5. After the WHERE clause


Correct Option: E

In which case would you use a FULL OUTER JOIN?

  1. Both tables have NULL values

  2. You want all unmatched data from one table

  3. You want all matched data from both tables

  4. You want all unmatched data from both tables

  5. One of the tables has more data than the other

  6. You want all matched and unmatched data from only one table


Correct Option: D
  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


Correct Option: D,F
  1. Connection Management

  2. Bean Management

  3. Transaction Management

  4. Object relational mapping

  5. Relational Management


Correct Option: A,C,D
- Hide questions