• databases Online Quiz - 166
Back
0

databases Online Quiz - 166

Description: databases Online Quiz - 166
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

Which two roles or privileges must you have to export tables owned by another user? (Choose two)
technology databases

  1. CREATE USER

  2. CREATE SESSION

  3. CREATE ANY TABLE

  4. IMP_FULL_DATABASE

  5. EXP_FULL_DATABASE

Show answer
Correct Option: B,E

Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database? (Choose three)
technology databases

  1. SYNC or ASYNC to identify the network transmission mode.

  2. LGWR or ARCH to identify the primary database process responsible for sending redo information to the standby.

  3. AFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously.

  4. PROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database.

Show answer
Correct Option: A,B,C

When an oracle Instance is started, background process are started. Background processes perform which two functions ? (Choose two)

technology databases

  1. Perform I/O

  2. Lock rows that are not data dictionary rows

  3. Monitor other Oracle processes

  4. Connect users to the Oracle instance

  5. Execute SQL statments issued through an application

Show answer
Correct Option: A,C

Which three are the physical structures that constiture the Oracle database ? (Choose Three)

technology databases

  1. Control file

  2. Extent

  3. Segment

  4. Data file

  5. Log file

  6. Tablespace

Show answer
Correct Option: A,D,E

SQL> CREATE TABLESPACE user_data EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; Which twp assumptions must be true for this statement to execute successfully ? (Choose two)

technology databases

  1. Oracle Managed Files used for this instance.

  2. The USER_DATA tablespace in managed using FET$/UET$ tables.

  3. The COMPATIBLE intialization paramter must be 9.0.0 or higer.

  4. Space within segments is the USER_DATA tablespace is managed with freelists.

Show answer
Correct Option: A,C

Which two statments regarding the control file and Recover Manager are true ? (Choose two)

technology databases

  1. The control file can grow in size.

  2. The control file can store RMAN scripts.

  3. CONTROL_FILE_RECORD_KEEP_TIME determine retention time for RMAN records.

  4. The RMAN catalog can exist solely in the control file of the target database.

Show answer
Correct Option: C,D

what is true regarding the role Oracle Net provides in a client server connection with no middle tier? (Choose two)

technology databases

  1. Oracle Net is layered on top of the network protocol.

  2. Oracle Net must reside on both the client and the server for peer-to-peer communication to occur.

  3. On the client side, Oracle Net is responsible for working with the listener to receive incoming connection requests.

  4. On the server side, Oracle Net is responsible for several connectivity issues such as : the location of the server, whatever one or more protocol is involved in the connection, and how to handle exception and interrupts.

Show answer
Correct Option: A,B

The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover ? (Choose two)
technology databases

  1. Restore the data file and perform incomplete recovery.

  2. Restore the data file and perform point-in-time recover.

  3. Drop the tablespace and lose all data in the tablespace.

  4. Restore the database and lose all data since the last backup.

Show answer
Correct Option: C,D

What file will give you Oracle instance status information?

technology databases

  1. alert.ora

  2. init.ora

  3. tnsname.ora

  4. redolog

Show answer
Correct Option: A

Which of the following SQL statements does count the rows in the 'Sales' table?

technology databases

  1. SELECT COUNT(*) IN Sales

  2. SELECT NUM() FROM Sales

  3. SELECT COUNTER(*) FROM Sales

  4. SELECT COUNT(*) FROM Sales

Show answer
Correct Option: D

Which SQL statement inserts data into a table called Projects?

technology databases

  1. INSERT Projects ('Content Development', 'Website content development project')

  2. INSERT INTO Projects (ProjectName, ProjectDescription) VALUES ('Content Development', 'Website content development project')

  3. INSERT Projects VALUES ('Content Development', 'Website content development project')

  4. SAVE INTO Projects (ProjectName, ProjectDescription) VALUES ('Content Development', 'Website content development project')

Show answer
Correct Option: B

Which of the following is a SQL aggregate function?

technology databases

  1. CAST

  2. LEFT

  3. MIN

  4. RIGHT

Show answer
Correct Option: C

The LIKE SQL keyword is used along with ...

technology databases

  1. ORDER BY clause

  2. GROUP BY clause.

  3. JOIN clause.

  4. WHERE clause.

