Tag: databases

Questions Related to databases

  1. With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
technology databases

  1. INSERT INTO Persons ('Olsen') INTO LastName

  2. INSERT ('Olsen') INTO Persons (LastName)

  3. INSERT INTO Persons (LastName) VALUES ('Olsen')

  4. None

Show answer
Correct Option: C
  1. With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?
technology databases

  1. DELETE ROW FirstName='Peter' FROM Persons

  2. DELETE FROM Persons WHERE FirstName = 'Peter'

  3. DELETE FirstName='Peter' FROM Persons

  4. None

Show answer
Correct Option: B
  1. With SQL, how can you return the number of records in the "Persons" table?
technology databases

  1. SELECT COLUMNS() FROM Persons

  2. SELECT COUNT(*) FROM Persons

  3. SELECT COUNT() FROM Persons

  4. SELECT COLUMNS(*) FROM Persons

Show answer
Correct Option: B
  1. Which SQL statement is used to return only different values?
technology databases

  1. SELECT UNIQUE

  2. SELECT DISTINCT

  3. SELECT DIFFERENT

  4. None

Show answer
Correct Option: B

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true
technology databases

  1. True

  2. False

Show answer
Correct Option: A

How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?
technology databases

  1. UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'

  2. MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen

  3. UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

  4. MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen

Show answer
Correct Option: B

Your database operates in ARCHIVELOGmode. User-managed consistent backups are performed every Sunday night. On Tuesday, client A drops a table at8:00 a.m.as follows: SQL> DROP TABLEcust_ordPURGE; Table dropped. Client B executes a query at9:00 a.m.on the same table as follows: SQL> SELECT * FROMcust_ord SELECT * FROMcust_ord * ERROR at line 1: ORA-00942: table or view does not exist Client B needs the dropped table and reports the problem to you. With reference to this scenario, which action should you take?
technology databases

  1. retrieve the table by using the flashback feature

  2. restore all the data files from last Sunday's backup and then perform a time-based recovery

  3. restore all the data files from last Sunday's backup and then perform a log sequence recovery

  4. restore all the data files from last Sunday's backup and then perform a cancel-based recovery

  5. restore from last Sunday's backup only data files that belong to the tablespace in which the table was stored and then perform a complete recovery

Show answer
Correct Option: B

One of the tablespaces is read-only in your database. The loss of all control files forced you to re-create the control file. Which operation do you need to perform after re-creating the control file and opening the database?
technology databases

  1. drop and re-create the read-only tablespaces

  2. rename the read-only data files to their correct file names

  3. change the tablespace status from read/write to read-only

  4. re-create the read-only tablespace because it is automatically removed

  5. none of the above

Show answer
Correct Option: B

The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file?
technology databases

  1. The data file cannot be recovered.

  2. The date file can be restored from the SYSTEM auto backup.

  3. Take thetablespaceoffline,drop,kand re-create it.

  4. Recovery Manager (RMAN) is used to recover the data file.

  5. The ALTER DATABSE CREATE DATAFILE

Show answer
Correct Option: A

You work as a database administrator for TCS .com. You decided to manage client and server connections using Local Naming method in TCS .com. When you try to connect to the database you get the following error: ERROR: ORA-12154:TNS:couldnot resolve service name Which network configuration files would you look into to resolve this error?
technology databases

  1. snmp.ora

  2. names.ora

  3. spfile.ora

  4. sqlnet.ora

  5. listener.ora

  6. tnsnames.ora

Show answer
Correct Option: D,F