databases Online Quiz - 185
Description: databases Online Quiz - 185 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
Which constraint can be defined only at column level?
Which SELECT statement will get the result 'elloworld' from the string 'HelloWorld'?
Which substitution variable would you use if you want to reuse the variable without prompting the user each time
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?
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;
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?
Which statement about the shared pool is true?
Which action will cause a log switch?
Which is a valid CREATE TABLE statement?
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?
Which four are types of functions available in SQL?
In a SELECT statement that includes a WHERE clause, where is teh GROUP BY clause placed in the SELECT statement?
In which case would you use a FULL OUTER JOIN?