Show answer
Correct Option: D
Explanation:

To solve this question, the user needs to know the basic syntax and usage of the LIKE keyword in SQL.

The LIKE keyword is used in SQL along with the WHERE clause to search for a specific pattern in a column of a table. The LIKE keyword is used to perform partial matching of strings and can be used with wildcard characters, such as % to represent any number of characters or _ to represent a single character.

Now, let's go through each option and explain why it is right or wrong:

A. ORDER BY clause: This option is incorrect because the ORDER BY clause is used to sort the result set in ascending or descending order based on one or more columns. It does not have any relation to the LIKE keyword.

B. GROUP BY clause: This option is incorrect because the GROUP BY clause is used to group the result set based on one or more columns. It also does not have any relation to the LIKE keyword.

C. JOIN clause: This option is incorrect because the JOIN clause is used to combine rows from two or more tables based on a related column between them. It also does not have any relation to the LIKE keyword.

D. WHERE clause: This option is correct. The LIKE keyword is used along with the WHERE clause to filter the rows in a table based on a specific pattern in a column. The WHERE clause is used to specify the condition that must be met for a row to be included in the result set.

Therefore, the correct answer is: D. WHERE clause.

Which of the following is a SQL aggregate function

technology databases

  1. JOIN

  2. LEN

  3. LEFT

  4. AVG

Show answer
Correct Option: D

The JOIN is a SQL keyword used to ...

technology databases

  1. update database table.

  2. verify that the inserted data is correct.

  3. select data from 2 or more tables related by common attribute (table column).

  4. delete data from database table.

Show answer
Correct Option: C

Which SQL statement selects all rows from table called Contest, with column ContestDate having values greater or equal to May 25, 2006?

technology databases

  1. SELECT * FROM Contest HAVING ContestDate >= '05/25/2006'

  2. SELECT * FROM Contest WHERE ContestDate >= '05/25/2006'

  3. SELECT * FROM Contest WHERE ContestDate < '05/25/2006'

  4. SELECT * FROM Contest IN ContestDate < '05/25/2006'

Show answer
Correct Option: B

Can you use the UPDATE and SELECT clauses in one SQL statement?

technology databases

  1. You can if you use nested SQL statements

  2. You can use UPDATE and SELECT clauses together, even if you don’t have nested SQL statements.

  3. You can if you use WITH clause.

  4. You can't

Show answer
Correct Option: A

What does the FROM SQL keyword specify?

technology databases

  1. The FROM SQL keyword specifies a column list

  2. The FROM SQL keyword specifies a search condition.

  3. The FROM SQL keyword specifies the tables, views, and joined tables used in SELECT, UPDATE and DELETE SQL statements.

  4. The FROM SQL keyword specifies a find condition.

Show answer
Correct Option: C

A trigger belongs to…

technology databases

  1. a single table in the database

  2. to all tables in the database

  3. to all the tables of the user

  4. more than one table in the database

Show answer
Correct Option: B

The LIKE SQL keyword is used along with ...

technology databases

  1. ORDER BY clause.

  2. GROUP BY clause.

  3. JOIN clause.

  4. WHERE clause.

Show answer
Correct Option: D
Explanation:

To use the LIKE SQL keyword, the user needs to know that it is used for pattern matching in SQL queries. It is used to search for a specific pattern within a column of a table.

The correct answer is:

D. WHERE clause.

Explanation:

The LIKE keyword is used along with the WHERE clause to filter the results based on a specific pattern. The WHERE clause is used to extract only those records that fulfill a specified condition. The LIKE keyword is used to specify the pattern that the user wants to match.

A. ORDER BY clause: This clause is used to sort the results in ascending or descending order based on one or more columns of a table.

B. GROUP BY clause: This clause is used to group the results based on one or more columns of a table. It is typically used along with aggregate functions like SUM, COUNT, AVG, etc.

C. JOIN clause: This clause is used to combine two or more tables based on a related column between them.

D. WHERE clause: This clause is used to filter the results based on a specific condition. The LIKE keyword is used along with this clause to match a specific pattern within a column.

Therefore, option D is the correct answer.

- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions