Oracle Certification problems
- 1. Foreign key in DBMS is Also asked in: Analyst, Database Administrator, IT Trainer, Project Manager
Correct Answer: Foreign keys are the columns of a table that points to the primary key of another table They act as a cross-reference between tables In detail : A Foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table or the same table In simpler words, the foreign key is defined in a second table, but it refers to the primary key or a unique key in the first table
- 2. Difference between Union and Union all? Also asked in: Analyst, Database Administrator, IT Trainer, Software Architect
Correct Answer: The difference between Union and Union all is that Union all will not eliminate duplicate rows, instead it just pulls all rows from all tables fitting your query specifics and combines them into a table A UNION statement effectively does a SELECT DISTINCT on the results set
- 3. Candidate Key in DBMS? Also asked in: Analyst, Database Administrator, IT Trainer, Software Architect
Correct Answer: A candidate key is a column, or set of columns, in a table that can uniquely identify any database record without referring to any other data Each table may have one or more candidate keys, but one candidate key is unique, and it is called the primary key
- 4. The SQL keyword(s) ________ is used with wildcards.
Options- A. LIKE only
- B. IN only
- C. NOT IN only
- D. IN and NOT IN Also asked in: Database Administrator, IT Trainer
Correct Answer: LIKE only
- 5. Which of the following is a comparison operator in SQL?
Options- A. LIKE
- B. BETWEEN
- C. =
- D. All of the above Also asked in: AIEEE, Bank Exams, Analyst, Bank Clerk
Correct Answer: All of the above
Explanation:
LIKE, BETWEEN and = operators are used for comparison in SQL. Comparison operators test whether two expressions are the same. Comparison operators can be used on all expressions except expressions of the text, ntext, or image data types.
- 6. Go command is a signal to execute the entire batch of SQL statements after previous Go
Options- A. TRUE
- B. FALSE Also asked in: Database Administrator
Correct Answer: TRUE
- 7. Copying the logs on the standby/backup server is an operation of Log Shipping
Options- A. TRUE
- B. FALSE Also asked in: Database Administrator
Correct Answer: TRUE
Explanation:
It is one of the operation of Log Shipping
- 8. Multiple users can share a local temporary table
Options- A. TRUE
- B. FALSE Also asked in: Database Administrator
Correct Answer: FALSE
Explanation:
Multiple users can't share a local temporary table
- 9. STUFF and REPLACE are used to replace characters in a string
Options- A. TRUE
- B. FALSE Also asked in: Database Administrator
Correct Answer: TRUE
Explanation:
They both are used to replace characters in a string
- 10. Breaking of relationships is allowed once referential integrity on a database is enforced
Options- A. TRUE
- B. FALSE Also asked in: Database Administrator
Correct Answer: FALSE
Explanation:
Breaking of relationships is prevented once referential integrity on a database is enforced
Programming
Copyright ©CuriousTab. All rights reserved.