You need to display the last names of those employees who have the letter "A" as the second character in their names. Which SQL statement displays the required results? （）A、SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';B、SELECT last_name FROM EMP WHERE last name ='*A%'C、SELECT last_name FROM EMP WHERE last name ='_A%';D、SELECT last_name FROM EMP WHERE last name LIKE '*A%'
You need to display the last names of those employees who have the letter "A" as the second character in their names. Which SQL statement displays the required results? （）
- A、SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';
- B、SELECT last_name FROM EMP WHERE last name ='*A%'
- C、SELECT last_name FROM EMP WHERE last name ='_A%';
- D、SELECT last_name FROM EMP WHERE last name LIKE '*A%'
相关考题：
The EMP table contains these columns:You need to display the employees who have not been assigned to any department.You write the SELECT statement:What is true about this SQL statement?() A. The SQL statement displays the desired results.B. The column in the WHERE clause should be changed to display the desired results.C. The operator in the WHERE clause should be changed to display the desired results.D. The WHERE clause should be changed to use an outer join to display the desired results.
You need to configure the power settings of your portable computer so that the display turns off when it is inactive and running on battery power. You also need to ensure that the power settings of the hard disk remain unaffected.What should you do?（）A.AB.BC.CD.D
Your portable computer has a built－in secondary display on the lid.You need to display your e－mail messages, calendar, and contacts on the secondary display.What should you do?() A.AB.BC.CD.D
Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member， which is not a member of the current group. How would you recover from the loss of the redo log member？（）A、SMON would automatically restore the lost file.B、You would need to restore the whole database from the last backup.C、You would need to restore the file from the last full database backup.D、You would need to use flashback technology to restore the lost redo log member.E、You would need to use Recovery Manager （RMAN） to restore the lost redo log member.F、You would need to restore the missing log file by copying one of the remaining files from the same group.
Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）A、You need to perform the restore and recover operations manually, because the backup was made manually. B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.
You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）A、 V$BACKUP_CORRUPTIONB、 V$COPY_CORRUPTIONC、 V$DATABASE_BLOCK_CORRUPTIOND、 RC_BACKUP_CORRUPTION
In which scenario， will you issue the following command？（） RMAN REPORT NEED BACKUP DAYS 7；A、 to configure RMAN to maintain backup information in the RMAN repository for seven daysB、 to configure RMAN to maintain backup information in the control file for at least seven daysC、 to display the list of files that have not been backed up for the last seven daysD、 to display the list of files that must be backed up within seven days
You issue the following command on the RMAN prompt. RMAN REPORT NEED BACKUP DAYS = 5 DATABASE； Which statement is true about executing this command？（）A、 It will display a list of files that need incremental backup.B、 It will display a list of files that need backup after five days.C、 It will display a list of files that were backed up in the last five days.D、 It will display a list of files that have not been backed up in the last five days.E、 It will apply the current retention policy to determine the files that need to be backed up.
You connect an external monitor to a portable computer. You need to increase the available desktop area to include the external monitor. What should you do?（） A、From the Display properties, extend the display. B、From the Display properties, modify the resolution settings.C、Restart the computer in VGA Mode. Run dxdiag.exe. D、Restart the computer in VGA Mode. Install the most up-to-date driver for the video graphics adapter.
You have a computer that runs Windows 7. You need to provide standard users the ability to update thedrivers for display adapters. What should you modify from the Local Group Policy?（）A、device installation settings for the computer.B、display settings for the user.C、driver installation settings for the computer.D、driver installation settings for the user.
When you connect an external monitor to your portable computer， the same image appears on both monitors. You need to drag a window from one monitor to the other. What should you do？（）A、Change the display setting to extend the desktop.B、In the Microsoft Windows Mobility Center window， turn on the Presentation Settings feature. C、Configure the external monitor as the primary display and the built-in monitor as the secondary display.D、Change the secondary display resolution settings to make them equal to or less than the primary display resolution settings.
You are creating a Windows Forms application by using the .Net Framework 3.5.You plan to display detailed help instructions for each control in the form.You create a help file.You configure a HelpProvider component on the form.You need to display the help file for the control that is focused when the F1 key is pressed.Which method of the HelpProvider class should you call for each control？（）A、SetShowHelpB、SetHelpStringC、SetHelpKeywordD、SetHelpNavigator
You plan to give an on-site presentation. The external display available for your audience is a 42-inch flat panel monitor. You need to ensure that the presentation on the monitor of your computer is duplicated on the external monitor for the audience. What should you do？（）A、Click the Show my desktop on the external display only option.B、Configure the Presentation settings to mirror your desktop on the external display. C、Configure the Presentation settings to extend your desktop to the external display.D、Reduce the screen resolution of your primary display to a value equal to the maximum resolution of the external display.
单选题In which scenario， will you issue the following command？（） RMAN REPORT NEED BACKUP DAYS 7；A to configure RMAN to maintain backup information in the RMAN repository for seven daysB to configure RMAN to maintain backup information in the control file for at least seven daysC to display the list of files that have not been backed up for the last seven daysD to display the list of files that must be backed up within seven days
单选题You need to display the last names of those employees who have the letter "A" as the second character in their names.Which SQL statement displays the required results?（）ASELECT last_name FROM EMP WHERE last_ name LIKE '_A%';BSELECT last_name FROM EMP WHERE last name ='*A%'CSELECT last_name FROM EMP WHERE last name ='_A%';DSELECT last_name FROM EMP WHERE last name LIKE '*A%'
单选题The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) COMMISSION_PCT NUMBER (6) You need to write a query that will produce these results: 1.Display the salary multiplied by the commission_pct. 2.Exclude employees with a zero commission_pct. 3.Display a zero for employees with a null commission value. Evaluate the SQL statement: SELECT LAST_NAME, SALARY*COMMISSION_PCT FROM EMPLOYEES WHERE COMMISSION_PCT IS NOT NULL; What does the statement provide?（）Aall of the desired resultsBtwo of the desired resultsCone of the desired resultsDan error statement
单选题You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）A V$BACKUP_CORRUPTIONB V$COPY_CORRUPTIONC V$DATABASE_BLOCK_CORRUPTIOND RC_BACKUP_CORRUPTION
单选题You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5； Which statement is true about executing this command？（）A It will display a list of files that need incremental backupB It will display a list of files that need backup after five daysC It will display a list of files that were backed up in the last five daysD It will display a list of files that have not been backed up in the last five daysE It will apply the current retention policy to determine the files that need to be backed up
单选题The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) COMMISSION_PCT NUMBER (6) You need to write a query that will produce these results: 1.Display the salary multiplied by the commission_pct. 2.Exclude employees with a zero commission_pct. 3.Display a zero for employees with a null commission value. Evaluate the SQL statement: SELECT LAST_NAME, SALARY*COMMISSION_PCT FROM EMPLOYEES WHERE COMMISSION_PCT IS NOT NULL; What does the statement provide?（）Aall of the desired resultsBtwo of the desired resultsCone of the desired resultsDan error statement
单选题You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5; Which statement is true about executing this command?（）AIt will display a list of files that need incremental backupBIt will display a list of files that need backup after five daysCIt will display a list of files that were backed up in the last five daysDIt will display a list of files that have not been backed up in the last five daysEIt will apply the current retention policy to determine the files that need to be backed up
单选题The EMP table contains these columns: LAST NAME VARCHAR2(25) SALARY NUMBER(6,2) DEPARTMENT_ID NUMBER(6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARMENT_ID = NULL; What is true about this SQL statement?（）AThe SQL statement displays the desired results.BThe column in the WHERE clause should be changed to display the desired results.CThe operator in the WHERE clause should be changed to display the desired results.DThe WHERE clause should be changed to use an outer join to display the desired results.
单选题The EMP table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) DEPARTMENT_ID NUMBER (6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARTMENT_ID = NULL; What is true about this SQL statement ?（）AThe SQL statement displays the desired results.BThe column in the WHERE clause should be changed to display the desired results.CThe operator in the WHERE clause should be changed to display the desired results.DThe WHERE clause should be changed to use an outer join to display the desired results.
单选题You issue the following command on the RMAN prompt. RMAN REPORT NEED BACKUP DAYS = 5 DATABASE； Which statement is true about executing this command？（）A It will display a list of files that need incremental backup.B It will display a list of files that need backup after five days.C It will display a list of files that were backed up in the last five days.D It will display a list of files that have not been backed up in the last five days.E It will apply the current retention policy to determine the files that need to be backed up.