databases Online Quiz - 43
Description: databases Online Quiz - 43 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
Given below, What is the maximum level of data protection
Which statement is true if using NUPIs to accomplish data distribution?
What option can best describe Teradata's architecture
Why to Choose a Non Unique primary index instead of a unique primary index
When utilizing a unique secondary index, how many AMP(s) are most probably accessed
Temporary space is
Which is the component limits queries based on set thresholds?
Sybase char_length equialent of SQL is
How to change <> null in sybase to SQL?
" in sybase is changed to ' in sql
exp1 LIKE exp2 in sybase is changed to
*= operator belongs to SQL server 2008
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements inserts a row into the table?
You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others. Which statement accomplishes this?
The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR;
Which statement about views are true?
Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) JOB_CAT VARCHARD2(30) SALARY NUMBER(8,2) Which statement shows the maximum salary paid in each job category of each department?