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 WH

题目

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%'
相似考题

1.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.

2.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

3.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.

4.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

参考答案和解析
正确答案:A
更多“You need to display the last nam”相关问题

  • 第1题：

    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. 

    正确答案:C

  • 第2题：

    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 days
    • B、 to configure RMAN to maintain backup information in the control file for at least seven days
    • C、 to display the list of files that have not been backed up for the last seven days
    • D、 to display the list of files that must be backed up within seven days

    正确答案:C

  • 第3题：

     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.

    正确答案:A

  • 第4题：

    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.

    正确答案:A

  • 第5题：

    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.

    正确答案:B

  • 第6题：

    单选题
    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%'


    正确答案： C
    解析： 暂无解析

  • 第7题：

    单选题
    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_CORRUPTION

    B

     V$COPY_CORRUPTION

    C

     V$DATABASE_BLOCK_CORRUPTION

    D

     RC_BACKUP_CORRUPTION


    正确答案： C
    解析： 暂无解析

  • 第8题：

    单选题
    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?（）
    A

    all of the desired results

    B

    two of the desired results

    C

    one of the desired results

    D

    an error statement


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    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?（）
    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.


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    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.


    正确答案： E
    解析： 暂无解析

  • 第11题：

    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_CORRUPTION
    • B、 V$COPY_CORRUPTION
    • C、 V$DATABASE_BLOCK_CORRUPTION
    • D、 RC_BACKUP_CORRUPTION

    正确答案:C

  • 第12题：

    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.

    正确答案:D

  • 第13题：

    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.

    正确答案:C

  • 第14题：

    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、SetShowHelp
    • B、SetHelpString
    • C、SetHelpKeyword
    • D、SetHelpNavigator

    正确答案:A

  • 第15题：

    单选题
    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 days

    B

     to configure RMAN to maintain backup information in the control file for at least seven days

    C

     to display the list of files that have not been backed up for the last seven days

    D

     to display the list of files that must be backed up within seven days


    正确答案： B
    解析： 暂无解析

  • 第16题：

    单选题
    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?（）
    A

    all of the desired results

    B

    two of the desired results

    C

    one of the desired results

    D

    an error statement


    正确答案： A
    解析： 暂无解析

  • 第17题：

    单选题
    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 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


    正确答案： B
    解析： 暂无解析

  • 第18题：

    单选题
    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 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


    正确答案： C
    解析： 暂无解析

  • 第19题：

    单选题
    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 ?（）
    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.


    正确答案： C
    解析： 暂无解析

相关内容