相关考题
单项选择题 Evaluate this SQL statement: SELECT e.emp_name, d...
多项选择题 Which three statements about subqueries are true? (...
单项选择题 For which action can you use the TO_DATE function?...
单项选择题 What is true regarding subqueries?()
单项选择题 What is true about sequences? ()
单项选择题 Examine the structure of the EMPLOYEES table: EMPLOY...
单项选择题 Examine the statement: Create synonym emp for hr. ...
单项选择题 Which statement accomplish this? ()
单项选择题 User Mary has a view called EMP_DEPT_LOC_VU that ...
多项选择题 Which two statements about subqueries are true? ()
单项选择题 Examine the structure of the EMPLOYEES table: EMPLOY...
多项选择题 Which are SQL*Plus commands? ()
单项选择题 Examine the structure of the STUDENTS table: STUDENT...
单项选择题 Which statement correctly describes SQL and SQL*Plus...
多项选择题 Which two are true about aggregate functions?()
单项选择题 You need to perform these tasks: 1. Create and a...
单项选择题 Which one is a system privilege? ()
单项选择题 Which SQL statement displays the date March 19, ...
单项选择题 Evaluate these two SQL statements: SELECT last_name...
单项选择题 Which is an iSQL*Plus command? ()
单项选择题 Which object privileges can be granted on a view? ...
多项选择题 Examine the structure of the EMPLOYEES table: EMPLOY...
多项选择题 Which four are types of functions available in SQL?...
单项选择题 A SELECT statement can be used to perform these thr...
单项选择题 Which is a valid CREATE TABLE statement? ()
多项选择题 Which three are true? ()
多项选择题 Which two statements are true about constraints? (...
多项选择题 Evaluate the SQL statement: TRUNCATE TABLE DEPT; Wh...
单项选择题 You need to design a student registration database t...
多项选择题 Which two statements about subqueries are true? ()
单项选择题 Examine these statements: CREATE ROLE registrar GRANT...
单项选择题 Which view should a user query to display the colum...
单项选择题 The user Alice wants to grant all users query privi...
单项选择题 Which constraint can be defined only at the column ...
多项选择题 In which two cases would you use an outer join? ...
单项选择题 The PRODUCTS table has these columns: PRODUCT_ID NU...
单项选择题 Which best describes an inline view? ()
单项选择题 The DBA issues this SQL command: CREATE USER scott...
多项选择题 Which two tasks can you perform using only the TO_...
单项选择题 A data manipulation language statement ().
单项选择题 What does the FORCE option for creating a view do?...
单项选择题 Which are iSQL*Plus commands? ()
单项选择题 The CUSTOMERS table has these columns: CUSTOMER_ID ...
单项选择题 What is true about updates through a view? ()
多项选择题 What are two reasons to create synonyms? ()
单项选择题 Which SQL statement returns a numeric value?()
单项选择题 Examine this statement: SELECT student_id, gpa FROM...
多项选择题 In which four clauses can a subquery be used? ()
单项选择题 The STUDENT_GRADES table has these columns: STUDENT...
单项选择题 What is true of using group functions on columns th...
单项选择题 Which object privileges can be granted on a view? ...
单项选择题 What is true about sequences? ()
单项选择题 The user Sue issues this SQL statement: GRANT SELEC...
多项选择题 Examine the structure of the EMPLOYEES table: EMPLOY...
单项选择题 You need to create a table named ORDERS that contai...
多项选择题 Which four are attributes of single row functions? ...
单项选择题 Which describes the default behavior when you create...
单项选择题 The STUDENT_GRADES table has these columns: STUDENT...
单项选择题 You need to modify the STUDENTS table to add a pri...
单项选择题 You are the DBA for an academic database. You need...
单项选择题 Evaluate this SQL statement: SELECT ename, sal, 1...
单项选择题 Which statement adds a constraint that ensures the C...
单项选择题 Examine the description of the EMPLOYEES table: EMP...
单项选择题 Which is an iSQL*Plus command? ()
单项选择题 Which SQL statement would you use to remove a view...
多项选择题 Which four are valid Oracle constraint types? ()
单项选择题 The EMPLOYEES table contains these columns: EMPLOYEE...
单项选择题 You own a table called EMPLOYEES with this table st...
单项选择题 Examine the structure of the EMP_DEPT_VU view: Col...
单项选择题 Examine the structure of the EMPLOYEES and NEW_EMPLO...
单项选择题 The CUSTOMERS table has these columns: CUSTOMER_ID ...
单项选择题 Evaluate the SQL statement: SELECT ROUND(45.953...
单项选择题 Which SQL statement accepts user input for the colum...
多项选择题 Which two statements are true about WHERE and HAVING...
多项选择题 Which two statements about creating constraints are t...
单项选择题 You are granted the CREATE VIEW privilege. What doe...
多项选择题 Evaluate the SQL statement DROP TABLE DEPT: Which f...
单项选择题 Which statement describes the ROWID data type? ()
单项选择题 You need to produce a report for mailing labels for...
多项选择题 Which two statements complete a transaction? ()
单项选择题 The DBA issues this SQL command: CREATE USER scott...
单项选择题 The EMPLOYEES table has these columns: LAST NAME VA...
单项选择题 Which substitution variable would you use if you wan...
单项选择题 What is true about the WITH GRANT OPTION clause?(...
单项选择题 Which constraint can be defines only at the column ...
单项选择题 In which scenario would TOP N analysis be the best...
多项选择题 Which three are true regarding the use of outer joi...
单项选择题 Which statement creates a new user? ()
单项选择题 You need to change the definition of an existing ta...
单项选择题 What does the TRUNCATE statement do?()
单项选择题 Which is an SQL*Plus command? ()
单项选择题 Which SELECT statement should you use to extract the...
单项选择题 The EMPLOYEES table contains these columns: LAST_NAM...
单项选择题 A subquery can be used to ().
单项选择题 Which clause should you use to exclude group results...
单项选择题 What is true about joining tables through an equijoi...
单项选择题 You need to calculate the total of all salaries in...
单项选择题 You define a multiple-row subquery in the WHERE cla...
多项选择题 Which three statements correctly describe the function...
多项选择题 Which two are character manipulation functions? ()